2011-03-27, 06:06 AM
Well i have serfed my brains out, tryed update.php over and over, and nothing!
my site ProxyHelp.org/mybb/ is crashing with
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 't.prefix' in 'on clause'
Query:
SELECT t.*, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='0') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='5' AND t.visible='1' GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20
as you can see at this link
http://www.proxyhelp.org/mybb/forumdisplay.php?fid=5
Any help would be nice!!!
Well i fixed it, just was picked like 4.16.2 or something in upgrade (i had like 6.1 ) and it worked
my site ProxyHelp.org/mybb/ is crashing with
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 't.prefix' in 'on clause'
Query:
SELECT t.*, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='0') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='5' AND t.visible='1' GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20
as you can see at this link
http://www.proxyhelp.org/mybb/forumdisplay.php?fid=5
Any help would be nice!!!
Well i fixed it, just was picked like 4.16.2 or something in upgrade (i had like 6.1 ) and it worked