

DougieMac
Members-
Content count
12 -
Joined
-
Last visited
Profile Information
-
Real Name
Dougie MacIntosh
-
[Contribution] QTpro - Quantity Tracking Professional
DougieMac replied to zonetown's topic in General Add-Ons Support
Have went for a complete rebuild from scratch, so the previous post can be ignored -
Multiple Attribute entry boxes in product info page v1.0 for 2.3.1
DougieMac replied to peteravu's topic in General Add-Ons Support
Have went for a complete rebuild from scratch, so the previous post can be ignored -
[Contribution] QTpro - Quantity Tracking Professional
DougieMac replied to zonetown's topic in General Add-Ons Support
Ihave oscommerce v2.3.1 and have installed QT Pro. However when I go to do "REMEMBER: You must activate attribute tracking here: admin -> catalog -> product attributes ->" I get the following Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/....../public_html/catalog/myadmindir/products_attributes.php on line 284 the code in products_attributes.php around the area of line 284, with the BOLD section i believe to be line 284 is... <?php if (($action == 'update_option') && ($HTTP_GET_VARS['option_id'] == $options_values['products_options_id'])) { echo ' $inputs = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) { $option_name = tep_db_query("select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_values['products_options_id'] . "' and language_id = '" . $languages[$i]['id'] . "'"); $option_name = tep_db_fetch_array($option_name); $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20" value="' . $option_name['products_options_name'] . '"> <br>'; } ?> <td align="center" class="smallText"> <?php echo $options_values['products_options_id']; ?><input type="hidden" name="option_id" value="<?php echo $options_values['products_options_id']; ?>"> </td> <td class="smallText"><?php echo $inputs; ?></td> <?php Can anyone see what the problem is? Thanks in advance -
Multiple Attribute entry boxes in product info page v1.0 for 2.3.1
DougieMac replied to peteravu's topic in General Add-Ons Support
I have installed this contribution and get the following error when I go to the product page of an item I have set 2 attributes on. The attributes are :- Colour (red, white) Available Options: 1054 - Unknown column 'attributes_hide_from_groups' in 'where clause' select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='29' and patrib.options_id = popt.products_options_id and popt.language_id = '1' and find_in_set('', attributes_hide_from_groups) = 0 order by popt.products_options_name [TEP STOP] On another item where i have set five attributes :- Colour(blue, red and hematite) and Chain Length (16" 18") the drop down box for the colour displays fine but the dropdown for the length does not display. Any suggestions as to where I've went wrong? -
PHP Intrusion Detection System for osCommerce
DougieMac replied to celextel's topic in General Add-Ons Support
Ok, fresh look at the forum this morning and I found the solution. Doh! Apologies. -
PHP Intrusion Detection System for osCommerce
DougieMac replied to celextel's topic in General Add-Ons Support
Hi, Let me apologise first in case this problem has already been posted, but its late now and I cant find anything similar. I am hoping you can help me with this error :- 1146 - Table 'a4993375_msc.TABLE_BANNED_IP' doesn't exist select ip_address from TABLE_BANNED_IP where ip_status='0' [TEP STOP] when I try to access the shop, http://mywebsite/catalog/index.php. This occured when trying the test http://mywebsite/catalog/index.php.?id=1&test=">XXX. Prior to this test I could access the site easily. I am running oscommerce 2.3.1 on win xp64 with phpids 1.7 installed. Given that I am fairly new to php, can you point me to where I have went wrong. There are no entries in the PHPIDS log and no entries in the banned IP section.