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.

[Natch]

Visit vbwar.com

[linuxgurugamer]

I just installed vbug on my system. Looks nice, but I ran into a problem with the vbug_install.php.

I have a table prefix for all my tables. In vbug_install.php, there are several references to the datastore table without the table prefix. This causes the install to fail if there is a table prefix.

Let me know if you want a fixed version of it.

Also, I see that you don't use the table prefix for the vbug tables. I think you should, otherwise it would be very difficult to run more than one forum on a single system.


JBB

[theArchitect]

I am having a problem with user group preferences.

When I scroll down to the section in the user group manager for the bug tracker and change the preferences the system is not remembering these preferences. As a result my Registered Users have the power to administer bugs.

Any thoughts.

[Natch]

I would recommend in thi sinstance (until the author comes back from a cruise ) that you backup your bug and comments tables, then uninstall and reinstall the script...

[Zachariah]

Mr. Wizard - nice dude.

Found some stuff: ver. - 1.02 (11.25.04 download)

1) Edit Bug template in AdminCP - missing phrase (Bug Version)
2) vbugs_footer (1) - 1 queries for uncached templates

[The Wise One]

real nice hack. been looking for something like this for quite awhile.

i am xperiencing a couple of problems...

when viewing vbugs.php? in the browser, i enter a text search term in the "Enter a bug ID or terms to search for:" box and get an error. i know the exact search term exists in one of the bug posts.

this is the error:

Database error in vBulletin 3.0.3:

Invalid SQL: 
	SELECT DISTINCT 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 user AS admin ON (vbugs.adminid = admin.userid)
	LEFT JOIN user ON (vbugs.userid = user.userid)
	LEFT JOIN 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 1 AND MATCH (title, description) LIKE '%search error%' 
	ORDER BY lastedit desc
	LIMIT 0, 15
	
mysql error: You have an error in your SQL syntax near 'LIKE '%search error%' 
	ORDER BY lastedit desc
	LIMIT 0, 15
	' at line 12

mysql error number: 1064

Date: Thursday 25th of November 2004 02:33:21 PM
Script: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=search+error
Referer: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=
Username: The Wise One
IP Address: *********

i get the same error if i use the EXACT title of a bug...word for word. searching using the options below the bug list works fine except if i try to use the field to enter text to search by.

also...even tho i (and others) have ticked the subscribed box...email notifies dont function when someone replies.

what i think would be great to add to this would be a way to edit the content of individual posts in the tracker.

any ideas?

[Zachariah]

Same for me Wise One.

I did a little adminCP/index.php menu edit also.

1 dropdown menu vs. 5
- To me having 5 dropdowns vs. 1 is a waste of space.

// vBug Tracker
// *************************************************

if ($permissions['vbugpermissions'] & CANADMINBUGS)
{
   if ($printhr == true)
   {
     construct_nav_spacer();
   }
  construct_nav_option("Add","vbugs_admin.php?do=add");
  construct_nav_option("Modify","vbugs_admin.php?do=modify");
  construct_nav_option("Moderate","vbugs_admin.php?do=moderate");
  construct_nav_option("<b><u>vBug Status</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addstatus");
  construct_nav_option("Modify","vbugs_admin.php?do=modifystatus");
  construct_nav_option("<b><u>vBug Severities</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addseverity");
  construct_nav_option("Modify","vbugs_admin.php?do=modifyseverity");
  construct_nav_option("<b><u>vBug Versions</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addversion");
  construct_nav_option("Modify","vbugs_admin.php?do=modifyversion");
  construct_nav_option("<b><u>vBug Types</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addtype");
  construct_nav_option("Modify","vbugs_admin.php?do=modifytype");
  construct_nav_group("vBug Bugs");
	if ($printhr == true)
   {
     construct_nav_spacer();
   }
}
// vBug Tracker

[The Wise One]

nice. much cleaner. thanks!

[peterska2]

OK open to ideas

Warning: Invalid argument supplied for foreach() in 
/path to/vbugs.php on line 104

Warning: Invalid argument supplied for foreach() in 
/path to/vbugs.php on line 109

Warning: Invalid argument supplied for foreach() in 
/path to/vbugs.php on line 114

Warning: Invalid argument supplied for foreach() in 
/path to/vbugs.php on line 119

Theres a table prefix which was a bugger to work around with this but I got there in the end. I need this fixing tonight though

[peterska2]

anyone?????

I'm getting stressed about this as I just can't get a workaround going.