Error after install of Photo Post

[katana]

After installing Photo Post with PHPBB integration, I go to my main photo post site and I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/w0202/d08/s33/b02a1a0f/www/mydomain.com/gallery/forums/phpbb2.php on line 72

I'm setting the server up for the first time and did a complete re-install (including phpbb within a new database... phpbb is working fine by the way) and I still get the same error.

If I log into PHPBB and then go to my Photo Post page it recognizes my user I used on the forum, but I get the error along the top of the page.

Any ideas???

Thanks in advance

Gary

[Chuck S]

That error tells me that on install you have either entered incorrectly the phpBB database info on config or more than likely on step4 you did not correctly input the phpbb table prefix which is usually phpbb_

[katana]

Thanks for getting back to me. I've double checked all my settings. The photopost tables are all getting added to my PHPBB database with the pp_ prefix. I decided to remove everything again (PHPBB and PP) and did a complete re-install with a new database name etc. and paid close attention to all the settings (including the PHPBB prefix which is phpbb_)... no errors during install of PP, everything looks to work fine but I still get exact same error when I try to launch the gallery or it's admin.

Again, if I'm logged into PHPBB and go to my gallery it is recognizing me and has logged me into the gallery but I get the error along the top of the page. If I try to go to the Admin page of PP all I get is the error with nothing under it.

Any other things I can try... permissions???

Thanks

Gary

[Chuck S]

What version of phpbb are you using?

What Integrations we support!!

We do note you need to be using version 2.019 and above. I think its actually 2.018 and above but the newer code has a session_keys table which yours does not have so upgrade your forum.

Content visible to verified customers only.

[katana]

Darn... PHPBB is provided by our hosting provider and it's 2.0.6... would have thought they would have had a newer version

[Chuck S]

You can easily download phpBB from phpBB.com and update your files uploading everything except CONFIG.PHP and then run this replacing with your domain name and forumpath

http://www.domain.com/phpBB/install/..._to_latest.php

Once that runs you delete the install and contrib directories and you should be fine. They have full upgrade instructions on there site though this is just what I remember from doing phpBB upgrades for customers

[katana]

Thanks for your help, and the quick replies. I'll give it a try