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.

[EDDIE!]

Hey, this hack is really cool, but I'm having a bit of a problem. When I try to set the vbug permissions in usergroups I get this error:
Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '<font color=\"darkRed\"><b><u><i>',
closetag = '</i></b></u></font>',
passwordexpires = '180',
passwordhistory = '360',
attachlimit = '0',
avatarmaxwidth = '110',
avatarmaxheight = '110',
avatarmaxsize = '2000000',
profilepicmaxwidth = '120',
profilepicmaxheight = '120',
profilepicmaxsize = '6553500',
pmquota = '200',
pmsendmax = '7',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '3145663',
genericoptions = '31',
vbugpermissions = '7'
WHERE usergroupid=6
mysql error: Unknown column 'vbugpermissions' in 'field list'

mysql error number: 1054

Date: Friday 22nd of October 2004 11:51:39 PM
Script: http://twdforums.com/admincp/usergroup.php
Referer: http://twdforums.com/admincp/usergro...&usergroupid=6
Username: Macajabroni
IP Address: 205.188.116.72

Do you guys know how to help me out?

[Dark_Wizard]

EDDIE...you missed a step editing the admincp/usergroup.php file...please check per the install docs. Once you correct it make sure you set the permissions per usergroup.

[EDDIE!]

I double checked the install document, and I did everything exactly how it told me to. It's still not working.

[EDDIE!]

I'm really sorry Dark, but I manually deleted the tables, and then uninstalled. And now I've tried reinstalling and once I add all the tracker tables, I get yet another error:
Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:"status";a:12:{i:1;a:2:{s:10:"statusname ";s:11:"Unconfirmed";s:12:"dis playorder";s:1:"1";}i:2;a:2:{s:10:"statusname";s:9 :"Confirmed";s:12:"displayorde r";s:1:"2";}i:3;a:2:{s:10:"statusname";s:14:"Close d (Fixed)";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:1 0:"statusname";s:9:"Duplicate" ;s:12:"displayorder";s:1:"4";}i:5;a:2:{s:10:"statu sname";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:"statusna me";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:1 0:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severit y";a:4:{i:1;a:2:{s:12:"severit yname";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:"sever ityname";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:"ty pename";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:"typena me";s:9:"Leader CP";s:12:"displayorder";s:1:"9";}i:18;a:2:{s:8:"ty pename";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:"displ ayorder";s:2:"12";}}s:7:"version";a:1:{i:1;a:2:{s: 11:"versionname";s:4:"Test";s: 12:"displayorder";s:1:"1";}}}')
mysql error: Table 'EDDIE_TWD.datastore' doesn't exist

mysql error number: 1146

Thanks for all your help, I can't wait to get this up for I know it's an amazing hack.

[Natch]

If you have deleted the datastore table, you have really screwed up your vBulletin database: that is a core vB table and should never be deleted.

[EDDIE!]

the problem is that it's still there in my tables, and there's no problems with the site, just installing this hack.

[FASherman]

I just ran across a problem in the install script and it may be a problem throughout the whole program.

The program mistakenly assumes there is a "datastore" table. BAD assumption. There will always be a VBPREFIX_datastore table.

I ran the query

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:10:\"statusn ame\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s :1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confi rmed\";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:\"dis playorder\";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:\"displa yorder\";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:\"s everity\";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:\"dis playorder\";s:1:\"2\";}i:3;a:2:{s:12:\"severitynam e\";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:\"dis playorder\";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:\"disp layorder\";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:\"displayo rder\";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\";}}} ')

manually, but guess what? No way to rerun the install script.

[zendiver]

Eddie and Dark_Wizard,

I got the same DB error that you did, BUT mine was on a fresh install, about the 5th or 6th screen into the installation. I am so glad that I backed up my database before hand as it really FUBARed my site and I had to delete my database tables and import them just to get my site back up and going. Oh that happen about 3am this morning.

Database error in vBulletin 3.0.3:

Invalid SQL: 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:"d isplayorder";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:1 0:"statusname";s:9:"Duplicate";s:12:"displayorder" ;s:1:"4";}i:5;a:2:{s:10:"statusname";s:17:"Awaitin g 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:1 0:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severit y";a:4:{i:1;a:2:{s:12:"severityname";s:7:"Trivial" ;s:12:"displayorder";s:1:"1";}i:2;a:2:{s:12:"sever ityname";s:5:"Minor";s:12:"displayorder";s:1:"2";} i:3;a:2:{s:12:"severityname";s:5:"Major";s:12:"dis playorder";s:1:"3";}i:4;a:2:{s:12:"severityname";s :8:"Critical";s:12:"displayorder";s:1:"4";}}s:4:"t ype";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:"ty pename";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:"ty pename";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:"displa yorder";s:1:"1";}}}')
mysql error: Table 'divingan_vboard.datastore' doesn't exist

mysql error number: 1146

Originally Posted by EDDIE!

I'm really sorry Dark, but I manually deleted the tables, and then uninstalled. And now I've tried reinstalling and once I add all the tracker tables, I get yet another error:
Database error in vBulletin 3.0.3:

Invalid SQL: 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:"d isplayorder";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:1 0:"statusname";s:9:"Duplicate";s:12:"displayorder" ;s:1:"4";}i:5;a:2:{s:10:"statusname";s:17:"Awaitin g 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:1 0:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severit y";a:4:{i:1;a:2:{s:12:"severityname";s:7:"Trivial" ;s:12:"displayorder";s:1:"1";}i:2;a:2:{s:12:"sever ityname";s:5:"Minor";s:12:"displayorder";s:1:"2";} i:3;a:2:{s:12:"severityname";s:5:"Major";s:12:"dis playorder";s:1:"3";}i:4;a:2:{s:12:"severityname";s :8:"Critical";s:12:"displayorder";s:1:"4";}}s:4:"t ype";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:"ty pename";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:"ty pename";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:"displa yorder";s:1:"1";}}}')
mysql error: Table 'EDDIE_TWD.datastore' doesn't exist

mysql error number: 1146

Thanks for all your help, I can't wait to get this up for I know it's an amazing hack.

[FASherman]

I managed to fix the install script, made all the code hacks and got this error on the initial run:

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 vb3_user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN vb3_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 1
ORDER BY lastedit desc
LIMIT 0, 20

mysql error: Unknown table 'user' in field list

mysql error number: 1109

The code appears to not handle tables with a prefix very well. The code really needs to be gone through well before another release.

[zendiver]

Thanks for the update FASherman,

I guess I will just wait for the next release of vBulletin or vbPortal. They both have working version of Bug Tracker and Bug Reporter in the works.