PortalParts.com Site

 Forum Index > Geeklog > Filemgmt Plugin Support New Topic Post Reply
 Unkown column ratingd
 |  Printable Version
dtrumbower
 November 05 2007 08:11 AM (Read 2070 times)  
Forum Big Cheese
Big Cheese

Status: offline

Registered: 01/12/03
Posts: 61

After upgrading to the latest version of file management, on a new upload I get the following error.

PHP Formatted Code
Sun 04 Nov 2007 11:41:22 PM GMT-6 - 1054: Unknown column 'ratingd' in 'order clause'. SQL in question: SELECT a.lid, a.cid, a.title, a.url, a.homepage, a.version, a.size, a.submitter, a.logourl, a.status, a.date, a.hits, a.rating, a.votes, a.comments, b.description FROM gl_filemgmt_filedetail a LEFT JOIN  gl_filemgmt_filedesc b on a.lid=b.lid LEFT JOIN gl_filemgmt_category c ON a.cid=c.cid WHERE a.cid='1' AND a.status > 0  AND grp_access = '2' ORDER BY ratingd LIMIT 0, 10
Sun 04 Nov 2007 11:41:27 PM GMT-6 - 1054: Unknown column 'titled' in 'order clause'. SQL in question: SELECT a.lid, a.cid, a.title, a.url, a.homepage, a.version, a.size, a.submitter, a.logourl, a.status, a.date, a.hits, a.rating, a.votes, a.comments, b.description FROM gl_filemgmt_filedetail a LEFT JOIN  gl_filemgmt_filedesc b on a.lid=b.lid LEFT JOIN gl_filemgmt_category c ON a.cid=c.cid WHERE a.cid='1' AND a.status > 0  AND grp_access = '2' ORDER BY titled LIMIT 0, 10
Sun 04 Nov 2007 11:41:39 PM GMT-6 - 1054: Unknown column 'dated' in 'order clause'. SQL in question: SELECT a.lid, a.cid, a.title, a.url, a.homepage, a.version, a.size, a.submitter, a.logourl, a.status, a.date, a.hits, a.rating, a.votes, a.comments, b.description FROM gl_filemgmt_filedetail a LEFT JOIN  gl_filemgmt_filedesc b on a.lid=b.lid LEFT JOIN gl_filemgmt_category c ON a.cid=c.cid WHERE a.cid='1' AND a.status > 0  AND grp_access = '2' ORDER BY dated LIMIT 0, 10
Sun 04 Nov 2007 11:41:40 PM GMT-6 - 1054: Unknown column 'hitsd' in 'order clause'. SQL in question: SELECT a.lid, a.cid, a.title, a.url, a.homepage, a.version, a.size, a.submitter, a.logourl, a.status, a.date, a.hits, a.rating, a.votes, a.comments, b.description FROM gl_filemgmt_filedetail a LEFT JOIN  gl_filemgmt_filedesc b on a.lid=b.lid LEFT JOIN gl_filemgmt_category c ON a.cid=c.cid WHERE a.cid='1' AND a.status > 0  AND grp_access = '2' ORDER BY hitsd LIMIT 0, 10
 


Dwight
 
Profile Email Website PM
Quote
Blaine
 November 05 2007 08:18 AM  
Forum Admin
Admin

Status: offline

Registered: 03/01/02
Posts: 3576

Dwight,

There should be no 'd' at the end of those fieldname. Looks like that code changed somehow.


Please consider contributing to support my efforts ..
 
Profile Email Website PM
Quote
dtrumbower
 November 06 2007 14:20 PM  
Forum Big Cheese
Big Cheese

Status: offline

Registered: 01/12/03
Posts: 61

It's the order clause that is not getting converted properly. I noticed in there is routine to switch the ratingD to rating Descending. But I can't find a ratingd in any of the code yet.


Dwight
 
Profile Email Website PM
Quote
Content generated in: 0.27 seconds
New Topic Post Reply



 All times are CDT. The time is now 12:43 AM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Anonymous users can post 
Filtered HTML Allowed 
Censored Content