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
 Snitz: Issue with latest version of MySQL		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jarrek
Starting Member

17 Posts
Posted - 28 November 2006 :  17:39:43  Show Profile
When setting up a new MySQL database, some TEXT fields cannot be created because of the " DEFAULT ''" statement.

I had to remove it from code.

Is this a known issue?

This is with build 5.0.27 of MySQL.

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 28 November 2006 :  18:39:01  Show Profile  Send ruirib a Yahoo! Message
Are you talking about Snitz 3.4.06?

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

Jarrek
Starting Member

17 Posts
Posted - 29 November 2006 :  00:39:31  Show Profile
Yes.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 November 2006 :  06:03:25  Show Profile  Send ruirib a Yahoo! Message
Snitz 3.4.06 fixed, AFAIK, those default values. Can you post the exact error message?

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

Jarrek
Starting Member

17 Posts
Posted - 29 November 2006 :  14:15:40  Show Profile
I'll set up another board on my server and will post the results here over the weekend.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 29 November 2006 :  19:20:41  Show Profile
you can probably get around the problem by removing the STRICT_TRANS_TABLES property in my.ini
======
Doug G
======
Computer history and help at www.dougscode.com
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.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07