PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   phpbb3 theme bug (http://www.photopost.com/forum/photopost-pro-bug-reports/136337-phpbb3-theme-bug.html)

Swanny April 27th, 2008 04:35 PM

phpbb3 theme bug
 
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:
Quote:

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:
Quote:

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:
Quote:

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 April 27th, 2008 05:01 PM

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 April 27th, 2008 07:35 PM

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 April 27th, 2008 07:38 PM

yes i meant email address


All times are GMT -5. The time now is 10:26 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97