vb.org Archive
Page 7 of 32 « First 56 7 8917 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 Display Enhancements - vBi-Gallery for vB 3.6.X (https://vborg.vbsupport.ru/showthread.php?t=128598)

Harald_T 10-16-2006 04:10 PM
@Hades: I don't have much freetime, as i have a job and a family also. The problem with the permissions. Give guests the permission to download attachments, this should help.

As soon as i get the time for it, i will update the FAQ on the first page.

If you get messages displaying that there missing columns in the SQL-Database try to reinstall the product (and overwrite the old version). Or check out for sure, that you have the rights to run queries.

Antiblank 10-16-2006 04:17 PM
Tried overwriting the product again, every other product I have installs/upgrades fine. But as soon as I enable the gallery again the boards totally break and all I get is:

Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT gallery, threadid, firstpostid, thread.title, attachmentid, attachment.dateline FROM attachment, thread, forum
WHERE gallery='1'AND thread.featured!='1' AND  thread.forumid=forum.forumid AND thread.firstpostid = attachment.postid AND attachment.dateline < 1161018334 ORDER BY RAND() LIMIT 5;

MySQL Error  : Unknown column 'thread.featured' in 'where clause'
Error Number : 1054

Antiblank 10-16-2006 04:20 PM
By the way, the 3.5.4 Version of this Hack lists itself on the post as version 1.23. Where here on this thread you list the version as 1.30 for 3.6.2 vBulletin. But when I upgrade with the download here on this thread the product lists itself in the Product manager section as 1.23:

vBI-Gallery 1.23 A gallery-system integrated in the forum

Hades-1 10-16-2006 04:46 PM
well can u please tell me how to show the image at original size not 3x to large???

Harald_T 10-16-2006 05:10 PM
Edit "gallery-attachment"-Template

Replace it with:

Code:
<a href="attachment.php?$session[sessionurl]attachmentid=$attachment[attachmentid]&amp;d=$attachment[dateline]"<if condition="$show['newwindow']"> target="_blank"</if>>

<if condition="$attachment[filename]!=$vboptions[gal_feat_name]">
<img class="thumbnail" src="attachment.php?$session[sessionurl]attachmentid=$attachment[attachmentid]&amp;stc=1&amp;thumb=0&amp;d=$attachment[thumbnail_dateline]" border="0" align="center"></a>
&nbsp;<if condition="$show['br']"><br /><br /></if>
</if>

Harald_T 10-16-2006 05:21 PM
@Antiblank:

Try this one. Replace the code for random_thumbs in the plugin "gallery_images_forumhome" with this one:

Code:
if ($vbulletin->options['show_random']) {
$random_thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title,". TABLE_PREFIX . "thread.featured, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1'AND ". TABLE_PREFIX . "thread.featured!='1' AND  ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ." ORDER BY RAND() LIMIT 5");

while ($rand_gallery = $db->fetch_array($random_thumbs))
{
eval('$random_gallery .= "' . fetch_template('gallery_randompictures') . '";');
}

Antiblank 10-16-2006 06:35 PM
Quote:
Originally Posted by Harald_T
@Antiblank:

Try this one. Replace the code for random_thumbs in the plugin "gallery_images_forumhome" with this one:
...

Nearly perfect thank you for the help. The only issue now is that on my forum home page, I see a header section at the top for Random Images from the gallery, but no images appear there. But the layout is showing correctly in the gallery forum as well as on the members profile pages. So for those you get my mightest thanks. Glad to be able to turn that much back on again.

Antiblank 10-16-2006 06:49 PM
Now I'm starting to feel bad about posting but maybe this is related to my other issue. I just went to my forum manager and tried to update the settings on my gallery forum. (I also tried updating any of our forums and the error is along the same lines).

Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE forum SET
        title_clean = 'Refridgerator of Joy',
        title = 'Refridgerator of Joy',
        description_clean = '',
        description = '',
        link = '',
        displayorder = 1,
        parentid = 31,
        daysprune = -1,
        defaultsortfield = 'lastpost',
        defaultsortorder = 'desc',
        showprivate = 0,
        newpostemail = '',
        newthreademail = '',
        ### Bitfield: forum.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 16, options - 16, options),
                options = IF(options & 32, options - 32, options),
                options = IF(options & 32768, options - 32768, options),
                options = IF(options & 8192, options, options + 8192),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 16384, options, options + 16384),
                options = IF(options & 256, options - 256, options),
                options = IF(options & 64, options, options + 64),
                options = IF(options & 128, options, options + 128),
                options = IF(options & 512, options, options + 512),
                options = IF(options & 1024, options, options + 1024),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options, options + 4096),
                options = IF(options & 65536, options, options + 65536),
        styleid = 0,
        password = '',
        gallery = '1',
        gallery_cat = '0',
        gal_thumbs = 0,
        gal_statusicon = ''
WHERE forumid = 32;

MySQL Error  : Unknown column 'gallery_cat' in 'field list'
The bit:

Code:
MySQL Error  : Unknown column 'gallery_cat' in 'field list'
appears for every forum in the error after I try to save any settings.

Harald_T 10-16-2006 08:41 PM
The altering on the table "forums" is missing for the gallery_cat. Did you check your config-file if you are able to run a query? Normally this shouldn't, but you never know.

Otherwise run the query in your admin-cp.

Code:
ALTER TABLE forum ADD gallery_cat TINYINT( 4 ) NOT NULL
Be sure to set the the prefix for the table forum, if you have so. E.g. vb_forum

Antiblank 10-16-2006 10:51 PM
Quote:
Originally Posted by Harald_T
The altering on the table "forums" is missing for the gallery_cat. Did you check your config-file if you are able to run a query? Normally this shouldn't, but you never know.

Otherwise run the query in your admin-cp.

Code:
ALTER TABLE forum ADD gallery_cat TINYINT( 4 ) NOT NULL
Be sure to set the the prefix for the table forum, if you have so. E.g. vb_forum
I added that in as it was missing and tried again, now it seems I'm missing another. This is leading me to believe that perhaps none of the sql queries were made. Yet I have a gallery set up on my site, it was there and seeming to run fine before this upgrade.

New Error:
Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE forum SET
        title_clean = 'Refridgerator of Joy',
        title = 'Refridgerator of Joy',
        description_clean = '',
        description = '',
        link = '',
        displayorder = 1,
        parentid = 31,
        daysprune = -1,
        defaultsortfield = 'lastpost',
        defaultsortorder = 'desc',
        showprivate = 0,
        newpostemail = '',
        newthreademail = '',
        ### Bitfield: forum.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 16, options - 16, options),
                options = IF(options & 32, options - 32, options),
                options = IF(options & 32768, options - 32768, options),
                options = IF(options & 8192, options, options + 8192),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 16384, options, options + 16384),
                options = IF(options & 256, options - 256, options),
                options = IF(options & 64, options, options + 64),
                options = IF(options & 128, options, options + 128),
                options = IF(options & 512, options, options + 512),
                options = IF(options & 1024, options, options + 1024),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options, options + 4096),
                options = IF(options & 65536, options, options + 65536),
        styleid = 0,
        password = '',
        gallery = '1',
        gallery_cat = '0',
        gal_thumbs = 1,
        gal_statusicon = ''
WHERE forumid = 32;

MySQL Error  : Unknown column 'gal_thumbs' in 'field list'


All times are GMT. The time now is 03:55 PM.
Page 7 of 32 « First 56 7 8917 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.01322 seconds
  • Memory Usage 1,767KB
  • 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
  • (8)bbcode_code_printable
  • (2)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