Dear Joe!

I found the problem for a lot of issues in MySql queries
when a MySql server is running under linux systems, the table names are filenames (same as in win32 MySql server version) but, all Unix OS has case sensitive filenames.

So, the query

CREATE TABLE `mp_ForumThreads` (
`ThreadID` int(11) NOT NULL auto_increment,
`ForumID` int(11) NOT NULL default '0',
`ThreadSubject` varchar(255) NOT NULL default '',
`ThreadDate` datetime NOT NULL default '0000-00-00 00:00:00',
`TotalViews` int(11) NOT NULL default '0',
`TotalReplies` int(11) NOT NULL default '0',
`SortOrder` int(11) NOT NULL default '1000',
`IsLocked` tinyint(1) unsigned NOT NULL default '0',
`ForumSequence` int(11) NOT NULL default '1',
`MostRecentPostDate` datetime default NULL,
`MostRecentPostUserID` int(11) default NULL,
`StartedByUserID` int(11) NOT NULL default '0',
PRIMARY KEY (`ThreadID`),
KEY `FK_mp_ForumThreads_Forum` (`ForumID`),
CONSTRAINT `FK_mp_ForumThreads_Forum` FOREIGN KEY (`ForumID`) REFERENCES `mp_forums` (`ItemID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

of course fails, becouse there is no such table mp_forums.
it was creates with name mp_Forums

I just changed the case and it worked.
will be better to fix all the queries, to support Unix based Mysql versions.

thanks

Alexei Vladychevski (Алексей Владышевский)

Hey Joe, is this problem already fixed in 2.2.8.2 ?

or do i need to get the latest stuff from svn ?