https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 18:06:27 +0000 Wed, 11 Jan 2006 22:11:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17840 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96900.html#96900 Author: Mikey
Subject: 17840
Posted: 11 January 2006 at 10:11pm

Sorry for the late reply -BoRg- i had to go to work  lol

A few more errors came up but after i created a fresh blank DB it worked a treat, now to get playing and skinning
]]> Wed, 11 Jan 2006 22:11:08 +0000 https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96900.html#96900 https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96841.html#96841 Author: WebWiz-Bruce
Subject: 17840
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.
]]> Wed, 11 Jan 2006 15:21:07 +0000 https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96841.html#96841 https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96838.html#96838 Author: Mikey
Subject: 17840
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...

Error Creating the Table tblThread [MySQL][ODBC 3.51 Driver][mysqld-4.0.21-debug]Too big column length for column 'File_uploads' (max = 255). Use BLOB instead Error Creating one or more Indexs [MySQL][ODBC 3.51 Driver][mysqld-4.0.21-debug]Table 'v8test.tblthread' doesn't exist mySQL database is set up, but with Error!

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-
]]> Wed, 11 Jan 2006 15:14:45 +0000 https://forums.webwiz.net/mysql-error-creating-tblthread_topic17840_post96838.html#96838