SQL error on a column that doesn't exist in the table

SQL error on a column that doesn't exist in the table

jimomakjimomak Posts: 22Questions: 4Answers: 0

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?

Answers

  • colincolin Posts: 15,177Questions: 1Answers: 2,590

    Thread repeated here - please only post once.

    Colin

This discussion has been closed.