SQL error on install

[oldwillyswagons]

Your Portal Version: 105
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Beginner

PHP Version: 3.0.7

What have you done before the problem was there?
SQL error on install

What have you already tryed to solve the problem?
came here first...

Description and Message
I have a clean install of phpBB3 version 3.0.7 installed on a localhost setup for a test board using XAMPP on a MAC. The test board works fine without the portal. I did the mods to install the Portal, and when I run the install file, I get the following error:

General Error
SQL ERROR [ mysql4 ]

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

SQL

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

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 258
CALL: dbal_mysql->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'm a newb at putting this stuff together, so I have no idea what is happening. Any help greatly appreciated!

Thanks,

Pete

[Marc]

I suppose you have phpmyadmin then?
Open phpmyadmin and run the following sql queries:

Code: Select all

DELETE FROM phpbb_acl_options WHERE auth_option = 'a_portal_manage';
DELETE FROM phpbb_acl_roles_data WHERE auth_option_id = 119;
DROP TABLE IF EXISTS phpbb_portal_config;

After that run the installer again.

[oldwillyswagons]

Excellent Marc, that did it.

Thanks for your help-

Pete