Field Start_date on tblTopic is not updated!
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25681
Printed Date: 03 April 2026 at 4:05pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Field Start_date on tblTopic is not updated!
Posted By: Jesper kick
Subject: Field Start_date on tblTopic is not updated!
Date Posted: 03 May 2008 at 9:28am
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
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 05 May 2008 at 8:53pm
mySQL is very different to Access and SQL Server which are relational databases and therefore the database schema for mySQL is very different to the other support database types.
Migrating to mySQL from Acess or SQL Server is something which is not supported as it is often leads to errors and an unstable forum, owing to the very different database schema.
If you were previously using Access you should upsize your database to SQL Server, the mySQL version should only be used from the start and not be migrated to.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: Jesper Ahlers
Date Posted: 05 May 2008 at 10:12pm
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.
|
|