MyBB Community Forums

Full Version: t.prefix on clause after upgrading
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3
I'm getting this error.

Parse error: syntax error, unexpected T_VARIABLE in /home/btsxchan/public_html/inc/settings.php on line 58

cookieprefix that is on line 58

I got my real domain to work - http://btsxchange.com

But I'm not sure how do I set the cookies thingy in settings.php
Open ./inc/settings.php file and paste the code of line#58
$settings['cookieprefix'] = "";
It goes to my old temp url instead of the new one when I click memberlist.
you need to add your cookie bit to that i think
Replace it with a clean file from a fresh download of MyBB
Just delete ./inc/settings.php and let it regenerate.

(2011-03-30, 06:18 PM)Yaldaram Wrote: [ -> ]Replace it with a clean file from a fresh download of MyBB

settings.php is empty in a fresh download, you can just delete it...
Doesn't regenerate. Thanks for help I had to reinstalled for it to worked.
I'm getting this mysql error on whatever links I clicked.

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

It looks like you haven't run ./install/upgrade.php, otherwise the column would be there, run it again to make sure.
(2011-03-31, 01:59 PM)Yaldaram Wrote: [ -> ]It looks like you haven't run ./install/upgrade.php, otherwise the column would be there, run it again to make sure.

It was due to Pre-Fix Manager plugin

Now I'm using default Prefixes for the forum. Instead of coming out [name] on the pages
It came out as [4][name], [5][name]
In the source they wrote <strong>[4]</strong>
In the template I checked its {$prefix} only
So I'm not sure why that [4] is there.

Here is a screenshot of it.
[Image: numberinthreads.png]

Also I can't click Database Backups. When I clicked it loads and stay in the current page. Maintenance tabs on the AdminCP is also missing.

For more information on the number thread. here's the link www.btsxchange.com

Any idea how to fix it ?
Pages: 1 2 3