Field Start_date on tblTopic is not updated!

Hi Web Wiz
I have discovered that the fields "Start_date"  and "Last_entry_date" on the tabel  tblTopic is not  updated any longer when creating a "New Topic".

I have recently updated to version 9.06 and after that changed database engine to MySQL.
I think the error came together with the change to MySQL.
( Have also tried to update to version 9.5 without luck)

The fields are defined as "Datetime" and "Not Null"

Can any one help me?

Jesper Kick

Hi WebWiz-Bruce

Thanks for your fast reply, which surprise me a little. As far as I can se is the Access and the Mysql version using exactly the same code, the only difference is the database engine. To my best knowledge are both of them relational database. But ok I'm not an expert in these areas.

I did not know that I should upgrade from Access to MSSQL and not MYSQL. So I did upgrated from Access to Mysql  and it went fine.

First  I converted the database with a standard tool from MySQL.
Second I changed the tabel name to a capitol first letter e.g. tbltopic to tblTopic.
Third I installed at test version of the standard MySQL version webwizdatabase, and manually comparred the field definition of all the tabels with my converted MySQL
And final I corrected the converted database.
After that no problems, untill I found the two fields.

I have studied the version 9.06 of the code and the two fields are not mentioned there. So it must bee some old garbage from a mod, sorry to bother you.




Edited by Jesper Ahlers - 05 May 2008 at 10:15pm