sputnikinternet
-
Posts
41 -
Joined
-
Last visited
Posts posted by sputnikinternet
-
-
I would be interested to find the latest version as well.
I thought i had th latest, but my own switch number is not accepted (it starts 675940).
It's strange cos when i look at the code, it look like it should be accepting it.
Any suggestions?
-
Hmmm
I seem to have fixed the SELECT blah blah problem.
For those that suffer the same gremlin, i took this code in index.php, and removed the bit in red cos it seemed to be putting too many commas in.
Hopefully this won't bring up problems elsewhere.
for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {
continue;
}
if (tep_not_null($select_column_list)) {
$select_column_list .= ', ';
}
switch ($column_list[$col]) {
case 'PRODUCT_LIST_MODEL':
$select_column_list .= 'p.products_model';
break;
case 'PRODUCT_LIST_NAME':
$select_column_list .= 'pd.products_name';
break;
// Products Description Hack begins
case 'PRODUCT_LIST_DESCRIPTION':
$select_column_list .= 'pd.products_description';
break;
// Products Description Hack ends
case 'PRODUCT_LIST_MANUFACTURER':
$select_column_list .= 'm.manufacturers_name';
break;
case 'PRODUCT_LIST_QUANTITY':
$select_column_list .= 'p.products_quantity';
break;
case 'PRODUCT_LIST_IMAGE':
$select_column_list .= 'p.products_image';
break;
case 'PRODUCT_LIST_WEIGHT':
$select_column_list .= 'p.products_weight';
break;
}
}
if (tep_not_null($select_column_list)) {
$select_column_list .= ', ';
}
-
It seems to be something to do with the
if (tep_not_null($select_column_list)) {
$select_column_list .= ', ';
}
bits
if i change it to
if (tep_not_null($select_column_list)) {
$select_column_list .= ', 555';
}
i get
1064 - You have an error in your SQL syntax near ' 555pd.products_name, , 555, 555, 555pd.products_description, p.products_id, p.' at line 1
select p.products_image, , 555pd.products_name, , 555, 555, 555pd.products_description, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = '2' order by pd.products_name limit 0, 20
-
I see a few people have had this problem...
1064 - You have an error in your SQL syntax near ' pd.products_name, , , , pd.products_description, p.products_id, p.manufacturer' at line 1
select p.products_image, , pd.products_name, , , , pd.products_description, 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, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = '2' order by pd.products_name limit 0, 20
...but i've replaced my general.php and index.php files and it's not worked.
I know I shouldn't have the extra commas, but they're put in dynamically by the code.
Does anyone know the fix?
Is the bug brought in from one of the other includes?
A
-
I've been fiddling and put all files back the way the mod specifies.
The advanced_search works (I know the page appears at the bottom, that's next on the list to fix, i know what the prob is there) - but the simple product_listing doesn't display the description, and is probably responsible for the jagged table display.
Any clues will be throughly investigated.
A
-
Hi All
WARNING: This site is not for the faint hearted, for others who can help, read on....
My truncated description is not appearing on the page
http://www.musthavetoys.com/index.php?cPath=2
I have copied the product_listing.php page directly from the mod.
I was having problems with formatting, so i took out
// Products Description Hack begins
if (PRODUCT_LIST_DESCRIPTION > 0) {
$lc_params = 'rowspan="2" ';
}
// Products Description Hack ends
from product_listing.php
Don't know if it's related? Any ideas?
Cheers
Andy
-
Hi All
WARNING: This site os not for the faint hearted, for others who can help, read on....
My truncated description is not appearing in
http://www.musthavetoys.com/index.php?cPath=2
I was having problems with formatting, so i took out
// Products Description Hack begins
if (PRODUCT_LIST_DESCRIPTION > 0) {
$lc_params = 'rowspan="2" ';
}
// Products Description Hack ends
Don't know if it's related? Any ideas?
Cheers
Andy
-
seeing as it seems to be a problem (and i could be wrong) with the Nogift bit, i notice that in the module for nogift, i don't get the zones drop down like i do in the gift module. instead i get a text box with no description about what it is.
is this what other people get?
-
just noticed that my problem seems to be something to do with $quotes1.
at this stage
$quotes1_size = sizeof($quotes1);
if ($quotes1_size > 1) {
$quotes1_size turns out to be 1. It doesn't seem to be reading my "No Gift Wrap" option. Could be wrong, but if this helps someone help me...
Andy
-
damn, i'm a fool!
needed to activate it in Modules-->Orders_Total
Sorry.
-
Hi Mark
I'm getting the same error now. Seemed to happen for no reason.
Aslo, I've lost my radio button to deselect gift wrapping.
Did you find a solution?
Andy
-
this is what i get if i add the giftwrap facliity
Sub-Total: ?57.00
Flat Rate (Best Way): ?0.01
Total: ?62.01
No idea why it isn't listing. I've had a rummage, but it SEEMS ok. Any suggestions?
message card option
in General Add-Ons Support
Posted
I've searched forums and contributions to see if there is a way to have an option to charge for a personal message to be delivered with the purchase.
I can't find it anywhere. does anyone know of one?
Cheers
Andy