Apache2Triad Help, Support and Development Forum Index Apache2Triad Help, Support and Development
The apache2triad help , support and development forums
 

mySQL and vBulletin 3.0.7 Incompatibility
Click here to go to the original topic

 
       Apache2Triad Help, Support and Development Forum Index -> Apache2Triad Bugs
View previous topic :: View next topic  
Author Message
pathological



Joined: 26 May 2006
Posts: 1

Posted: Fri May 26, 2006 8:18 pm    Post subject: mySQL and vBulletin 3.0.7 Incompatibility  

Just a heads up, i had a problem with vBulletin 3.0.7 with the latest apache2triad. I had 1 problem when trying to click on a link for the UserCP. I copied the information to a mySQL forum and they told me why, not sure if is hould post it here or directly to mySQL but here is a good start.

BTW i used the OLD phptriad and the option works fine. So it does look like you need to downgrade your version of mySQL.

Here is the info and reason.

-Path
_____________
I just inasalled Vbulletin version 3.0.7
I get the following problem when i click on the UserCP option.
I am using Apache2triad as my software.
I can gain access to some UserCP options but no when i click on the UserCP link. I get the follwoing error.
Below is the error i get. Below that is the propperty of the table that i have exported.

CODE
Database error

Invalid SQL:
SELECT thread.threadid, thread.forumid
FROM thread AS thread, subscribethread AS subscribethread
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = 1
AND thread.visible = 1
AND lastpost > 1148663336
AND deletionlog.primaryid IS NULL

mysql error: Unknown column 'thread.threadid' in 'on clause'

mysql error number: 1054

Date: Friday 26th 2006f May 2006 01:11:47 PM
Username: pathological
IP Address: 127.0.0.1


CODE
DROP TABLE IF EXISTS `thread`;
CREATE TABLE IF NOT EXISTS `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`postusername` char(50) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` char(50) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
__________________
This error arises because the comma operator was used in the SELECT query. This query was not designed to work under the new MySQL 5 strict query parser, which treats commas as lower precedence than joins. Thus, it used to be that:

t1, t2 JOIN t3 ==> ( t1, t2 ) JOIN t3

But now:

t1, t2 JOIN t3 ==> t1, ( t2 JOIN t3 )

Obviously, t1 isn't part of the join, so you can't use a t1 field in the ON condition; hence the error.

I suggest you report this error to whomever supplied you with this software, or downgrade your MySQL version.
Back to top  
 
       Apache2Triad Help, Support and Development Forum Index -> Apache2Triad Bugs
Page 1 of 1


Powered by phpBB Search Engine Indexer
Powered by phpBB 2.0.13 © 2001, 2002 phpBB Group