vb.org Archive - Major Additions - [DBTech] Dragonbyte Gallery v1 (vB4)

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)

I'm seriously thinking of buying the pro version of this mod, but am a little bit wary of transferring my 2000 or so images from my standard vbulletin gallery into it.
The reason being that vB4 is nearly at the end of its life, and vB5 will be the next step.
My question is, will this mod be compatible, and will it allow for images to be put back into the standard vBulletin user galleries in the future if need be?
Thankyou:up:

Hi

I installed it on vb4.2.2 and there are no errors so far. Couple of Q's

1. Can this option be changed in the lite version? Max Upload Size 24M

2. Can this footer be disabled/edited? It is longer than the vbulletin copyright footer!

Image Gallery provided by DragonByte Gallery v1.2.8 (Lite) -
vBulletin Mods & Addons Copyright © 2013 DragonByte Technologies Ltd.

I have selected yes to "(Lite) Disable "Runs best on HiVelocity Hosting" Link" but it still appears.

Thanks

Hi Dylan I've installed it but i can't seem to locate the gallery url.

Also it is causing my forum style to break.

Edit: See below.

I really hope future mods doesn't alter tables heavily like this because it locks table and takes around 30 min to import or uninstall for big sites.

I really want to uninstall your mod and now i can't.

Code:

Database error in vBulletin 4.2.1:



Invalid SQL:



                                        SELECT 

                                                gi.*, 

                                                gin.shortname 

                                        FROM dbtech_gallery_images gi 

                                        LEFT JOIN dbtech_gallery_instances gin ON gi.instanceid = gin.instanceid 

                                        LEFT JOIN dbtech_gallery_albums ga ON gi.albumid = ga.albumid 

                                        WHERE 

                                                gi.instanceid IN (1) && 

                                                gi.approved        = 1 && 

                                                gi.deleted        = 0 && 

                                                ((gi.albumid = 0) || ((ga.hidden = 0) && (ga.password = '')) || (gi.userid = 1)) && 

                                                gi.is_flash        = 0 

                                        ORDER BY 

                                                gi.dateline DESC 

                                        LIMIT 

                                                0, 5;



MySQL Error   : Table 'nihonoma_forum.dbtech_gallery_images' doesn't exist

Error Number  : 1146

Request Date  : Friday, November 1st 2013 @ 11:12:14 PM

Error Date    : Friday, November 1st 2013 @ 11:12:14 PM

Uninstalling xml gave me this error ^

Then after i deleted all the files which belongs to this mod, i get a blank page on my site, can't see anything.

Edit: I've re-uploaded the gallery files again but not importing the xml, now i can see the site instead of a blank page but i want to delete the files, i don't want it on my server. I think if i deleted the files again, i will get a blank page.

What should i do ?

I don't want to try install and uninstall the xml product again, it locks my table and takes 30+ min to complete and sometimes it fails, my browser gets disconnected.

_________

I've imported the xml again, but i really want to get rid of this modification, it is causing many issues. These are the entire list of the tables that were created after importing the xml. I presume if i uninstall the product, i will get the same db error again?

http://imagetwist.com/utqjtmizrftc/Capture.PNG.html
https://vborg.vbsupport.ru/external/2013/11/26.jpg

What should i do to install this plugin without issues?

Edit: i've installed the xml twice, and override it and now i see the admin side of it and the gallery url etc.. i guess when the table were locked because it alters many things, it did not finish installing completely. This mod looks very risk if i use it and decided to uninstall it in the future, it would cause many problems when it comes to uninstall.

It took 30 min to import the product, then i had to import it again to complete the entire installation. I have no idea what it will do if i try to uninstall it now. what should i do to completely remove it? I am getting db errors like these too

Code:

Database error in vBulletin 4.2.1:



Invalid SQL:



    UPDATE

        dbtech_gallery_images

    SET

        username    = ''

    WHERE

        userid    = 785326;



MySQL Error   : Table 'nihonoma_forum.dbtech_gallery_images' doesn't exist

Error Number  : 1146

Request Date  : Saturday, November 2nd 2013 @ 12:26:10 AM

Error Date    : Saturday, November 2nd 2013 @ 12:26:10 AM

Script        : http://forum.nihonomaru.com/private.php?do=showpm&pmid=704512Referrer      : http://forum.nihonomaru.com/private.php

IP Address    : 

Username      : Sun Seto

Classname     : vB_Database

MySQL Version :

I am trying again to uninstall the xml and i receive timeout. It takes around 30+ min to finish and when it happens, i guess because of the time out the product doesn't completely get uninstalled, what should i do ? This is a very heavy mod for big sites and does alter many tables.

After uninstall the xml, i get this db error on my site. I want to safely get rid of it completely.

I also see DBtech admin side in my admin cp, it is not gone but all the links to the dbtech admin cp would give DB errors.

Code:

Database error in vBulletin 4.2.1:



Invalid SQL:



                SELECT phrasegroup_dbtech_gallery AS dbtech_gallery

                FROM language

                WHERE languageid = 1;



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

Error Number  : 1054

Request Date  : Saturday, November 2nd 2013 @ 08:13:39 AM

Error Date    : Saturday, November 2nd 2013 @ 08:13:39 AM

Script        : http://forum.nihonomaru.com/

Hi, this is what i did after exchanging emails with Fillip (:

Quote:

After you have uninstalled the product, does the product still appear in the list of products?

If not, try opening another plugin and saving it with no changes made.

Regards,

Fillip Hannisdal
Founder & Programming Director
DragonByte Technologies Ltd http://www.DragonByte-Tech.com

Quote:

Hi Filip,

No the product is not there but i see the DBtech gallery in my admin cp on the left side but all do lead to db errors. This is what is happning now after i uninstalled the xml which took like 30+ min and the browser did time out https://vborg.vbsupport.ru/showpost....&postcount=546

Hmm i think now the issue is gone?

What i did is that i enabled one of my disabled mods, and the templates rebuilt, and the DBtech admin side was gone now, i enabled hook again and now i don't see any db errors and deleted the gallery files.
Is this ok now? So nothing related to DBtech gallery is on tables or the server ?

I can access my site now though without db errors, and hook is enable but i have no idea if something hidden here or there.

Thanks.

The crux of the issue was that after uninstall, the plugin cache had not been rebuilt by vB, and editing/saving a random other plugin rebuilt the cache and sorted the issue :)

Fillip

I do not show the gallery's link in the navbar. I let user go to the gallery through a link. (abc.com/bbs/dbtgallery.php?gal=qc)

The question is how to add the following menu into dbtech_gallery_home. Data like {vb:raw instance.shortname} & {vb:raw instance.navbar_title} are empty. How to register them?

Code:

<a class="navtab" href="{vb:raw file_link}?gal={vb:raw instance.shortname}">{vb:raw instance.navbar_title}</a>

        <ul class="floatcontainer">

                <li><a href="{vb:raw file_link}?do=main&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_main}">{vb:rawphrase dbtech_gallery_nav_main}</a></li>



                <vb:if condition="$instance[user_can_add_cat11]">

                <li><a href="{vb:raw file_link}?do=add_category&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_add_category}">{vb:rawphrase dbtech_gallery_nav_add_category}</a></li>

                </vb:if>



                <vb:if condition="$instance[user_can_add_album]">

                <li><a href="{vb:raw file_link}?do=add_album&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_add_album}">{vb:rawphrase dbtech_gallery_nav_add_album}</a></li>

                </vb:if>



                <vb:if condition="$instance[user_can_upload]">

                <li><a href="{vb:raw file_link}?do=add_image&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_upload}">{vb:rawphrase dbtech_gallery_nav_upload}</a></li>



                <li><a href="{vb:raw file_link}?do=profile&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_my_profile}">{vb:rawphrase dbtech_gallery_nav_my_profile}</a></li>



                <li><a href="{vb:raw file_link}?do=add_prof_image&amp;gal={vb:raw instance.shortname}" title="{vb:rawphrase dbtech_gallery_nav_add_prof_img}">{vb:rawphrase dbtech_gallery_nav_add_prof_img}</a></li>

                </vb:if>

        </ul>

The reason I do this is because if I do not show the gallery's link in the navbar, I can not find out how to let user add album and images.

I noticed all my forum's link is changed after installing the add-on. Is it normal?

before it is:
/bbs/forumdisplay.php?8

now it is:
/bbs/forumdisplay.php?8#.UoKDxfmbO2U

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)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 (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01691 seconds Memory Usage 1,769KB 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 (4)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 (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
Messages: