vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] Dragonbyte Gallery v1 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=285074)

PattiOz 07-12-2012 11:55 PM

Hmmmm. SQL error after installing the gallery. I disabled your "Thank You" mod and the error disappeared. Then I re-enabled the "Thank You" mod and disabled the Gallery mod, and there was no error. Seems there is a conflict with running your two mods together on my install, or I missed some steps somewhere.

Database error in vBulletin 4.2.0:

Code:

Invalid SQL:

                        SELECT
                                entry.*,
                                user.*
                                ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                        FROM (
                                (
        SELECT
                post.postid,
                post.title AS posttitle,
                thread.title AS threadtitle,
                thread.title AS title,
                thread.threadid,
                thread.forumid,
                entry_post.*
        FROM (SELECT * FROM dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'post' ORDER BY entryid DESC LIMIT 5) AS entry_post
        LEFT JOIN post AS post ON (post.postid = entry_post.contentid)
        LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
) UNION ALL (
                SELECT
                        image.imageid AS postid,
                        image.title AS posttitle,
                        image.filename AS threadtitle,               
                        image.userid,
                        image_instance.shortname AS threadid,
                        0 AS forumid,
                        entry_dbgallery_image.*
                FROM (SELECT * FROM dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'dbgallery_image' ORDER BY entryid DESC LIMIT 5) AS entry_dbgallery_image
                LEFT JOIN dbtech_gallery_images AS image ON (image.imageid = entry_dbgallery_image.contentid)
                LEFT JOIN dbtech_gallery_instances AS image_instance ON (image_instance.instanceid = image.instanceid)               
        ) UNION ALL (
                SELECT
                        groupmessage.gmid AS postid,
                        groupmessage.title AS posttitle,
                        firstgroupmessage.title AS threadtitle,               
                        groupmessage.postuserid AS userid,
                        groupmessage.discussionid AS threadid,
                        0 AS forumid,
                        entry_socialgroup.*
                FROM (SELECT * FROM dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'socialgroup' ORDER BY entryid DESC LIMIT 5) AS entry_socialgroup
                LEFT JOIN groupmessage AS groupmessage ON (groupmessage.gmid = entry_socialgroup.contentid)
                LEFT JOIN discussion AS discussion ON (discussion.discussionid = groupmessage.discussionid)               
                LEFT JOIN groupmessage AS firstgroupmessage ON (firstgroupmessage.gmid = discussion.firstpostid)               
        ) UNION ALL (
                SELECT
                        usernote.usernoteid AS postid,
                        usernote.title AS posttitle,
                        'N/A' AS threadtitle,               
                        usernote.posterid AS userid,
                        usernote.userid AS threadid,
                        0 AS forumid,
                        entry_usernote.*
                FROM (SELECT * FROM dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'usernote' ORDER BY entryid DESC LIMIT 5) AS entry_usernote
                LEFT JOIN usernote AS usernote ON (usernote.usernoteid = entry_usernote.contentid)
        ) UNION ALL (
                SELECT
                        visitormessage.vmid AS postid,
                        visitormessage.title AS posttitle,
                        'N/A' AS threadtitle,               
                        visitormessage.postuserid AS userid,
                        visitormessage.userid AS threadid,
                        0 AS forumid,
                        entry_visitormessage.*
                FROM (SELECT * FROM dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'visitormessage' ORDER BY entryid DESC LIMIT 5) AS entry_visitormessage
                LEFT JOIN visitormessage AS visitormessage ON (visitormessage.vmid = entry_visitormessage.contentid)
        )
                        ) AS entry
                        LEFT JOIN user AS user USING(userid)
                        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                        WHERE 1=1;

MySQL Error  : Illegal mix of collations for operation 'UNION'
Error Number  : 1271
Request Date  : Thursday, July 12th 2012 @ 07:56:47 PM
Error Date    : Thursday, July 12th 2012 @ 07:56:47 PM
Script        : http://www.MYSITE.com/dev2012/forum/activity.php
Referrer      : http://www.MYSITE.com/dev2012/forum/...hp?gal=gallery
IP Address    : 49.176.65.59
Username      : admin
Classname    : vB_Database
MySQL Version : 5.0.95-community

Errors on image upload:

Code:

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in [path]/dbtech/gallery/includes/class_core.php on line 755

Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 763

Warning: imagecolortransparent() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 764

Warning: imagealphablending() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 765

Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 766

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 770

Warning: imagejpeg() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 785

Warning: imagedestroy() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 792

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in [path]/dbtech/gallery/includes/class_core.php on line 755

Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 763

Warning: imagecolortransparent() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 764

Warning: imagealphablending() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 765

Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 766

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 770

Warning: imagejpeg() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 785

Warning: imagedestroy() expects parameter 1 to be resource, boolean given in [path]/dbtech/gallery/includes/class_core.php on line 792

Warning: filesize() [function.filesize]: stat failed for [path]/dbtech/gallery/images/upload/1/1/full/4_1342146302.jpg in [path]/dbtech/gallery/includes/class_core.php on line 664

Warning: filesize() [function.filesize]: stat failed for [path]/dbtech/gallery/images/upload/1/1/thumb/4_1342146302.jpg in [path]/dbtech/gallery/includes/class_core.php on line 665


Preech 07-13-2012 11:03 AM

Is the CMS block working. Just curious

Geisthund99 07-13-2012 02:32 PM

Hi

Install appeared to go OK but on trying to upload image

Quote:

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in [path]\dbtech\gallery\includes\class_core.php on line 755

Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 763

Warning: imagecolortransparent() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 764

Warning: imagealphablending() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 765

Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 766

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 770

Warning: imagejpeg() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 785

Warning: imagedestroy() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 792

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in [path]\dbtech\gallery\includes\class_core.php on line 755

Warning: imagecolorallocate() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 763

Warning: imagecolortransparent() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 764

Warning: imagealphablending() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 765

Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 766

Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 770

Warning: imagejpeg() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 785

Warning: imagedestroy() expects parameter 1 to be resource, boolean given in [path]\dbtech\gallery\includes\class_core.php on line 792

Warning: filesize() [function.filesize]: stat failed for [path]/dbtech/gallery/images/upload/1/1/full/2_1342193422.jpg in [path]\dbtech\gallery\includes\class_core.php on line 664

Warning: filesize() [function.filesize]: stat failed for [path]/dbtech/gallery/images/upload/1/1/thumb/2_1342193422.jpg in [path]\dbtech\gallery\includes\class_core.php on line 665
HTH
Gareth

Craigr 07-13-2012 02:51 PM

Quote:

Originally Posted by Preech (Post 2347541)
Is the CMS block working. Just curious

Doesn't seem to be working for me. Just shows block, but no images. EDIT: Works fine if horizontal rather than vertical used.


In the gallery are we allowed to change the title from 'Dragonbyte Gallery' to our own name? Also the DBTech - Gallery line at the top.

Also for some reason when i upload a 514Kb file it ends up 1.78Mb on the site? Any idea what is wrong there?

vb_nils 07-13-2012 05:39 PM

Hi there,

Manage to install the mod with no problem.
But when uploading an image, it shows me a big "Image is missing".
I've checked the upload folders and rights are 777 on all subfolders.
I've noticed that owners are "apache" and "root". Is it normal?

Any ideas?

Craigr 07-14-2012 11:38 AM

Great job on the gallery. Any chance of a few requests:

> When you search for an image, could you also include the image name below the image like it is shown normally on the index page, etc
> Some statistics on the main gallery page. How many images, categories, views, etc.
> Better pagination, would like to see it the same as the vBulletin thread and board view showing page 1 of 8 and links to others.
> Way to sort the images in each gallery (by name, comments, uploaded, etc)
> When you view an image include the category and link in the breadcrumb.

I would be willing to donate for the above if it could be done, i am using an old forum software and created my own custom gallery with nearly 15,000 images. I managed to import them all to this gallery.

sp3z!aL 07-14-2012 12:45 PM

Quote:

Originally Posted by vb_nils (Post 2347674)
Hi there,

Manage to install the mod with no problem.
But when uploading an image, it shows me a big "Image is missing".
I've checked the upload folders and rights are 777 on all subfolders.
I've noticed that owners are "apache" and "root". Is it normal?

Any ideas?

you must setup in Instance Management in your Galery the Image size of thumb and Image.

vb_nils 07-15-2012 07:08 AM

Quote:

Originally Posted by sp3z!aL (Post 2348018)
you must setup in Instance Management in your Galery the Image size of thumb and Image.

OOhhhh I see ... very good :cool:

Thanks a lot for the information :D

glen290 07-15-2012 07:38 PM

Getting this huge error when I select latest albums in the drop down box..
"Invalid response from server: <br /><strong>Warning</strong>: getimagesize([path]/dbtech/gallery/images/upload//1/thumb/_.) [<a href='function.getimagesize'>function.getimagesize </a>]: failed to open stream: No such file or directory in <strong>[path]/dbtech/gallery/modules/gallery/functions/class_module.php</strong> on line <strong>350</strong><br /><br /><strong>Warning</strong>: getimagesize([path]/dbtech/gallery/images/upload//1/thumb/_.) [<a href='function.getimagesize'>function.getimagesize </a>]: failed to open stream: No such file or directory in <strong>[path]/dbtech/gallery/modules/gallery/functions/class_module.php</strong> on line <strong>350</strong><br /><?xml version="1.0" encoding="windows-1252"?>
<gallery_home>
<gallery_images><![CDATA[

<div class="image_box" style="padding-top: 5px; width: 210px;">

<span></span>

<a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=1&amp;gal =gallery&amp;id=3&amp;type=alb ums"><img src="http://www.bowluk.com/dbtgallery.php?do=gallery_image&amp;id=3&amp;gal=g allery&amp;type=folder" alt="Bowl UK Summer Handicap Tournament Gallery by Glen" border="0" /></a>

<div class="text">



<span class="small">

User: <a href="http://www.bowluk.com/dbtgallery.php?do=view_user&id=1&gal=gallery">Glen </a><br />





Album: <a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=&amp;gal= gallery&amp;id=3&amp;type=albu ms">Bowl UK Summer Handicap Tournament Gallery</a><br />



<a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=1&amp;gal =gallery&amp;id=3&amp;type=alb ums#comments"><img src="dbtech/gallery/images/comments.png" border="0" alt=" Comments" title=" Comments" />&nbsp; Comments</a>

</span>

</div>

<div class="options">



</div>

</div>





<div class="image_box" style="padding-top: 5px; width: 210px;">

<span></span>

<a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=1&amp;gal =gallery&amp;id=2&amp;type=alb ums"><img src="http://www.bowluk.com/dbtgallery.php?do=gallery_image&amp;id=2&amp;gal=g allery&amp;type=folder" alt="YBC by Glen" border="0" /></a>

<div class="text">



<span class="small">

User: <a href="http://www.bowluk.com/dbtgallery.php?do=view_user&id=1&gal=gallery">Glen </a><br />





Album: <a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=&amp;gal= gallery&amp;id=2&amp;type=albu ms">YBC</a><br />



<a href="http://www.bowluk.com/dbtgallery.php?do=browse_user&amp;userid=1&amp;gal =gallery&amp;id=2&amp;type=alb ums#comments"><img src="dbtech/gallery/images/comments.png" border="0" alt=" Comments" title=" Comments" />&nbsp; Comments</a>

</span>

</div>

<div class="options">



</div>

</div>



]]></gallery_images>
<gallery_buttons><![CDATA[

<div class="table" style="width: 100%;">

<div class="tr">

<div class="td blockrow" style="vertical-align: top; text-align: center;">



<span class="gallery_button_left_dis">Previous</span>







</div>

<div class="td blockrow" style="vertical-align: top; text-align: center;">



<span class="gallery_button_right_dis">Next</span>







</div>

</div>

</div>

]]></gallery_buttons>"

DragonByte Tech 07-15-2012 08:21 PM

Quote:

Originally Posted by alhidaya (Post 2346871)
Hello,

Thank you Dylan

I wait with joy the slidershow.

Thank you for this work is magnificent.

How can we remove the orange record album ?

In Acp :


It doesn't work

It s work horizontal

Could you scroll through the images in the widget because they are fixed ?

Gallery ForumHome block :

I want to place it at the bottom of the forum and not the top, how can we do ?

Can you show me a screenshot of what it looks like when set to vertical? It works on my local dev.

If you want to move where the forumhome block is displayed, in the settings, set Enable Automatic Deployment to No, then edit your FORUMHOME template and put {vb:raw gallery_fh} where you want it to be displayed.

You can replace the orange album picture with something else if you want. Just be sure there is space for the latest image to show. Or if you don't want it to show the album image at all I guess you can try and replace it with a transparent image the same size.

Dylan


All times are GMT. The time now is 01:15 PM.

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.01640 seconds
  • Memory Usage 1,815KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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