Install EM error: Some queries failed, ...

[jtrumpfheller]

I have already installed on two other forums Easy Mod without any problem. Now I got the following error message:

Result :: Some queries failed, the statements and errors are listing below

Error :: Invalid default value for 'mod_id'
SQL :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL DEFAULT '0' auto_increment, ...)

Question: Shouldn't be the 0 for mod_id without quotes '0'?

I could go on with the installation and when the installer tried to INSERT INTO phpbb_easymod there is coming naturally the next error message:

Executing SQL: INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, ...)

Progress :: . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Table 'stayhuman_org_-_messageboard.phpbb_easymod' doesn't exist

EasyMod is installed. I can login to it and it seems to work. So shall I install the table within phpMyAdmin Contral Panel? What could be the effect if there is not such table?

[jtrumpfheller]

Ok,

because I am sometimes impatient I have committed the failed sql-statements in the sql window of phpMyAdmin with the same error message "Error :: Invalid default value for 'mod_id'". And as I remember right default values and autoincrement don't fit together. So I take the default '0' away from the statement and it worked fine. Also the Insert.

But when I open the EM History I can't click details to get more infos shown and of course the select fields where I could deinstall some mods. Any suggestion?

[Nightrider]

Ok, your database must be extremely sensitive. The SQL statements work fine on most MySql databases...

I can't begin to guess why you can't get into Details in EM History unless there are no details to show you. If you haven't installed any MODs since creating the two EM tables, there may not be anything stored in them yet, so the Details pages would be meaningless...

[jtrumpfheller]

Ok, your database must be extremely sensitive. The SQL statements work fine on most MySql databases...

I can't begin to guess why you can't get into Details in EM History unless there are no details to show you. If you haven't installed any MODs since creating the two EM tables, there may not be anything stored in them yet, so the Details pages would be meaningless...

Thanks for answer, as I said it before I have it already installed into two othere forums without any problem. Don't know why it is here that way. I also tried to update the installation by giving the old EM a lower number. This installation worked fine without any error messages but the same behaviour in the EM history with two datasets of the EM (old and new installation). No details to click. The text detail is written there without any link. Maybe after I have installed another mod it will work. Let's hope and I will give info about it.

[Nightrider]

Ok, you are describing something that I haven't seen before. Unless you installed using the Manual option, I can't even begin to guess what might be causing the problems you are describing. So have you looked in the phpbb_easymod table to see if it is adding MOD records after each MOD install? Are there any errors during or after you install a MOD???