Claudia

It's code change I made to the db. Added to several databases so I could use it thru admin products and orders. I sort my products in the categories by it. Layout in admin let me choose it.

I have it at line 1845 $sale_mode = $GLOBALS['config']->get('config', 'catalogue_sale_mode'); if ($sale_mode == 2) { $sale_percentage = $GLOBALS['config']->get('config', 'catalogue_sale_percentage'); } $user = (array)$GLOBALS['user']->get(); $group_id = 'WHERE group_id = 0'; if (($memberships = $GLOBALS['user']->getMemberships()) !== false) { $group_id = 'WHERE '; foreach ($memberships as $membership) { $group_id .= 'group_id = '.$membership['group_id'].' OR '; } $group_id = substr($group_id, 0, -4); } if (strtolower($page) != 'all') { $page = (is_numeric($page)) ? $page : 1; $limit = sprintf('LIMIT %d OFFSET %d', (int)$per_page, $per_page*($page-1)); } else { $limit = 'LIMIT 100'; } // Presence of a join is similar to presence of a search keyword if (!empty($joins) || is_array($search_data)) { if($GLOBALS['config']->get('config', 'hide_out_of_stock')=='1') { $search_data['inStock'] = true; }

GET: 'Before Sanitise:' => 'seo_path' => ashtrays 'page' => 2 'After Sanitise:' => '_a' => category 'cat_id' => 3 'page' => 2 This is the only thing I closely resembling query 31. Hack: 1681070244.17480 --- Duration: 7838 µs [CACHE WRITE] --- Key: sql.42a84a6e1af5e736143e4cb797ab58da SELECT * FROM `CubeCart_inventory` WHERE `product_id` IN (80,100,79,103,113,115,124,7,116,29,104,106,108,109,110,112,27,28,26,111,78,75,14,8,15,9,122,119,65,66,64,67,121,126) AND CubeCart_inventory.status = '1' ORDER BY `excel_name` ASC LIMIT 12 OFFSET 0; 32. Hack: 1681070244.17700 --- Duration: 1999 µs [CACHE WRITE] --- Key: sql.f5558282f2540e546ea7a9f62bb3fbc4 SELECT COUNT(*) AS `Count` FROM `CubeCart_inventory` WHERE `product_id` IN (80,100,79,103,113,115,124,7,116,29,104,106,108,109,110,112,27,28,26,111,78,75,14,8,15,9,122,119,65,66,64,67,121,126) AND CubeCart_inventory.status = '1' ; As for the list of product_ids, how many values are in your list? Where do I find this? All above is if I'm on page 2 of ashtrays Here's what I have on view all page 23. Hack: 1681071325.20270 --- Duration: 424 µs [CACHE READ] --- Key: sql.42a84a6e1af5e736143e4cb797ab58da SELECT * FROM `CubeCart_inventory` WHERE `product_id` IN (80,100,79,103,113,115,124,7,116,29,104,106,108,109,110,112,27,28,26,111,78,75,14,8,15,9,122,119,65,66,64,67,121,126) AND CubeCart_inventory.status = '1' ORDER BY `excel_name` ASC LIMIT 12 OFFSET 0;

Just noticed that after upgrade to 6.5.0 my pagination does not work on the storefront category page. If I click page 1 or 2 or view all it stays on the first page. https://www.cambargainstore.com/ashtrays

I noticed something else - I have added the image title to a product with the front view / back view appendage ( two photos and I haven't implemented your code above yet) When you look at the product page the main image will show the correct front view and the thumbnails will show their front or back view. But if you hover of the back view and it becomes the main image it still shows the title as front view. Here's an example page. Image Titles

Thanks Brian!!!

On the product page of a store if you click on the main image it goes to a page with an enlarged image of the main image with thumbnails under in. It also shows the Product title given when the product was created in admin. Is there a way for the product title to be the image title created when the photos are uploaded? For example in the image shown below the Image title I created for each photos is 1967 Jim Beam Decanter: Alaska Purchase Centennial: Front View 1967 Jim Beam Decanter: Alaska Purchase Centennial: Back View I'd like this to show for each thumbnail when it is enlarged if I have added the image title in admin. I haven't added it to all my products yet.

Thanks Brian. If you say these, and more, warnings aren't hurting anything and my site is working correctly I'll stop bugging you with this.

I just went in and cleared my error log. Five minutes late I went and checked. Got these errrors numerous times.. [07-Mar-2023 10:43:31 America/Louisville] PHP Warning: Undefined array key "_g" in /home/cambarga/public_html/includes/extra/snippet_f4308ce0418a4ec0d7106f4189af8605.php on line 2 [07-Mar-2023 10:53:41 America/Louisville] PHP Warning: Undefined variable $random_product in /home/cambarga/public_html/classes/gui.class.php on line 1348 [07-Mar-2023 10:55:17 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/cambarga/public_html/classes/session.class.php on line 676 [07-Mar-2023 10:55:17 America/Louisville] PHP Warning: Undefined array key "_g" in /home/cambarga/public_html/classes/ssl.class.php on line 39 The first one is for a code snippet you created for me to add a new tab to the orders page in admin: <?php if($_GET['_g'] == 'orders' && (!isset($_GET['node']) || $_GET['node'] == 'index') && isset($_GET['action']) && in_array($_GET['action'], array('add','edit'))) { $tab['name'] = 'More Order Info'; $tab['tab_id'] = 'tab_moreorderinfo'; $tab['target'] = '#moreorderinfo'; $tabs[] = $tab; } Hold on there was another snippet you created that might have something to do with the sort error. This is to show the product images by file name. I name my photos 01-front, 02-left, etc. <?php $return_filenames = array_map(function($element){return $element['filename'];},$return); array_multisort($return_filenames,$return); ?>

All I have are those additional fields I added in Products and Orders that I made sortable. No code snippets

I am still getting a lot of PHP Warnings even though I've updated to 6.4.10. This is just the last couple of hours. I deleted a bunch earlier today. Most in the cPanel log are repeats of these. Nothing in the admin log. PHP Version 8.1.16 [06-Mar-2023 18:39:43 America/Louisville] PHP Warning: Undefined variable $random_product in /home/xxxxxxx/public_html/classes/gui.class.php on line 1348 [06-Mar-2023 18:45:40 America/Louisville] PHP Warning: Undefined array key "_g" in /home/xxxxxxx/public_html/classes/ssl.class.php on line 39 [06-Mar-2023 18:46:44 America/Louisville] PHP Warning: Undefined variable $random_product in /home/xxxxxxx/public_html/classes/gui.class.php on line 1348 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Undefined array key "doc_name" in /home/xxxxxxx/public_html/classes/cubecart.class.php on line 89 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Undefined array key "hide_title" in /home/xxxxxxx/public_html/classes/cubecart.class.php on line 91 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Undefined variable $contents in /home/xxxxx/public_html/classes/cubecart.class.php on line 197 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Trying to access array offset on value of type null in /home/xxxxxx/public_html/classes/cubecart.class.php on line 197 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Undefined variable $contents in /home/xxxxxxx/public_html/classes/cubecart.class.php on line 194 [06-Mar-2023 18:30:19 America/Louisville] PHP Warning: Trying to access array offset on value of type null in /home/xxxxxx/public_html/classes/cubecart.class.php on line 194 [06-Mar-2023 18:17:11 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/xxxxxx/public_html/classes/session.class.php on line 676 [06-Mar-2023 18:14:31 America/Louisville] PHP Warning: Array to string conversion in /home/xxxxxx/public_html/classes/db/database.class.php on line 178 [06-Mar-2023 18:14:37 America/Louisville] PHP Warning: Undefined variable $external_categories in /home/xxxxxx/public_html/admin_Ot3sX0/sources/products.index.inc.php on line 853 [06-Mar-2023 18:14:37 America/Louisville] PHP Warning: Undefined variable $option_list in /home/xxxxxxx/public_html/admin_Ot3sX0/sources/products.index.inc.php on line 957 [06-Mar-2023 18:14:37 America/Louisville] PHP Warning: Undefined array key "option_matrix" in /home/xxxxxx/public_html/admin_Ot3sX0/sources/products.index.inc.php on line 1216 [06-Mar-2023 18:14:37 America/Louisville] PHP Warning: Undefined array key "plugin_tabs" in /home/xxxxxxx/public_html/admin_Ot3sX0/sources/products.index.inc.php on line 1276 [06-Mar-2023 18:06:00 America/Louisville] PHP Warning: Undefined global variable $_GET in /home/xxxxx/public_html/includes/functions.inc.php on line 206 [06-Mar-2023 18:06:00 America/Louisville] PHP Warning: Invalid Security Token in /home/xxxxx/public_html/classes/sanitize.class.php on line 155

I don't know how long this has not been working. I input all required info hit send message and nothing happens. I tested my email settings in admin and it tested successfully. There are no red error banners on the contact form page explaining why the message was not sent. Using SMTP with SSL and invisible reCAPTCHA. CC version 6.4.10 Any thoughts? I checked, my reCaptcha keys are correct. Debug shows this on contact page storefront: PHP: [Warning] /home/xxxxxx/public_html/classes/gui.class.php:1348 - Undefined variable $random_product GET: 'Before Sanitise:' => 'seo_path' => contact-us 'After Sanitise:' => '_a' => contact POST: Empty SESSION: '__client' => 'ip_address' => 98.211.12.144 'useragent' => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0 'session_start' => 1677352563 'session_last' => 1677352567 'language' => en-US 'currency' => USD 'admin_id' => 1 '__recaptcha' => 'error' => The verification code was incorrect. Please try again. 'confirmed' => Admin error log shows this: File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'America/Louisville'" - Unknown or incorrect time zone: 'America/Louisville' [<strong>Warning</strong>] /home/xxxxxxxxx/public_html/classes/ajax.class.php:48 - Undefined array key "q" https://www.cambargainstore.com/admin_xxxxxxxxx.php?_g=xml&function=SMTPTest Ok I just went back to the contact page ( no invisible reCAPTCHA info showing in the corner) completed message and sent and it went thru. Green banner saying it went thru.

Yep, that was the problem ... got it fixed now. Thanks Brian

I'll make sure all my skins uploaded have been changed. Thanks Brian If that's not it - "I'll be Back" LOL

No PHP Fatal Errors that I can see I also got a lot of these but I thought it was because I didn't leave a space in the config file. I fixed that. quality="80"default to quality="80" default [24-Feb-2023 12:40:09 America/Louisville] PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.construct.php'>simplexmlelement.construct.php</a>] Entity: line 62: parser error : attributes construct error in /home/cambarga/public_html/classes/gui.class.php on line 613 [24-Feb-2023 12:41:41 America/Louisville] PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.construct.php'>simplexmlelement.construct.php</a>]: &lt;image reference=&quot;large&quot; maximum=&quot;600&quot; quality=&quot;80&quot;default=&quot;noimage.png&quot; /&gt; in /home/xxxxxx/public_html/classes/gui.class.php on line 613

I upgraded to 6.4.10 and all went fine. Could see my admin and storefront - even custom skins. I knew I had to still update my admin/sources files to match my custom admin skin. When I cleared my cache in admin everything disappeared. White screen in admin and store front. I have tried reinstalling with and without my custom files and still get the white screens. My error log in cpanel is Huge!! from this and before. He are some from today. What should I do? [24-Feb-2023 15:00:12 America/Louisville] PHP Warning: Undefined array key "_g" in /home/xxxxx/public_html/classes/ssl.class.php on line 39 [24-Feb-2023 19:29:15 UTC] PHP Warning: Undefined array key "ADMIN_URL" in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 350 [24-Feb-2023 19:29:15 UTC] PHP Warning: Attempt to read property "value" on null in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 350 [24-Feb-2023 19:29:15 UTC] PHP Warning: Undefined array key "ADMIN_URL" in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 351 [24-Feb-2023 19:29:15 UTC] PHP Warning: Attempt to read property "value" on null in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 351 [24-Feb-2023 19:29:15 UTC] PHP Warning: Undefined array key "STORE_URL" in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 357 [24-Feb-2023 19:29:15 UTC] PHP Warning: Attempt to read property "value" on null in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 357 [24-Feb-2023 19:29:15 UTC] PHP Warning: Undefined array key "STORE_URL" in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 358 [24-Feb-2023 19:29:15 UTC] PHP Warning: Attempt to read property "value" on null in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 358 [24-Feb-2023 19:29:55 UTC] PHP Warning: Undefined array key "ADMIN_URL" in /home/xxxxx/public_html/cache/skin/26680caf5441a1ba00cf28d03267ef60abd0b2db_0.file.skin.install.php.php on line 350 [24-Feb-2023 12:26:12 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/xxxxx/public_html/classes/session.class.php on line 676 [24-Feb-2023 12:26:12 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/xxxxx/public_html/classes/session.class.php on line 676 [24-Feb-2023 12:26:12 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/xxxxx/public_html/classes/session.class.php on line 676 [24-Feb-2023 12:26:12 America/Louisville] PHP Warning: Undefined array key "HTTP_USER_AGENT" in /home/xxxxx/public_html/classes/session.class.php on line 676

Figured it out. Thanks for once again leading me in the right direction

I don't want to lose any info in the new store. I have the same host for both stores, Ian. How would I do what you say above.

I'm closing one store and starting a new one. I'd like to keep all the customer and order info from the old store either in databases in the new store or an Excel worksheet similiar to the catalogue export. Any thoughts how I can do this? Thanks in advance

Thanks Brian. I'll make those changes ASAP!

Admin System Error Log When I got up this morning I checked my admin error log. I had over 4200 entries in the system error log. I try to clear the log every day but still get thousands. Has this been addressed or is it something I'm doing to cause this. This has been happening since I updated to CC6.4.9 PHP 8.1.13 Here's an example. Anything I can do? Today, 11:55 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/index.php Today, 11:47 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/index.php?seo_path=listed-only-on-etsy Today, 11:44 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/index.php Today, 11:40 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/index.php Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/debug.class.php:260 - strstr(): Passing null to parameter #1 ($haystack) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/user.class.php:719 - strtolower(): Passing null to parameter #1 ($string) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/session.class.php:676 - htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/session.class.php:676 - strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/xxxxxx/public_html/classes/session.class.php:676 - htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:33 [<strong>Deprecated</strong>] /home/cambarga/public_html/classes/session.class.php:676 - strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated https://www.gza-e.com/api/consumer/user/common/applet/code Today, 11:30 [<strong>Deprecated</strong>] /home/cambarga/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/index.php Today, 11:18 [<strong>Deprecated</strong>] /home/cambarga/public_html/classes/cache/file.class.php:224 - preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated https://www.cambargainstore.com/soft-drink-bottles

I found the topic: https://forums.cubecart.com/topic/57993-save-reload-button-on-admin-orders-page/#comment-252113 I forgot to make this change in admin/skin/templates/order.index when I upgraded to 6.4.9. I kept my code as it was Change line 36 from: httpredir('?_g=orders&'.http_build_query($_POST)); To: if (array_walk_recursive($_POST['search'],function($v,$k)use(&$aSearch){$aSearch=sprintf("%s%s",$aSearch,$v);},$aSearch) && !empty($aSearch)) httpredir('?_g=orders&'.http_build_query($_POST));

So what should my code be to be able to change them all at one time?

I have this: (Forgot to post it) } else { $GLOBALS['main']->errorMessage($lang['orders']['error_orders_delete']); } } } if ($updated) { $GLOBALS['main']->successMessage($lang['orders']['notify_orders_status']); } if (isset($_GET['redirect']) && $_GET['redirect'] == 'dashboard' && $_POST['multi-action'] == '') { httpredir('?', 'orders'); } else { httpredir(currentPage(array('print_hash', 'multi-action'), $add_array)); } } elseif (isset($_POST['venue_sold_site'])) { foreach ($_POST['venue_sold_site'] as $order_id => $site_name) { $GLOBALS['db']->update('CubeCart_order_summary', array('venue_sold_site' => $site_name), array('cart_order_id' => $order_id)); } $GLOBALS['main']->successMessage("One or more orders Sold Sites were updated"); } elseif (isset($_POST['all_order_date'])) { foreach ($_POST['all_order_date'] as $order_id => $site_name) { $GLOBALS['db']->update('CubeCart_order_summary', array('all_order_date' => $site_name), array('cart_order_id' => $order_id)); } $GLOBALS['main']->successMessage("One or more orders All Order Dates were updated"); } elseif (isset($_POST['all_delivery_date'])) { foreach ($_POST['all_delivery_date'] as $order_id => $site_name) { $GLOBALS['db']->update('CubeCart_order_summary', array('all_delivery_date' => $site_name), array('cart_order_id' => $order_id)); } $GLOBALS['main']->successMessage("One or more orders All Delivery Dates were updated"); } elseif (isset($_POST['feedback'])) { foreach ($_POST['feedback'] as $order_id => $site_name) { $GLOBALS['db']->update('CubeCart_order_summary', array('feedback' => $site_name), array('cart_order_id' => $order_id)); } $GLOBALS['main']->successMessage("One or more orders Feedbacks were updated"); } elseif (isset($_GET['search'])) { // Search by date range

I hate to keep bothering you all, but things have been creeping up and I don't know if it's related to CC6.4.9 and/or PHP 8. I haven't changed any of the code for this issue since 6.4.7 and I have basically the same thing in customers and products and it works fine. Here goes: On the main order page I have some custom columns that I have made editable. That way I don't have to go into each order and input the info. I input it from the main order page and it populates the individual order. Right now if I edit the info in the individual order it will populate the main order page. I just can't edit and save on the main order page. Well it will let me input in the info just won't save it. Thanks in advance. Here's my code in admin/skin/templates/order.index Line 18: <thead> <tr> <td>&nbsp;</td> <td nowrap="nowrap">{$THEAD.cart_order_id}</td> <td>&nbsp;</td> <td>{$THEAD.customer}</td> <td>Sold Site</td> <td>{$THEAD.date}</td> <td>Order Date</td> <td nowrap="nowrap">{$THEAD.status}</td> <td>Delivery Date</td> <td>Feedback</td> <td>{$THEAD.total}</td> <td>&nbsp;</td> </tr> </thead> Line 51: <td><span class="editable" name="venue_sold_site[{$order.cart_order_id}]">{$order.venue_sold_site}</span></td> <td>{$order.date}</td> <td><span class="editable" name="all_order_date[{$order.cart_order_id}]">{$order.all_order_date}</span></td> <td class="{$order.status_class}">{$order.status}</td> <td><span class="editable" name="all_delivery_date[{$order.cart_order_id}]">{$order.all_delivery_date}</span></td> <td><span class="editable" name="feedback[{$order.cart_order_id}]">{$order.feedback}</span></td> Here's my code in admin/sources/order.index.inc Line 963: $thead_sort = array( 'venue_sold_site' => $GLOBALS['db']->column_sort('venue_sold_site','Venue Sold Site', 'sort', $current_page, $_GET['sort']), 'cart_order_id' => $GLOBALS['db']->column_sort('cart_order_id', $lang['orders']['order_number'], 'sort', $current_page, $_GET['sort']), 'customer' => $GLOBALS['db']->column_sort('customer', $lang['orders']['title_customer'], 'sort', $current_page, $_GET['sort']), 'all_order_date' => $GLOBALS['db']->column_sort('all_order_date', 'Order Date', 'sort', $current_page, $_GET['sort']), 'all_delivery_date' => $GLOBALS['db']->column_sort('all_delivery_date', 'Delivery Date', 'sort', $current_page, $_GET['sort']), 'feedback' => $GLOBALS['db']->column_sort('feedback','Feedback', 'sort', $current_page, $_GET['sort']), 'status' => $GLOBALS['db']->column_sort('status', $lang['common']['status'], 'sort', $current_page, $_GET['sort']), 'date' => $GLOBALS['db']->column_sort('order_date', $lang['common']['date'], 'sort', $current_page, $_GET['sort']), 'total' => $GLOBALS['db']->column_sort('total', $lang['basket']['total'], 'sort', $current_page, $_GET['sort']) );