Issue with Specials page in combination with SPCC

[Vinotheca]

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

[Jan Zonjee]

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?

[Vinotheca]

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