Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    John Tikis
  • Website
  1. Problem solved by manually inputting data in the DB.
  2. I just installed v1.14 and I get the following errors in the admin section, in all link files: admin/links.php 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 '-20, 20' at line 1 select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from links l left join links_description ld on l.links_id = ld.links_id order by ld.links_title limit -20, 20 admin/link_categories.php 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 '-20, 20' at line 1 select lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from link_categories lc left join link_categories_description lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '4' order by lc.link_categories_sort_order, lcd.link_categories_name limit -20, 20 admin/links_status.php 064 - 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 '-20, 20' at line 1 SELECT l.links_id, l.links_reciprocal_url, l.links_status, ld.links_id, ld.links_title, lc.links_id, lc.date_last_checked, lc.link_found, ls.links_status_name from links l LEFT JOIN links_description ld on l.links_id = ld.links_id LEFT JOIN links_check lc on l.links_id = lc.links_id LEFT JOIN links_status ls on l.links_status = ls.links_status_id and ls.language_id = '4' limit -20, 20 [TEP STOP] Any ideas?
  3. I installed PDF datasheet and it was working fine. All of a sudden, without any apparent change in php files or server config, the script stopped outputting data. In detail, when PDF datasheet icon is selected, the new browser page comes up, PDF reader loads but nothing is transferred. Instead, the conneciton times out. I searched apache's & php logs but could not find anything related to this incident. Any ideas?
  4. mx5gr


    Hi to all, Is there a BTS compatible version of the catalog/includes/boxes/coolmenu.php ?
  5. mx5gr

    SQL error

    Hi to all, I just upgraded to visitors 2.2d and I get the following error within admin when I try to view the visitor stats (visitors.php): 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 '-20, 20' at line 1 SELECT * from visitors WHERE TO_DAYS(date) >= TO_DAYS('2005-9-01') AND TO_DAYS(date) <= TO_DAYS('2005-10-01') - 1 AND SUBSTRING(browser_language,1,1) != '[' order by online DESC limit -20, 20 Any ideas?
  6. mx5gr

    [Contribution] Product Sort Order

    I just installed the latest 1.5b version and it seems to be working fine, apart from one major glitch: When I open the product sorter in the admin area, all products within categories are displayed correctly. I have some products, however, that they have not been entered in a category. For these products (that is, in the top level) I don't see anything, I see a blank page (they are not displayed). The contrib works perfectly with any product that is inside a subcategory. Has anyone noticed the same?
  7. mx5gr

    Multi-Stores Multiple Shops Support

    Hi Ryan, Thanx for the info. I took your advice and made the following easy code: // set the store id if (tep_session_is_registered('customer_id') && (($HTTP_GET_VARS['stores_id'])=='')) { $stores_query = tep_db_query("select stores_id as cust_store_id from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); $stores = tep_db_fetch_array($stores_query); $stores_id = $stores[cust_store_id]; tep_session_register('stores_id'); } if (!tep_session_is_registered('stores_id') || isset($HTTP_GET_VARS['stores_id'])) { if (!tep_session_is_registered('stores_id')) { $stores_id = '1'; tep_session_register('stores_id'); } if (isset($HTTP_GET_VARS['stores_id']) && tep_not_null($HTTP_GET_VARS['stores_id'])) { $stores_id=$HTTP_GET_VARS['stores_id']; } } define('STORES_ID',$stores_id); Sorry if it is a bit crude, but it does the job. Basically, what it does, is that if a user is registered in, then STORE_ID is obtained from an additional column stores_id defined in customers table. This is set during register. If a user is not logged in, then he/she is redirected to the default shop (with id 1 in my example). If a user is registered, then stores_id is obtained from the database corresponding to this user and is valid throughout the user session. Hands up for this great mod!
  8. mx5gr

    Multi-Stores Multiple Shops Support

    I managed to fix all conflicting code and the contributions now work fine. Another (and last) silly question: How is STORE_ID retrieved in order to be used throughout the scripts. In other words, I am looking a way of using the existing multi stores installation but STORE_ID is declared as a session variable, or otherwise, when and only a user logs in. I have the problem of creating virtual stores under the same url and the distinction is made based on delivery address. I am not well in PHP coding and I have been trying to find out how the catalog (not the admin) distinguishes between stores during ordering, so that it marks product A as ordered from store A and product B ordered from store B. Any ideas?
  9. mx5gr

    [contribution] Total B2B

    I installed the 1.1 version of B2B over a clean MS2 installation patched with multi stores 1.4. I am running on a curious problem. First of all, all prices in the catalog show as 0. Regardless, I get this error in the "What's new" box: Warning: Missing argument 3 for display_price() in E:\Miata\dividi\includes\classes\currencies.php on line 72 Line 72 is function display_price($products_id, $products_price, $products_tax, $quantity = 1) { Any ideas?
  10. mx5gr

    Multi-Stores Multiple Shops Support

    Hi Ryan, B) for the quick response! I just downloaded it and I'll apply it to my demo site tonight. Just a question (I haven't dug your code yet to see how you do it). I am interested in a multi shop system that has the features that your script provides but all the shops use the same URL. I noticed from my installed release that the products table is shared among all shops and when someone buys something from shop A, the item quantity is removed from the master, one and only, products table. Hence, if someone wants to buy the same item from shop B, then the quantity that this shop shows is the one which has been affected by the shop A purchase. In other words, according to postal code after logging in, the customers can choose between different or overlapping sets of products. For example: If the customer has not logged-in yet, then he/she can see all products in the system. If however he/she decides to make a purchase and logs in, then (according to postal code) he is displayed the products that can be delivered in his area. Oh, I forgot to mention that shop A and shop B serve different areas in terms of postcode. I am still experimenting with this feature of oSC, hence excuse me if my question seems trivial. Last but not least, thumbs up for the excellent work!
  11. mx5gr

    Multi-Stores Multiple Shops Support

    I have ran upon another issue. I create shop A from the "Stores" option within the Admin panel and everything goes out fine. Details: Store Name-> Store A, Store URL-> http://localhost/, Configuration table-> configuration_1 I then create the second store, Store B, with details: Store Name->Store B, Store URL->http://localhost/2/, Configuration table-> configuration_2 and the box ticked to include the default config. This then destroyed completely osC, since the scripts were looking for configuration table, which no longer existed. After restoring the database structure (plain vanilla MS2 with your files overwriting the clean install), I did not declare the config table nameon Store B and I left the "insert default configuration table" checked. I got: 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 '(configuration_id int NOT NULL auto_increment, configuration_ti CREATE TABLE (configuration_id int NOT NULL auto_increment, configuration_title varchar(64) NOT NULL, configuration_key varchar(64) NOT NULL, configuration_value varchar(255) NOT NULL, configuration_description varchar(255) NOT NULL, configuration_group_id int NOT NULL, sort_order int(5) NULL, last_modified datetime NULL, date_added datetime NOT NULL, use_function varchar(255) NULL, set_function varchar(255) NULL, PRIMARY KEY (configuration_id)) Any ideas?
  12. Where can this module be downloaded?
  13. I installed the mod, which is installed as a module within Catalog. However, the SQL syntax may be incorrect, since it does not show up unique categories on the main page but it displays all main categories in all languages entered. For example, if we have two categories called "Tables" and "Chairs", they will be shown 4 times, twice for English & French each. Can someone check the SQL syntax and point any errors found? I attach the code of the module. Thank you in advance. <?php /* $Id: also_purchased_products.php,v 1.21 2003/02/12 23:55:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License Contribution by Diego Discacciati */ ?> <!-- main categories/ pictures and name//--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf('Main Categories', strftime('%B'))); new contentBoxHeading($info_box_contents); $new_products_query = tep_db_query("select p.categories_id, p.categories_image, s.categories_name from " . TABLE_CATEGORIES . " p left join " . TABLE_CATEGORIES_DESCRIPTION . " s on p.categories_id = s.categories_id where parent_id = '0' order by p.sort_order limit " . MAX_DISPLAY_NEW_PRODUCTS); $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $info_box_contents[$row][$col] = array( 'align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $new_products['categories_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['categories_image'], $new_products['categories_name'], 70, auto) . '</a><br><a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $new_products['categories_id']) . '">' . $new_products['categories_name']); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); ?>
  14. mx5gr

    PDF-Catalog Problem

    I am running into another problem. Irrespective of the image format, when I'm trying to create a PDF catalogue within admin, I get an error since imagecreatefrompng & imagecreatefromjpg functions that are called within php_catalogue.php do not exist. Any ideas?