MySQL error creating ’tblThread’
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=17840
Printed Date: 13 April 2026 at 6:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL error creating ’tblThread’
Posted By: Mikey
Subject: MySQL error creating ’tblThread’
Date Posted: 11 January 2006 at 3:14pm
Firstly, Congrats to -BoRg- on all the great software he produces i have been waiting for a chance to play with V8 with bated breath  So far i have tried to install the MySQL version (will try MSSQL at a later date to). I have created a new blank MySQL DB and configured the 'database_configuration.asp' file, Upon running the 'mysql_server_setup.asp' file and entering the correct username and password i receive these errors...
not sure if this is on my behalf or if it's a problem with the setup file. Thought i better let you know just incase and wondered if there's a fix i can use? Cheers -BoRg-  ------------- Handyman man? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 11 January 2006 at 3:21pm
|
Try changing line 331 of the mySQL_server_setup.asp file to:- strSQL = strSQL & "File_uploads text NOT NULL, " I changed it to 'varchar (750)' last night as I found a problem with ADO updates if the record contains a 'NULL' value in a 'text' field. So I had to find a work aorund for this ADO bug. However, by setting it to text NOT NULL, it should fix the issue. ------------- 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: Mikey
Date Posted: 11 January 2006 at 10:11pm
Sorry for the late reply -BoRg- i had to go to work  lolA few more errors came up but after i created a fresh blank DB it worked a treat, now to get playing and skinning   ------------- Handyman man? |