Posted on: 04/30/06 12:46pm
By: kemal
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
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?
Filemgmt Update problem
Posted on: 04/30/06 01:13pm
By: Blaine
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.
Filemgmt Update problem
Posted on: 04/30/06 07:12pm
By: trinity
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
Filemgmt Update problem
Posted on: 05/02/06 11:56am
By: kemal
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
Filemgmt Update problem
Posted on: 05/03/06 02:58pm
By: kemal
yes, problem is MySQL version , i tested last version and there is no problem..
But what we can do for earlier versions?
Filemgmt Update problem
Posted on: 05/03/06 06:14pm
By: trinity
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