Database Error in vbgallery_install.php !

[antivirus]

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?

[Chuck S]

we changed table names to ppgal_ on 2.0 upgrade so your version number has to be incorrect if your tables are already named that try running this query in phpmyadmin then run the upgrade

UPDATE ppgal_setting SET value = '2.2' WHERE varname = 'gallery_version';

Of course replace with your proper version.

[antivirus]

hi Chhuck - thanks for the suggestion. I will try it this week when i have a chance. I was looking for the correct version niumber in the gallery files, however there don't seem to be any! Is this possible?

[Chuck S]

The version number of your vbgallery is listed in the config table for the gallery

You can use the query in phpmyadmin to change it and then proceed to try the upgrade again.