Web Wiz Support and Community Forums : 2 database errors https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 06:36:43 +0000 Fri, 26 Jan 2007 11:39:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20914 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[2 database errors : -boRg- wrote:Also, if your...]]> https://forums.webwiz.net/2-database-errors_topic20914_post119861.html#119861 Author: MrMellie
Subject: 20914
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!

Edited by MrMellie - 26 January 2007 at 11:48am]]> Fri, 26 Jan 2007 11:39:20 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post119861.html#119861 <![CDATA[2 database errors : OK progess of a sort, but not...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112199.html#112199 Author: njsweb
Subject: 20914
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?
 
]]> Sun, 06 Aug 2006 06:17:13 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112199.html#112199 <![CDATA[2 database errors : OK, I need to check out a few...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112197.html#112197 Author: njsweb
Subject: 20914
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
]]> Sun, 06 Aug 2006 05:27:10 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112197.html#112197 <![CDATA[2 database errors : Access is a flat file which is...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112176.html#112176 Author: WebWiz-Bruce
Subject: 20914
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.
]]> Sat, 05 Aug 2006 17:50:59 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112176.html#112176 <![CDATA[2 database errors : Alternativey, anyone have a working...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112174.html#112174 Author: njsweb
Subject: 20914
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
]]> Sat, 05 Aug 2006 17:38:33 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112174.html#112174 <![CDATA[2 database errors : I set the database defaults, I...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112173.html#112173 Author: njsweb
Subject: 20914
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?]]> Sat, 05 Aug 2006 17:36:54 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112173.html#112173 <![CDATA[2 database errors : Another way to do it, is to have...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112171.html#112171 Author: WebWiz-Bruce
Subject: 20914
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.
]]> Sat, 05 Aug 2006 17:20:29 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112171.html#112171 <![CDATA[2 database errors : Well, I started with a new download...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112156.html#112156 Author: njsweb
Subject: 20914
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
]]> Sat, 05 Aug 2006 13:31:58 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112156.html#112156 <![CDATA[2 database errors : the mysql migration tool kit is...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112153.html#112153 Author: angel
Subject: 20914
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
]]> Sat, 05 Aug 2006 13:09:01 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112153.html#112153 <![CDATA[2 database errors : I&#039;ve never seen the tool...]]> https://forums.webwiz.net/2-database-errors_topic20914_post112143.html#112143 Author: WebWiz-Bruce
Subject: 20914
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.
]]> Sat, 05 Aug 2006 08:59:13 +0000 https://forums.webwiz.net/2-database-errors_topic20914_post112143.html#112143