|
koakley
|
July 20, 2017 at 12:45 pm
Every few days we get this error. Is this a sign of bigger, underlying problem? Why is this database query trying to change a bunch of WP-options?
[Sun Jul 16 08:20:17.121262 2017] [:error] [pid 1941] [client xxx.xx.xx.xx:xxxxx] WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query INSERT INTO xx_options (option_name, `op
tion_value,autoload`) VALUES ('ee_core_routes', 'a:4:{s:10:\\"ee/v4.8.29\\";a:371:{s:6:\\"config\\";a:1:{i:0;a:3:{s:8:\\"callback\\";a:2:{i:0;s:61:\\"EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\co
nfig\\\\Read\\";i:1;s:14:\\"handle_request\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;}}s:10:\\"/resources\\";a:1:{i:0;a:3:{s:8:\\"callback\\";a:2:{i:0;s:60:\\"EventEspresso\\\\core\\\\libraries\\
\\rest_api\\\\controllers\\\\model\\\\Meta\\";i:1;s:26:\\"handle_request_models_meta\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;}}s:7:\\"answers\\";a:1:{i:0;a:5:{s:8:\\"callback\\";a:2:{i:0;s:60:\
\"EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\model\\\\Read\\";i:1;s:22:\\"handle_request_get_all\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;s:4:\\"args\\";a:7:{s:7:\\"include
\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:1:\\"*\\";s:11:\\"description\\";s:141:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#Including_Specific_Fields_and_Related_Entities_in_Results fo
r documentation\\";}s:5:\\"where\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";a:0:{}s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#where for documentation\\";}s:5:\\"
limit\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";i:50;s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#limit for documentation\\";}s:8:\\"order_by\\";a:3:{s:8:\\"requ
ired\\";b:0;s:7:\\"default\\";a:1:{s:6:\\"ANS_ID\\";s:3:\\"ASC\\";}s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#order_by for documentation\\";}s:8:\\"group_by\\";a:3:{s
:8:\\"required\\";b:0;s:7:\\"default\\";N;s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#group_by for documentation\\";}s:6:\\"having\\";a:3:{s:8:\\"required\\";b:0;s:7:\
\"default\\";N;s:11:\\"description\\";s:90:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#having for documentation\\";}s:4:\\"caps\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:4:\\"read\\";s:1
1:\\"description\\";s:88:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#caps for documentation\\";}}s:6:\\"_links\\";a:1:{s:4:\\"self\\";s:62:\\"https://www.faulkner.edu/wp-json/ee/v4.8.29answers/(?
P<id>\\\\d+)\\";}}}s:19:\\"answers/(?P<id>\\\\d+)\\";a:1:{i:0;a:4:{s:8:\\"callback\\";a:2:{i:0;s:60:\\"EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\model\\\\Read\\";i:1;s:22:\\"handle_request_get_one\
\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;s:4:\\"args\\";a:1:{s:7:\\"include\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:1:\\"*\\";s:11:\\"description\\";s:141:\\"See http://developer.even
tespresso.com/docs/ee4-rest-api-reading/#Including_Specific_Fields_and_Related_Entities_in_Results for documentation\\";}}}}s:32:\\"answers/(?P<id>\\\\d+)/registration\\";a:1:{i:0;a:4:{s:8:\\"callback\\";a:2:{i:0;s:60:\\
"EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\model\\\\Read\\";i:1;s:26:\\"handle_request_get_related\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;s:4:\\"args\\";a:7:{s:7:\\"incl
ude\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:1:\\"*\\";s:11:\\"description\\";s:141:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#Including_Specific_Fields_and_Related_Entities_in_Results
for documentation\\";}s:5:\\"where\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";a:0:{}s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#where for documentation\\";}s:5:
\\"limit\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";i:50;s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#limit for documentation\\";}s:8:\\"order_by\\";a:3:{s:8:\\"r
equired\\";b:0;s:7:\\"default\\";a:1:{s:6:\\"REG_ID\\";s:3:\\"ASC\\";}s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#order_by for documentation\\";}s:8:\\"group_by\\";a:3
:{s:8:\\"required\\";b:0;s:7:\\"default\\";N;s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#group_by for documentation\\";}s:6:\\"having\\";a:3:{s:8:\\"required\\";b:0;s:
7:\\"default\\";N;s:11:\\"description\\";s:90:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#having for documentation\\";}s:4:\\"caps\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:4:\\"read\\";
s:11:\\"description\\";s:88:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#caps for documentation\\";}}}}s:28:\\"answers/(?P<id>\\\\d+)/question\\";a:1:{i:0;a:4:{s:8:\\"callback\\";a:2:{i:0;s:60:\\"
EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\model\\\\Read\\";i:1;s:26:\\"handle_request_get_related\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;s:4:\\"args\\";a:7:{s:7:\\"inclu
de\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:1:\\"*\\";s:11:\\"description\\";s:141:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#Including_Specific_Fields_and_Related_Entities_in_Results
for documentation\\";}s:5:\\"where\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";a:0:{}s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#where for documentation\\";}s:5:\
\"limit\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";i:50;s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#limit for documentation\\";}s:8:\\"order_by\\";a:3:{s:8:\\"re
quired\\";b:0;s:7:\\"default\\";a:1:{s:6:\\"QST_ID\\";s:3:\\"ASC\\";}s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#order_by for documentation\\";}s:8:\\"group_by\\";a:3:
{s:8:\\"required\\";b:0;s:7:\\"default\\";N;s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#group_by for documentation\\";}s:6:\\"having\\";a:3:{s:8:\\"required\\";b:0;s:7
:\\"default\\";N;s:11:\\"description\\";s:90:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#having for documentation\\";}s:4:\\"caps\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:4:\\"read\\";s
:11:\\"description\\";s:88:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#caps for documentation\\";}}}}s:31:\\"answers/(?P<id>\\\\d+)/extra_metas\\";a:1:{i:0;a:4:{s:8:\\"callback\\";a:2:{i:0;s:60:\
\"EventEspresso\\\\core\\\\libraries\\\\rest_api\\\\controllers\\\\model\\\\Read\\";i:1;s:26:\\"handle_request_get_related\\";}s:7:\\"methods\\";s:3:\\"GET\\";s:15:\\"hidden_endpoint\\";b:1;s:4:\\"args\\";a:7:{s:7:\\"inc
lude\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";s:1:\\"*\\";s:11:\\"description\\";s:141:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#Including_Specific_Fields_and_Related_Entities_in_Result
s for documentation\\";}s:5:\\"where\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";a:0:{}s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#where for documentation\\";}s:5
:\\"limit\\";a:3:{s:8:\\"required\\";b:0;s:7:\\"default\\";i:50;s:11:\\"description\\";s:89:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#limit for documentation\\";}s:8:\\"order_by\\";a:3:{s:8:\\"
required\\";b:0;s:7:\\"default\\";a:1:{s:6:\\"EXM_ID\\";s:3:\\"ASC\\";}s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#order_by for documentation\\";}s:8:\\"group_by\\";a:
3:{s:8:\\"required\\";b:0;s:7:\\"default\\";N;s:11:\\"description\\";s:92:\\"See http://developer.eventespresso.com/docs/ee4-rest-api-reading/#group_by for documentation\\";}s:6:\\"having\\";a:3:{s:8:\\"required\\";b:0;s
:7:\\"default\\";N;s:11:\\"description\\";s:90:\\"
|
|
Josh
|
July 20, 2017 at 6:05 pm
Hi Keith,
It’s actually only trying to update one option. That’s a big option though. If you update to the current version of Event Espresso 4 you will not see that error anymore, because the later versions of Event Espresso do not use that option.
|
