The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
What is wrong with this query?
This is probably something really easy that I'm an idiot for not spotting...
Code:
INSERT INTO mylogs( `occur`,`ip`,`ip2`,`agent`, `refer`,`request`,`host`,`lang`, `chars`,`encode`,`accept`,`protocol`, `port`,`con`,`query_string`,`remote_user`, `path_info`) VALUES( `1204953122`,`########`,``,`Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12`, ``,`/awesome.php`,``,`en-us,en;q=0.5`, `ISO-8859-1,utf-8;q=0.7,*;q=0.7`,`gzip,deflate`,`text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5`,`HTTP/1.1`, `80`,`keep-alive`,``,``, ``) Note: IP replaced with #### |
#2
|
||||
|
||||
What's the error it's telling you?
|
#3
|
|||
|
|||
Code:
#1054 - Unknown column '1204953122' in 'field list' |
#4
|
|||
|
|||
Use `table` for defining tables and columns and 'some kind of data' for data.
|
#5
|
|||
|
|||
I would try it without any single quotes (backward apostrophe) in the first half of the statement
then in the values part, use the single quote ' character instead of the ` backward apostrophe. |
#6
|
|||
|
|||
Quote:
|
#7
|
||||
|
||||
You only really need to use backticks (`) if you're using reserved MySQL keywords.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|