Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can someone please look at mysql error


tauntry

Recommended Posts

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!!!!

Link to comment
Share on other sites

**** 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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...