Jump to content

Search the Community

Showing results for tags 'mysql'.

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. Hi everybody: My site based on Oscommerce 2.2 is restricted by my server provider almost one week. After optimization of the Database and removing some suspicious files, they still told me the MySQL resources were stressed heavily during the short 3 minutes period, and more than half of the resources they allow over time were exhausted. Does it happen on anybody here? Have to tell the background: This site we use many years, same as this hosting plan provider. I didn't do too much customization on this site cause I don't know programming, especially for the code about Database. I dont know why it suddenly caused such a problem, we don't have lots of visitors, 300 or 400 hundred visits per day. Recently I bought this company's SSL to keep site safe, then they suggest me to upgrade to a separated server I tried but failed cause of version of PHP.(yes the site is quite old version, we should and will upgrade it. ) Now, the problem comes, the site is restricted, and I received the mail to ask me optimize, then I did optimization of database, and other things i can do like to check files, compare the codes related between new and old version, the site is still blocked. I want to ask if the problem is produced by our data, for example, there are 16300 records in table "products"(data shows 1.2MiB, Index 395Kib). Is it too many? Now we just stuck at this point don't know what else we can do. Are there anybody can give me a help, I will really appreciate it.
  2. I've been building some new interfaces on my shop, and have realized that I would like to use mysqli_fetch_all, so I added it into my database.php. It might be a useful function to have in osC. Just a proposal. function tep_db_fetch_all($db_query) { return mysqli_fetch_all($db_query, MYSQLI_ASSOC); }
  3. I am looking to create a google feed for my instance of osCommerce. However, I have the ultimate SEO URL's 5 installed on my 2.3.1 instance. How do I get the product URL's for each product at they are not stored in the database in the products table? Any help would be appreciated.
  4. Native MySQL extension is slightly faster than the improved MySQLi extension, but the latest more stable and have more features. This addon simply replicate the default database function, so you don't have to worry that you need to edit many files. The installation process as easy as uploading a file (database_mysqli.php) and edit one line in application.top.php. As a bonus, this addon add new tep_db_multi_query function (see: mysqli.multi-query.php), so now you can make multi query in one call. Sample of using "tep_db_multi_query" can be found in the archive. Download it here: http://addons.oscommerce.com/info/8168 Best, @zaenal