Just upgraded to the new version of Photopost Classifieds to get my classifieds to work with an upgraded phpbb3 site. I'm having a hard time finding any information in the forums or support section on getting switched to phpbb3 (old classifieds used phpbb2). I believe I have everything setup right in config-inc.php and config.intc, went through the upgrade processes.
I can't log in as admin to the classifieds software
Current errors at index.php;
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /classifieds/forums/phpbb2.php on line 42
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/forums/phpbb2.php on line 65
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/forums/phpbb2.php on line 335
(I removed a portion of the path above for security reasons). It appears to be trying to work with a phpbb2.php integration, not phpbb3. I have not found where to specify what forum to use in any config files, etc.
It is connecting to the classifieds database ok, I can see some user ads, so that portion appears to be close to working correctly - a few broken images in the templates, but other than that it's close to working.
Please give me a hand as soon as you can... this is on a live site that is now down.
Okay yeah its not as simple as just upgrading as this is a complete new integration.
Here is what you want to do there.
1. Using phpmyadmin or database viewer in your hosting control panel delete the 3 usergroup entries under your cp_usergroups table.
2. Upload install.php and go through the install using the same database and table prefix info etc to update your current database. This will not delete anything on your classifieds. make sure to place the proper phpbb3 database info table prefixes or COOKIE NAME asked in the install.
Once you install correctly with phpbb3 you should be able to login and set permissions in admin edit usergroups and have a working install with phpbb3.
I'm a total newbie at using SQL and phpmyadmin so bear with me here... When logged into phpmyadmin for the phpbb3 database, I do not see anything labeled cp_usergroups. There is a table labled Table: phpbb_user_group, it has 4 fields, group_id, user_id, group_leader and user_pending. This doesn't sound like what you're talking about?
Or are you talking about the Classifieds database? There is a pp_usergroups in that one? There are 16 fields in it..
Appreciate your quick replys.. I'm getting there. SQL errors are gone, I was able to login as admin finally, also got all the image errors fixed.
Problem I'm running into now must be a configuration issue. When logged in as admin, and I try to post an ad I get an error (from classifieds software) that says "You do not have permission for this action! "
I also noticed when logged in as a regular user, there is no option for "place an ad" in the header. I looked at the admin options and don't see anything I'm missing there, like an option turned off. The only options on the right side menu are "Home · Search · Profile · Logout" when logged in as a normal user.
I like easy... Didn't think about having to redo the permissions. Got that done, now admin and users can post ads. However users can't edit, move/delete or "Sold it" for their ads. I have users set to "YES" for Moderate Ads, Allow posting, Allow highlight, Allow bold,Allow italic,Allow Payment,Allow comments. Only MOD and ADMIN access are set to "NO".
Also I now have the PhotoPost classifieds Powered By footer on the bottom of all pages, this was previously a non-branded version of the software. How do I remove the footer?