vb.org Archive
Page 3 of 5 12 3 45
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)

R.Solutions 09-24-2006 10:14 PM
Any word on this?

GlobalFusion 09-26-2006 12:43 PM
Ditto.
After making the edit in init.php, the forums spit chips with a DB Error:

Code:
Database error in vBulletin 3.6.1:

Invalid SQL:

                SELECT
                        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                        language.phrasegroup_cfmdirectory AS phrasegroup_cfmdirectory,
                        language.phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
                        language.phrasegroup_global AS phrasegroup_global,
                        language.options AS lang_options,
                        language.languagecode AS lang_code,
                        language.charset AS lang_charset,
                        language.locale AS lang_locale,
                        language.imagesoverride AS lang_imagesoverride,
                        language.dateoverride AS lang_dateoverride,
                        language.timeoverride AS lang_timeoverride,
                        language.registereddateoverride AS lang_registereddateoverride,
                        language.calformat1override AS lang_calformat1override,
                        language.calformat2override AS lang_calformat2override,
                        language.logdateoverride AS lang_logdateoverride,
                        language.decimalsep AS lang_decimalsep,
                        language.thousandsep AS lang_thousandsep
                       
                FROM dfusion_user AS user
                LEFT JOIN dfusion_userfield AS userfield ON (user.userid = userfield.userid)
                LEFT JOIN dfusion_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN dfusion_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
               
                WHERE user.userid = 1;

MySQL Error  : Unknown column 'language.phrasegroup_adv_gallery' in 'field list'
Error Number : 1054
Date        : Tuesday, September 26th 2006 @ 11:28:36 PM
Script      : http://some.url
Referrer    : http://some.url
IP Address  : My.IP
Username    :
Classname    : vB_Database
I am running:
vBulletin 3.6.1
PHP version 5.1.4
MySQL version 4.1.21-standard
PhotoPost Version Pro v5.2.1


Oh.. and then there is this:
Code:

Warning: require_once(./includes/functions_gallery.php) [function.require-once]: failed to open stream: No such file or directory in /includes/vbgallery/forumhome_complete.php on line 16

Fatal error: require_once() [function.require]: Failed opening required './includes/functions_gallery.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dfusion/public_html/forums/includes/vbgallery/forumhome_complete.php on line 16
But im looking into that atm.
[EDIT]
  • forumhome_complete.php - DOES exist in the forums/includes/vbgallery/ directory
  • ./includes/functions_gallery.php - does NOT exist (./includes/functions_gallery_store.php does however)

[EDIT]
  • edited forumhome_complete to reflect functions_gallery_store.php location (instead of functions_gallery.php)
  • Below Edit Fixed above problem :) (now to tackle the DB issue...)
    Code:
    //Latest Images In ForumHome BEGIN

    require_once('./includes/functions_gallery_store.php'); 
    require_once('./includes/class_bbcode.php');

GlobalFusion 09-26-2006 01:03 PM
This File is causing my headaches....

functions_gallery_store.php:
PHP Code:
<?php

// ################### PRE-CACHE TEMPLATES AND DATA ######################

if (PHP_VERSION < '5.0.0') {

    // get special phrase groups
            $phrasegroups = array_merge($phrasegroups, array(
                                                                    'adv_gallery'
                                                                    ));

    // get special data templates from the datastore
            $specialtemplates = array_merge($specialtemplates, array(
                                                                    'gallery_c_cache',
                                                                    'adv_gallery_opt',
                                                                    'gallery_ugroups',
                                                                    ));
}else{
    
     /*
     PHP5.x - ONLY
     The behavior of array_merge() was modified in PHP 5. 
     Unlike PHP 4, array_merge() now only accepts parameters of type array. 
     However, you can use typecasting to merge other types.
    */
    
    // get special phrase groups
            $phrasegroups = array_merge((array)$phrasegroups, (array)array(
                                                                    'adv_gallery'
                                                                    ));

    // get special data templates from the datastore
            $specialtemplates = array_merge((array)$specialtemplates, (array)array(
                                                                    'gallery_c_cache', 
                                                                    'adv_gallery_opt',
                                                                    'gallery_ugroups',
                                                                    ));
}
?>
Possibly the PHP5 Inclusion?
PHP Code:
    // get special phrase groups
            $phrasegroups = array_merge((array)$phrasegroups, (array)array(
                                                                    'adv_gallery'
                                                                    )); 

GlobalFusion 09-26-2006 01:45 PM
I see you reading Zac. And im eagerly awaiting your reply... as im dead in the water atm (as far as the forumhome enhancement goes anyway.. :))

[edit]
But Alas... you have vanished.. and without a response... :(

Zachariah 09-26-2006 02:03 PM
@GlobalFusion
- This is not for PhotoPost Pro gallery. It is for PhotoPost vBGallery.

Try here for some Pro hacks

GlobalFusion 09-26-2006 02:30 PM
ok. cheers Zac. Will have a look.

Hornstar 09-27-2006 05:04 AM
Is there anyway to get this positioned down the left hand side of the forumhome? as I am going to have a navigation system on the left hand side, and thought this would be nice to add in extra space.

Thanks.

Zachariah 09-27-2006 12:09 PM
Quote:
Originally Posted by hornstar1337
Is there anyway to get this positioned down the left hand side of the forumhome? as I am going to have a navigation system on the left hand side, and thought this would be nice to add in extra space.

Thanks.
Location: Custom

Select "Custom" and place $vbgallery in FORUMHOME template for custom location.

midirtrider 09-27-2006 03:46 PM
noticed something weird..

in the vb options>vbgallery... this is what it says..

Imagebit Title
Here you may select to enable items that you would like to display with thumbnails. Yes No
Error:
1

for every option.. under every heading.. the headings are all there.. but the
"Here you may select to enable items that you would like to display with thumbnails. Yes No " is displayed under them all..

Plus when I try to run it on my board I am getting a database error..

I uninstalled the xml. file and removed the require_once(CWD . '/includes/functions_gallery_store.php'); from the init.php file and now my board is back to working fine..
is there a way I can fix this error.. Im a noob and really know very little about coding.

Draygonia 09-28-2006 11:04 PM
After I add this below the init.php file I get a huge error...

require_once(CWD . '/includes/functions_gallery_store.php');

That gives a database error, its kinda bad :( Also, where are the template edits in the readme file?

G_Man 09-29-2006 12:26 AM
Hey this thing doesn't work if you upload the files to wrong directory *blush*

After fixing MYSELF, everything is working beautifully.

Thanks, Zac. Love the additions and LOVE vbaGallery. :D :D :D

Zachariah 09-29-2006 12:58 AM
Quote:
Originally Posted by G_Man
Hey this thing doesn't work if you upload the files to wrong directory *blush*

After fixing MYSELF, everything is working beautifully.

Thanks, Zac. Love the additions and LOVE vbaGallery. :D :D :D
oh man, I hear ya on the wrong folders. :banana:

austrekkers 09-29-2006 05:45 AM
Hmmm... first mod I've tried since just installing VB, and I've got problems. :surprised: Didn't think I could stuff it up, looks so easy. I ran the XML file, uploaded the files and edited the init.php. Now for all pages on the forum I get a "database error" page.

When I view the source, I get:

MySQL Error : Unknown column 'phrasegroup_adv_gallery' in 'field list'
Error Number : 1054

Help???

Zachariah 09-29-2006 11:48 AM
Quote:
Originally Posted by austrekkers
Hmmm... first mod I've tried since just installing VB, and I've got problems. :surprised: Didn't think I could stuff it up, looks so easy. I ran the XML file, uploaded the files and edited the init.php. Now for all pages on the forum I get a "database error" page.

When I view the source, I get:

MySQL Error : Unknown column 'phrasegroup_adv_gallery' in 'field list'
Error Number : 1054

Help???
Hi,

This is an add-on to a gallery already installed.
- It's not a gallery.

Neal-UK 09-29-2006 11:54 AM
http://www.talkbritain.co.uk/external/chav_01.jpg

:confused:

austrekkers 10-02-2006 10:53 PM
Quote:
Originally Posted by Zachariah
Hi,

This is an add-on to a gallery already installed.
- It's not a gallery.
How embarrasing. :surprised:

Can you tell me how to undo the install? :cry:

Zachariah 10-03-2006 11:10 AM
Quote:
Originally Posted by austrekkers
How embarrasing. :surprised:

Can you tell me how to undo the install? :cry:
https://vborg.vbsupport.ru/showpost....5&postcount=76

MikaP 10-08-2006 08:06 AM
Hello,

I get every time on my vbulletin 3.6.2, a vbulletin db error.

Doglet 10-09-2006 05:57 AM
Can you do this with PhotoPost Pro as well? I have the Featured Photos hack, but it is a bit restricted.

detalhe 10-10-2006 06:45 PM
Quote:
Originally Posted by MikaP
Hello,

I get every time on my vbulletin 3.6.2, a vbulletin db error.
Same here, vb 3.6.2, error disapears after reverting the init.php edit :(

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.

Jaxx 11-02-2006 12:37 AM
As an update, users were not able to log in, I was, as well as my supermods. Everyone else couldn't.

permissiosn are set. I disabled this and they were able to log in.

Ideas?

bonjurkes 11-02-2006 05:51 PM
is there a way to make the thumbs at forumhome bigger?

ABeautifulBrown 11-04-2006 01:46 PM
I think because I am using the Blaze template, it is not showing up on my forumhome. How can I add it in there?

Zachariah 11-04-2006 03:34 PM
Quote:
Originally Posted by ABeautifulBrown
I think because I am using the Blaze template, it is not showing up on my forumhome. How can I add it in there?
You should be able to select "custom" in the placement of the hack.

add: $vbgallery

In the forumhome template.

ABeautifulBrown 11-04-2006 09:41 PM
hey. I put that in the template and I set the placement to custom. I still don't see it though. It's supposed to be showing above my stats mod display but nothing shows. Any ideas? TIA!
www.sofreshforums.com

Roxie 11-04-2006 10:06 PM
Quote:
Originally Posted by ABeautifulBrown
hey. I put that in the template and I set the placement to custom. I still don't see it though. It's supposed to be showing above my stats mod display but nothing shows. Any ideas? TIA!
www.sofreshforums.com

Hey E! I've had this working for a while, so if you need help, let me know.

sunnycher 11-05-2006 05:52 AM
I'd love to put this on my forum.
Is it stable for 3.62?
I'm reading all the database errors here, I sure don't want to go through those again.
Any ideas if it's working with no problems?

lifesourcerec 11-05-2006 12:25 PM
Quote:
Originally Posted by sunnycher
I'd love to put this on my forum.
Is it stable for 3.62?
I'm reading all the database errors here, I sure don't want to go through those again.
Any ideas if it's working with no problems?
Well, this almost got me kicked off of my hoster because of the ineffient coding, so I removed it.

sunnycher 11-05-2006 12:27 PM
Thank you!!
I don't think I'll be installing it, I sure hate that too.
It's a nice hack!

lifesourcerec 11-05-2006 06:50 PM
Quote:
Originally Posted by sunnycher
Thank you!!
I don't think I'll be installing it, I sure hate that too.
It's a nice hack!
And I quote the message I received after trying to get this installed:

Quote:
There were some developments this morning with your site that were causing crashes. This was apparently due to some photo gallery hack you had installed in your vBulletin install. I've needed to disable this, as it's both highly inefficient code and was resulting in degraded service for everyone. We've also determined your account to be using an excessive amount of CPU time and memory on the server. Your site is currently responsible for 10-20% of the CPU time and up to 33% of the memory usage on the system over the past few weeks.
Remove it and no longer having problems.


All times are GMT. The time now is 09:50 PM.
Page 3 of 5 12 3 45
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.01724 seconds
  • Memory Usage 1,871KB
  • 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
  • (3)bbcode_code_printable
  • (2)bbcode_php_printable
  • (17)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
  • (40)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