Jump to content

nomem

Member
  • Content Count

    72
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by nomem

  1. I just got a notice from someone that the small font size is a problem for them as well on their Android phone in portrait mode.  I have tried increasing the 580 table width, but that doesn't change anything.  In my old store I completely did away with the width for that table and the font is very readable and looks nice.  Do you think this will cause problems on other devices?  I don't have a tablet, etc.  Just a laptop and desktop computer.

    Thanks,

  2. Hi Brian,

    I just upgraded to CC6.11 and the lines in the following file are different for the prev::next coding.  Where exactly does this code go now?  All the other code was ok. I think I know, just want to be sure. Thanks in advance!

     

    /classes/catalogue.class.php, at the bottom of the getCategoryProducts() function:

    Was in 6.12:

                                                 $productList = $this->getProductData($list, 1, $order, $per_page, $page, true);

                                  }

     

                                  return (isset($productList) && is_array($productList)) ? $productList : false;

                   }

     

    Changes to be made:

    Now:

                                                 $productList = $this->getProductData($list, 1, $order, $per_page, $page, true);

                                  }

                                  $GLOBALS['session']->set('last_visited_category',$category_id,'client',true);

    $GLOBALS['session']->set('last_visited_category_product_ids',$list,'client',true);

    foreach ($GLOBALS['hooks']->load('class.catalogue.category_product_list_return') as $hook) include $hook; return (isset($productList) && is_array($productList)) ? $productList : false;

                   }

     

    Now code in 6.11:

     

    foreach ($GLOBALS['hooks']->load('class.catalogue.category_product_list') as $hook) include $hook;

                                                 $productList = $this->getProductData($list, 1, $order, $per_page, $page, true);

                                  }

                                  foreach ($GLOBALS['hooks']->load('class.catalogue.category_product_list_return') as $hook) include $hook;     

    return (isset($productList) && is_array($productList)) ? $productList : false;

                        }

  3. If it helps I actually got 4 errors not just the one I showed in the post.

    Yesterday, 05:06               File: [catalogue.class.php] Line: [1726] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%') LIMIT 9 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%')' at line 1

     

    Yesterday, 05:06               File: [catalogue.class.php] Line: [1728] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%') " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%')' at line 1

     

    01 Nov 2016, 05:02          File: [catalogue.class.php] Line: [1726] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%') LIMIT 9 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%')' at line 1

     

    01 Nov 2016, 05:02          File: [catalogue.class.php] Line: [1728] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%') " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%')' at line

     
         
         
         
         
  4. Good idea Rosemary.  Unfortunately my husband is behind the technical times and has a $20.00 flip phone from Walmart. LOL  But this does let me know it is probably my phone's software and nothing to do with Cubecart.  Thanks very much for everyone's time and effort with this.  Rosemary, I'm going to cancel your order in my store.

    Thanks again!!

  5. Just a note to followup:

    In my old store I don't use the store logo in my emails.  Just wording.  In this case, on my phone, the font is the correct size, but in portrait I have to scroll right to see the rest of the message.  In landcape it fills the screen nicely.  My logo is not svg in either store

  6. When I said all other emails look fine I meant from businesses, friends, spam, etc.  Everything but what Cubecart sends out with orders.

    I've been messing around and here are my findings:

    1.  I have all my emails as basically stock Cubecart email templates except for adding some wording and changing the font size to 13 instead of 14.

    2.  On my desktop - Everything looks great, as it should, in Microsoft Outlook and my Comcast infinity website account.

    On My Phone with phone app:

    1. From the pulldown menu and the email app the font is small (no smaller than at 14).  In portrait mode - no scrolling message fits screen as it should. 

    In landscape mode - font small - message stays at the 580 - does not fill screen.

    On my phone with the Comcast Infinity app:

    Portrait Mode:  Font looks great but I have to scroll to read the right side of the message

    Landscape mode:  Font looks great and the message is the width of the screen - looks very nice.

    I'm not too worried about the small font for me, I just hope my customers don't see it that small.

  7. Woke up this morning and found this erroy in my system error log.

    File: [catalogue.class.php] Line: [1726] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%') LIMIT 9 OFFSET 0 " - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fulltext '%1%' OR I.description fulltext '%1%' OR I.product_code fulltext '%1%')' at line 1

    Any thoughts?

  8. I know this really isn't  totally a Cubecart issue, just want to see if anyone else has encountered this.  I have a LG G Stylo cell phone.  When I receive an email sent thru my store, when a order status has changed, the font is so small it is nearly unreadable.  All my other emails from the Cubecart forum and outside Cubecart are formatted very nicely.  I have changed the settings on my phone, in admin - everywhere and the font is still small.  I'm now back to the default Arial 14px in my default html email template. Has anyone else encountered this?

    Claudia

  9. When I delete the file font-awesome.css from my custom skin (based on Foundation) my Prev::Next buttons disappear.  I deleted the file because it was not with the Foundation skin in CC6.10 since it is no longer needed. Any modifications so I can delete the font-awesome file?

    Thanks

     

×
×
  • Create New...