vb.org Archive - Add-On Releases - Module CMPS: PhotoPost vBGallery

Page 9 of 29

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Add-On Releases - Module CMPS: PhotoPost vBGallery (https://vborg.vbsupport.ru/showthread.php?t=126697)

carpzone

12-28-2006 01:35 PM

Yes the block works fine with the datbase call change.

But i get databse error when i'm not logged in.
The block only shows up ( and my website) when a users is registered.

Is there a fix to work this out ? ...

zetetic

12-31-2006 02:43 PM

In case this wasn't clear to anyone, most of the db errors are the result of an incorrect table name in the vbgallery_block.php file.

Make sure to edit vbgallery_block.php

find:

adv_gallery_images

and change to:

ppgal_images

Save changes and upload the file to your server.

carpzone

12-31-2006 06:12 PM

Hm Yes, I did change that database call fom ADV_..... to PPGAL_..... in the vbgalleryblock.

The block works only if logged in.
If i turn the block on for Unlogged visitors. My webpage dont open.

I get follow error by email

Code:

Database error in vBulletin 3.6.4:



Invalid SQL:



                SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid  ,images.userid, images.username, images.title, images.dateline, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal

                FROM vb_ppgal_images AS images

                

                WHERE Array valid = 1 

    

                 

                      ORDER BY dateline DESC

                LIMIT 6;



MySQL Error  : 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 dateline DESC

                LIMIT ' at line 4

Error Number : 1064

zetetic

01-01-2007 04:20 AM

Hmm, I spoke to soon. It works fine for me in Firefox, but using IE I get that same db error.

gunitman247

01-01-2007 09:57 PM

any thing like this for photoplog?

johnstires

01-06-2007 08:03 PM

Quote:

Originally Posted by zetetic (Post 1148378)

Hmm, I spoke to soon. It works fine for me in Firefox, but using IE I get that same db error.

That fix worked for me in FF and IE7! Thanks!

gator777

01-07-2007 09:41 AM

I'm unable to get this mod working no matter what I do. I've used this block for a long time, and I miss not having it on my site. I hope Zach has the time to fix it. For now, I am using the "Recent Comments Block" to fill the void. :confused:

I hope you read this Zach :)

johnstires

01-07-2007 12:34 PM

Quote:

Originally Posted by gator777 (Post 1152499)

Make sure the table prefixes match up. That was my problem.

First, make sure to edit vbgallery_block.php

https://vborg.vbsupport.ru/showpost....9&postcount=82

AND

Make this change.

https://vborg.vbsupport.ru/showpost....2&postcount=52

gator777

01-07-2007 11:47 PM

Quote:

Originally Posted by johnstires (Post 1152577)

Thanks for your help, but I'm still getting the error messages. I am using....

CMPS x2.2.1
VB v3.6.4
Photopost VB Gallery 2.1

All was goon until I installed Photopost VB Gallery 2.1. If I had know it was going to diable my block, I would not have upgraded to Photopost VB Gallery 2.1. :D

carpzone

01-21-2007 10:29 AM

Quote:

Originally Posted by carpzone (Post 1148187)

Code:

Database error in vBulletin 3.6.4:



Invalid SQL:



                SELECT imageid, images.title, images.description, filename, thumbname, originalname, extension, images.catid  ,images.userid, images.username, images.title, images.dateline, images.views, images.posts, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal

                FROM vb_ppgal_images AS images

                

                WHERE Array valid = 1 

    

                 

                      ORDER BY dateline DESC

                LIMIT 6;



MySQL Error  : 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 dateline DESC

                LIMIT ' at line 4

Error Number : 1064

Nobody has a clue what the problem is ?

All times are GMT. The time now is 12:09 AM.

Page 9 of 29

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01743 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: