I have this problem:
when i click on 'Plugin control panel', i have a popup window with this error:

SQL errorDB function failed with error number 1146
Table 'forum.jos_users' doesn't exist SQL=SELECT count(*) as total FROM (jos_users as j INNER JOIN jos_comprofiler as cb ON j.id = cb.id) INNER JOIN phpbb_users as p ON cb.cb_phpbbid = p.user_id WHERE cb.approved='1' AND p.user_active='1' AND j.block='0' AND (j.username = p.username) AND (j.password = p.user_password) ORDER by j.id
SQL =

SELECT count(*) as total
FROM (jos_users as j INNER JOIN jos_comprofiler as cb ON j.id = cb.id)
INNER JOIN phpbb_users as p ON cb.cb_phpbbid = p.user_id
WHERE cb.approved='1' AND p.user_active='1' AND j.block='0' AND (j.username = p.username) AND (j.password = p.user_password)
ORDER by j.id

Help me please and excuse for my english.
Thank you!

The error is indicating that the jos_users table does not exist...

Are both Joomla and phpBB installed into the same database?

Greg

geeffland wrote:

The error is indicating that the jos_users table does not exist...

I have controlled: the table exists.

Are both Joomla and phpBB installed into the same database?

Greg

Yes, I have installed Joomla and phpBB into the same database.

Post edited by: duccio80, at: 2006/10/15 11:44

Help me, please!

hello, i get the same error.
i tried to set different names to forum field in phpbb connector settings, but i cannot solve!! (i.e. forum; /forum ; /forum/)

i have joomla and forum folders both in root, so that:
joomla is www.site.com/joomla
forum is www.site.com/forum

joomla and phpbb are in the same database..
please help us!!

Assuming Buzzy's error is the 1146 posted in the other thread I think these are different problems... note in buzzy's error it showed the "users" table... no prefix... indiciates that if did not find what the prefix should be... i.e. did not load the config file from phpbb.

If duccio80's example it correctly showed jos_users and phpbb_users... so it appears to be getting the info from the config file... but the error message indicates that the table does not exists... so not exactly sure what that issue is...

duccio80 if interested PM me some info so I can get into your MySQL database and peek around (i.e. make sure the tables are not corrupted and do exist)... then if that doesn't turn up anything I may need to peek around on the admin side of your site to see what is happening. Kinda of a tight week for myself but I will try to get it peeked at...

Greg