Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Theme installation help


moogles

Recommended Posts

Was looking around

http://www.dcpcwebdevelopment.co.uk/instru...tions/index.htm

looks easy enough to install... so I grab a theme and start lookin at the instructions.

 

Step1... insert below line into OSC tables... thats easy enough... open phpmyadmin, clicked my main OSC database, opened the SQL and copy n pasted in the SQL code...

 

SInce I'm not the msot proficient SQL database programmer and all I looka t the error... and wonder...

 

Error



There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem



ERROR: Unclosed quote @ 242

STR: `

SQL: INSERT INTO `configuration` (`configuration_id`,configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`,`set_function`) VALUES('Site Theme Options&', 'STORE_THEME','black_orange','You can change site thema here.', '1', '19','2003-01-28 21:41:48', '0000-00-00 00:00:00','', 'tep_cfg_select_option(array('WhatsNew','original', 'blue', ' black_orange'),');

SQL-query :  



INSERT INTO `configuration` (`configuration_id`,configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`,`set_function`) VALUES('Site Theme Options&', 'STORE_THEME','black_orange','You can change site thema here.', '1', '19','2003-01-28 21:41:48', '0000-00-00 00:00:00','', 'tep_cfg_select_option(array('WhatsNew','original', 'blue', ' black_orange'),'); 



MySQL said: 



You have an error in your SQL syntax near ', `configuration_key`, `configuration_value`, `configuration_description`, `conf' at line 1

 

ohhhkay, thats nice so move on to the

 

Please Note!!

Should you get a database error when inserting the above

Please check the last number used in the configuration_id table and change the number 122 above to a number greater than the last used.

Numer 122... hmm, I don't see a 122 anywhere in

INSERT INTO `configuration` (`configuration_id`,configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`,`set_function`) VALUES('Site Theme Options&', 'STORE_THEME','black_orange','You can change site thema here.', '1', '19','2003-01-28 21:41:48', '0000-00-00 00:00:00','', 'tep_cfg_select_option(array('WhatsNew','original', 'blue', ' black_orange'),');

 

So... I browse the "configuration" database... configuration_id Value is 145... well that looks to be over 122...

 

So... what could be wrong?

Link to comment
Share on other sites

SQL: INSERT INTO `configuration` (`configuration_id`,configuration_title`, `configuration_key`,

 

That's the first line of the query. If you look really close you'll see that configuration_title doesn't have a beginning single quote. Hopefully that's it.

If every member of this board donated $1 to the dev team, that would be over $11,000.00. Don't you think this cart is worth at least a $1????

Link to comment
Share on other sites

SQL: INSERT INTO `configuration` (`configuration_id`,configuration_title`, `configuration_key`,

 

That's the first line of the query.  If you look really close you'll see that configuration_title doesn't have a beginning single quote.  Hopefully that's it.

 

removing the `'s around configuration didn't work, tried removing most all the ` and it still didn't work (spacing properly)

Link to comment
Share on other sites

moogles:

If you continued on your previous post

http://www.www.oscommerce.com/forums/viewtopic.php?t=44646

 

You would have seen that I have updated the instructions:

 

Try this:

 

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES('122', 'Site Theme Options', 'STORE_THEME','black_orange','You can change site thema here.', '1', '19','2003-01-28 21:41:48', '0000-00-00 00:00:00','', 'tep_cfg_select_option(array('WhatsNew','original', 'blue', ' black_orange'),');

Link to comment
Share on other sites

  • 2 years later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...