SQL Error

17 years 4 months ago #26216 by BryanL0911
SQL Error was created by BryanL0911
I get the following error when trying to access my profile on the front end after publishing the connector.

SQL errorDB function failed with error number 1146
Table '******_joom1.phpbb_users' doesn't exist SQL=UPDATE phpbb_users SET user_avatar_type='2', user_avatar='http://******.com/images/comprofiler/62_457438ff7c83d.gif' WHERE user_id=''
SQL =

UPDATE phpbb_users SET user_avatar_type='2', user_avatar='http://******.com/images/comprofiler/62_457438ff7c83d.gif' WHERE

I've read the other posts and have checked to make sure the directory listing is correct for the forum location.

Joomla is in root. PHPbb is under /forum

Any help appreciated!
Thanks

Please Log in to join the conversation.

17 years 4 months ago #26218 by geeffland
Replied by geeffland on topic Re:SQL Error
Are phpbb and Joomla installed into the same database?

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

17 years 4 months ago #26227 by BryanL0911
Replied by BryanL0911 on topic Re:SQL Error
geeffland wrote:

Are phpbb and Joomla installed into the same database?

Greg


Well no, they are on the MySQL server but two different databases joom1 for Joomla and PHPbb is phpb1. I installed both of them via fantastico from my web host cpanel. I did make sure the database userid has permissions in both databases though

Please Log in to join the conversation.

17 years 4 months ago #26228 by geeffland
Replied by geeffland on topic Re:SQL Error
Currently this plugin requires that both Joomla and phpbb be installed on the same website and within the same database. A future version will allow separate databases but currently they must be in the same one...

Greg

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in to join the conversation.

Moderators: beatnantgeefflandmartijn189krileon
Time to create page: 0.173 seconds