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

Hello,

I am installing a fresh copy of EQDKP 6.4.6 and getting a MySQL error. My platform is as follows:

IIS 7.5
PHP 5.3.6 - mysql extension - NOT mysqli
MySQL 5.5.12

# MySQL EQdkp Structure
# $Id: mysql_structure.sql 363 2007-07-15 13:46:45Z osr-corgan $

I think this structure file needs to be updated for MySQL 5.5.x

When I run the install and try to create the tables the database gives the following error:

#1071 - Specified key was too long; max key length is 767 bytes

This is a UTF8 problem, you can either change the size of varchar to 32 instead of 255
OR
Do not use UTF8 format for your database. ( Use latin1_general_ci )

Just thought I would throw that out there so you can work that into your patches and new versions.

EDIT: one other thing I also noticed that some of the table structure is missing NULL values Need to input all NULL values for the structure.

ERROR: eq_style_config is missing NULL value for some columns. (background_img, css_file)

Error! Failed to execute this SQL Statement:
INSERT INTO eq_style_config (style_id, attendees_columns, logo_path) VALUES
1, '6', 'logo_plus.gif')
There were a few other ones as well but I didn't record them, sorry. I just went into the DB and added a NULL value and then manually re-ran the required information from mysql_data.sql file.

It would also be nice if you included a "config.sample.inc" file in your package so when my installation fails I can continue and simply edit and rename the sample config file rather than having to read your PHP code and building one manually.

Thanks,
CC

a) Use latin, as 0.6 does not work with UTF
b) disable the MySQL Strict mode, 0.6 will not run in strict mode

--> both fixed in 0.7, this will run in strict mode and will be a native UTF-8 app. Till then, see a) and b)

excellent, thanks!

CC