Adding a prefix to your PhotoPost tables

[Michael P]

If for some reason you need to change your PhotoPost tables to use a prefix because of conflicts with other scripts; this group of RENAMEs will accomplish what you need quickly.

First, close your gallery. Then paste these commands into phpmyadmin using your PhotoPost database.

Content visible to verified customers only.

You'll need to edit your config-inc.php and change

$pp_db_prefix = "pp_";

That's it. Now your tables are using a pp_ prefix which will avoid any conflicts with other tables created in your database by other applications.

[aacircle]

Just an update on the above. Members may want to realise that the search table has now been renamed to searchids as of v5.61.

Also, I think an important first step has been left out of the above instructions.

You need to go into your photopost admin area and change "Forum database table prefix" to whatever you are changing it to. If you rename your tables prior, then the whole system will break and you wont be able to get into admin or even view your gallery.

Can a member from Photopost please confirm this?

Thank you.

[Chuck S]

You never update the forum database table prefix. The instructions above are correct you edit your config file as Michael noted and set your new Photopost $pp_db_prefix to pp_ in your config-inc.php

[Smoothie]

So, Michaels instructions are correct? I was thinking of changing the prefixes in the PP database.

[Michael P]

Yes. You follow mine in the first post and it'll work (I did it to my site); the $pp_db_prefix is in the config-inc.php file, so you can edit that outside of the PP Admin to avoid any issues.

[aacircle]

Thanks, and sorry to confuse everyone. Will get to your instructions right away. It's always better to have table with a prefix according to their product. If not you may run into bugs later as was the case for me when search table was renamed to searchids because vbulletin also uses a search table.

[Smoothie]

Question. What if the PP dB and vB db are one in the same? Any ill effects?

[Smoothie]

This must only work with the latest version, because some of these tables don't exist in the version I'm running. Now I got half done and it stopped with an error

[Smoothie]

Michael, you forgot to add one thing. If you run the plugin that shows thumbs on your vB forum, you also need to change 1 other file.

1. config-int.php

or else you'll get errors on forumhome.

[Smoothie]

The table search is in use by vBulletin. How can PP have the same table?

[Smoothie]

These are the tables I have for PP, am I missing something?

# Browse pp_admingroups
# Browse pp_admlog
# Browse pp_cache
# Browse pp_categories
# Browse pp_comments
# Browse pp_ecards
# Browse pp_exif
# Browse pp_extrafields
# Browse pp_favorites
# Browse pp_ipcache
# Browse pp_iponline
# Browse pp_laston
# Browse pp_notify
# Browse pp_photoextras
# Browse pp_photos
# Browse pp_photoviews
# Browse pp_searchids
# Browse pp_settings
# Browse pp_sort
# Browse pp_sortmemb
# Browse pp_usergroups
# Browse pp_users

[aacircle]

Originally Posted by Smoothie

The table search is in use by vBulletin. How can PP have the same table?

Yes, we were using the same table as our photopost installation wasn't prefixed, hence it become a problem when we upgraded to 5.61. The search and searchids tables are different, so be careful.

Originally Posted by Smoothie

you also need to change 1 other file.

1. config-int.php

Yep, I noted this as well.

The tables I have as at 5.61 are:

pp_admingroups
pp_admlog
pp_cache
pp_categories
pp_comments
pp_ecards
pp_exif
pp_extrafields
pp_favorites
pp_ipcache
pp_iponline
pp_laston
pp_notify
pp_photosextra
pp_photos
pp_photoviews
pp_searchids
pp_settings
pp_sort
pp_sortmemb
pp_usergroups
pp_users

TOTAL = 22 tables.

In the first post by Michael, he has 24 tables. The following tables no longer exist so take note:

pp_perpage
pp_stylesheet

[aacircle]

Well, am happy to say all worked fine for us. With now have photopost tables prefixed with pp_.

[Smoothie]

Yes, 22 here as well. I assume we can remove those 2 extra, not needed tables? Shouldn't upgrade.php remove these unused tables?

[aacircle]

I don't have those extra tables, and if the upgrade script worked for u, it should have removed these tables. Perhaps u are not running the latest version. Check in your admin panel of photopost.

[Chuck S]

Yes the upgrade script does remove extra tables and I see Michael has already edited his rename post to remove the table names

[Smoothie]

Current version 5.61

RENAME TABLE search TO pp_search;

Does not exist in PP

[Smoothie]

perpage and stylesheet no longer exist, looks like the script removed them.

[Chuck S]

Smoothie search table is created in 5.6 which is when Michael posted this. In 5.61 we further renamed search to searchid to avoid conflicts with vb3

[Smoothie]

Chuck, thanks!