Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Issue with Specials page in combination with SPCC


Recommended Posts

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

Link to comment
Share on other sites

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?

I'm not familiar with either of the above mentioned contributions but the specials page doesn't do very fancy queries to if changes were made to say the table products I wouldn't expect any problems.

 

The blank dropdown may indicate an sql error. Did you check the error log?

Link to comment
Share on other sites

I'm not familiar with either of the above mentioned contributions but the specials page doesn't do very fancy queries to if changes were made to say the table products I wouldn't expect any problems.

 

The blank dropdown may indicate an sql error. Did you check the error log?

 

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...