PHP and SQL errors on Phpbb3

  • So when i make a change on the back end of the forums, i get this error, at first i was ignoring it because it would accept my changes but I think this could cause problems down the road and I’m trying to figure it out.

    I am not running any other mods on my forums right now, I just loaded them up so Phpbb single sign on has to have something to do with it. This is the Php error i get on the top 

    [phpBB Debug] PHP Notice: in file /common.php(87) : eval()'d code on line 579: include_once() [function.include-once]: Unable to access ./../includes/auth/auth_.php
[phpBB Debug] PHP Notice: in file /common.php(87) : eval()'d code on line 579: include_once(./../includes/auth/auth_.php) [function.include-once]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /common.php(87) : eval()'d code on line 579: include_once() [function.include]: Failed opening './../includes/auth/auth_.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php')

Warning: Cannot modify header information - headers already sent by (output started at /root/forums/includes/functions.php:3691) in /root/forums/includes/functions.php on line 2629

    Then on top of this i also get SQL errors

    Return to the index page
General Error
SQL ERROR [ mysql4 ]

Duplicate entry 'allow_autologin' for key 'PRIMARY' [1062]

SQL

INSERT INTO database.phpbb_config (config_name, config_value, is_dynamic) VALUES ('allow_autologin', 1, 0)

BACKTRACE

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

FILE: includes/functions.php
LINE: 157
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_board.php
LINE: 475
CALL: set_config()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_board->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

    I’m still following the trail of code, but I’m thinking it has somethign to do with the modified Common.php file you get. There are references to a wp-blog-header.php file that i haven’t been able to find yet.

    I’m also trying to find where it’s trying to locate the auth_.php file.

    I’m very new to website building but I know how to read code even if i don’t fully understand the language.

    ANY help would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter brambo23

    (@brambo23)

    Update, I found that for some reason in includes/session.php – it was not grabbing the Auth method from the SQL database, as a temporary fix to see if the php errors would stop i modified all of the references to include_once($phpbb_root_path . 'includes/auth/auth_' . $method . '.' . $phpEx); to include_once($phpbb_root_path . 'includes/auth/auth_wpbb.' . $phpEx);

    that removed the Php errors with finding the auth_ file, but i’m still getting the SQL errors, so obviously the issue is with something not talking to the SQL database properly, I will look into that next.

    Thread Starter brambo23

    (@brambo23)

    So now I’m not getting any errors when I login to the admin, but when i register a new user, and i try to login to wordpress, i get this error 

    General Error
SQL ERROR [ mysqli ]

Duplicate entry 'brambo' for key 'username_clean' [1062]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

    the footer says below the error “Powered by phpBB? Forum Software ? phpBB Group “

    I checked the database and both usernames are in the database, but for some reason they are not talking to eachother.

    I’m using MySQl 5.1.56 with WordPress 3.1.2 and Phpbb 3.0.8

    Another note, when I login to the admin logins (which are identical) it doesn’t auto sign me in. It seems there is still a issue with the plugin talking to the SQL database. I have wordpress and PHPBB in the same database.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘PHP and SQL errors on Phpbb3’ is closed to new replies.