[DragonByte Tech]

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

Originally Posted by PattiOz

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:

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:

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