MySQL Upgrade
Posted: 20. October 2009 02:33
Your Portal Version: Board3 Por
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://aquariumfishforum.com
PHP Version: 3.5
What have you done before the problem was there?
Have been using Board3 Portal for months without any problems. Today the company I host with upgraded from MySQL 4 to MySQL 5 and my portal page comes up blank.
What have you already tryed to solve the problem?
In ACP all the blocks are turned off. Turned them on and get the error:
SQL ERROR [ mysql4 ]
Duplicate entry 'portal_advanced_stat' for key 1 [1062]
SQL
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_advanced_stat', 0)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: portal/includes/functions.php
LINE: 64
CALL: dbal_mysql->sql_query()
FILE: includes/acp/acp_portal.php
LINE: 378
CALL: set_portal_config()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_portal->main()
FILE: adm/index.php
LINE: 78
CALL: p_master->load_active()
Description and Message
Hi all,
Sorry to bother you with this question but after a recent MySQL upgrade, I'm having a problem with my portal page. I do have some experience with phpbb but I'm not really confident enough to know what to do here so I thought I would ask before I get in too deep. If it matters, the rest of my board works fine after the upgrade.
Thanks for your time,
TG
Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://aquariumfishforum.com
PHP Version: 3.5
What have you done before the problem was there?
Have been using Board3 Portal for months without any problems. Today the company I host with upgraded from MySQL 4 to MySQL 5 and my portal page comes up blank.
What have you already tryed to solve the problem?
In ACP all the blocks are turned off. Turned them on and get the error:
SQL ERROR [ mysql4 ]
Duplicate entry 'portal_advanced_stat' for key 1 [1062]
SQL
INSERT INTO phpbb_portal_config (config_name, config_value) VALUES ('portal_advanced_stat', 0)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: portal/includes/functions.php
LINE: 64
CALL: dbal_mysql->sql_query()
FILE: includes/acp/acp_portal.php
LINE: 378
CALL: set_portal_config()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_portal->main()
FILE: adm/index.php
LINE: 78
CALL: p_master->load_active()
Description and Message
Hi all,
Sorry to bother you with this question but after a recent MySQL upgrade, I'm having a problem with my portal page. I do have some experience with phpbb but I'm not really confident enough to know what to do here so I thought I would ask before I get in too deep. If it matters, the rest of my board works fine after the upgrade.
Thanks for your time,
TG