vBug Tracker 1.0.3

You asked for it and here it is...a bug tracker that mimics the one at vBulletin.com.
There is no upgrade yet from the other bug trackers listed on this site but if enough people request it I will add it to the installer.

Also, please DO NOT request help, assistance or ask questions via IM as I will ignore you and if your persistent will block you. Your best option for immediate support is at vbwar.com but I will check in here from time to time.

Enjoy!

Please click install if you use this hack. Support is only given to those who click. Thx!

Version 1.0.1:
Fixed missing phrase (here)
Fixed redirect to blank page after edit bug
Fixed assigned to not working after bug edit

Version 1.0.2:
Finally fixed the dropped title and missing phrases.
Plus a few other small bugs you people didn't catch.

New bug found...file updated. Users of version 1.0.2 need to perform these steps found here.

Version 1.0.3:
Fixed all tableprefixes and a small bug. Tested in both tableprefixed db and no tableprefix db...

Pro Version can be seen here!

Additional support can be found here.

[FASherman]

Don't throw the baby out with the bathwater. I like what I've seen on the author's site and this is a very fixable problem. Not only that, it should be all in the released code. It'll have no bearing on the code hacks.

I bet he could have this fixed today. If not, I'm sure I could. Its really nothing more than adding " . TABLE_PREFIX . " everyplace that a VB table is referenced without a prefix.

[FASherman]

It wasn't even that hard!

FIND:
LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)

REPLACE WITH:
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)

(Occurs twice)

[zendiver]

What file are you saying to fix this in? Also, you re-wrote the install. Care to make an update to this hack so I don't have to go through everything that I have gone through last night, again?

[FASherman]

Its generally considered bad form to release someone else's software, so out of respect for Dark Wizard, I'll simply post my changes.

In admincp/vbugs_install.php

FIND:

PHP Code:

$DB_site->query("INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:"status";a:12:{i:1;a:2:{s:10:"statusname";s:11:"Unconfirmed";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:10:"statusname";s:9:"Confirmed";s:12:"displayorder";s:1:"2";}i:3;a:2:{s:10:"statusname";s:14:"Closed (Fixed)";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:10:"statusname";s:9:"Duplicate";s:12:"displayorder";s:1:"4";}i:5;a:2:{s:10:"statusname";s:17:"Awaiting Feedback";s:12:"displayorder";s:1:"5";}i:6;a:2:{s:10:"statusname";s:5:"Bogus";s:12:"displayorder";s:1:"6";}i:7;a:2:{s:10:"statusname";s:20:"Closed (No Response)";s:12:"displayorder";s:1:"7";}i:8;a:2:{s:10:"statusname";s:19:"Working As Designed";s:12:"displayorder";s:1:"8";}i:9;a:2:{s:10:"statusname";s:17:"Browser Bug/Issue";s:12:"displayorder";s:1:"9";}i:10;a:2:{s:10:"statusname";s:9:"Won\'t Fix";s:12:"displayorder";s:2:"10";}i:11;a:2:{s:10:"statusname";s:12:"Design Issue";s:12:"displayorder";s:2:"11";}i:12;a:2:{s:10:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severity";a:4:{i:1;a:2:{s:12:"severityname";s:7:"Trivial";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:12:"severityname";s:5:"Minor";s:12:"displayorder";s:1:"2";}i:3;a:2:{s:12:"severityname";s:5:"Major";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:12:"severityname";s:8:"Critical";s:12:"displayorder";s:1:"4";}}s:4:"type";a:12:{i:1;a:2:{s:8:"typename";s:3:"Bug";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:8:"typename";s:4:"ToDo";s:12:"displayorder";s:1:"2";}i:11;a:2:{s:8:"typename";s:15:"Feature-Request";s:12:"displayorder";s:1:"3";}i:12;a:2:{s:8:"typename";s:8:"Admin CP";s:12:"displayorder";s:1:"4";}i:13;a:2:{s:8:"typename";s:28:"Integration (Calendar/Forum)";s:12:"displayorder";s:1:"5";}i:14;a:2:{s:8:"typename";s:20:"Installation/Upgrade";s:12:"displayorder";s:1:"6";}i:15;a:2:{s:8:"typename";s:17:"Language/Phrasing";s:12:"displayorder";s:1:"7";}i:16;a:2:{s:8:"typename";s:9:"Templates";s:12:"displayorder";s:1:"8";}i:17;a:2:{s:8:"typename";s:9:"Leader CP";s:12:"displayorder";s:1:"9";}i:18;a:2:{s:8:"typename";s:15:"General/Unknown";s:12:"displayorder";s:2:"10";}i:19;a:2:{s:8:"typename";s:5:"Email";s:12:"displayorder";s:2:"11";}i:20;a:2:{s:8:"typename";s:10:"Suggestion";s:12:"displayorder";s:2:"12";}}s:7:"version";a:1:{i:1;a:2:{s:11:"versionname";s:4:"Test";s:12:"displayorder";s:1:"1";}}}')"); 


REPLACE WITH:

PHP Code:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('bugcache', 'a:4:{s:6:"status";a:12:{i:1;a:2:{s:10:"statusname";s:11:"Unconfirmed";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:10:"statusname";s:9:"Confirmed";s:12:"displayorder";s:1:"2";}i:3;a:2:{s:10:"statusname";s:14:"Closed (Fixed)";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:10:"statusname";s:9:"Duplicate";s:12:"displayorder";s:1:"4";}i:5;a:2:{s:10:"statusname";s:17:"Awaiting Feedback";s:12:"displayorder";s:1:"5";}i:6;a:2:{s:10:"statusname";s:5:"Bogus";s:12:"displayorder";s:1:"6";}i:7;a:2:{s:10:"statusname";s:20:"Closed (No Response)";s:12:"displayorder";s:1:"7";}i:8;a:2:{s:10:"statusname";s:19:"Working As Designed";s:12:"displayorder";s:1:"8";}i:9;a:2:{s:10:"statusname";s:17:"Browser Bug/Issue";s:12:"displayorder";s:1:"9";}i:10;a:2:{s:10:"statusname";s:9:"Won\'t Fix";s:12:"displayorder";s:2:"10";}i:11;a:2:{s:10:"statusname";s:12:"Design Issue";s:12:"displayorder";s:2:"11";}i:12;a:2:{s:10:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severity";a:4:{i:1;a:2:{s:12:"severityname";s:7:"Trivial";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:12:"severityname";s:5:"Minor";s:12:"displayorder";s:1:"2";}i:3;a:2:{s:12:"severityname";s:5:"Major";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:12:"severityname";s:8:"Critical";s:12:"displayorder";s:1:"4";}}s:4:"type";a:12:{i:1;a:2:{s:8:"typename";s:3:"Bug";s:12:"displayorder";s:1:"1";}i:2;a:2:{s:8:"typename";s:4:"ToDo";s:12:"displayorder";s:1:"2";}i:11;a:2:{s:8:"typename";s:15:"Feature-Request";s:12:"displayorder";s:1:"3";}i:12;a:2:{s:8:"typename";s:8:"Admin CP";s:12:"displayorder";s:1:"4";}i:13;a:2:{s:8:"typename";s:28:"Integration (Calendar/Forum)";s:12:"displayorder";s:1:"5";}i:14;a:2:{s:8:"typename";s:20:"Installation/Upgrade";s:12:"displayorder";s:1:"6";}i:15;a:2:{s:8:"typename";s:17:"Language/Phrasing";s:12:"displayorder";s:1:"7";}i:16;a:2:{s:8:"typename";s:9:"Templates";s:12:"displayorder";s:1:"8";}i:17;a:2:{s:8:"typename";s:9:"Leader CP";s:12:"displayorder";s:1:"9";}i:18;a:2:{s:8:"typename";s:15:"General/Unknown";s:12:"displayorder";s:2:"10";}i:19;a:2:{s:8:"typename";s:5:"Email";s:12:"displayorder";s:2:"11";}i:20;a:2:{s:8:"typename";s:10:"Suggestion";s:12:"displayorder";s:2:"12";}}s:7:"version";a:1:{i:1;a:2:{s:11:"versionname";s:4:"Test";s:12:"displayorder";s:1:"1";}}}')"); 


FIND:

PHP Code:

$DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:"1.0.2"')"); 


REPLACE WITH:

PHP Code:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:"1.0.2"')"); 


SAVE admincp/vbug_install.php

EDIT /vbugs.php

FIND BOTH INSTANCES (There are two) OF:

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid) 


AND REPLACE WITH

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid) 


SAVE vbugs.php

This fixed it for me and I like the results.

[zendiver]

Thanks bro...I will give it another shot. GOD I hope this works as I really don't want to re-do my database again. There has got to be another way of restoring your database besides using phpMyAdmin. If the db is over a mb, then you have to break it down or it times out. arghhhh..

Wish me luck.

Again, thanks for helping with this as this is an awesome hack if I can get it to work.

[Andreas]

Hmm, at least the tables and templates look quite similar to my old vBBugs for which I never had time to continue developement?

[zendiver]

WORKS AWESOME BRO...thanks.

[zendiver]

One thing bro, now that I am in the AdminCP, there are a number of new, left hand column, options to choose from.

vBug Bugs
vBug Status
vBug Severities
vBug Versions
vBug Types

The only one that I am having a problem with is the first one, vBug Bugs. If you click on 'Add', it gives a database error that looks like this: (seems there is another table missing)

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT typename, vbug_typeid FROM vb3_vbug_type ORDER BY displayorder
mysql error: Table 'divingan_vboard.vb3_vbug_type' doesn't exist

mysql error number: 1146

[FASherman]

Originally Posted by zendiver

Thanks bro...I will give it another shot. GOD I hope this works as I really don't want to re-do my database again. There has got to be another way of restoring your database besides using phpMyAdmin. If the db is over a mb, then you have to break it down or it times out. arghhhh..

Wish me luck.

Again, thanks for helping with this as this is an awesome hack if I can get it to work.

I hear you. I use Navicat 2004 instead. Far more powerful, much faster response, but it isn't free.

Still, with all I've spent on my website, it doesn't make sense to quibble over $85 for something that helps guarantee I can always fix my server quickly.

[FASherman]

Yeah, the admin functions appear to be way screwed up. TABLE_PREFIX is used where it shouldn't be and forgotten where it should be. Its like peeling an onion, layer after layer breaks.

I've got it about half worked out.

I wouldn't recommend anyone who has their VB tables prefixed to install this just yet. This shouldn't be a release. Since the testing was incomplete, its still basically a beta.