View Full Version : Missing table
July 2nd, 2012, 07:44 AM
Upgraded to the latest version last night and imported the XML. When enabled the site throws an error: Table 'vb_forums.pp_photos' doesn't exist
I must have missed something...
July 2nd, 2012, 07:55 AM
After some digging I see if I disable "Photopost Featured Photos on Forumhome" it does not throw the error.
I just noticed I now also am not seeing any upload links or link to the ACP.
July 2nd, 2012, 08:36 AM
Your issue can only be one thing and it has to do with permissions so this should help right from the upgrade instructions in the downloaded code. Redoing the plugins setting permissions should work.
IMPORTANT - FOR VBULLETIN 4 ONLY. New plugins included in download.
In the install directory set permissions on the file product_pppro.xml, source-vb4.xml and source-vb42.xml files to 777
2. Go to your photopost admin panel and hit the option to generate vbulletin plugin xml. That file will download to your computer.
3. Go into your vbulletin admin panel ( http://www.yoursite.com/gallery/adm-index.php ) and under plugins & products select the option to manage products. You can then use the add/import product option
and upload the xml file you downloaded to your computer called product_pppro.xml file. Once that is done your forum will show gallery content.
4. Thats it your done!!
Please read the CHANGELOG.TXT FILE so you know what to expect from version upgrades.
July 2nd, 2012, 11:59 AM
Ok, I go thte nav bar stuff working. Was not a permissions issue as I was very careful to follow the directions. Seems that you need to uninstall then install the newer xml. Over writing did not seem to work. Although it might have been a caching issue on my end. Thank you for the push in the right direction...
But again I still am getting Table 'vb_forums.pp_photos' doesn't exist when "Photopost Featured Photos on Forumhome" is enabled. When disabled the forums are working but I can ge the error even when disabled by clicking on the "My Profile" link within PhotoPost.
Also the navbar links back to the fourms is pointing to /photopost/forums.php and not ../forums.php Double and triple checked the config-inc.php and config-int.php files
July 2nd, 2012, 01:44 PM
Could be a cache issue but yes if you do not check the overwrite issue then nothing that exists would be the new stuff.
You would have to give alot more information for me to comment further. There are quite a few sites using the new xml
A community photo gallery - ReefTalk Gallery (http://www.reeftalk.com/gallery)
Your urls taken would be entered when generating the xml so what is under the global variables plugin for the Pro plugin?
July 2nd, 2012, 03:08 PM
Here is what is in the file.
//Photopost Directory Name
$vbulletin->options['prodir'] = 'forums';
//Url to PhotoPost Install
$vbulletin->options['ppurl'] = 'http://www.MyDomain.org/forums/photopost';
//Server Path to PhotoPost Install
$vbulletin->options['pppath'] = '/var/www/vhosts/userid/domain/wwwroot/forums/photopost';
//PhotoPost Database Name
$vbulletin->options['db1'] = 'vb_photopost';
//vBulletin Database Name
$vbulletin->options['db2'] = 'vb_forums';
//PhotoPost Mysql Host
$vbulletin->options['dbhost'] = 'xxx.xxx.xxx.xxx';
//PhotoPost Mysql Username
$vbulletin->options['dbuser'] = 'dbuser';
//PhotoPost Mysql Password
$vbulletin->options['dbpass'] = 'dbpassword';
July 2nd, 2012, 04:49 PM
Well your prodir in your options should that not be photopost
As far as your error are you sure no old plugins are active? I know a few people have forgot this one when upgrading.
Try uninstalling the whole product in vb product manager and try regenerating.
You can send us more specific site information through the contact us link if you want me to take a look.
July 3rd, 2012, 09:26 AM
I have not seen any info come through our helpdesk so are you needing assistance?
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.