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
  • 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

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name




Found 5 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. 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
  4. 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
  5. 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