Can someone please look at mysql error

[tauntry]

Hello all! I have recently downloaded oscommerce. I am trying to add the extra stores so my affiliates can share the cart. I have done everything to make the tables (and I'm new at this so I gave myself a pat on the back) But when (of course had problems on the last line) I tried to install the last insert I get this error. Can someone please help me?

 

**** Warning this is an adult website****

Error

 

SQL query: Documentation

 

INSERT INTO stores( stores_id, stores_name, stores_image, stores_url, stores_config_table, stores_status, stores_admin_selected, date_added )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', , '1', now( )

)

 

MySQL said: Documentation

#1064 - 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 ''1', now())' at line 1

 

 

Now when I log on it does have the drop down menu and it seems to want to work. Does any one know what the heck I'm doing wrong

 

Thanks NEWBIE!!!!

[Loon]

**** Warning this is an adult website****

Error

 

SQL query: Documentation

 

INSERT INTO stores( stores_id, stores_name, stores_image, stores_url, stores_config_table, stores_status, stores_admin_selected, date_added )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', , '1', now( )

)

 

You have an extra comma between here: '1', , '1', now( )

 

8 fields, 9 arguments to the fields, remove the red comma.

[tauntry]

You have an extra comma between here: '1', , '1', now( )

 

8 fields, 9 arguments to the fields, remove the red comma.

OK now I get this and yes its working now but i know if it's not exact I will encounter problems later on down the road. So I better check with you guys before I loose anyones data.

SQL query: Documentation

 

INSERT INTO stores( `stores_id` , `stores_name` , `stores_image` , `stores_url` , `stores_config_table` , `stores_status` , `stores_admin_selected` , `date_added` )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', '1', now( )

)

 

 

error you have aduplicate in line one on '1'

 

SQL query: Documentation

 

SQL query : Documentation INSERT INTO stores( `stores_id` , `stores_name` , `stores_image` , `stores_url` , `stores_config_table` , `stores_status` , `stores_admin_selected` , `date_added` )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', '1', now( )

)

 

MySQL said: Documentation

#1064 - 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 'SQL query: Documentation

 

INSERT INTO stores( `stores_id` , `stores_name` , `s' at line 1

 

And I dont dare add nay themes on , I m scared . An auto installer would be ideal , is anyone working on one?

 

 

But thanks for your help will donate a few bucks to your project.

[tauntry]

OK now I get this and yes its working now but i know if it's not exact I will encounter problems later on down the road. So I better check with you guys before I loose anyones data.

SQL query: Documentation

 

INSERT INTO stores( `stores_id` , `stores_name` , `stores_image` , `stores_url` , `stores_config_table` , `stores_status` , `stores_admin_selected` , `date_added` )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', '1', now( )

)

error you have aduplicate in line one on '1'

 

SQL query: Documentation

 

SQL query : Documentation INSERT INTO stores( `stores_id` , `stores_name` , `stores_image` , `stores_url` , `stores_config_table` , `stores_status` , `stores_admin_selected` , `date_added` )

VALUES (

'1', 'Default', 'oscommerce.gif', 'http://www.knaughtyknickers.com/', 'configuration', '1', '1', now( )

)

 

MySQL said: Documentation

#1064 - 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 'SQL query: Documentation

 

INSERT INTO stores( `stores_id` , `stores_name` , `s' at line 1

 

And I dont dare add nay themes on , I m scared . An auto installer would be ideal , is anyone working on one?

But thanks for your help will donate a few bucks to your project.

 

 

Now it seem more probs...

tried to log in to my admin

and recieved this

 

1146 - Table 'bleep_osc1.bleep' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from tauntry

 

[TEP STOP]