Page 1 of 1

[SOLVED] Error SQL at the install of 1.0.5

Posted: 29. August 2010 08:57
by 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 :mrgreen:[/i]

Re: Error SQL at the install of 1.0.5

Posted: 29. August 2010 14:51
by 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.

Re: Error SQL at the install of 1.0.5

Posted: 30. August 2010 11:51
by Routloutlou
Thanks ;)

Install completed .... But because i've a but :lol:
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 :shock:

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