Claudia M

What does this mean? Should I worry? Thanks in advance, Claudia File: [catalogue.class.php] Line: [1017] "SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_inventory` WHERE `product_id` IN (1510,1556,1557,1543,759,760,593,594,595,599,600,601,604,612,626,629,635,918) AND CubeCart_inventory.status = '1' ORDER BY `custom_sort` ASC LIMIT 24 OFFSET 7.70906906909E+14;" - 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 '7.70906906909E+14' at line 1

I use SemperFi's Vertical Navigation, too. I've modified it with Darren's help. You can see it here. https://www.claudiasbargains.com/

That did it Brian. Thank you. Now I think I'll style it a little better. Well, in the morning. By the way, you said to edit line 150 in cubecart.css. I was under the impression that it wasn't a good idea to change any of the .css files that come with Foundation. I've been putting all my changes to these files in a new (for now working.css) .css file. Is this the correct way?

I've tried that and more. my web address is https://www.claudiasbargains.com. You'll have to add something to the basket to see it.

This is driving me nuts!! I am redoing the layout of my checkout pages and on content/medium-up I want the word Quantity and the box with the qty in it all on one line. I can't get it to do it!! Here is my code. The last line I want on a line by itself under the product code: <tr> <td class="text-center"><a href="{$STORE_URL}/index.php?_a=basket&remove-item={$hash}"><svg class="icon icon-trash-o"><use xlink:href="#icon-trash-o"></use></svg></a></td> <td width="90"> <a href="{$item.link}" class="th" title="{$item.name}"><img src="{$item.image}" alt="{$item.name}"></a></td> <td colspan="2"> <div><a class="txt" href="{$item.link}">{$item.name}</a> {if !empty($item.product_code)} - {$item.product_code}{/if}</div> <div class="txt"> Quantity: <input name="quan[{$hash}]" type="quantity" value="{$item.quantity}" maxlength="6" class="quantity checkout" {$QUAN_READ_ONLY}></div> Thanks in advance for any and all help, Claudia

Thanks Brian!

Hi, I got this error (warning) in my cPanel error log: [10-Oct-2017 14:04:27 America/Louisville] PHP Warning: Invalid argument supplied for foreach() in /home/claudias/public_html/modules/shipping/All_In_One_Shipping/shipping.class.php on line 46. Here is the code referenced: $this->_item_count = 0; (LINE 46) foreach ($this->_basket['contents'] as $item) { // XXX May want to exclude digital products from the item count, i.e. // if ($item['digital']) continue; $this->_item_count += $item['quantity']; } Anything to worry about? If so how do I fix it? Thanks in advance, Claudia

Nevermind

Thanks for your quick response Brian. I think I'll just use the code you provided for now and worry about the other when the need arises. Claudia

Just wondering if there is any way to create a database column with a blank "fill out the name as you go". For example I may need a custom field for a certain item(s) and it would be nice to create the name on an as needed basis. For example: Now Item Mfg / Brand - add a new one blank column so I can type in, for example, distributor or mfg. location - whatever is need for that product. Thanks in advance, Claudia

Hey Brian, Your code worked great! Have a question .... please keep in mind I am not smart in this at all. I mean at all. When you say Be careful! The parsed code must reference * data already assigned to targeted Smarty variables Does that mean I have to have a column in the inventory database. For example if I want to show the manufacturer's line would I create a coulmn called mfg_line (which I have) and have the code something like this? {if $PRODUCT.mfg_line} <tr> <td class="prod-spec-title">{$LANG.products_en.mfg_line}</td> <td class="prod-spec-txt">{$PRODUCT.mfg_line}</td> </tr> {/if} I don't use the stock manufacturer that comes with CubeCart. I think I answered my own question. But Brian please reply just in case. I added this to the bottom of a product description <table class="nobord bgw"> <tbody> {if $PRODUCT.product_code} <tr> <td class="prod-spec-title">{$LANG.products_en.product_code}</td> <td class="prod-spec-txt">{$PRODUCT.product_code}</td> </tr> {/if} {if $PRODUCT.item_mfg} <tr> <td class="prod-spec-title">{$LANG.products_en.item_mfg}</td> <td class="prod-spec-txt">{$PRODUCT.item_mfg}</td> </tr> {/if} {if $PRODUCT.mfg_brand} <tr> <td class="prod-spec-title">{$LANG.products_en.mfg_brand}</td> <td class="prod-spec-txt">{$PRODUCT.mfg_brand}</td> </tr> {/if} {if $PRODUCT.mfg_line} <tr> <td class="prod-spec-title">{$LANG.products_en.mfg_line}</td> <td class="prod-spec-txt">{$PRODUCT.mfg_line}</td> </tr> {/if} {if $PRODUCT.mfg_model} <tr> <td class="prod-spec-title">{$LANG.products_en.mfg_model}</td> <td class="prod-spec-txt">{$PRODUCT.mfg_model}</td> </tr> {/if} {if $PRODUCT.stock_level} <tr> <td class="prod-spec-title">{$LANG.products_en.stock_level}</td> <td class="prod-spec-txt">{$PRODUCT.stock_level}</td> </tr> {/if} {if $PRODUCT.item_age} <tr> <td class="prod-spec-title">{$LANG.products_en.item_age}</td> <td class="prod-spec-txt">{$PRODUCT.item_age}</td> </tr> {/if} {if $PRODUCT.box_size} <tr> <td class="prod-spec-title">{$LANG.products_en.item_box_size}</td> <td class="prod-spec-txt">{$PRODUCT.box_size}</td> </tr> {/if} {if $PRODUCT.item_size} <tr> <td class="prod-spec-title">{$LANG.products_en.item_size}</td> <td class="prod-spec-txt">{$PRODUCT.item_size}</td> </tr> {/if} {if $PRODUCT.item_wgt} <tr> <td class="prod-spec-title-last">{$LANG.products_en.item_actual_wgt}</td> <td class="prod-spec-txt-last">{$PRODUCT.item_wgt}</td> </tr> {/if} </tbody> </table> and got this (with some styling): Product Code: THS993 Item Mfg / Brand: Thomson & Taylor Spice Com Stock Level: 1 Item Age: Vintage Item Size: 2-5/8L x 1-1/2W x 5/8H

Thanks for continuing to look into this Brian

Thank you so much for sharing. I have always used something similar in word then copy / paste it to the editor. <div class="prod-txt"> Main Description </div> <div class="prod-section-title">Interesting Facts ...</div> <div class="prod-spec-txt"> Some items have fun historical facts </div> Below is the new part I’m adding, catered to each item. <div class="prod-section-title">Product Specifications ...</div> <table class="nobord"> <tbody> <tr> <td class="prod-spec-title">Product Code:</td> <td class="prod-spec-txt">PPC119</td> </tr> <tr> <td class="prod-spec-title">Stock Level:</td> <td class="prod-spec-txt"><div><a class="prode-txt" href="http://www.ebay.com/itm/havana-gran-hotel-america-brochure/152720008293">Link to eBay listing</a> </div></td> </tr> <tr> <td class="prod-spec-title">Condition:</td> <td class="prod-spec-txt">Original</td> </tr> <tr> <td class="prod-spec-title">Age:</td> <td class="prod-spec-txt">Vintage - 1926</td> </tr> <tr> <td class="prod-spec-title">Item Size:</td> <td class="prod-spec-txt">8-1/2W x 11H </td> </tr> <tr> <td class="prod-spec-title">Actual Weight:</td> <td class="prod-spec-txt">0.3 oz.</td> </tr> </tbody> </table>

This seems confusing. LOL! I think i'll just cheat and do it manually Thanks, Brian

Thanks for your quick response Brian, What needs to be done to parse Smarty syntax in product descriptions? Seems alot of people could use this ability. Please forgive my ignorance on this but would each specification have to be added to the database? I'm trying to avoid that. Claudia

I’m trying to do away with the tabs (using a very custom Foundation skin) and adding all needed information in the product description. As I sell vintage items that I may only have one of – one and gone - with numerous manufacturers and brands I need to be able to make my specifications unique for each product. I’m having a problem with the product code and stock level. I want the stock level and product code to automatically update when the item sells or info changes. Anyway to do this with html since I’m using the editor? Here’s a sample of what I tried. <div class="prod-section-title">Product Specifications ...</div> <table class="nobord"> <tbody> <tr> <td class="prod-spec-title">Product Code:</td> <td class="prod-spec-txt">{$PRODUCT.product_code}</td> </tr> <tr> {if $PRODUCT.stock_level} <td class="prod-spec-title">Stock Level</td> <td class="prod-spec-txt">{$PRODUCT.stock_level}</td> {/if} </tr> <tr> <td class="prod-spec-title">Manufacturer:</td> <td class="prod-spec-txt">OBI</td> </tr> </tbody> </table> But this is what it looks like online – it’s showing the code: Product Specifications ... {if $PRODUCT.stock_level} {/if} Product Code: {$PRODUCT.product_code} Stock Level: {$PRODUCT.stock_level} Manufacturer: OBI Thanks, Claudia

I thought this was fixed in CC or did I miss something? When I look at my page source I find this: NOTE: Store Name Claudia’s Bargains - showing in page source as Claudia&#39;s Bargains HOMEPAGE <meta name="description" content="Antiques, Vintage and Collectibles - We search yard sales, estate sales, flea markets, auctions and attics to find items you didn&#39;t know you were looking for"> CONTACT PAGE <meta name="description" content="Claudia&#39;s Bargains Collectibles and More Shop. We search yard sales, estate sales, flea markets, auctions and attics to find items you didn&#39;t know you were looking for. Toss in some brand new items and some handcrafted creations and the mix is complete!"> Claudia

Did as you said. No distrubing the statements after the return false: }. Seems to be working now. Thank you so much for this Brian!

The "Find" line doesn't read the same as what you say: My Line reads: $error = "[<strong>".$type."</strong>] \t".$error_file.":".$error_line." - ".$error_string; $this->_errors[] = $error; if($log) { $this->_writeErrorLog($error, $type); } Also I got an error, [11-Sep-2017 15:14:46 UTC] PHP Parse error: syntax error, unexpected 'public' (T_PUBLIC) in /home/claudias/public_html/classes/debug.class.php on line 467, and the website and admin would not load. But when I put a } after the "Change to" it worked. Is that OK? Or am I going to get problems down the road. Find: $error = "[<strong>".$type."</strong>] \t".htmlentities(strip_tags($error_file.":".$error_line." - ".$error_string)); $this->_errors[] = $error; $this->_writeErrorLog($error, $type); } Then find: return false; Change to: return ($this->_suppress_php_notices && $type == 'Notice') ? true : false; // See PHP manual for set_error_handler() callback function return value

Got it. Thank you Brian

Brian, Part of your code changes read: Find: $error = "[<strong>".$type."</strong>] \t".htmlentities(strip_tags($error_file.":".$error_line." - ".$error_string)); $this->_errors[] = $error; $this->_writeErrorLog($error, $type); } Then find: return false; Change to: return ($this->_suppress_php_notices && $type == 'Notice') ? true : false; // See PHP manual for set_error_handler() callback function return value MY QUESTION Am I suppose to change all the “find and then find” code to the following: Or was there a “change to” missing after the first “find” return ($this->_suppress_php_notices && $type == 'Notice') ? true : false; // See PHP manual for set_error_handler() callback function return value } Thanks, Claudia

It's from the error log in CPanel

I have always had the debug mode disabled, unless I'm searching for something, and look at all the notices I got.

Do you think we need to add this to GitHub or feature request? Can't believe it's just the two of us that would like this done.

Thanks for looking into this Brian. 1. By error log I mean the one in CPanel. The "error_log" file that PHP creates. 2. Sorry .. didn't mean to include this one. Daren is looking into it: This is interesting. Something really outside the bounds of the normal sequence of events must have happened. curl_setopt(): Disabling safe uploads is no longer supported You will need to get with SemperFi and get an updated version of the "Automatic Social Media Posts" plugin. 3. This one is because I don't use the sorting method that comes with CubeCart. I sort by newly listed or by Daren's mod Custom Product Sort. Security Warning: Illegal array key &quot;sort%5Bdate_added%5D&quot; was detected and was removed 4. I don't know what this is [07-Sep-2017 13:59:57 America/Louisville] PHP Warning: No customer information detected. Order summary was not built or inserted. in /home/claudias/public_html/classes/order.class.php on line 1170 Whatever you think I can have removed from the error log safely I'd like the code to do it. It's really annoying getting this large error log. And I can always put it back if need be. Thanks, Claudia