pls help me
mySQL error: 1146
Table 'db_tracker.mybb_threads' doesn't exist
Query: SELECT f.*, t.subject AS lastpostsubject FROM mybb_forums f LEFT JOIN mybb_threads t ON (t.tid = f.lastposttid) WHERE active!='no' ORDER BY f.pid, f.disporder
thanks
you haver to give us more details:
Where was this?
What were you doing?
How long have you gotten this error for?
Hi all!
I ahve managed to sort out the problem with MySQL error 1146. The error is caused because these lines here:
Quote:KEY subject (subject),
FULLTEXT KEY subject_2 (subject)
desn't seem to be compatible with MySQL 4.1.x as when it goes to create the table
mybb_threads it doesn't report back an error or anythink it just says done! Even tho it hasn't made the table for mybb_threads.
To solve it open up
db_tables.php and find the follwoing:
Quote:$tables[] = "CREATE TABLE mybb_threads (
tid int(10) NOT NULL auto_increment,
fid smallint(6) NOT NULL default '0',
subject varchar(120) NOT NULL default '',
icon smallint(6) NOT NULL default '0',
poll smallint(6) NOT NULL default '0',
uid smallint(6) NOT NULL default '0',
username varchar(80) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastpost bigint(30) NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
views int(100) NOT NULL default '0',
replies int(100) NOT NULL default '0',
closed varchar(30) NOT NULL default '',
sticky smallint(6) NOT NULL default '0',
numratings smallint(6) NOT NULL default '0',
totalratings smallint(6) NOT NULL default '0',
notes text NOT NULL,
visible smallint(6) NOT NULL default '0',
messageindex text NOT NULL,
subjectindex text NOT NULL,
PRIMARY KEY (tid),
KEY subject (subject),
FULLTEXT KEY subject_2 (subject)
);";
and replace with:
Quote:$tables[] = "CREATE TABLE mybb_threads (
tid int(10) NOT NULL auto_increment,
fid smallint(6) NOT NULL default '0',
subject varchar(120) NOT NULL default '',
icon smallint(6) NOT NULL default '0',
poll smallint(6) NOT NULL default '0',
uid smallint(6) NOT NULL default '0',
username varchar(80) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastpost bigint(30) NOT NULL default '0',
lastposter varchar(120) NOT NULL default '',
views int(100) NOT NULL default '0',
replies int(100) NOT NULL default '0',
closed varchar(30) NOT NULL default '',
sticky smallint(6) NOT NULL default '0',
numratings smallint(6) NOT NULL default '0',
totalratings smallint(6) NOT NULL default '0',
notes text NOT NULL,
visible smallint(6) NOT NULL default '0',
messageindex text NOT NULL,
subjectindex text NOT NULL,
PRIMARY KEY (tid)
);";
and all should be well!
Also to Chris or Musical that you should add this change or a better fix to your current downloadable version of MyBB.
Well that should solve it!
EDIIT: Sorry for the double post and that. It was just to make this thread noticable.
Thanks for pointing that out wildteen88. We'll be looking into this issue.