The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
SQL synax problem
PHP Code:
'id'' at line 7 Error Number : 1064 im thinking that theres an extra comma some where near id |
#2
|
||||
|
||||
look at your last three lines.... now tell me where the ending ") is for the first line.
|
#3
|
|||
|
|||
what do you mean ending? i put an ending parentheses at the end of ") but still no go
|
#4
|
||||
|
||||
Yeah, so where is the ending paren to the UNIQUE ( that you have?
|
#5
|
|||
|
|||
oh ok
PHP Code:
|
#6
|
||||
|
||||
You're still missing a closing parenthesis (from right after the dbhVictims), and you may also want to get rid of the ` symbol. In Perl the `operator performs a system command and PHP is supposed to be Perl embedded in HTML (but I'm unclear as to the status of the ` operator in PHP).
Try this instead... PHP Code:
|
#7
|
|||
|
|||
yeagh i thought those tick marks looked weird...
edits.. its not going into the database for some reason |
#8
|
||||
|
||||
There's nothing wrong with the backticks in a MySQL command. I know of many .SQL files that use them. Using the ` operator can be confusing in Perl though. It's not required, so why put them in?
|
#9
|
|||
|
|||
yeagh... its still not going into the database tho
there is actually no syntax errors now its just not going in when i upload the product |
#10
|
||||
|
||||
Well it might have to do with the IF NOT EXISTS that you gave it. If you ran this code with the wrong syntax then it may have created an empty table. Then when you ran it a second time the empty table was there and it didn't issue the create statement again.
Whatever method you're using to view your database, you may be missing the table. Sometimes viewers sort based on the capital letters and the lower case letters. If it's a web-based viewer then you may need to close it down and open it again (browser cache could mess you up). |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|