2 database errors

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
njsweb Members Profile Find Members Posts Newbie Joined: 25 January 2005 Status: Offline Points: 15	Post Options Post Reply Quote njsweb Report Post Thanks(0) Quote Reply Topic: 2 database errors Posted: 04 August 2006 at 1:02pm
	I converted from Access ot Mysql. I now get this when I try to create a new topic: Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator. Support Error Code:- err_mySQL_save_new_topic_data File Name:- new_post.asp Error details:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Field 'Topic_ID' doesn't have a default value and I get this when I try to edit an existing post: SELECT tblThread.Thread_ID, tblThread.Author_ID, tblThread.Message, tblThread.Show_signature, tblThread.IP_addr, tblThread.Hide, tblThread.File_uploads FROM tblThread WHERE tblThread.Thread_ID=279; Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Invalid string or buffer length /forum/edit_post.asp, line 562 Help - my forum is down! Thank you

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 04 August 2006 at 1:22pm
	It looks like what ever method you used to convert the database to mySQL has not worked and the default values for the fields have not been carried across. You need to do the conversion process again and this time insure that default values are carried across as well.
	Web Wiz Forums Hosting ASP.NET Web Hosting

njsweb Members Profile Find Members Posts Newbie Joined: 25 January 2005 Status: Offline Points: 15	Post Options Post Reply Quote njsweb Report Post Thanks(0) Quote Reply Posted: 04 August 2006 at 11:59pm
	I used the mysql database migration tool. I set permissions the way the migration tool recommended. I uninstalled mysql adn reinstalled it, then re-migrated the data. Same results. I don't see how I can set the default value to be imported. I looked for those optons when I impirted and didn't see them. The forum was working a few days ago and suddenly stopped. Still down... Thanks Edited by njsweb - 05 August 2006 at 12:08am

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 05 August 2006 at 8:59am
	I've never seen the tool you mention, but there are lots of tools around to migrate from Access to mySQL, maybe worth trying a different tool. Also, if your Access database was originally a 7.x database that has been upgraded then you will not be able to migrate the database to mySQL.
	Web Wiz Forums Hosting ASP.NET Web Hosting

angel Members Profile Find Members Posts Newbie Joined: 16 February 2006 Status: Offline Points: 36	Post Options Post Reply Quote angel Report Post Thanks(0) Quote Reply Posted: 05 August 2006 at 1:09pm
	the mysql migration tool kit is not moving corectly the data for the tables, do to defrences in data types between the database types

njsweb Members Profile Find Members Posts Newbie Joined: 25 January 2005 Status: Offline Points: 15	Post Options Post Reply Quote njsweb Report Post Thanks(0) Quote Reply Posted: 05 August 2006 at 1:31pm
	Well, I started with a new download of hte Access version, added some posts to test and converted to mysql using the Mysql data migration tool. Same results as before: Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator. Support Error Code:- err_mySQL_save_new_topic_data File Name:- new_post.asp Error details:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Field 'Locked' doesn't have a default value anyone know of a good data migration tool? Thanks

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 05 August 2006 at 5:20pm
	Another way to do it, is to have a look through the Access database and manually create the default values in the mySQL database. A few things to watch out for is that True and False become 1 and 0 in mySQL, but date felds which is Now() in Access are now handles by the forum code.
	Web Wiz Forums Hosting ASP.NET Web Hosting

njsweb Members Profile Find Members Posts Newbie Joined: 25 January 2005 Status: Offline Points: 15	Post Options Post Reply Quote njsweb Report Post Thanks(0) Quote Reply Posted: 05 August 2006 at 5:36pm
	I set the database defaults, I suppose, but I don't understand what you mean regarding the now()... what do I do with those fields?

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum