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]

Okay, I've got it all worked out.

Edit includes/adminfunctions_vbugs.php

FIND

PHP Code:

    $result = $DB_site->query("SELECT $idfield, $titlefield FROM $tablename $filter ORDER BY $order"); 


REPLACE WITH

PHP Code:

    $result = $DB_site->query("SELECT $idfield, $titlefield FROM " . TABLE_PREFIX . "$tablename $filter ORDER BY $order"); 


FIND

PHP Code:

                $result = $DB_site->query("SELECT statusname, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY displayorder"); 


REPLACE WITH

PHP Code:

               $result = $DB_site->query("SELECT statusname, $tableid FROM $tablename $wherecondition ORDER BY displayorder"); 


FIND

PHP Code:

                $result = $DB_site->query("SELECT typename, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY displayorder"); 


REPLACE WITH

PHP Code:

                $result = $DB_site->query("SELECT typename, $tableid FROM $tablename $wherecondition ORDER BY displayorder"); 


FIND

PHP Code:

                $result = $DB_site->query("SELECT severityname, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY displayorder"); 


REPLACE WITH

PHP Code:

                $result = $DB_site->query("SELECT severityname, $tableid FROM $tablename $wherecondition ORDER BY displayorder"); 


FIND

PHP Code:

                $result = $DB_site->query("SELECT versionname, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY displayorder"); 


REPLACE WITH

PHP Code:

                $result = $DB_site->query("SELECT versionname, $tableid FROM $tablename $wherecondition ORDER BY displayorder"); 


And finally, add a new phrase:
VARNAME = vbugs_bug_version
TEXT = Bug Version

Hopefully everything should work now.

[zendiver]

FASherman,

You are daMan....it works, looks, and feels awesome bro....^5. GREAT JOB. DW should think about hiring you.

Awesome work man, simply awesome. I hope I can return a favor to you someday soon.

[zendiver]

Well, brother, we still arn't out of the woods yet. If you add a bug, either through the AdminCP or in the forums, everything seems to work fine until you click on it to read it. Then a HUGE big db error occurs:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN vb3_user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN vb3_user AS user ON (vbugs.userid = user.userid
LEFT JOIN vb3_user AS lastreply ON (vbugs.lastreplyuid = lastreply.userid)
LEFT JOIN vbug_type ON (vbugs.vbug_typeid = vbug_type.vbug_typeid)
LEFT JOIN vbug_version ON (vbugs.vbug_versionid = vbug_version.vbug_versionid)
LEFT JOIN vbug_severity ON (vbugs.vbug_severityid = vbug_severity.vbug_severityid)
WHERE vbugs_id = 2

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN vb3_user AS lastreply ON (vbugs.lastreplyuid = lastre

mysql error number: 1064

[FASherman]

Originally Posted by FASherman

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.

This one is your typo, my friend. In one of those two replacements, you left off the ")" at the end of the line.

Search vbugs.php for

PHP Code:

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


And add ")" to the end of the one that doesn't have it.

[zendiver]

(hangs head and apologizes for his stupidity) You were right on the money. Working so far....so good.

[theArchitect]

I am getting:

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

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissionssection of the control panel."

When I try to Admin things. And if I just go to vbugs.php I get:

"you do not have permission to access this page. This could be due to one of several reasons:"

I have obviously got something wrong. Any thoughts as to what?

[Natch]

You need to set permissions on the ModCP/User's page

[theArchitect]

Originally Posted by Natch

You need to set permissions on the ModCP/User's page

Even if I am a Super Administrator?

I check the permissions for Administrators and Yes is ticked for Can Administer, Can Add and Can View.

[Natch]

Yes.

[theArchitect]

Thanks. It is working fine now.

BTW, what is the Pro version and how can one get hold of it?