Welcome to Geeklog Friday, May 20 2022 @ 11:48 pm EDT

Geeklog Forums

Filemgmt Update problem


Status: offline

kemal

Forum User
Regular Poster
Registered: 05/04/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

PHP 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

Status: offline

Blaine

Forum User
Moderator
Registered: 16/07/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

Status: offline

trinity

Forum User
Regular Poster
Registered: 30/01/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

Status: offline

kemal

Forum User
Regular Poster
Registered: 05/04/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

Status: offline

kemal

Forum User
Regular Poster
Registered: 05/04/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

Status: offline

trinity

Forum User
Regular Poster
Registered: 30/01/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

All times are EDT. The time is now 11:48 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