Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL syntax error


14steve14

Recommended Posts

I am trying to get this sql command to work, but phpmyadmin tells me ther eis a syntax error. Is there anyone that can tell what the problem is.

 

ALTER TABLE `products_description` ADD `products_spec` TEXT DEFAULT NULL AFTER `products_description`;

 

Its probably something stupid

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

Try this:

 

ALTER TABLE products_description ADD products_spec TEXT DEFAULT NULL AFTER `products_description`;

 

worked on my database, should be OK!

Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem....

Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums.....

if (stumped == true) {

return(square_one($start_over)

} else {

$random_query = tep_fetch_answer($forum_query)

}

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...