New 
Search the Community
Showing results for tags 'sql'.
Found 4 results
-
Need to update product weights in bulk? One osCommerce user faced the challenge of correcting the weight of over 500 window decals without manual edits. The osCommerce support team provided a quick and efficient SQL solution to update all products at once. 👉 Read the full success story on the osCommerce Blog.
-
Struggling with outdated V2-style URLs in your osCommerce store? Learn how a simple SQL command and SEO-friendly naming can keep your rankings intact. Read the full success story on the osCommerce blog! -
MySQLi Prepared Statement Automator This Add-On comes with the only guarantee of possibly causing you a lot of headaches. It looks like it's working quite well, but further testing is required ... - Support Thread - http://addons.oscommerce.com/info/9076
-
Hi, As part of the installation of a contribution I have to run the following SQL database query: DROP TABLE IF EXISTS `products_cross_sell`; CREATE TABLE IF NOT EXISTS `products_cross_sell` ( `products_cross_sell_id` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `cross_sell_id` int(10) unsigned NOT NULL default '1', `cross_sell_sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`products_cross_sell_id`) ) TYPE=MyISAM; When I do this I get the following error message: #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 'TYPE=MyISAM' at line 7 Is there an obvious error does anyone know? Thanks David
