The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Invalid sql INSERT
PHP Code:
Database error in vBulletin 3.5.3: Invalid SQL: INSERT INTO armyintelreports (id, time, from, target, type, result, spies_sent, spies_caught, sab_item, sab_amount) VALUES ('37', 1141168830, 'Nullified', 'jasondoe', 'sab', 'Aborted', '1', '0', 'Indestructable Shield', '1'); 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 'from, target, type, result, spies_sent, spies_caught, sab_item, sab_amount) VALU' at line 1 Error Number : 1064 never mind. had to wrap the from and type fields in `. |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
I have changed the fields, but what symptoms are you referring to?
|
#4
|
|||
|
|||
Symptoms = the error message.
Adding ` around them only removes the symptom (the error) Renaming them is removing the cause of the error (and will prevent future problems like running in strict mode or trying to export/import your database). |
#5
|
|||
|
|||
k, thanks for the heads up.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|