SQL errorDB function failed with error number 1146

17 years 3 months ago #30963 by vrayco
Hello!

I speak a bit english, sorry!. I have got this problem:

SQL errorDB function failed with error number 1146
Table 'buenavistasemueve.phpbb_users' doesn't exist SQL=SELECT count( * ) as total_record FROM phpbb_users WHERE user_active = '1'
SQL =
SELECT count( * ) as total_record FROM phpbb_users WHERE user_active = '1'

When I do click in "Plugin control panel"

Help me, please!!

Thanks

Please Log in to join the conversation.

17 years 3 months ago #31022 by geeffland
Is phpbb installed into the same database as Joomla?

It need to be in the same database for the phpbb connector to work properly...

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

17 years 3 months ago #31087 by icecubejackal
Replied by icecubejackal on topic Re:SQL errorDB function failed with error number 1
geeffland wrote:

Is phpbb installed into the same database as Joomla?

It need to be in the same database for the phpbb connector to work properly...

Greg


Im in this situation also, phpbb2 properly installed with same database of joomla, and also the sessions.php in phpBB/includes is edited already.

Modify lines 419-421 by adding ‘ around $user_id on line 421
• ORIGINAL
• AND session_user_id = $user_id";
• MODIFIED
• AND session_user_id = '$user_id'";

Additional:
jos_ = my joomla prefix table
phpbb_ = my phpbb prefix table

I got this error when im trying to register new user::

SQL errorDB function failed with error number 1146
Table 'joomladatabase.users' doesn't exist SQL=SELECT username FROM users WHERE username='jhonfoo' AND user_id<>''
SQL =

SELECT username FROM users WHERE username='jhonfoo' AND user_id<>''


If im going to login my existing user i got "blank page display"

Please i really need a good solution for this.. Thanks in advance!!

Post edited by: icecubejackal, at: 2007/02/15 03:52

Please Log in to join the conversation.

17 years 3 months ago #31204 by geeffland
The two problems reported here are not the same issue...

Note in the first error it shows "phpbb_users" in the error message... and the second shows "users" in the error message.

Unless the second case has their phpbb prefix set to "" instead of "phpbb_" then the first one can find the forum but not the table, and the second one can't find the forum...

vrayco, was phpBB installed in the same DB as Joomla/CB?

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

Moderators: beatnantgeefflandmartijn189krileon
Time to create page: 0.270 seconds

Facebook Twitter LinkedIn