SQL error on a column that doesn't exist in the table
SQL error on a column that doesn't exist in the table
error "An SQL error occurred: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column users.vendors.Id at row 1
This is a odd error, as the database does not have a column with a datetime format, nor do any of the php files in use. table.vendors.php does not have a datetime field, nor the html headers, nor table.vendors.js . I've rebooted, cleared the cache, checked the files, yet this error persists. I generated the first table 'users' which had a datatime field. I then copied theses files, changed the fields, generated the table properly, and it all renders. Everything works accept 'CREATE' which throws this error.
Does anyone have an idea?
This discussion has been closed.
Answers
Thread repeated here - please only post once.
Colin