vb.org Archive - sql error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - sql error (https://vborg.vbsupport.ru/showthread.php?t=258826)

regitbull

02-13-2011 05:55 PM

sql error

Ey,

Im trying to input a valua into a table field.

I added 3 colums to the user table called type,points and dateline.
I want to make it edit the values of a user.

So lets say we have a user called testuser with userid1.

I want to make it write values into the fields of userid1.

I tried this code:

Code:

        $vbulletin->db->query_write("

                INSERT INTO

                        ".TABLE_PREFIX."user WHERE userid = ".$userid.",,

                SET

                        type = 1,

                        points = '".$points."',

                        dateline = ".TIMENOW."          

        ");

So what this code needs to do is first search the table user for userid1.
Then it will edit the fields of userid1 and add the values of the script.
When i run the script i get this error:
Error Number : 1064

Could you guys tell me whats wrong with this code and show the fix.
I tried to google it but could not find a solution.

I dont know much about sql im only editing a existing mod.

Thx for the help

kh99	02-13-2011 06:21 PM

I think 1064 just means there's an error in the SQL. I think you'd want to use UPDATE instead of INSERT if you want to change an existing row (but maybe INSERT works too, I'm not sure). In the mysql manual the syntax for UPDATE (http://dev.mysql.com/doc/refman/5.0/en/update.html) shows the WHERE coming after the SET, but I don't know if that's a requirement.

Also, you have two commas at the end of the WHERE line that probably shouldn't be there.

All times are GMT. The time now is 04:46 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01164 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: