PDA

View Full Version : Add-On Releases - vBug Tracker Lite


Dark_Wizard
02-14-2010, 10:00 PM
I'm back again and with an updated version of vBug Tracker. This add-on if you are not familiar with it is a mimic of the one used back a while ago on vbulletin.com. This is currently in beta just to make sure I caught all the bugs.

There is no upgrade yet from version 3.7 but I am working on it.

There will be a Pro version coming soon but will not be posted here and will contain many features and enhancements.

Support is only provided to those who click install! Finally, if you really like this addon please nominate this for MOTM.

Thanks and enjoy!

I have removed this from the Beta stage and consider this stable.

4.0.1 Release:

* Fixed a query problem with table prefixes.
* Fixed/Added phrase issues.
* Fixed group by issue.
* Added permissions to the navtab so that users who cannot view bugs won't see the tab.


To upgrade all you need to do is "Import Product" and select "Allow Overwrite" then upload all the files overwriting the older ones.

Dark_Wizard
02-15-2010, 08:04 PM
Screenshot...

shadowgfx
02-15-2010, 09:33 PM
So uhm, what exactly does this do?

woffie
02-15-2010, 09:41 PM
Isnt project going to be released here?

Spikeman
02-15-2010, 09:56 PM
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT count(*) AS status, vbug.*
FROM vbvbug
WHERE vbug_statusid = 1;

MySQL Error : Unknown table 'vbug'
Error Number : 1051
Request Date : Monday, February 15th 2010 @ 11:54:02 PM
Error Date : Monday, February 15th 2010 @ 11:54:02 PM
Script : http://www.****************/vbugs.php
Referrer :
IP Address :
Username : ****
Classname : vB_Database_MySQLi
MySQL Version : 5.0.68-percona-3-log



This did not impress me

Storyteller69
02-15-2010, 09:59 PM
First of all many thanks! Looks really good.

I have one problem so far: After installing I have a { at the top of the page (above the header). Any idea what this can be?

Dark_Wizard
02-15-2010, 10:01 PM
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT count(*) AS status, vbug.*
FROM vbvbug
WHERE vbug_statusid = 1;

MySQL Error : Unknown table 'vbug'
Error Number : 1051
Request Date : Monday, February 15th 2010 @ 11:54:02 PM
Error Date : Monday, February 15th 2010 @ 11:54:02 PM
Script : http://www.****************/vbugs.php
Referrer :
IP Address :
Username : ****
Classname : vB_Database_MySQLi
MySQL Version : 5.0.68-percona-3-log



This did not impress me

I cannot reproduce that error. I tried to register on your site to check it out and I get this error upon submitting my registration info:

Parse error: syntax error, unexpected T_VARIABLE, expecting ';' in /websites/**************/beta-tester.co.uk/public_html/iphone/fbb/runbox_hook_register_addmember_complete.php on line 5

This did not impress me.... ;)

Dark_Wizard
02-15-2010, 10:04 PM
First of all many thanks! Looks really good.

I have one problem so far: After installing I have a { at the top of the page (above the header). Any idea what this can be?

I don't see this on my site. Can you provide me a link so I can look at it?

Thx,
Bob

Spikeman
02-15-2010, 10:10 PM
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT vbug.*, username, vbug_version.title AS vtitle, vbug_status.title AS stitle, vbug_type.title AS ttitle, vbug_severity.title AS svtitle
FROM vbvbug AS vbug
LEFT JOIN vbuser AS user ON(user.userid = vbug.adminid)
LEFT JOIN vbvbug_version ON(vbug_version.vbug_versionid = vbug.vbug_versionid)
LEFT JOIN vbvbug_status ON(vbug_status.vbug_statusid = vbug.vbug_statusid)
LEFT JOIN vbvbug_type ON(vbug_type.vbug_typeid = vbug.vbug_typeid)
LEFT JOIN vbvbug_severity ON(vbug_severity.vbug_severityid = vbug.vbug_severityid)
ORDER BY vbug.postdate DESC
LIMIT 0, 15;

MySQL Error : Unknown column 'vbug_version.title' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 16th 2010 @ 12:07:31 AM
Error Date : Tuesday, February 16th 2010 @ 12:07:31 AM
Script : http://www.**************admincp/vbugs_admin.php?do=modify
Referrer : http://www.**************/admincp/index.php?do=nav
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.68-percona-3-log

This is the error I get from acp side

When you tried to register on my site did you use facebook connect?

Storyteller69
02-15-2010, 10:11 PM
I send you a PM because it's a Testforum behind htaccess.

Dark_Wizard
02-15-2010, 10:20 PM
I send you a PM because it's a Testforum behind htaccess.

Fixed!

Dark_Wizard
02-15-2010, 10:20 PM
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT vbug.*, username, vbug_version.title AS vtitle, vbug_status.title AS stitle, vbug_type.title AS ttitle, vbug_severity.title AS svtitle
FROM vbvbug AS vbug
LEFT JOIN vbuser AS user ON(user.userid = vbug.adminid)
LEFT JOIN vbvbug_version ON(vbug_version.vbug_versionid = vbug.vbug_versionid)
LEFT JOIN vbvbug_status ON(vbug_status.vbug_statusid = vbug.vbug_statusid)
LEFT JOIN vbvbug_type ON(vbug_type.vbug_typeid = vbug.vbug_typeid)
LEFT JOIN vbvbug_severity ON(vbug_severity.vbug_severityid = vbug.vbug_severityid)
ORDER BY vbug.postdate DESC
LIMIT 0, 15;

MySQL Error : Unknown column 'vbug_version.title' in 'field list'
Error Number : 1054
Request Date : Tuesday, February 16th 2010 @ 12:07:31 AM
Error Date : Tuesday, February 16th 2010 @ 12:07:31 AM
Script : http://www.**************admincp/vbugs_admin.php?do=modify
Referrer : http://www.**************/admincp/index.php?do=nav
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.68-percona-3-log

This is the error I get from acp side

When you tried to register on my site did you use facebook connect?

No facebook just standard vb register. That error cannot be reproduced. I was just on Storyteller69's site and he has no issues. Uninstall and install again and select "Allow Overwrite" and let me know if you have the issues still.

Storyteller69
02-15-2010, 10:24 PM
Fixed!Many thanks! :up:

Spikeman
02-15-2010, 10:30 PM
This is an error i found in db = The following indexes appear to be equal and one of them should be removed: PRIMARY, id - This is in the table vbug

Spikeman
02-15-2010, 10:38 PM
Uninstall and install again and select "Allow Overwrite" and let me know if you have the issues still.

Yep, done that but still errors

Dark_Wizard
02-15-2010, 10:40 PM
This is an error i found in db = The following indexes appear to be equal and one of them should be removed: PRIMARY, id - This is in the table vbug

Look at my xml file...nothing exists except the primary and unique keys...

Dark_Wizard
02-15-2010, 10:42 PM
Yep, done that but still errors

I am registered on your site. allow me access to view the admincp with query rights and I will fix it very quickly...

Spikeman
02-15-2010, 10:46 PM
I am registered on your site. allow me access to view the admincp with query rights and I will fix it very quickly...

You should have full access rights now

Dark_Wizard
02-15-2010, 10:52 PM
You should have full access rights now

I don't have sql query access...add my userid in your includes/config.php file

Spikeman
02-15-2010, 10:59 PM
I don't have sql query access...add my userid in your includes/config.php file

Yep thats done

Dark_Wizard
02-15-2010, 11:07 PM
Yep thats done

Something is strange for sure as the table prefix doesn't work for you on that specific table. Can you provide me phpMyAdmin access? PM me if you will...

Thx,
Bob

Dark_Wizard
02-15-2010, 11:49 PM
Spikeman,

Check your PM's...

Bob

Spikeman
02-16-2010, 12:00 AM
Spikeman,

Check your PM's...

Bob

Yep done it, Well the Dark Wizard did weave his magic and all is now working perfect, this is a critical mod for my site and as a result of the support Bob has just given me and this mod I shall without a doubt be going for the Pro version.. Thanks Bob

5*
Installed

Spikeman
02-16-2010, 09:48 AM
Can I request that the Bug Tracker nav tab be viewable by usergroup? Right now I have setup permissions for only one usergroup to have access to the Bug Tracker however all users can se the tab in the navbar, I just want to declutter the navbar and stop users getting the message - You do not have permission to access this area.

thanks in advance.

Dark_Wizard
02-16-2010, 11:51 AM
Can I request that the Bug Tracker nav tab be viewable by usergroup? Right now I have setup permissions for only one usergroup to have access to the Bug Tracker however all users can se the tab in the navbar, I just want to declutter the navbar and stop users getting the message - You do not have permission to access this area.

thanks in advance.

No problem. You need to go into "Plugin Manager" and edit the "vBug Tracker Nav Tab" and replace the code with this:


if ($vbulletin->userinfo['permissions']['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canviewbugs'])
{
$tabselected = '';
$tablinks = '';

if (THIS_SCRIPT == 'vbugs')
{
$vbulletin->options['selectednavtab']='vBug';
$tabselected = ' class="selected"';
$tablinks = ' <ul class="floatcontainer">
<li><a href="vbugs.php?do=new">Submit Bug</a></li>
<li><a href="vbugs.php">View Bugs</a></li>
</ul> ';
}

$template_hook['navtab_end'] .= '<li'.$tabselected.'><a class="navtab" href="vbugs.php">vBug Tracker</a>'.$tablinks.'</li>';
}


Bob

Spikeman
02-16-2010, 11:57 AM
Thanks for the quick response, works great, thanks Bob

Dark_Wizard
02-16-2010, 12:13 PM
Thanks for the quick response, works great, thanks Bob

Your welcome. There is an update coming soon as I did find a few minor bugs i.e. missing phrases...and also the code above isn't phrased either.

Bob

Cadellin
02-16-2010, 12:17 PM
It's great to see you've done a vB 4 version Dark Wizard - I was a great fan of your previous releases. I look forward to installing it later today.

We use bug tracking a lot so a well supported premium mod would be something we might be interested in provided it wasn't excessively expensive and it had free patches/updates ;)

Dark_Wizard
02-16-2010, 12:32 PM
It's great to see you've done a vB 4 version Dark Wizard - I was a great fan of your previous releases. I look forward to installing it later today.

We use bug tracking a lot so a well supported premium mod would be something we might be interested in provided it wasn't excessively expensive and it had free patches/updates ;)

It won't be expensive and never has been plus updates have been free as well.

balu84
02-16-2010, 02:06 PM
When you call up the page in the forum, I have the following errors:
Datenbankfehler in vBulletin 4.0.1:

Invalid SQL:

SELECT count(*) AS status, vbug.*
FROM vbug AS vbug
WHERE vbug_statusid = 1;

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Tuesday, 16.02.2010 @ 16:36:45
Datum : Tuesday, 16.02.2010 @ 16:36:46
Skript : http://************/web/vbugs.php
Referrer : http://***********/web/forum.php
IP-Adresse : *******
Benutzername : ****
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2+spu1


edit:
i took in $statuscount = $db->query_first("
SELECT count(*) AS status, vbug.*
FROM " . TABLE_PREFIX . "vbug AS vbug
WHERE vbug_statusid = $key
$perms GROUP BY lastedit
");



after this it works without errors
but i dont know if it is correct this way

Dark_Wizard
02-16-2010, 03:49 PM
When you call up the page in the forum, I have the following errors:
Datenbankfehler in vBulletin 4.0.1:

Invalid SQL:

SELECT count(*) AS status, vbug.*
FROM vbug AS vbug
WHERE vbug_statusid = 1;

MySQL-Fehler : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Fehler-Nr. : 1140
Fehler-Zeit : Tuesday, 16.02.2010 @ 16:36:45
Datum : Tuesday, 16.02.2010 @ 16:36:46
Skript : http://************/web/vbugs.php
Referrer : http://***********/web/forum.php
IP-Adresse : *******
Benutzername : ****
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2+spu1

I just fixed that but have just a few more bugs to fix then I will update the file and post instructions on upgrading.

balu84
02-16-2010, 04:15 PM
thanks good work. I've long been waiting for a plug in now. I can soon switch to VB4

Dark_Wizard
02-16-2010, 07:13 PM
Version update released. Please read the upgrade instructions.

Bob

Cadellin
02-17-2010, 10:15 PM
Would it be possible for you to tell me what php I need to add to vbugs.php to be able to view the status id in the template? I can't work out how to create $bug['statusid'] but the rest after that I can handle.

Thanks

Dark_Wizard
02-18-2010, 12:52 AM
Would it be possible for you to tell me what php I need to add to vbugs.php to be able to view the status id in the template? I can't work out how to create $bug['statusid'] but the rest after that I can handle.

Thanks

You don't need to add anything, the $bug variable is already registered in the template. Also it is $bug['vbug_statusid'].

Storyteller69
02-18-2010, 09:12 AM
I have some little Style issues with vB 4.0.2. Will there be a fix for this?

sKippah
02-18-2010, 09:36 AM
Is everybody goin with his addon to PRO Version now... A Shame

Dark_Wizard
02-18-2010, 02:19 PM
I have some little Style issues with vB 4.0.2. Will there be a fix for this?

Can you provide me a link?

Thx,
Bob

Dark_Wizard
02-18-2010, 02:20 PM
Is everybody goin with his addon to PRO Version now... A Shame

A shame????

Storyteller69
02-18-2010, 02:30 PM
It has something to do with the vB-Style/Language-Option CSS-Stylesheets store as files. If it's set to Yes all is fine but when it's set to No there are some smaller issues.
Send you Link via PM.

Leo Brazil
02-18-2010, 04:30 PM
I'm gonna test this if I can use it for what I need.

By the way, have you thought about changing this mod to make it as a "report system" and not a bug tracker ? You know, every reported item in you board, like posts, blogs, whatever, could let a entry on the system and be discussed by moderators after closed it. You know, just an idea that probably lots of people could use it too.

Dark_Wizard
02-18-2010, 10:43 PM
It has something to do with the vB-Style/Language-Option CSS-Stylesheets store as files. If it's set to Yes all is fine but when it's set to No there are some smaller issues.
Send you Link via PM.

Ok, I see it, your missing the column colors. I will look into it and get back with a fix. Been heavily involved in the Pro version, sorry for the delay.

Bob

dtommy79
02-22-2010, 07:12 PM
Does it work with vb 4.0.2? A lot of plugins were affected by the latest css changes.

OPsNaStYM0FO
02-26-2010, 12:29 PM
I'm using it with 4.02 and have no problems with it .

cardealercheck
03-03-2010, 01:04 AM
Okay I know I must be doing something stupid but when I click on any of the left hand side admin links for Vbug Tracker I get

Sorry, you don't have permission to access the administrative controls on this page.

I read and re-read the install and I just must be missing something. I do not see an option to give access permission to myself in Administrator Permissions.

Vbulletin version 4.0.2

Any help is appreciated

FIXED

Just reinstalled the XML and it seems to work fine now

owning_y0u
03-03-2010, 07:30 AM
Plugin = Great :) no more people who pm me with this kind of questions :) but..

Looks kind of .. crap if you ask me :P

need to do some recoding on the comment box as its floating on edit.

toonysnn
04-15-2010, 11:56 AM
Okay I know I must be doing something stupid but when I click on any of the left hand side admin links for Vbug Tracker I get



I read and re-read the install and I just must be missing something. I do not see an option to give access permission to myself in Administrator Permissions.

Vbulletin version 4.0.2

Any help is appreciated

FIXED

Just reinstalled the XML and it seems to work fine now
Anyone who receives this issue, just edit a usergroup from the usergroup manager. It'll fix it.

latch
07-15-2010, 10:07 AM
Does this mod work for the latest version of VB? Also, did you release the pro version yet?

Dark_Wizard
07-15-2010, 12:12 PM
It is working with the latest version of vb. Pro is being worked on, no eta yet.

xtremecoders
08-17-2010, 12:40 AM
Installed on VB4.0.6 and after some minor fixes running fine.

Thanks :up:

wierdo124
09-06-2010, 11:50 PM
How to get rid of the tab?

bposner
03-18-2011, 05:13 PM
Hi
Is there a way to send notification to an email address when a bug/issue is reported?
If so I did not find it.
Thanks

mavrick4283
07-05-2011, 01:24 AM
I just installed it and i am getting 404 when i click on the links in the admincp i dubble checked and all the needed files are uploaded correctly. Is there something i am missing?

This is the URL

http://mysite.com/forum/acp/index.php?loc=plugin.php%3Fdo%3Dproduct


Fixed it, My site was not caching it correct :(

BTW great mod tyvm

majsm
07-06-2011, 07:00 AM
I'd like to see a port of this including the GeSHi generic syntax highlighting library http://qbnz.com/highlighter/

HansMuenchen
08-06-2011, 08:22 AM
Hello,

when I try to submit a bug or a comment nothing happened into the frontend. The only way now to submit a bug is to submit it into the admincp.

Does I did something wrong?

Thnx for the help
Hans

Dark_Wizard
08-06-2011, 06:23 PM
Hello,

when I try to submit a bug or a comment nothing happened into the frontend. The only way now to submit a bug is to submit it into the admincp.

Does I did something wrong?

Thnx for the help
Hans

Pm me a link to your site please....

Dark_Wizard
08-06-2011, 06:26 PM
Update coming soon.

laebshade
08-06-2011, 06:44 PM
Tagged. Was using MantisBT to track bugs, but it's too much of a hassle for members to have to sign up with another account just to report issues. They would rather post/PM :rolleyes:

Will come back and get later when it is updated as promised.

mavrick4283
08-09-2011, 07:32 PM
BTW there is a typo in the vbug_edit template your have 2 {{ at the start :) BTW great plugin.

Dark_Wizard
08-09-2011, 07:59 PM
BTW there is a typo in the vbug_edit template your have 2 {{ at the start :) BTW great plugin.

Thanks!

Dark_Wizard
08-12-2011, 06:54 PM
Good news and bad news....

A new version is in the works but there will be no upgrade as I have rewritten this completely. See screenshot below. There is no eta as of yet...but as you can see I have been working on it.

dmm2020
08-13-2011, 03:16 PM
Is there a way to get all bugs checked private by default? I want to avoid premature public release of any security type bugs that are reported. Ideally, I would like it set to private if certain types are set.

Dark_Wizard
08-14-2011, 10:03 AM
Is there a way to get all bugs checked private by default? I want to avoid premature public release of any security type bugs that are reported. Ideally, I would like it set to private if certain types are set.

You could change the default for that column in the database to make it private right off the get go. As for doing it for certain types, that would have to be coded.

bengbeng87
08-18-2011, 08:26 AM
Good news and bad news....

A new version is in the works but there will be no upgrade as I have rewritten this completely. See screenshot below. There is no eta as of yet...but as you can see I have been working on it.

Take your time. This mod served me well in v3.8 cant wait for the update so I can reinstall it.

Dark_Wizard
08-18-2011, 11:48 AM
Well it's coming along nicely. Below is a current screenshot of the new listing page.

https://vborg.vbsupport.ru/external/2011/08/21.jpg

Dark_Wizard
08-21-2011, 02:00 PM
I am going to need beta testers soon. Please respond here. Only the first 10 will get to be beta testers. This is only for previous users!

Also, I would like to see your site with an earlier version running, either post the url here or PM me. The reason for this is in the past the beta testers I had selected some didn't know how to use it nor did they report any bugs.

Bob

bengbeng87
08-21-2011, 02:54 PM
I am going to need beta testers soon. Please respond here. Only the first 10 will get to be beta testers. This is only for previous users!

Bob

Im happy to test it for you. Just let me know what I would need to do.

Dark_Wizard
08-21-2011, 06:58 PM
Im happy to test it for you. Just let me know what I would need to do.

Do you have a version already running?

bengbeng87
08-22-2011, 06:12 AM
Do you have a version already running?

Yes. Not sure if we are meant to post links but I can PM it to you or something if you like.

I am running version 3.7 of vbug lite on 3.8 currently. I am now moving to vb 4.0.

mavrick4283
08-26-2011, 11:34 PM
nvm i like the way i have mine working do not want to change it.

The Rocketeer
11-25-2011, 09:41 AM
So, did this ever get updated ? or abandoned ?

Dark_Wizard
11-25-2011, 12:31 PM
So, did this ever get updated ? or abandoned ?

This will be completed, just ran behind due to new job.

Dispersion
02-13-2013, 01:21 PM
Any word on an update?

Adambean
02-23-2014, 04:46 PM
Are there any screen shots of this mod in action? The mod doesn't describe the features of this mod or how it works, and there don't appear to be any examples.

I'm thinking of possibly using this as a public bug tracker as a lightweight alternative to our main bug tracker, so that we can maintain a status with the public about bugs whilst benefitting from an existing moderation team, lightweight functionality, and use it as a feeder into our primary (and non-public) bug tracker.

Kaminah
01-24-2016, 06:26 AM
Hey Any update to this bud? I actively use this, but it's becoming a lot worse :(, was hoping maybe any info on the new one?

Elixar
02-10-2016, 03:58 PM
I've attached a version with the new XML file that reflects the MYSQL update from TYPE to ENGINE. :)

Elixar
03-11-2016, 05:27 PM
Bump.

MarkFL
03-11-2016, 06:16 PM
Bump.

Why are you bumping this thread? Your post prior to the bump didn't seem to indicate a request for a response...or am I missing something?

Elixar
04-12-2016, 02:15 AM
Why are you bumping this thread? Your post prior to the bump didn't seem to indicate a request for a response...or am I missing something?

You know, I just realized that lol. I meant to ask for an update, but I think I bumped my head lol. :D