Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Vinotheca

Archived
  • Posts

    6
  • Joined

  • Last visited

Profile Information

Vinotheca's Achievements

  1. Jan, in the OS Admin panel I can't seem to find an error log, nor do I see one in the PHPAdmin page. Where can i look for it? My products table still looks unchanged from an original install (I've checked against the default install), I haven't installed any contribution modifying this. Just a quick check, current structure: products_id products_quantity products_model products_image products_price products_date_added products_last_modified products_date_available products_weight products_status products_tax_class_id manufacturers_id products_ordered If I look at the page source of the admin page (specials) I am opening, I get: ******* <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Promoties</td> <td class="pageHeading" align="right"><img src="images/pixel_trans.gif" border="0" alt="" width="80" height="65"></td> </tr> </table></td> </tr> <tr><form name="new_special" action="http://www.vinotheca.be/admin/specials.php?page=0&action=insert" method="post"> <td><br><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main">Artikel: </td> <td class="main"><select name="products_id" style="font-size:10px"></select><input type="hidden" name="products_price"></td> </tr> <!-- BOF Separate Pricing per Customer --> <tr> <td class="main">Klantengroep: </td> <td class="main"><select name="customers_group"><option value="0">Standaard</option><option value="1">Doorverkoper</option><option value="2">SteepConsult</option><option value="3">NextiraOne</option><option value="4">Abonnee</option></select> </td> <!-- EOF Separate Pricing per Customer --> </tr> <tr> <td class="main">Promotie prijs: </td> <td class="main"><input type="text" name="specials_price"></td> </tr> <tr> <td class="main">Vervaldatum: </td> <td class="main"><input type="text" name="day" size="2" maxlength="2" class="cal-TextBox"><input type="text" name="month" size="2" maxlength="2" class="cal-TextBox"><input type="text" name="year" size="4" maxlength="4" class="cal-TextBox"><a class="so-BtnLink" href="java script:calClick();return false;" onmouseover="calSwapImg('BTN_date', 'img_Date_OVER',true);" onmouseout="calSwapImg('BTN_date', 'img_Date_UP',true);" onclick="calSwapImg('BTN_date', 'img_Date_DOWN');showCalendar('new_special','dteWhen','BTN_date');return false;"><img src="images/cal_date_up.gif" border="0" alt="Calendar" title=" Calendar " width="22" height="17" align="absmiddle" name="BTN_date"></a></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><br><b>N.B. Aanbiedingen:</b><ul><li>Je kan een percentage in het veld invoeren dat van de prijs wordt afgetrokken, bijv.: <b>20%</b></li><li>Als u een nieuwe prijs invult moet het decimaalteken een '.' (decimale punt) zijn, bijv.: <b>49.99</b></li><li>Laat het Vervaldatum veld leeg om geen vervaldatum in te geven</li></ul></td> <td class="main" align="right" valign="top"><br><input type="image" src="includes/languages/dutch/images/buttons/button_insert.gif" border="0" alt="Invoegen" title=" Invoegen "> <a href="http://www.vinotheca.be/admin/specials.php?page=0"><img src="includes/languages/dutch/images/buttons/button_cancel.gif" border="0" alt="Annuleer" title=" Annuleer "></a></td> </tr> </table></td> </form></tr> </tr> </table></td> </tr> </table></td> ************ The line that gives the issue is: <td class="main"><select name="products_id" style="font-size:10px"></select><input type="hidden" name="products_price"></td> I would have expected here a select query from the products table instead, but am at a loss why it's not displaying anything (it did so before installing SPCC). Regards, Philippe
  2. Jan, I have added to my site (vinotheca.be) the 'get1free_v13', the 'order_editor_v5066' with both UK, NL & FR language files. All worked well and I recently added 'spcc_422'. SPCC as such works well and I have defined several groups. However, I am no longer able to use the 'get1free' module nor the 'specials' module (which was adapted for SPCC): The field (dropdown box) where you select the product to which you apply the discount or '1 free' remains empty, making it impossible to select a product. I can't seem to figure this out: using Windiff I scanned for changes, but the specials.php files are the ones from the SPCC contribution. Would it be possible that my DB is corrupted for not displaying the products in the dropdown box? Or am I missing something elsewhere? I am quite novice to PHP, sure would appreciate some help. Any clues for me? Regards, Ph Delete Post
  3. Jan, In the Admin panel indeed, when I go to "Catalog / Specials / New product" I have a screen where I can select the product that will receive the promotion, a box to select the 'customer group' that this promotion applies to, and of course the price & date. It is the 'product dropdown box' that remains empty, the list seems to display no product at all. I am no whiz in DB debugging, so can't seem to figure out which query it is that now no longer works, any idea ? Thanks, Philippe - Vinotheca
  4. Hi Installed version 4.2.2, works fine & helps me maintain prices for 5 types of customers. Many thanks to all contributors who made all those versions & improved on it. Only issue I have (twice in fact, but same issue in each): both in the SPECIALS module & in the GET 1 FREE module the product dropdown box remains empty. I can no longer select any products to add a promotion to, which is kind of awkward. Anyone an idea in which file I should add which section to enable my dropdown boxes to be populated again?
  5. I've installed SPPC v2.2 and it seems to work quite fine (manual installation as several other items also changed). All now seems to work fine, except for one feature: if you try to change the sort order of the product listing (by default the list is sorted on product name & this works fine), I get an SQL 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 'order by final_price , pd.products_name limit 0, 50' at line 1 select p.products_image, pd.products_name, m.manufacturers_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '24' order by order by final_price , pd.products_name limit 0, 50 >> I am no SQL wizard, but indeed it seems the last part of the statement is something my version of MySQL cannot translate. Anyone out there that could help me out here? Regards, Philippe
×
×
  • Create New...