Print Page | Close Window

2 database errors

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=20914
Printed Date: 08 April 2026 at 6:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: 2 database errors
Posted By: njsweb
Subject: 2 database errors
Date 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
 



Replies:
Posted By: WebWiz-Bruce
Date 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.


-------------
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: njsweb
Date 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
 
 
 


Posted By: WebWiz-Bruce
Date 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.


-------------
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: angel
Date 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


-------------
soon


Posted By: njsweb
Date 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


Posted By: WebWiz-Bruce
Date 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.


-------------
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: njsweb
Date 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?


Posted By: njsweb
Date Posted: 05 August 2006 at 5:38pm
Alternativey, anyone have a working mysql database I can copy and clear of all posts? or a blank mySQL dadtabase for webwhiz forums that I can copy over?
I rather wish a sample mysql database was included like the one for access


Posted By: WebWiz-Bruce
Date Posted: 05 August 2006 at 5:50pm
Access is a flat file which is why it is crap and the database is included.

mySQL is a server so you don't have the physical file like with Access, instead there is a mySQL setup tool that creates the mySQL database for you on the mySQL server.

If you create a blank mySQL database then use the database setup tool that comes with web wiz forums to create the database schema.


-------------
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: njsweb
Date Posted: 06 August 2006 at 5:27am
OK, I need to check out a few things then.. First, I need to find a tool to create a blank mySQL database.  I have 5.0 running here, but I am completely unfamiliar with mySQL.
 
Second thing i need to find is the database set up tool that comes with web wiz forum. I dont' recall seeing that tool anywhere in the zip file.
 
Sorry for asking such rudimentary quesitons, but Access, crappy as it may be, is hte devil I know. MySQL is hte deveil I don't know...
 
Thanks


Posted By: njsweb
Date Posted: 06 August 2006 at 6:17am

OK progess of a sort, but not done

I created a database, and ran the MYSQL setup script.. It works with one problem

If i have one category and try to create a forum, I get an error:

POST /forum-mysql/admin_forum_details.asp FID=0|143|800a000d|Type_mismatch:_'CInt' 500
 
If I create a second category, I can create forums (or is it fora?) in the second category, but not the first one.
 
If I delete the first one, then I can't create forums in the remaining category.
 
any ideas?
 


Posted By: MrMellie
Date Posted: 26 January 2007 at 11:39am
Originally posted by -boRg- -boRg- wrote:

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.
Bruce, could you expand on why this is? It throws a spanner in the works for me converting from Snitz as the conversion route involves starting with a v7 Access database and then upgrading to v8 and thence to MySQL or MSQL.

[edit]Ok, think I found the explanation in your response on this thread:

http://forums.webwiz.net/forum_posts.asp?TID=21376&KW=mysql+conversion

is that all that needs doing or is there anything else that might upset it? Thanks!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net