Integration with phpBB 2.0.6

[bebek]

hi,
i found that integration instruction to phpBB now clearly understood.
have a problem to integrate with my current database phpBB 2.0.6
when i login i got this message

MySQL error reported!
Script: install
Query: SELECT groupid, groupname, cpaccess FROM phpbb_usergroups
Result: Table 'databasename.phpbb_usergroups' doesn't exist
Database handle: Resource id #12

while i check my phpBB forum it should be phpbb_user_groups not phpbb_usergroups

and also got this error message

MySQL error reported!
Script: index
Query: SELECT userid,username,email,password,usergroupid,offset FROM phpbb_users WHERE userid='-1'
Result: Unknown column 'userid' in 'field list'
Database handle: Resource id #7

and i check it should be user_id not userid in my phpBB database
where should i change this in reviewpost file...
thanks

[Chuck S]

Simple answer choose the proper integration

You have selected photopost integration with reviewpost not phpbb2

You need to alter your settings table and change setting 41 from photopost to phpbb2

Originally Posted by bebek

hi,
i found that integration instruction to phpBB now clearly understood.
have a problem to integrate with my current database phpBB 2.0.6
when i login i got this message

MySQL error reported!
Script: install
Query: SELECT groupid, groupname, cpaccess FROM phpbb_usergroups
Result: Table 'databasename.phpbb_usergroups' doesn't exist
Database handle: Resource id #12

while i check my phpBB forum it should be phpbb_user_groups not phpbb_usergroups

and also got this error message

MySQL error reported!
Script: index
Query: SELECT userid,username,email,password,usergroupid,offset FROM phpbb_users WHERE userid='-1'
Result: Unknown column 'userid' in 'field list'
Database handle: Resource id #7

and i check it should be user_id not userid in my phpBB database
where should i change this in reviewpost file...
thanks

[bebek]

i am sorry i only use reviewpost not photopost to integrate with my board (phpBB), are they the same configuration ?
what is setting 41 ?... sorry can not find anything in manual installation ..

[Chuck S]

Same difference whether its photopost or reviewpost.

Basically when you install the second to last step of install asks what you will be integrating with whether your doing an internal install or whether your integrating with a forum.

( there is no manual on this as its self explanatory in the install process )


You have installed Reviewpost as an internal install not integrating with phpbb. If this is a new install I would start over and reinstall selecting the correct integration type.

[bebek]

thanks omegatron, it works... yeah i forgot about that part
now looking how to change the template...