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
 Weird error when adding DKP mod to forum.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Heu
Starting Member

9 Posts

Posted - 03 February 2006 :  16:06:33  Show Profile
Hi

I'm trying to add the DKP system mod to the forum but,
I get this error when trying to add the database.
-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Invalid default value for 'BID'

-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Invalid default value for 'IID'

-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Invalid default value for 'MDID'

-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Invalid default value for 'RMID'

-2147467259 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Invalid default value for 'RID'

I have tried adding the the tables to the database mannually but that doesn't work ar all with those weird tables called BID only

I hope you can help

Thx

Heu
Starting Member

9 Posts

Posted - 03 February 2006 :  18:19:48  Show Profile
The basic problem is how do i add that BID line...
The script from the asp file to create the database is this:
[CREATE]
DKP_BOSSES
BID
BOSS#varchar(100)#NULL#
BOSSVAL#int#NULL#
[END]

The bid wont be added, it just makes the error above.
Go to Top of Page

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  07:52:19  Show Profile
Can't anyone help?????
Go to Top of Page

AnonJr
Moderator

United States
5765 Posts

Posted - 05 February 2006 :  09:37:15  Show Profile  Visit AnonJr's Homepage
Have you checked this item? http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55925
Go to Top of Page

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  11:35:51  Show Profile
Yes i had that problem too, but that's a whole other problem. This is about the database. It cant create that bid line.
i had another error where it said this:
[MySQL][ODBC 3.51 Driver][mysqld-4.1.12-standard]Unknown column 'FORUM_DKP_RAIDS.RID' in 'field list'
how do i make that RID column???
someone must know!!
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 February 2006 :  11:45:59  Show Profile  Send ruirib a Yahoo! Message
In admin_mod_dbsetup.asp, line# 275, where you now have

strSql = strSql & idFieldName &" INT (11) DEFAULT '' NOT NULL auto_increment "

replace it by

strSql = strSql & idFieldName &" INT (11) NOT NULL auto_increment "


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

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  12:47:07  Show Profile
now it just says:
Table already exists
and still doesn't work
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 February 2006 :  13:03:51  Show Profile  Send ruirib a Yahoo! Message
Better delete the table and try again.


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

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  15:20:11  Show Profile
almost works now..
I get this error when trying to add a raid:
ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/admin_dkp_add_raid.asp, line 131
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 February 2006 :  16:38:38  Show Profile  Send ruirib a Yahoo! Message
Did you run setup.asp before that?


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

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  16:50:47  Show Profile
yes that's long time ago
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 February 2006 :  17:17:18  Show Profile  Send ruirib a Yahoo! Message
Need to do it after the mod install too.


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

Heu
Starting Member

9 Posts

Posted - 05 February 2006 :  18:04:00  Show Profile
It just deleted all i have on the forum.... and it doesn't work....
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 05 February 2006 :  18:28:26  Show Profile  Send ruirib a Yahoo! Message
Maybe it has to do with the mod... I don't know it.


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.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07