We are unable to crate a new content region on one of our sites ... whenever we click "New region" we get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.7.10]Field 'contentID' doesn't have a default value

/vsadmin/inc/incfunctions.asp, line 1868

Never saw that one before ... any ideas?

Tim Gorski

Hi Tim
This seems to be because in the PHP version there is code to search for the first free content ID and use that, but in the ASP version the content ID is AUTO NUMERIC / AUTO_INCREMENT so does this automatically. I think as you are using a mySQL database with the ASP version this is how the problem has arisen. Do you have access to phpMyAdmin? If so, can you give the contentregions -> contentID the AUTO_INCREMENT (click on the contentregions table, then structure, then check A_I)

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

You da man, Vince! That did it ...

Thanks!

Tim Gorski