Jump to content
Latest News: (loading..)

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
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • Club osC's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 7 results

  1. Imperiodocha

    Osc V2.2RC2 sql (?) Error

    Hello all, I have a webstore running many years now in OSC V2.2rc2 and never upgraded to other version because for what I need this works perfect. My webhost changed server, and from thet point on my main page, where shopping cart should be, this appears: 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'vooghhhx_osc2.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '374' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10 [TEP STOP] I have searched many solutions but have not found one so far. Costumers cannot login to their accounts, or add nothing to shopping cart. From what i've read tgisd has something to do with sql, but i cannot find a solution. can anyone be of any help? thanks all very much
  2. zetap

    Developer guide

    I am a programmer and I have to do a development on an existing oscommerce site, as it is the first time I work on this platform, I am looking for, if it exists, some kind of developer guide on oscommerce, on the official site, I have not been able to find any. If anyone has information about it, I thank you from now on Regards !
  3. Mort-lemur

    Set Values in Database

    Hi, Im looking to run a simple sql command to set all values in a database column to 0. To be more specific Im looking to unsubscribe all registered customers from the newsletter so table would be "Customers" and column would be "customers_newsletter" - I have googled solutions but there seems to be a couple of methods - and as always, with running sql commands the scope for disaster is huge - so I would be grateful if someone could give some expert advice please :) I know there is a large thread running on GDPR so I dont want to cloud that thread. Many Thanks
  4. Hello wonderful people of the osCommerce forums! My client would like a stock control system wherein he could look at all of the products on the website that are out of stock. I have not, so far, found any contribs for this at all, hence my post. By executing the following SQL query in PMA (SELECT * FROM `products` WHERE `products_quantity` = 0), I have managed to list the products that are out of stock. However, I would like a way to display this in the Administrative 'side' of osCommerce in some sort of simplistic layout. Any help whatsoever would be great! Thanks, J
  5. 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
  6. katapofatico

    LIMIT 1 optimization

    I'm migrating to osc 2.3.x from a old osc version. I'm surprised because I see again SQL SELECT queries without "LIMIT 1" optimizations. An example, on application_top.php: for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'"); // possible LIMIT 1 optimization if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); [...] } ...few lines more and again: if (isset($HTTP_GET_VARS['products_id'])) { $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); // possible LIMIT 1 optimization if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); [...] } } Do you imagine how much the performance is downgraded? It's a basic best practice developing: don't you plan implement it? Thanks in advance
  7. 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