vb.org Archive
Page 27 of 82 « First 172526 27 28293777 Last »
Show 40 post(s) from this thread on one page

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)

Leica.Robbiani 09-13-2012 02:36 PM
Hi there,

I get the following error when I call forumhome:

Code:
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 vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'post' ORDER BY entryid DESC LIMIT 5) AS entry_post
        LEFT JOIN vbs420_post AS post ON (post.postid = entry_post.contentid)
        LEFT JOIN vbs420_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 vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'dbgallery_image' ORDER BY entryid DESC LIMIT 5) AS entry_dbgallery_image
                LEFT JOIN vbs420_dbtech_gallery_images AS image ON (image.imageid = entry_dbgallery_image.contentid)
                LEFT JOIN vbs420_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 vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'socialgroup' ORDER BY entryid DESC LIMIT 5) AS entry_socialgroup
                LEFT JOIN vbs420_groupmessage AS groupmessage ON (groupmessage.gmid = entry_socialgroup.contentid)
                LEFT JOIN vbs420_discussion AS discussion ON (discussion.discussionid = groupmessage.discussionid)               
                LEFT JOIN vbs420_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 vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'usernote' ORDER BY entryid DESC LIMIT 5) AS entry_usernote
                LEFT JOIN vbs420_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 vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'visitormessage' ORDER BY entryid DESC LIMIT 5) AS entry_visitormessage
                LEFT JOIN vbs420_visitormessage AS visitormessage ON (visitormessage.vmid = entry_visitormessage.contentid)
        )
                        ) AS entry
                        LEFT JOIN vbs420_user AS user USING(userid)
                        LEFT JOIN vbs420_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbs420_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, September 13th 2012 @ 05:09:12 PM
Error Date    : Thursday, September 13th 2012 @ 05:09:12 PM
Script        : http://localhost/vbs420/upload/forum.php
Referrer      : http://localhost/vbs420/upload/dbtgallery.php?do=view_image&id=3&gal=gallery
IP Address    : 127.0.0.1
Username      : XXX
Classname    : vB_Database_MySQLi
MySQL Version : 5.5.16
Best regards

L.R.

Leica.Robbiani 09-13-2012 03:02 PM
Hi there,

it's me again. It seems to be a conflict with your Thanks/Like-Mod. Disabling this one, and the forumhome doesn't show a database error.

Best regards

L.R.

Alibass 09-13-2012 03:04 PM
Quote:
Originally Posted by Leica.Robbiani (Post 2365124)
Hi there,

it's me again. It seems to be a conflict with your Thanks/Like-Mod. Disabling this one, and the forumhome doesn't show a database error.

Best regards

L.R.
Download their latest thanks mod and see if that fixes your issue.

Leica.Robbiani 09-13-2012 04:31 PM
Hi there,

I have the latest version of Thanks/Like-Mod installed. Thanks for your help.

Best regards

L.R.

DragonByte Tech 09-13-2012 06:58 PM
Quote:
Originally Posted by qpurser (Post 2365021)
Dylan,
thx for another great MOD.

It has so many options I might have overlooked something :) and have a couple questions.

From my understanding this can replace the "standard" vBulletin albums?
I guess I can NOT delete the albums from the "standard" vBulletin after importing as I would loose all the links from their images/albums posted before installing your MOD?

Could you add a an option with link to a members pictures/albums into the "member settings" sidebar?

I had to import about 5000 images and it went well until about 4500 and then the server timed out.
Would it be possible to have an option to import only a certain amount at once in a session in the import settings from your MOD?

thx
Michael
I'll put an option in the next version to set the starting id on import so you can resume instead of having to start over.

You don't want to delete the albums for the reason you said, any previous links would be broken. I'll see if I can find a way to go in and replace the links, I keep the original album image id so it's possible in theory :)

Are you talking about adding a link in the UserCP settings area? That's doable in the next feature version.

The gallery replaces most of the album functions. I have a few more things to add, like displaying a block of albums on the profile, and I believe it will replace all the functionality.

Dylan

DragonByte Tech 09-13-2012 07:00 PM
Quote:
Originally Posted by Leica.Robbiani (Post 2365156)
Hi there,

I have the latest version of Thanks/Like-Mod installed. Thanks for your help.

Best regards

L.R.
It looks like some mysql configurations might have a problem between the two mods. Fillip and I are working on fixing it, thanks for letting us know and sorry about the conflict.

Dylan

DragonByte Tech 09-20-2012 04:06 AM
I just posted v1.2.4 which is a bugfix release.

v1.2.4 fixes the following:
Fixed - download not set on image create
Fixed - Extra username when viewing album
Fixed - default permissions on folder creation
Fixed - permissions not being set on instance creation
Fixed - dropped unique index on assoc field that's blocking favorites
Fixed - Broken path when gallery out of forum and physical images used

Leica, once Fillip releases updated thanks code the problem should be gone.

Dylan

ejbreeze 09-20-2012 11:04 PM
I have been working on this on my testsite and when I upload any a photo I get the following error:

Warning: copy(path/dbtech/gallery/images/upload/1/1/5/full/index.html) [function.copy]: failed to open stream: HTTP wrapper does not support writeable connections in[path]/dbtech/gallery/includes/class_core.php on line 1194

Folder "upload" and the ones inside are set at 0777 It did work once but after reverted back to this error. When importing there is a missing image icon for all the photos. The text seems correct. I did set the thumbnail size in Instance Management but they were also set by default when I viewed them.

Thanks in advance :)

https://vborg.vbsupport.ru/external/2012/09/18.png

DragonByte Tech 09-21-2012 04:10 AM
Quote:
Originally Posted by ejbreeze (Post 2367167)
I have been working on this on my testsite and when I upload any a photo I get the following error:

Warning: copy(path/dbtech/gallery/images/upload/1/1/5/full/index.html) [function.copy]: failed to open stream: HTTP wrapper does not support writeable connections in[path]/dbtech/gallery/includes/class_core.php on line 1194

Folder "upload" and the ones inside are set at 0777 It did work once but after reverted back to this error. When importing there is a missing image icon for all the photos. The text seems correct. I did set the thumbnail size in Instance Management but they were also set by default when I viewed them.

Thanks in advance :)
Check the permissions on the child folders, the 1/1/5/full and 1/1/5/thumb ones.
Also, what version are you running? The postbit here says 1.1.3?

Dylan

daniel.l 09-22-2012 01:44 PM
Get the following error

Warnung: mkdir() [function.mkdir]: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1174)

Warnung: copy(dbtech/gallery/images/upload/1/3/5/4/3/thumb/index.html) [function.copy]: failed to open stream: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1176)

Warnung: mkdir() [function.mkdir]: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1183)

Warnung: copy(dbtech/gallery/images/upload/1/3/5/4/3/wm/index.html) [function.copy]: failed to open stream: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1185)

Warnung: mkdir() [function.mkdir]: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1192)

Warnung: copy(dbtech/gallery/images/upload/1/3/5/4/3/full/index.html) [function.copy]: failed to open stream: Permission denied in [path]/dbtech/gallery/includes/class_core.php (Zeile 1194)


All times are GMT. The time now is 08:57 PM.
Page 27 of 82 « First 172526 27 28293777 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.01768 seconds
  • Memory Usage 1,771KB
  • 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
  • (1)bbcode_code_printable
  • (4)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