anyone?

Do you have vBGallery installed ?

yes PhotoPost vBGallery v2.0 is all working fine

ok have narrowed it down to when i do this part...

thats when i get the database error come up. -- any ideas why?

i also get

Thanks for letting me know ...Apparently this happens when i have both Links and download manager block and the gallery cmps block enabled....

I own Photopost v5.2, but I've not heard of vB Gallery til now. I've gone to Photopost's website and am not finding anything on it....then again I do have terrible eyesight....

Thanks,
Mark

I'm getting this error too. I have vbgallery 2.0 installed and vb 3.6.1

I get the exact same error. VBGallery 2.0 and VB 3.6.2

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.

I have a few things to update in this, Ill see about getting it done this weekend.

did the edits in post 52 and its working on 3.6.2

:confused:

Does it work with Photopost Pro 5.5 ?

Why would I get a database error from someone's uploaded file:

Installed 3.6.3 and it diasppeared. I tried reinstalling the hack and it still doesn't work.

When you updated the forums it killed the edit to the fourms/includes/init.php file.

thanks, i guess i missed that when i reinstalled it.

Have you been able to get around to this update? I have no clue why my module would suddenly stop working and cause a sql error. I think the only thing I did was add a cetegory, and everything stopped working:

this doesn't work with gallery 2.1

At least not for me anyhow..

I have new update planed, is there any errors ?

same for me. i get the aforementioned error message.

I am working on a new block.
- vs. 1 block with 1 set of settings it will have settings per VBA page.

Is anyone else getting a database error or am I the only one? I am completely baffled on why it would suddenly stop working for me. I can't translate the error. Is it because I am vbgallery 2.1? Any help would be much appreciated.

I'm only getting it when I'm not logged in and viewing the main page now (and with regular users apparently, just got an e-mail on it), I just got it installed myself so I haven't started digging

The one other error was fixed by changing adv_gallery_images to ppgal_images in the php file, this one now that I'm getting would be after the aforementioned fix.

Same for me. :cross-eyed:

Installed!
But this images show in Forum Home not good, how can i arrange it into 1 row.
In my 4rum it just show into 3 rows
http://ngoichatnghenhac.biz/4rum/
Help me plz

Can someone please post a complete version of the module so we can fix this in the meantime?

I'm still not sure why changing the names of all the tables for the gallery only constitutes a x.1 increment in revision numbers.

Thanks for keeping vbg going though.

Zach,

Any word on the fix? :)

Been a while, so I am bumping. Any word on a fix? Thanks!