Error in my syntax? I can't see it

[Atealtha]

I'm losing hair over this. Please tell me where my syntax is wrong

update
	setting
set
	title 			= 	'blah',
	uri 			= 	'foo',
	newscount 		= 	1,
	timezone 		= 	-5,
	articlecount 	= 	10,
	showlength 		= 	150,
	absolutepath 	= 	'/blah/etc/etc/'
where
	setting_id 		= 	1

This is what the error said:

Notice: 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 ' showlength = 150, absolutepath = '/blah/etc/etc' in ...

[MikeBigg]

I can't see it either. Can you post your table definition?

Mike

[Atealtha]

exported from phpMyAdmin

CREATE TABLE `setting` (
`setting_id` tinyint(3) unsigned NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`uri` varchar(200) NOT NULL default '',
`newscount` tinyint(3) unsigned NOT NULL default '0',
`timezone` tinyint(4) NOT NULL default '0',
`articlecount` tinyint(3) unsigned NOT NULL default '0',
`showlength` smallint(5) unsigned NOT NULL default '0',
`absolutepath` varchar(250) NOT NULL default '',
PRIMARY KEY (`setting_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

[MikeBigg]

Hmmm. Still can't see it, but then it is 3:30am

I must go ... good luck.

Mike

[r937]

the reason you can't see it, mike, is because it isn't there



thanks for the CREATE TABLE statement, Atealtha

i ran it, then i added a few rows, then i ran your UPDATE and it worked fine

where did you get the UPDATE statement from? it looks cut-n-pasted

there's gotta be something else in the sql that's not showing up here

the UPDATE statement as shown is fine