Theme installation help

[moogles]

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?

[ocularmagic]

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.

[moogles]

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)

[Guest]

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'),');

[moogles]

Thxs for the update (sorry for my late reply) that fixed the problem.... now to see what other problems their might be heh...

[TheExterminator]

how can i maek more end 5 ???