me too!

The tables have changed in vBGallery 2.0.
The prefix of tables changed from adv_gallery_ to ppgal_.

• adv_gallery_categories --> ppgal_categories
• adv_gallery_customfields --> ppgal_customfields
• adv_gallery_customfields_entries --> ppgal_customfields_entries
• adv_gallery_ecards --> ppgal_ecards
• adv_gallery_exif --> ppgal_exif
• adv_gallery_favorites --> ppgal_favorites
• adv_gallery_filetypes --> ppgal_filetypes
• adv_gallery_images --> ppgal_images
• adv_gallery_moderator --> ppgal_moderator
• adv_gallery_permissions --> ppgal_permissions
• adv_gallery_posts --> ppgal_posts
• adv_gallery_rate --> ppgal_rate
• adv_gallery_search --> ppgal_search
• adv_setting --> ppgal_setting
• adv_settinggroup --> ppgal_settinggroup
• adv_gallery_subscribecat --> ppgal_subscribecat
• adv_gallery_subscribeimage --> ppgal_subscribeimage

EX: Ver. 1.0, 1.0.1, 1.0.2, 1.0.3, 2.0B1/B2
Is now: Ver 2.0 +
Please take note if you have problems with old hacks or want to work on new projects.

This code change is for the vbgallery_block.php file. It fixed it for me. Thanks! Anyone have the vertical template for this?

Thanks for that fix, it did work.
Unfortunately, another problem has come up.

If I am logged in under my administrator account, the site loads and the portal shows up fine.

If I am logged in under a regular account or if I am logged out completely, I only get a database error and the site does not load.

Any help will be immensely appreciated - I installed and used this addition for a long time without any trouble under VB 3.5, and am hoping to continue using it under 3.6.

Thanks!

Had the same problem until I updated the init.php file.

I am still new to this; where do I make the corrections so that I don't get the "table does not exist" error?

You need to open the vbgallery_block.php file included in the mod download. Find "adv_gallery_images" in the line of code given above and replace it with "ppgal_images". Save file, reupload to to server/forums/modules/.

I would still love some help with this problem...or at least a suggestion? I would hate to permanently lose the use of this mod!

Invalid SQL:

SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid ,images.userid, images.username, images.title, images.dateline ,filesize, originalfilesize ,width, height, originalwidth, originalheight, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal
FROM forum_ppgal_images AS images

WHERE Array valid = 1


ORDER BY RAND()
LIMIT 4;

Ошибка MySQL : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'valid = 1


ORDER BY RAND()
LIMIT 4' at line 4

Wow, you're not the only one getting that error WZZZ.

I had to disable it because my users couldnt' log in due to that.