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
Yes it has been uninstall. Sorry for the trouble wasn't sure if you were moving the threads. But this is an old thread just that I changed the title. I didn't recreate a new thread. So is the best fix = reinstall ? I don't mind reinstalling but I wanna know if I can get the user database.
Run these queries in phpMyAdmin:

CREATE TABLE IF NOT EXISTS `mybb_threadprefixes` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prefix` varchar(120) NOT NULL DEFAULT '',
  `displaystyle` varchar(200) NOT NULL DEFAULT '',
  `forums` text NOT NULL,
  `groups` text NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;

ALTER TABLE `mybb_threads` ADD `prefix` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `subject`;
So run this under mybb_threadprefixes ? As I got the table already for mybb_threadprefixes
Ok so I got SQL > Paste that code in box ?
In that case just run the second one then.
Alright ! I got it working THANKS ! I appreciate it a lot and sorry for the troubles earlier on because of the threads. SOLVED !
Thread Prefixes. I've set it already but it doesn't come out.

[Image: threadprefixes.png]
New problems. I've set the Avatar Size @ 100x100 but when in posts / threads it's 80x80.

Anyone knows how to fix or is it pre-set in templates ?
Pages: 1 2 3