Upgrade Problems

[dragstuff]

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.

[Chuck S]

Dragstuff

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.

If there is anything else we can do let me know.

[dragstuff]

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..

[Chuck S]

Okay your using an older classifieds with a pp_ prefix thats fine. You can view your classifieds database using phpmyadmin and hit the SQL box link and in that box type this

DELETE FROM pp_usergroups

You can then go on to step 2 and do a reinstall make sure to note the proper classifieds database table prefix as on an install if you dont enter pp_ we will use cp_ on the newer version.

[dragstuff]

Just to clarify, should I use cp_ as a prefix or pp_ ? on the reinstall?

[Chuck S]

On the reinstall you want to make sure when you run install to use the same prefix as you have already on your existing tables which in your case would be pp_

If there is anything else I can do to assist let me know.

[dragstuff]

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.

Ideas?

Thanks - John

[Chuck S]

Thats an easy one my friend.

When you do a new install you must set permissions after install.

Login as admin and when in your admin panel hit edit usergroups and set permissions per usergroup as you wish to assign them and then you will be able to have you and other users post ads comment etc.

Let me know if there is anything else we can do to assist otherwise have a wonderful weekend.

[dragstuff]

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?

[Chuck S]

You can get specific brand free removal instructions by emailing support at photopost dot com as that is something we do not post publically.

As far as editing moving deleting ads etc

To edit an ad you must have in Admin => Edit Usergroups this set to yes for whichever usergroups you wish to edit their ads.

Allow edit own ads?

To be able to move or delete ads you must in Admin => Admin Options set this switch to yes.

Allow users to move/delete their own images?

Let me know if there is anything else I can assist with.

[dragstuff]

Duh - I didn't scroll over far enough when editing the usergroups to see those options. Got it now! We're back up and running, thanks for your help and hope you have a good weekend as well.

I'll email support on the other issue.

Thanks - John

[Chuck S]

Not a problem glad to help.