EQdkp-Plus - DKP System - Raidplaner - Guildportal - Gildenportal - WoW, Lotro, Runes of Magic home of the EQDKP Plus Projekt

Hiya

I am hoping you can help

I am new to administering forums and EQDKP+ although know former guild have used them successfully hence my choice.

I am trying to install the importlog plug in so i can input my dkp strings but get the following.

The following error(s) occurred:
Installation: Plugin "raidlogimport" installation SQL failed.
Installation: Error in SQL command:
"SQL ERROR

Query: INSERT INTO __raidlogimport_bz (bz_type, bz_string, bz_note, bz_bonus, bz_bonusph, bz_diff, bz_sort) VALUES ('zone', 'Naxxramas', 'Naxx', '0', '5', '', '0');
Message: Incorrect integer value: '' for column 'bz_diff' at row 1
Code: 1366
Database : Malice
Table Prefix: eqdkp_
PHP: 5.2.9-2 | Mysql: 5.0.51a

hmm. could be strict mode. try to disable mysql strict (use google for howto)

Thanks I know for a fact that it is, I had an initial issue trying to get eqdkp to install which I worked around by adding

SET @@session.sql_mode= '';

to the top of the .sql files instructed by one of your users here.

Would you be able to tell me which file i need to add this command to? All I can find are .php files. I am on shared hosting and unable to remove strict mode.

Many Thanks

If this is your own root server go to your my.cnf. If this is just a webspace for rent, you cannot change this. Contact me if this is the case, so i can send you a littel fix for the raidlogimport installation

This is just webspace for rent from a company called webhostinguk

Please extract and upload the following file to your eqdkp/plugins/raidlogimport/games/WoW/language/english directory and report if it is working afterwards.

Thanks

No it didn't but at least knowing the location the issue is coming from helps. It seems to be the null values that my db is taking exception to??? these below just as example

0 => array('zone', 'Naxxramas', 'Naxx', '0', '5', NULL, '0'),
1 => array('boss', 'Loatheb', 'Loatheb', '2', '0', NULL, '1.5'),
2 => array('boss', 'Instructor Razuvious', 'Razuvious', '2', '0', NULL, '1.6'),
3 => array('boss', 'Gothik the Harvester', 'Gothik', '2', '0', NULL, '1.7'),
4 => array('boss', 'Four Horsemen', 'Reiter', '2', '0', NULL, '1.8'),
5 => array('boss', "Anub'Rekhan", "Anub'rekhan", '2', '0', NULL, '1.0'),
6 => array('boss', 'Grand Widow Faerlina', 'Faerlina', '2', '0', NULL, '1.1'),
7 => array('boss', 'Maexxna', 'Maexxna', '2', '0', NULL, '1.2'),

So I deleted everything pre Cataclysm and the pluggin installed successfully as there were no NULL entries on these lines.

I'm logical but know nothing about programming so not sure if this may have any adverse affects not immediately visable? But atm I have it working it has successfully imported a string and added members who were missing and all is looking okay.

Next to the raid planner forum

Am a bit poor after paying for hosting and teamspeak server but I know I am going to be meithering you guys a lot over the coming days so have donated what I can.

Thanks you sooo much for your assistance.

The main problem with the current stable branch is, that the SQL structure is kind of old and has many problems with different security levels of SQL and PHP. This was already adressed in the new 0.7 branch.

Good you found a solution yourself. Kind of strange your SQL rejects NULL as a value.