| Author |
 Topic  |
|
|
Heu
Starting Member
9 Posts |
 Posted - 03 February 2006 : 16:06:33
|
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
|
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. |
 |
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 07:52:19
|
| Can't anyone help????? |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 11:35:51
|
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!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 February 2006 : 11:45:59
|
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 |
|
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 12:47:07
|
now it just says:
Table already exists
and still doesn't work |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 15:20:11
|
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 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 16:50:47
|
| yes that's long time ago |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Heu
Starting Member
9 Posts |
Posted - 05 February 2006 : 18:04:00
|
| It just deleted all i have on the forum.... and it doesn't work.... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
