[SOLVED] Error SQL at the install of 1.0.5

[Routloutlou]

Your Portal Version: 1.0.5
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge

What have you done before the problem was there?
I've update 1.0.2 >> 1.0.3 it's OK
After 1.0.3 >> 1.0.5 when I launch /install/index.php > install > next

What have you already tryed to solve the problem?
Check if all files are there ...

Description and Message
Hello

You can see here the message

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

Duplicate entry '4-147' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) VALUES (4, '147', 1)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 258
CALL: dbal_mysqli->sql_query()

FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 279
CALL: install_install->main()

FILE: install/index.php
LINE: 56
CALL: module->load()

I don't know were the mistake

In advance Thank for your Help [/i]

[Marc]

Execute this SQL query in your database (i.e. with phpmyadmin):

Code: Select all

DELETE FROM phpbb_acl_roles_data WHERE auth_option_id = 147

After that you should be able to update without any issues.

[Routloutlou]

Thanks

Install completed .... But because i've a but
After refersh I can't see in administration panel the control of teh portal in the .MOD page ??

I've check all files in FTP and all modification >> OK

Someone have an idea please

EDIT : Sorry, It's OK, I've just think to check the right of groups