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?