Jump to content

sputnikinternet

Members
  • Content count

    41
  • Joined

  • Last visited

Posts posted by sputnikinternet


  1. 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?


  2. 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 .= ', ';

    }


  3. 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


  4. 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


  5. 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


  6. 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


  7. 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


  8. 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?


  9. 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

×