Jump to content

Search the Community

Showing results for tags 'sql'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Developer Feedback
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 4 results

  1. Hello, I have a store installation (CE FROZEN, PHP 7.2) with very slow loading admin/categories.php, maybe 20-30 sec. Characteristics for products/chategories: products aprox. 1800 products_to categories aprox. 20000 (products are linked to several categories) categories aprox. 6000 The big number of categories and product links may explain the slow loading. Database tables have been analysed and optimized, they are all using MyISAM and the index settings in the tables are all correct (core). But I observe the following difference between server and local develop installation under XAMPP: Server: always the same loading time XAMPP: slow loading on first time page load rel. fast loading on second and following page loads (2-3 sec.) So my conclusion is that it should be related to a database cache setting. I checked the sqli settings in php.ini of the XAMPP installation and tried to lower mysqli.cache_size=2000 to a very low setting (10) in order to simulate the server problem but no difference. Questions: With the amount of products/categories/links does it sound reasonable this slow loading? Which setting on the server/database can produce this different behaviour Thank you in advance Rainer
  2. Hi Everyone, Hope everyone is keeping safe and well in these scary times. Im looking to run an sql to increase the shipping weight of products if under 1kg to 1.1kg leaving all other weights unchanged. Could do with some help as I dont want to destroy my database Many Thanks
  3. 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
  4. 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