Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 ODBC Drivers		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

snakedoctor
Starting Member

USA
12 Posts
Posted - 24 June 2007 :  10:24:56  Show Profile
Hope this is the right place for this problem. Had time last nite to try the snitz setup.asp. This is what i get: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'name of database.forum_moderator' doesn't exist/default.asp, line 108.
Looking around forum I didn't see anyone with same problem.

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 24 June 2007 :  10:41:48  Show Profile  Send ruirib a Yahoo! Message
Did setup complete without errors?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

snakedoctor
Starting Member

USA
12 Posts
Posted - 24 June 2007 :  16:11:47  Show Profile
yes i had five errors
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 24 June 2007 :  17:32:38  Show Profile  Send ruirib a Yahoo! Message
So, how can we help if you don't tell us what the errors were?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

snakedoctor
Starting Member

USA
12 Posts
Posted - 24 June 2007 :  17:49:59  Show Profile
sorry guess i should do this when have more time. here are the five errors.[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'XXXXX.forum_forum' doesn't exist
[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'XXXXX.forum_members' doesn't exist
has this line three times
[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 24 June 2007 :  17:57:55  Show Profile  Send ruirib a Yahoo! Message
That happened when running setup.asp? Try running setup.asp?RC=5

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

snakedoctor
Starting Member

USA
12 Posts
Posted - 25 June 2007 :  07:51:30  Show Profile
I have craeted new database then setup.asp?RC=5 and get 5 Critical Errors...

This what I get when I try setup.asp?RC=5 3 lines with the error 2147467259

Error: -2147467259 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value

Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'xxxxx.forum_members' doesn't exist

Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Table 'xxxxx.forum_forum' doesn't exist
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 25 June 2007 :  08:40:29  Show Profile  Send ruirib a Yahoo! Message
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=64954&SearchTerms=inc_create_forum_mysql

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

snakedoctor
Starting Member

USA
12 Posts
Posted - 25 June 2007 :  12:27:21  Show Profile
Thanks All for the help but this just take to much to get running and I don't have the time to learn all there is just to put it up on a server.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 25 June 2007 :  13:05:18  Show Profile  Send ruirib a Yahoo! Message
There is nothing to learn, the SQL code for MYSQL just needs a few changes, since MySQL 5.x is less tolerant regarding syntax than its predecessors.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07