Matt Lemke hasn't been able to do much SP work due to getting a really ugly SQL error (this is the one I got):
- Code: Select all
replace_object() INSERT INTO `objects` SET `last_edit`=NOW(),`last_edit_user_id`='67750',`show_toc`='Yes',`construction`='No',`obj_type_name`='Cheezy Peak',`object_name`='Cheezy Peak',`province`=NULL,`county`=NULL,`latitude`=NULL,`longitude`=NULL,`private_attach`='Yes',`bannertypeclick`='htmlSticker',`query`='Find Weather',`object_body_ft`='It ain\'t easy being cheezy',`object_id`='863222',`type_id`='8',`creation`='2013-08-24 21:15:52',`created_user_id`='67750',`is_primary_photo_user_set`=0,`query_name`='Cheezy Peak' ON DUPLICATE KEY UPDATE `last_edit`=NOW(),`last_edit_user_id`='67750',`show_toc`='Yes',`construction`='No',`obj_type_name`='Cheezy Peak',`object_name`='Cheezy Peak',`province`=NULL,`county`=NULL,`latitude`=NULL,`longitude`=NULL,`private_attach`='Yes',`bannertypeclick`='htmlSticker',`query`='Find Weather',`object_body_ft`='It ain\'t easy being cheezy',`object_id`='863222',`type_id`='8',`creation`='2013-08-24 21:15:52',`created_user_id`='67750',`is_primary_photo_user_set`=0,`query_name`='Cheezy Peak' failed: DB Error: no such field
Fortunately after doing over an hour of investigating I figured out it had to do with weather boxes (like weather underground and such). In this case there was a form and a event handler being called.
After stripping out the code, poof the page worked just fine. Another interesting fact about that was that it occurred more in Google Chrome than FireFox. So if anyone gets crazy code like I have above, let me investigate it. I'll probably figure it out.
But small time code, well I got more to learn for that part.