Claudia M

Got it Brian. I'll just delete them and be happy CubeCart is doing such a good job keeping my site safe.

What about the part that isn't "Most of that"?

Is there anything I should do? Should this be reported?

I found these in the cPanel error log. Any idea what they mean? What should I do to quit getting them as I got the same ones yesterday too. Thanks in advance for any and all help. I replaced my database name with xxx Claudia 10-Apr-2019 01:19:57 UTC] PHP Warning: Invalid Security Token in /home/xxx/public_html/classes/sanitize.class.php on line 155 [10-Apr-2019 01:21:01 UTC] PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '91.121.222.157' New IP Address: '91.121.222.157' Old User Agent: '}__test|O:21:"JDatabaseDriverMysqli":3:{s:2:"fc";O:17:"JSimplepieFactory":0:{}s:21:" in /home/xxx/public_html/classes/session.class.php on line 700 [09-Apr-2019 21:32:46 America/Louisville] PHP Warning: No customer information detected. Order summary was not built or inserted. in /home/xxx/public_html/classes/order.class.php on line 1362 [10-Apr-2019 01:35:13 UTC] PHP Warning: Invalid Security Token in /home/xxx/public_html/classes/sanitize.class.php on line 155 [10-Apr-2019 16:24:28 UTC] PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '192.99.4.102' New IP Address: '192.99.4.102' Old User Agent: '}__test|O:21:"JDatabaseDriverMysqli":3:{s:2:"fc";O:17:"JSimplepieFactory":0:{}s:21:" in /home/xxx/public_html/classes/session.class.php on line 700 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#post_render" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#type" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#markup" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#post_render" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#type" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:24:55 UTC] PHP Warning: Security Warning: Illegal array key "#markup" was detected and was removed. in /home/xxx/public_html/classes/sanitize.class.php on line 114 [10-Apr-2019 16:26:07 UTC] PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '192.99.4.102' New IP Address: '192.99.4.102' Old User Agent: '}__test|O:21:"JDatabaseDriverMysqli":3:{s:2:"fc";O:17:"JSimplepieFactory":0:{}s:21:" in /home/xxx/public_html/classes/session.class.php on line 700 [10-Apr-2019 16:26:25 UTC] PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '192.99.4.102' New IP Address: '192.99.4.102' Old User Agent: '}__test|O:21:"JDatabaseDriverMysqli":3:{s:2:"fc";O:17:"JSimplepieFactory":0:{}s:21:" in /home/xxx/public_html/classes/session.class.php on line 700

That must have done it Brian. I'm no longer getting the orange error in admin/database. Thank you so much!

Brian I cannot get this to work at all. Can I delete, drop, the custom_oid and query it back in correctly from the start? If so how would I word the query?

I get this when I do that

" I believe you can just click the edit icon for custom_oid and change the BTREE to UNIQUE. " It will only let me change BTREE to HASH under advanced options/ Index type. When I try to change the INDEX choice to Unique is when I get the error. For the life of me I cannot find a custom_oid_2

When I try to change the index to Unique I get this error, I don't have a column custom_oid_2 Error SQL query: ALTER TABLE `CubeCart_order_summary` ADD UNIQUE(`custom_oid`) MySQL said: #1062 - Duplicate entry '' for key 'custom_oid_2'

I do have the 'live_from' column. I have tried to getthe "dimension_unit' column to say Yes 'cm' but it won't take I guess. I put the following in admin/Query MySQL Database ALTER TABLE `CubeCart_inventory` CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm'; #EOQ. This was straight from the 6.2.3 db file. I got the above to work. I'll see if I get more errors Now I keep getting this error: [20-Mar-2019 09:50:24 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 ADMIN ERROR LOG: File: [database.class.php] Line: [556] "ALTER TABLE `CubeCart_inventory` CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm' " - 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 ''cm'' at line 1 Also, what about that orange banner error. I seems I got that awhile back in another version. Thanks for all your help.

Upon inspection it does seems that my database did upgrade. This is what I added back. Is it correct? And why am I still getting this orange error?

I deleted the product_width, product_height, product_depth and dimension_unit fields from my database a few versions ago because I don't use them. When I upgraded to the next version it automatically readded them, so I deleted them again. I know, I know I should have left them alone and will once this is figured out. Anyway, upgraded to 6.2.4 and these fields were not automatically added and I don't have the tax_percent field either. I went ahead and added the product_width, product_height, product_depth and dimension_unit fields I also get the orange error in admin/database. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. I have fields in the inventory table that I have added and what have been added via plugins. I don't think my database was updated when I upgraded to 6.2.4. In the 6.2.4 detup/db/upgrade file it says to CHANGE `dimension_unit` `dimension_unit` VARCHAR(2) NULL DEFAULT 'cm';. I don't know how to do that. I'd like to be sure my database is upgraded to the the current version 6.2.4. Anyway for me to check? When I upgraded I did get the red banner telling me to upgrade my database, which I did. Thanks for any and all help.

Hey Brian, If I use the code you gave me it works like I want. Thanks so much!! {if $product.available and $product.ctrl_stock}

Hey Brian, That worked if the item is unavailable (ie: listed on eBay etc.) But how do I NOT show the price ( or $0.00) if the item has sold? See the screenshot and my code earlier in this post.

I dont know if one has to do with the other but here goes. I do not use the height, width, depth, dimensional unit fields provided by CubeCart. I have previously deleted all fields (and related fields) from the product_inventory database. I don't like having columns I don't use. Anyway, after updating to 6.2.4 I keep getting the following error in my error log. What should I do? Thanks in advance for any and all help. [10-Mar-2019 17:34:28 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 18:03:25 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 19:17:11 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 19:19:35 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:05:19 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:33:38 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:49:35 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522 [10-Mar-2019 20:55:30 America/Louisville] PHP Warning: http_build_query() [<a href='http://docs.php.net/manual/en/function.http-build-query.php'>function.http-build-query.php</a>]: Parameter 1 expected to be Array or Object. Incorrect value given in /home/claudias/public_html/classes/db/database.class.php on line 522