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
 I can't install Snitz with MySQL server
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 29 January 2007 :  19:00:00  Show Profile
Can this be moved to the mysql forum please? Thanks.

Support Snitz Forums
Go to Top of Page

Leodemario
Starting Member

Brazil
34 Posts

Posted - 30 January 2007 :  10:45:09  Show Profile
Ok no problem, I have installed a fresh copy of Image 3.4.06 Portal 3D and have various error messages and had commented a few code lines in 5 files for complet the installtion. Then I go to install a fresh copy of Snitz Forum 3.4.06 and next I make a report in case of bugs.

Thanks for All.

The stairs of Humility have low and large degrees, the one of pride, high and strait degrees...
Go to Top of Page

Leodemario
Starting Member

Brazil
34 Posts

Posted - 30 January 2007 :  11:38:06  Show Profile
The Snitz 3.4.06 have bugs in inc_create_forum_mysql.asp too:

Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'F_DESCRIPTION' can't have a default value - CREATE TABLE FORUM
------------------------------------------------------------------------------
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value - CREATE TABLE MEMBERS
------------------------------------------------------------------------------
Error: -2147217871 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]BLOB/TEXT column 'M_SIG' can't have a default value - MEMBERS_PENDING
------------------------------------------------------------------------------
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'snitz3406.forum_members' doesn't exist
------------------------------------------------------------------------------
Error: -2147217865 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'snitz3406.forum_forum' doesn't exist

Then I drop and recreate the database in MySQL Server and replace the inc_create_forum_mysql.asp with my inc_create_forum... modified and all runs fine.

The stairs of Humility have low and large degrees, the one of pride, high and strait degrees...

Edited by - Leodemario on 30 January 2007 11:39:45
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 January 2007 :  16:44:27  Show Profile  Send ruirib a Yahoo! Message
That's because MySQL 5.0 doesn't like those default values... I guess we need to remove them.


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

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 30 January 2007 :  18:15:24  Show Profile
Somehow, those problems didn't arise when we tested it with an earlier version of version 5. So it seems they added those changes since we last released 3.4.06.

Will keep it in mind for the next update.

Support Snitz Forums
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 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.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07