vb.org Archive
Page 11 of 20 « First 910 11 1213 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)
-   -   Forum Home Enhancements - vBGallery - Forum Home (https://vborg.vbsupport.ru/showthread.php?t=123490)

dbarry 10-11-2006 12:39 AM
Tried installing this one, I'm getting this error:
Database error in vBulletin 3.6.1:

Invalid SQL:

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

WHERE valid = 1


ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Table 'electrak_forum.adv_gallery_images' doesn't exist Error Number : 1146

da420 10-11-2006 04:45 PM
Hey Zachariah, thanks for this.

One problem,
Everything seems to work fine when logged in. When showing as an unregistered user it is giving a database error. It only seems to be happening when unregistered, but when logged in it works perfectly. Any suggestions?

RMS-Chef 10-13-2006 04:19 AM
Quote:
Originally Posted by dbarry
Tried installing this one, I'm getting this error:
Database error in vBulletin 3.6.1:

Invalid SQL:

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

WHERE valid = 1


ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Table 'electrak_forum.adv_gallery_images' doesn't exist Error Number : 1146
I had the same issue. After a little research on the photopost.com release thread I noticed that with the vBGallery v2.0 GOLD release that there are quite a few database table name changes (if not all of them).
Quote:
Originally Posted by PhotoPost.com vBGallery v2.0 GOLD Release Thread
In order to not conflict with other vBAdvanced products the tables of the gallery have been renamed. 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

When you upgrade this will stop hacks in your site that use the gallery's old tables. Please disable or repair the add-ons in your site before upgrade.
I imagine users that are running the v2.0 betas with the older database table names are not having this issue but users like us that have installed the latest v2.0 GOLD with the new table names are out of luck with the hack until Zach updates it.

EDIT:
It appears that an updated version has been released by Zach on the PhotoPost forums HERE as it lists the vBGallery version as "v2.0 GOLD". The README.TXT in that download confirms this with the latest version notes. I am out of time tonight but will attempt to install that one tomorrow.

detalhe 10-13-2006 05:34 PM
Didn't find any updates of this hack there..:p

RMS-Chef 10-13-2006 05:55 PM
Quote:
Originally Posted by detalhe
Didn't find any updates of this hack there..:p
Log in on your verified customer account there and you will. ;)

da420 10-13-2006 06:07 PM
Quote:
Originally Posted by da420
Hey Zachariah, thanks for this.

One problem,
Everything seems to work fine when logged in. When showing as an unregistered user it is giving a database error. It only seems to be happening when unregistered, but when logged in it works perfectly. Any suggestions?
This was fixed by finding and deleting "$privatecatids" out of the gallery_block.php file under modules.

Zachariah 10-13-2006 11:39 PM
This will not be needed in vBGallery 2.1 +

:rambo: :ninja: :banana:

detalhe 10-17-2006 11:10 AM
Quote:
Originally Posted by RMS-Chef
Log in on your verified customer account there and you will. ;)

Now I did, when I looked for it first it wasn't there :)

Anyway, just installed it without problems, admicp shows correctly and hack is active but no images show on forum :alien:

TRR 10-26-2006 01:00 PM
yow. does this not work with the "Right Side Column 1.0.2" mod? When I install, it blows up my forum home page. Pictures are all over the place, various bits of html, and other general oddities and foolery.

Jaxx 11-01-2006 11:32 PM
Hmm. I started getting a bunch of these:

Quote:
Database error in vBulletin 3.6.2:

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 ppgal_images AS images

WHERE Array valid = 1


ORDER BY RAND()
LIMIT 1;

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 RAND()
LIMIT 1' at line 4
Error Number : 1064
I just updated from 3.07 to 3.62.


All times are GMT. The time now is 08:19 PM.
Page 11 of 20 « First 910 11 1213 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01371 seconds
  • Memory Usage 1,751KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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