04/30/06 12:46pm  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
Hi,

i updated filemgmt to 1.5.2..
But when i click "My downloads" giving this error "An SQL error has occurred. Please see error.log for details."

error.log says

Text Formatted Code
Sun 30 Apr 2006 19:20:44 EEST - 1054: Unknown column 'CID' in 'order clause'. SQL in question: SELECT cid, title, imgurl,grp_access FROM gl_filemgmt_category WHERE pid = 0  AND grp_access IN (2,4,7,24,11,5,13,12,10,8,1,14,3,6,9,43,37,20,25) ORDER BY CID

 


what is the problem & what can i do?
_KEMAL_
 04/30/06 01:13pm  
Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
What version were you running before the update?
The file cid was not changed and you will need to check out what went wrong with your filemgmt tables. The update script adds a new grp_access field but does not remove any fields.
Geeklog components by PortalParts -- www.portalparts.com
 04/30/06 07:12pm  
Status: offline

trinity

Forum User
Regular Poster
Registered: 01/30/05
Posts: 80
I had the same error but its related to a change in behavior of ON clauses in joins in mysql 5 as far as i can tell. so far is the only querry i have found in the file management plugin that has a problem with mysql 5
glFusion - Technology Fused with Style - www.gllabs.org
 05/02/06 11:56am  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
I used filemgmt 1.3 before update..
There is no problem on 1.3 but as you know as comment is not run on 1.3..

My register globals is off and my MySQL version is 3.23.58

_KEMAL_
 05/03/06 02:58pm  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
yes, problem is MySQL version , i tested last version and there is no problem..
But what we can do for earlier versions?
_KEMAL_
 05/03/06 06:14pm  
Status: offline

trinity

Forum User
Regular Poster
Registered: 01/30/05
Posts: 80
only thing i can tell you is ether fix the query yourself useing mysql docs or pester blaine to fix it for you. just post any fixes you do your self to this thread so every one can see them and make the fix too
glFusion - Technology Fused with Style - www.gllabs.org