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: MOD Implementation
 'SITESTAT_ID' problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

esser
Starting Member

United Kingdom
14 Posts
Posted - 12 January 2006 :  18:16:32  Show Profile
I'm quite new to MySQL db..

But I keep getting this error when trying to MOD Snitz:

-2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-log]Invalid default value for 'SITESTAT_ID'

ANY idea how to sort this out will be greatly appriciated!

[Mod edit: Moved to MySql Forum]
Edited by - Podge on 12 January 2006 18:22:04

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 12 January 2006 :  19:21:34  Show Profile
What mod are you trying to install?
Post the contents of the DBS file of the mod you are trying to install.
Support Snitz Forums
Go to Top of Page

esser
Starting Member

United Kingdom
14 Posts
Posted - 13 January 2006 :  13:14:08  Show Profile
SORRY about the misplacement of the post..
Here are the contents of two of the DBS files I've tried.
quote:
MOD: Forum Rules v1.3
[CREATE]
RULES
RULES_ID
RULES_TITLE#VARCHAR (100)#NULL#
RULES_DESCRIPTION#memo#NULL#
RULES_ORDER#int#NULL#1
RULES_CAT#int#NULL#
[END]
[CREATE]
RULES_CATEGORY
RCAT_ID
RCAT_TITLE#VARCHAR (100)#NULL#
RCAT_ORDER#int#NULL#1
[END]
[INSERT]
RULES_CATEGORY
(RCAT_TITLE)#('General')
[END]

quote:
Forum Site Statistic
[CREATE]
SITESTAT
SITESTAT_ID
SITESTAT_YEAR#int#NULL#
SITESTAT_MONTH#int#NULL#
SITESTAT_TODAY#int#NULL#
SITESTAT_MONTH_COUNT#int#NULL#
SITESTAT_DAY_COUNT#int#NULL#
SITESTAT_MONTH_VISITOR#int#NULL#
SITESTAT_DAY_VISITOR#int#NULL#
SITESTAT_YESTERDAY_VISITOR#int#NULL#
SITESTAT_YESTERDAY_COUNT#int#NULL#
[END]

Common is I get "Invalid default value for..".

I'm new to MySQL but have been through a LOOOOT of topics and can't seem to find anything of help. Any suggestions??
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 January 2006 :  14:12:06  Show Profile
On line 275 in the admin_mod_dbsetup.asp file, remove the following code in red:
strSql = strSql & idFieldName &" INT (11) DEFAULT '' NOT NULL auto_increment "
And do the same thing for line 307 in the admin_mod_dbsetup2.asp file.

Then run the DBS files again.
Support Snitz Forums
Go to Top of Page

esser
Starting Member

United Kingdom
14 Posts
Posted - 13 January 2006 :  17:22:33  Show Profile
You are a GOD!!!! Thanks EVER so much buddy, I would have never found that out by myself.

Thanks!!
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 January 2006 :  18:59:06  Show Profile
Don't worry. MySQL has updated thier server on how they handle the DEFAULT field for auto_increment fields. Our code need to be updated to work with the new mysql server versions.

And you're welcome.

And no, I'm not a god, just a mere human being.
Support Snitz Forums
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07