The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Comments |
#12
|
||||
|
||||
Quote:
My forum has db prefix FORUM so will that be a problem? |
#13
|
|||
|
|||
Hello, I get this error :
Database error in vBulletin 3.5.0 Release Candidate 1: Invalid SQL: SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid , NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') WHERE thread.forumid NOT IN () AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost DESC LIMIT 0, 5; MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost Error Number : 1064 Date : Thursday, July 28th 2005 @ 09:26:18 PM Script : http://www.pixsell.com.ar/forums/index.php Referrer : http://www.pixsell.com.ar/forums/pri...=showpm&pmid=1 IP Address : 201.255.27.156 Username : admin Classname : vb_database any idea? |
#14
|
||||
|
||||
I get that too:
Database error in vBulletin 3.5.0 Release Candidate 1: Invalid SQL: SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid , NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason FROM FORUMthread AS thread LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter) LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') WHERE thread.forumid NOT IN () AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost DESC LIMIT 0, 5; MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost DE Error Number : 1064 Date : Friday, July 29th 2005 @ 12:31:36 AM Script : http://www.burnleyweb.com/community/index.php Referrer : http://www.burnleyweb.com/community/online.php IP Address : 212.***.***.*** Username : ******* Classname : vb_database |
#15
|
|||
|
|||
Ok the database errors are because you left the excluded forums setting blank, put a zero in there for now and it should be okay. I'll put in a check statement that will make sure this doesn't happen in the future.
To everyone else having troubles uploading the plugin. I should have stated this before. IT IS A PRODUCT to import it you must go into your admincp click the Manage Products link in the nav bar. Click [Add/Import Product] then import it. If you have already tried to import it then it is best if you select 'yes' for Allow Overwrite. If you are still having troubles then pm me with the exact problem and I will look into it. |
#16
|
||||
|
||||
im struggling to find where you mean, i though i did the above but it still gives me the error
|
#17
|
|||
|
|||
Ok, sorry the settings didn't export. It *should* be fixed now, just download the new zip and follow the instructions.
Again if there are any problems pm me, it is much easier that way =) |
#18
|
||||
|
||||
Quote:
|
#19
|
||||
|
||||
Quote:
Database error in vBulletin 3.5.0 Release Candidate 1: Invalid SQL: SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid , NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason FROM FORUMthread AS thread LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter) LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') WHERE thread.forumid NOT IN () AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost DESC LIMIT 0, 5; MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND deletionlog.primaryid IS NULL ORDER BY thread.lastpost DE Error Number : 1064 Date : Friday, July 29th 2005 @ 01:42:01 AM Script : http://www.burnleyweb.com/community/index.php Referrer : http://www.burnleyweb.com/community/usercp.php IP Address : 212.***.****.***** Username : ****** Classname : vb_database |
#20
|
||||
|
||||
my forum prefix is FORUM, that causing a problem?
|
#21
|
|||
|
|||
Are the settings in the vB options this time?
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|