Thu Apr 11 2024 18:48:59 GMT+0000 (Coordinated Universal Time) {"code":"WARN_DATA_TRUNCATED","errno":1265,"sqlMessage":"Data truncated for column 'np_capacity' at row 1","sqlState":"01000","index":0,"sql":"CALL `new_solar_project`('{\\\"proj_name\\\":\\\"Siemer Solar\\\",\\\"agent_id\\\":\\\"10738\\\",\\\"address1\\\":\\\"2700 Noth Setterbo Road\\\",\\\"address2\\\":\\\"\\\",\\\"suite\\\":\\\"\\\",\\\"city\\\":\\\"Suttons Bay\\\",\\\"state\\\":\\\"MI\\\",\\\"zip\\\":\\\"49682\\\",\\\"pref_email\\\":\\\"putski57@gmail.com\\\",\\\"separate_location\\\":0,\\\"custom_data\\\":\\\"\\\",\\\"net_metering\\\":0}', '{\\\"np_capacity\\\":\\\"7,400\\\",\\\"p_address1\\\":\\\"2700 Noth Setterbo Road\\\",\\\"p_address2\\\":\\\"\\\",\\\"p_suite\\\":\\\"\\\",\\\"p_city\\\":\\\"Suttons Bay\\\",\\\"p_state\\\":\\\"MI\\\",\\\"p_zip\\\":\\\"49682\\\",\\\"defects\\\":0,\\\"function\\\":0,\\\"storage\\\":0}');"}
Thu Apr 11 2024 18:51:00 GMT+0000 (Coordinated Universal Time) {"code":"ER_BAD_NULL_ERROR","errno":1048,"sqlMessage":"Column 'owner_email' cannot be null","sqlState":"23000","index":0,"sql":"CALL `update_temp_project`('{\\\"id\\\":167,\\\"agent_id\\\":\\\"10738\\\",\\\"status\\\":\\\"inprogress\\\",\\\"data\\\":{\\\"proj_name\\\":\\\"Siemer Solar\\\",\\\"np_capacity\\\":\\\"7,400\\\",\\\"address1\\\":\\\"2700 North Setterbo Road\\\",\\\"address2\\\":\\\"\\\",\\\"suite\\\":\\\"\\\",\\\"city\\\":\\\"Suttons Bay\\\",\\\"state\\\":{\\\"value\\\":23,\\\"name\\\":\\\"Michigan\\\",\\\"abbreviation\\\":\\\"MI\\\"},\\\"zip\\\":\\\"49682\\\",\\\"p_address1\\\":\\\"2700 North Setterbo Road\\\",\\\"p_address2\\\":\\\"\\\",\\\"p_suite\\\":\\\"\\\",\\\"p_city\\\":\\\"Suttons Bay\\\",\\\"p_state\\\":{\\\"value\\\":23,\\\"name\\\":\\\"Michigan\\\",\\\"abbreviation\\\":\\\"MI\\\"},\\\"p_zip\\\":\\\"49682\\\",\\\"separate_location\\\":false}}');"}
Thu Apr 11 2024 18:52:58 GMT+0000 (Coordinated Universal Time) {"code":"ER_BAD_NULL_ERROR","errno":1048,"sqlMessage":"Column 'owner_email' cannot be null","sqlState":"23000","index":0,"sql":"CALL `update_temp_project`('{\\\"id\\\":167,\\\"agent_id\\\":\\\"10738\\\",\\\"status\\\":\\\"inprogress\\\",\\\"data\\\":{\\\"proj_name\\\":\\\"Setterbo House\\\",\\\"np_capacity\\\":\\\"7,400\\\",\\\"address1\\\":\\\"2700 North Setterbo Road\\\",\\\"address2\\\":\\\"\\\",\\\"suite\\\":\\\"\\\",\\\"city\\\":\\\"Suttons Bay\\\",\\\"state\\\":{\\\"value\\\":23,\\\"name\\\":\\\"Michigan\\\",\\\"abbreviation\\\":\\\"MI\\\"},\\\"zip\\\":\\\"49682\\\",\\\"p_address1\\\":\\\"2700 North Setterbo Road\\\",\\\"p_address2\\\":\\\"\\\",\\\"p_suite\\\":\\\"\\\",\\\"p_city\\\":\\\"Suttons Bay\\\",\\\"p_state\\\":{\\\"value\\\":23,\\\"name\\\":\\\"Michigan\\\",\\\"abbreviation\\\":\\\"MI\\\"},\\\"p_zip\\\":\\\"49682\\\",\\\"separate_location\\\":false}}');"}
Sun Apr 14 2024 12:04:59 GMT+0000 (Coordinated Universal Time) {"code":"ER_TRUNCATED_WRONG_VALUE_FOR_FIELD","errno":1366,"sqlMessage":"Incorrect integer value: 'null' for column 'agent_id' at row 1","sqlState":"HY000","index":0,"sql":"CALL `new_temp_project`('{\\\"id\\\":0,\\\"email\\\":\\\"shethrshethr@yahoo.com\\\",\\\"agent_id\\\":null,\\\"status\\\":\\\"inprogress\\\",\\\"data\\\":{\\\"proj_name\\\":\\\"Sheth Solar\\\",\\\"np_capacity\\\":\\\"8\\\",\\\"address1\\\":\\\"3262 North Hembree Road\\\",\\\"address2\\\":\\\"\\\",\\\"suite\\\":\\\"\\\",\\\"city\\\":\\\"Marietta\\\",\\\"state\\\":{\\\"value\\\":11,\\\"name\\\":\\\"Georgia\\\",\\\"abbreviation\\\":\\\"GA\\\"},\\\"zip\\\":\\\"30062\\\",\\\"p_address1\\\":\\\"3262 North Hembree Road\\\",\\\"p_address2\\\":\\\"\\\",\\\"p_suite\\\":\\\"\\\",\\\"p_city\\\":\\\"Marietta\\\",\\\"p_state\\\":{\\\"value\\\":11,\\\"name\\\":\\\"Georgia\\\",\\\"abbreviation\\\":\\\"GA\\\"},\\\"p_zip\\\":\\\"30062\\\",\\\"separate_location\\\":false}}');"}
Sun Apr 14 2024 12:05:04 GMT+0000 (Coordinated Universal Time) {"code":"ER_PARSE_ERROR","errno":1064,"sqlMessage":"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 '?)' at line 1","sqlState":"42000","index":0,"sql":"CALL `finalize_temp_project`(?);"}
Fri Apr 19 2024 02:26:01 GMT+0000 (Coordinated Universal Time) {"code":"ER_BAD_NULL_ERROR","errno":1048,"sqlMessage":"Column 'owner_email' cannot be null","sqlState":"23000","index":0,"sql":"CALL `update_temp_project`('{\\\"id\\\":174,\\\"agent_id\\\":\\\"46867\\\",\\\"status\\\":\\\"inprogress\\\",\\\"data\\\":{\\\"proj_name\\\":\\\"Better Earth\\\",\\\"np_capacity\\\":\\\"14\\\",\\\"address1\\\":\\\"3706 East North Bay Street\\\",\\\"address2\\\":\\\"\\\",\\\"suite\\\":\\\"\\\",\\\"city\\\":\\\"Tampa\\\",\\\"state\\\":{\\\"value\\\":10,\\\"name\\\":\\\"Florida\\\",\\\"abbreviation\\\":\\\"FL\\\"},\\\"zip\\\":\\\"33610\\\",\\\"p_address1\\\":\\\"3706 East North Bay Street\\\",\\\"p_address2\\\":\\\"\\\",\\\"p_suite\\\":\\\"\\\",\\\"p_city\\\":\\\"Tampa\\\",\\\"p_state\\\":{\\\"value\\\":10,\\\"name\\\":\\\"Florida\\\",\\\"abbreviation\\\":\\\"FL\\\"},\\\"p_zip\\\":\\\"33610\\\",\\\"separate_location\\\":false}}');"}