Quote by Trinity: did a fresh install and went to add a catagory and a file that worked fine but when i went to take a look to see if the file was there on /filemgmt/index.php u get a sql error
here is the error from the log
Mon 20 Mar 2006 19:26:59 EST - 1054: Unknown column 'd.cid' in 'on clause'. SQL in question: SELECT d.lid, d.cid, d.title, url, homepage, version, size, platform, submitter, logourl, status, date, hits, rating, votes, comments, description, grp_access FROM gl_filemgmt_filedetail d, gl_filemgmt_filedesc t LEFT JOIN gl_filemgmt_category c ON d.cid=c.cid WHERE status > 0 AND d.lid=t.lid ORDER BY date DESC LIMIT 0, 5
Since i'm using MySQL 5.0.18 & i have the same problem with you it's just that i have v1.3 installed & i just need to upgrade & the upgrading works great. You can fix the problem by modifying file index.php.
1. find a line:
Text Formatted Code
$sql .= "date, hits, rating, votes, comments, description, grp_access FROM {$_FM_TABLES['filemgmt_filedetail']} d, ";
replace with:
Text Formatted Code
$sql .= "date, hits, rating, votes, comments, description, grp_access FROM ({$_FM_TABLES['filemgmt_filedetail']} d, ";
2. find another line:
Text Formatted Code
$sql .= "{$_FM_TABLES['filemgmt_filedesc']} t LEFT JOIN {$_FM_TABLES['filemgmt_cat']} c ON d.cid=c.cid ";
and replace with:
Text Formatted Code
$sql .= "{$_FM_TABLES['filemgmt_filedesc']} t) LEFT JOIN {$_FM_TABLES['filemgmt_cat']} c ON d.cid=c.cid ";
P/S: maybe Blaine should try to install mysql5 for testing purpose.