Very Slow After New Update 6.4.9

[slic535]

i have updated my site from 6.4.7 to 6.4.9 and it makes it so slow it wont work. i get a 500 error. what can be done to fix this? in my error log i get this

 

42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 217
[08-Jan-2023 13:16:15 America/Chicago] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 217
[08-Jan-2023 13:16:15 America/Chicago] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 217
[08-Jan-2023 13:16:15 America/Chicago] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 217
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 196608 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 196608 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 196608 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:27 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:27 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 19:16:28 UTC] PHP Fatal error:  User 'slic535_ccr' has exceeded the 'max_user_connections' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 42
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 196608 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 200704 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 69632 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 106496 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 204800 bytes) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 174
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 13:16:28 America/Chicago] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home3/slic535/public_html/classes/db/database.class.php on line 1011
[08-Jan-2023 19:16:36 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home3/slic535/public_html/classes/db/database.class.php on line 959
[08-Jan-2023 19:16:37 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 132
[08-Jan-2023 19:16:37 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home3/slic535/public_html/classes/db/database.class.php on line 959
[08-Jan-2023 19:16:37 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 217
[08-Jan-2023 19:16:37 UTC] PHP Warning:  mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: (42000/1226): User 'slic535_ccr' has exceeded the 'max_questions' resource (current value: 1) in /home3/slic535/public_html/classes/db/mysqli.class.php on line 132
[08-Jan-2023 19:16:37 UTC] PHP Notice:  `language` is not allowed as a key in 'CubeCart_lang_strings' table! in /home3/slic535/public_html/classes/db/database.class.php on line 959

[bsmither]

I am basically familiar with 'max_user_connections'. I have never experienced it, but I think it would happen if the site was being very heavily hit by hundreds of visitors all at the same time.

Running out of memory... Line 1011 is where CubeCart is wanting to collect the 'backtrace'.

Using an external database utility (such as phpMyAdmin found in your host account's control panel), view the table CubeCart_system_error_log. Find the row with the highest 'log_id'. What values are in the 'message' and 'backtrace' column?

 

[slic535]

File: [catalogue.class.php] Line: [1872] "SELECT   `id` FROM `store1CubeCart_manufacturers` WHERE `name` LIKE '%Frank B 11' stiletto %'   ;" - 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 'stiletto %'' at line 1

 

 

i had to do a backup and go back to the last version 6.4.7 to make it work. this is what  i found but thats after the backup. i am afraid to do the update again because it didnt work the first time. i have another website at wholesaleselfdefense.com that i did the update on and its working ok. not sure what would cause the update not to work.

[bsmither]

I can see why MySQL doesn't like that query. The use of an apostrophe (and quote) to indicate a measure of length (feet, inches) will cause problems.

But the above does not look like what should be seen in phpMyAdmin - looking directly at the database.

For having done the backup, did you also restore the database from that backup? If so, the rows of interest in the table CubeCart_system_error_log may now be lost.