phpbb3 theme bug

[Swanny]

I upgraded my PP to 6.02. Then I upgraded my forums. Now I get a few mysql errors regarding phpbb_themes. See... the problem is with phpBB2 there was a table called phpbb_themes and it held info on the themes. Now in phpBB3 that table no longer exists.

The error messages are frequent so I'm getting a lot of e-mail warnings each day. Here are the messages:

First:

An error was encountered during execution of the query:

SELECT phpbb_users.user_id,phpbb_users.username,phpbb_users.user_email,phpbb_users.user_password,phpbb_users.user_level,phpbb_users.user_timezone,phpbb_themes.template_name FROM phpbb_users
LEFT JOIN phpbb_themes ON phpbb_users.user_style = phpbb_themes.themes_id
WHERE user_id='-1'

The query returned with an errorcode of:

Table 'sitename_forumdbname.phpbb_themes' doesn't exist

Another popular message is:

An error was encountered during execution of the query:

SELECT phpbb_user_group.group_id FROM phpbb_user_group
LEFT JOIN phpbb_groups ON phpbb_user_group.group_id = phpbb_groups.group_id
WHERE phpbb_user_group.user_id=-1
AND phpbb_user_group.user_pending=0
AND phpbb_groups.group_single_user=0

The query returned with an errorcode of:

Unknown column 'phpbb_groups.group_single_user' in 'where clause'

And:

An error was encountered during execution of the query:

SELECT template_name FROM phpbb_themes WHERE themes_id='2'

The query returned with an errorcode of:

Table 'sitename_forumdbname.phpbb_themes' doesn't exist

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

I think that's all of them, I'm not sure.

[Chuck S]

I dont see anywhere within our phpbb3.php file where we look for a phpbb_themes table in the downloaded code as we do not support styles with phpbb3 only user login.

I do know phpbb3 changed their integration after they released their final version and if you pm me with an address I can give you a file to try

[Swanny]

I PM'd you my e-mail address. The address of the problem is http://www.fordtaurus.net/photos/

Oh, BTW I was initally having TONS of user/login problems after I upgraded phpBB. So I reinstalled PP over top the existing PP database. It retained all the photos, comments, etc., it just updated the usergroup/integration settings exactly like I expected. But this issue of the themes still remains.

[Chuck S]

yes i meant email address