The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
problem running query for toplist hack
this is the error i get trying to run it... the other 2 querys for it run perfectly fine no problems, but this one wont... anybody got any idea why it wont work? this is what the error says
Database mvzsvhjf_forums running on localhost Error SQL-query : CREATE TABLE toplist_settings( settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT , title varchar( 50 ) NOT NULL default '', value varchar( 20 ) NOT NULL default '', PRIMARY KEY ( settingid ) ) INSERT INTO toplist_settings VALUES ( '1', 'lastreset', '20020402' ) MySQL said: #1064 - 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 'INSERT INTO toplist_settings VALUES('1','lastreset','20020402') |
#2
|
||||
|
||||
There are 2 queries theres, so try running each one seperatly:
[sql] CREATE TABLE toplist_settings( settingid int( 11 ) unsigned NOT NULL AUTO_INCREMENT , title varchar( 50 ) NOT NULL default '', value varchar( 20 ) NOT NULL default '', PRIMARY KEY ( settingid ) ) [/sql] and then [sql] INSERT INTO toplist_settings VALUES ( '1', 'lastreset', '20020402' ) [/sql] |
#3
|
|||
|
|||
oooo i didnt know that :-\ in the queries.txt file it showed it as one.. but now i know that ill try it now... thanks ill let u know if it worked
|
#4
|
|||
|
|||
wahoooo it worked lol
:-D thank you man i really appreciate that |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|