Everything has been working fine, but when I began using phpbb login, whenever a user uploads their characterprofiler.lua file, it gives me this error:

Database Error1146: Table 'wowroster.phpbbusers' doesn't exist
SQL:
update phpbbusers u, roster_members m set u.user_from=m.zone where ucase(u.name)=ucase(m.name)
File: lib\dbal\mysql.php
Line: 234

I didn't know if this was a problem with the databases communicating or not, however merging them with a fresh install didn't fix the issue either so I thought I would come to the geniuses that created this for help. Thank you in advance.

Are your phpbb and roster in the same database?

They are now. Initially they were not and I thought this might be what was causing the error. Its very strange because once yesterday it didn't come up at all, but every time after that it did.

Thanks for the help!

Hm, I'm not sure why the fact that they are in seperate databases would cause the problem.

The phpbb_login class includes the files from PHPBB directory to load those configuration values and creates a new SQL connection using the PHPBB values and sql class calls. And that connection is stored within the login class specifically to avoid any conflicts.

Any thoughts, PleegWat?

From the looks of the error, that query is a join between a roster table and a phpbb table, and that query is being run via the roster DB layer.

The simplest way to fix it would be explicitly specifying the database for the phpbb table. To do this the roster user would need SELECT permission on the relevant phpbb tables.

Alternatively, do the join in memory.

phpbb_Login class never calls an SQL string of that format. Are you using another addon that interacts with PHPBB and Roster? Perhaps a mod that modifies their posting profile on the forums?