Page 1 of 1

General Error on Installation

Posted: 15. July 2010 05:52
by jgarry2648
Your Portal Version: 1.0.5
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge
Boardlink: http://www.declutteratyourservice.com

What have you done before the problem was there?
New install

What have you already tryed to solve the problem?
I have installed the board according to instructions. I have uninstalled and reinstalled. I have triple checked includes ensuring al edits were correct

Description and Message
I continue to get a General Error. All files have been uploaded correctly.

General Error
SQL ERROR [ mysql4 ]

Duplicate entry '4-118' for key 1 [1062]

SQL

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

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->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()

Re: General Error on Installation

Posted: 15. July 2010 11:58
by Marc
Guess what, my friend the search has returned some information to me: viewtopic.php?f=10&t=3461&hilit=Duplicate+entry

Just replace the 119 with 118 in the Query.

Re: General Error on Installation

Posted: 15. July 2010 19:26
by jgarry2648
Dear Marc:

Since this request, I deleted everything and started over. My new General Error is as follows:
General Error
SQL ERROR [ mysql4 ]

Table 'declu0_declutter12.phpbb_portal_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I checked the includes/constant.php file, everything is where it should be. Should I use the same resolution for this or is there another resolution that you can point me to.

Thank you

Re: General Error on Installation

Posted: 15. July 2010 19:27
by Marc
Did you run the installer again?

Re: General Error on Installation

Posted: 15. July 2010 19:42
by jgarry2648
Ok....I must admit, I'm embarassed :roll: . I did not run the install again. I just ran it and it's up and running.

Thank you