The secure CMS.

Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 10:17 pm EST

Geeklog Forums

Filemgmt Update problem

 New Topic  Post Reply
 04/30/06 12:46pm (Read 2,349 times)  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
Location:Turkey
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_
 Quote
 04/30/06 01:13pm  
Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
 Quote
 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
 Quote
 05/02/06 11:56am  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
Location:Turkey
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_
 Quote
 05/03/06 02:58pm  
Status: offline

kemal

Forum User
Regular Poster
Registered: 04/05/05
Posts: 103
Location:Turkey
yes, problem is MySQL version , i tested last version and there is no problem..
But what we can do for earlier versions?
_KEMAL_
 Quote
 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
 Quote
 New Topic  Post Reply
All times are EST. The time is now 10:17 pm.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content