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)

DragonByte Tech 07-15-2012 08:24 PM

What are you doing when you see this? I have like 20 DBT mods installed on my local dev, thanks included, and I haven't run into an error like this.

With the image upload, double check your instance and make sure the instance has values set for the width/height thumb/full dimensions.

Dylan

Quote:

Originally Posted by PattiOz (Post 2347449)
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



DragonByte Tech 07-15-2012 08:26 PM

Quote:

Originally Posted by Geisthund99 (Post 2347587)
Hi

Install appeared to go OK but on trying to upload image


HTH
Gareth

Did you edit the instance and set the width/height for the thumb/full dimensions? That sounds like what's causing the error.

Dylan

DragonByte Tech 07-15-2012 08:28 PM

Quote:

Originally Posted by Craigr (Post 2347593)
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?

Are you using a watermark? I resize the image to fit, and add the watermark if it's set to etch. I didn't think it would be that much bigger though. If you want you can send me the image and I'll test it locally to see the size difference.

You can change any of the phrases you want :)

Dylan

DragonByte Tech 07-15-2012 08:29 PM

Quote:

Originally Posted by glen290 (Post 2348428)
Getting this huge error when I select latest albums in the drop down box..

Upgrade to 1.0.3, it looks like the error that I fixed in the latest release.

Dylan

glen290 07-16-2012 06:42 AM

That worked perfect, must have been the only DBTech mod i hadnt upgraded...

alhidaya 07-16-2012 10:53 AM

Hello,

I don't understand: the widget works horizontally but not vertically.

alhidaya 07-16-2012 02:57 PM

Hello,

When I'm in the picture gallery and I want to click on button "LIKES": a window opens and the message here:

Quote:

Pass error
/home/..../...../dbtech/thanks/contentypes/dbgallery__image/save.php
on line 128

Craigr 07-16-2012 04:08 PM

Quote:

Originally Posted by DragonByte Tech (Post 2348462)
Are you using a watermark? I resize the image to fit, and add the watermark if it's set to etch. I didn't think it would be that much bigger though. If you want you can send me the image and I'll test it locally to see the size difference.

You can change any of the phrases you want :)

Dylan

Thanks.

No watermarks used for image upload. Before adding it is 514Kb, but once uploaded to the gallery it becomes 1.78Mb. This is the image i am trying to add : http://www.specialforcesroh.com/gallery/file1308.jpg

Is it possibly because the original image is more than the 3020 pixels high and my limit is 3000 pixels so it is re-sizing it, but losing the compression.

DragonByte Tech 07-16-2012 04:53 PM

Quote:

Originally Posted by alhidaya (Post 2348630)
Hello,

I don't understand: the widget works horizontally but not vertically.

If you set it to vertical, does it not work or just shows but messed up looking? If it's messed up looking, can you take a screenshot and send it? It's working on my dev so I'm not sure what the problem is and "doesn't work" isn't descriptive enough :)

Dylan

DragonByte Tech 07-16-2012 05:11 PM

Quote:

Originally Posted by alhidaya (Post 2348695)
Hello,

When I'm in the picture gallery and I want to click on button "LIKES": a window opens and the message here:

We found the issue. The next advanced post thanks/likes release will have a fix for this.

Dylan


All times are GMT. The time now is 07:46 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.01586 seconds
  • Memory Usage 1,788KB
  • 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
  • (8)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