SQL error in "Ressources" after update 1.8 -> 14

Oliver_Welter 2015-02-22 13:23:52 UTC #1

Hi All,

I just upgraded an old eGroupware from 1.8 to 14.2. If it cares: manual
install, php-fpm 5.5 with mysql 5.5. on apache2.2.

When I go to “ressources list” and open a ressource, an ugly javascript
alert opens with a very bulky database error message shown below. I keep
getting this error whenever I try to go to ressources afterwards until I
re-login.

Is there any problem in the migration script or is it a general bug?

TIA and regards

Oliver

Database error

db::column_data_implode(’ AND ',Array
(
[mime] => /video/|image/|audio//
[accessory_of] => -1
[deleted] =>
[cat_id] => Array
(
[0] => 264
[1] => 304
[2] => 131
[3] => 1
)

)
,‘1’,

Array

(

[res_id] => Array

(

[type] => auto

[nullable] =>

)
[name] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[short_description] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[cat_id] => Array
    (
        [type] => int
        [meta] => category
        [precision] => 11
        [nullable] =>
    )

[quantity] => Array
    (
        [type] => int
        [precision] => 11
        [default] => 1
    )

[useable] => Array
    (
        [type] => int
        [precision] => 11
        [default] => 1
    )

[location] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[bookable] => Array
    (
        [type] => varchar
        [precision] => 1
    )

[buyable] => Array
    (
        [type] => varchar
        [precision] => 1
    )

[prize] => Array
    (
        [type] => varchar
        [precision] => 200
    )

[long_description] => Array
    (
        [type] => longtext
    )

[picture_src] => Array
    (
        [type] => varchar
        [precision] => 20
    )

[accessory_of] => Array
    (
        [type] => int
        [precision] => 11
        [default] => -1
    )

[storage_info] => Array
    (
        [type] => varchar
        [precision] => 200
    )

[inventory_number] => Array
    (
        [type] => varchar
        [precision] => 20
    )

[deleted] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

[res_creator] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 11
    )

[res_created] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

[res_modifier] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 11
    )

[res_modified] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

)

nothing known about column 'mime'!

–
Protect your environment - close windows and adopt a penguin!

Mgr_Peter_Tuharsky_M 2015-02-23 09:06:00 UTC #2

Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk

Ralf_Becker_Stylite 2015-02-24 20:08:35 UTC #3

This seems to happen when you sort by the icon, click again eg. on the name.

Ralf

We too have this problem.

Dňa 22.02.2015 o 14:23 Oliver Welter napísal(a):

Hi All,

I just upgraded an old eGroupware from 1.8 to 14.2. If it cares: manual
install, php-fpm 5.5 with mysql 5.5. on apache2.2.

Is there any problem in the migration script or is it a general bug?

TIA and regards

Oliver

Database error

db::column_data_implode(’ AND ',Array
(
[mime] => /video/|image/|audio//
[accessory_of] => -1
[deleted] =>
[cat_id] => Array
(
[0] => 264
[1] => 304
[2] => 131
[3] => 1
)

)
,‘1’,

Array

(

[res_id] => Array

(

[type] => auto

[nullable] =>

)
[name] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[short_description] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[cat_id] => Array
    (
        [type] => int
        [meta] => category
        [precision] => 11
        [nullable] =>
    )

[quantity] => Array
    (
        [type] => int
        [precision] => 11
        [default] => 1
    )

[useable] => Array
    (
        [type] => int
        [precision] => 11
        [default] => 1
    )

[location] => Array
    (
        [type] => varchar
        [precision] => 100
    )

[bookable] => Array
    (
        [type] => varchar
        [precision] => 1
    )

[buyable] => Array
    (
        [type] => varchar
        [precision] => 1
    )

[prize] => Array
    (
        [type] => varchar
        [precision] => 200
    )

[long_description] => Array
    (
        [type] => longtext
    )

[picture_src] => Array
    (
        [type] => varchar
        [precision] => 20
    )

[accessory_of] => Array
    (
        [type] => int
        [precision] => 11
        [default] => -1
    )

[storage_info] => Array
    (
        [type] => varchar
        [precision] => 200
    )

[inventory_number] => Array
    (
        [type] => varchar
        [precision] => 20
    )

[deleted] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

[res_creator] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 11
    )

[res_created] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

[res_modifier] => Array
    (
        [type] => int
        [meta] => user
        [precision] => 11
    )

[res_modified] => Array
    (
        [type] => int
        [meta] => timestamp
        [precision] => 8
    )

)

nothing known about column 'mime'!

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Chabi01 2015-03-11 12:30:47 UTC #4

Hi,
Same problem here with a fresh install of EGW 14.2
If i create a new ressources, all is fine.
If i try to order any column, all is fine.
If i click on the image of the object, the error occurs.
If i double click on the name, it opens the popup windows and i can edit or delete the object.

So the error only happens when i click on the image.
I tried with an upload image or the cat image, it’s the same : i have the same error “database error”…

Note that when the error “start”, you can see the “shadowed” lines, the number of object is correct, but you cannot click anywhere on the column or even ask for the list.

If you log out and log in again, all the object are here.

Any idea ?
Thanks

Ralf_Becker_Stylite 2015-03-11 12:53:59 UTC #5

Hi,

that bug has been fixed, are you running current 14.2.20150310?

Ralf

Hi,
Same problem here with a fresh install of EGW 14.2
If i create a new ressources, all is fine.
If i try to order any column, all is fine.
If i click on the image of the object, the error occurs.
If i double click on the name, it opens the popup windows and i can edit or
delete the object.

So the error only happens when i click on the image.
I tried with an upload image or the cat image, it’s the same : i have the
same error “database error”…

Note that when the error “start”, you can see the “shadowed” lines, the
number of object is correct, but you cannot click anywhere on the column or
even ask for the list.

If you log out and log in again, all the object are here.

Any idea ?
Thanks

–
View this message in context: http://egroupware.219119.n3.nabble.com/SQL-error-in-Ressources-after-update-1-8-14-tp4005375p4006094.html
Sent from the egroupware-users mailing list archive at Nabble.com.

Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Chabi01 2015-03-11 13:45:11 UTC #6

I have the egroupware-epl-14.2.20150218.zip file
Downloaded yesterday (???).

I check on sourceforce and i can see the “new” one posted 5 hours ago !

Ok, so i have to update.
I have just to upload by ftp the file to replace the old files and folders by the new ones ?

Thanks

Chabi01 2015-03-11 14:37:09 UTC #7

I answer by myself.
Just uploaded the files and folders by ftp and replace all.
I kept the config file (duplicate all the folder by security in fact).
All works fine and this issue is resolved for me.

I will go back if i see anything else
Thanks for the tip !!