nomem

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,

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; }

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

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

Rosemary was the font small on your Kindle?

I made the change in the code and have no new errors. But my search is not working from the search box. When I type in coke bottle it comes back none found error. When I search with advanced search all my coke bottles are found I put the code back to original and get the same as with new code

Rosemary .. I changed your order to processing. Thanks for doing this.

Thanks so much!! https://www.nestofmemories.com/

Just the changes for the Prev::Next coding

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

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.

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?

But I don't understand why it is just the emails sent to customers concerning their orders. All other emails I get look fine.

Thanks for taking the time to find these links Brian. I'll take a look in the morning

I was using the default email app that came with my phone. I just downloaded Microsoft Outlook and though the font is still small in portrait mode it does expand in landscape mode and is larger. I didn't see where I can view in my browser from my phone.