PhotoPost Community - View Single Post - Database Error in vbgallery_install.php !

antivirus · November 6th, 2008, 02:00 PM

While upgrading Photopost vbGallery from version 2.0.0 - 2.4.2, the following invalid sql on line 1151 evokes an error...

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "ppgal_setting SELECT * FROM " . TABLE_PREFIX . "adv_setting");

Naturally, this is a no-no, lol.

I'm looking at the rest of the upgrade case statement for 2.0.0/2.0 and according to the script, it seems to be expecting gallery files to have adv_ on the names, however mine already have ppgal_

I came across this post which Zach had supplied to fix a very similar issue. I ran the first query however the columns pppcount, ppicount do not exist.

Any idea on how to fix the upgrade script?

November 6th, 2008, 02:00 PM	#1 (permalink)
antivirus Member Verified Customer Join Date: Aug 2005 Location: NYC Posts: 63	Database Error in vbgallery_install.php ! While upgrading Photopost vbGallery from version 2.0.0 - 2.4.2, the following invalid sql on line 1151 evokes an error... $db->query_write("CREATE TABLE " . TABLE_PREFIX . "ppgal_setting SELECT * FROM " . TABLE_PREFIX . "adv_setting"); Naturally, this is a no-no, lol. I'm looking at the rest of the upgrade case statement for 2.0.0/2.0 and according to the script, it seems to be expecting gallery files to have adv_ on the names, however mine already have ppgal_ I came across this post which Zach had supplied to fix a very similar issue. I ran the first query however the columns pppcount, ppicount do not exist. Any idea on how to fix the upgrade script? Last edited by antivirus; November 6th, 2008 at 02:11 PM.