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
[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! 
|
-boRg- wrote: