and when this Pro version will be released ?!... also, this vBPool show released in your sig, but is not downloadable anywhere...

I am hoping to have the Pro released sometime this week coming up. As for the vBPool...contact Mike on sporstrant.com.

I get this weird text above my vbug tracker

Also is there anyway by default when a user posts a ticket that it will automatically be assigned to a status like "Awaiting Feedback", ect. and then from there my staff can sort through it and close it or what not?

Installed! Great.

You need to go to the "vBulletin Options" and then to "vBugs" Options and set the default status there. As for your error, I cannot duplicate it so it may be that you have set your vBugs Options yet in the vBulletin Options.

Lastly, please click install for any further support. Thx.

I have this installed but am having a problem, the datastore is not updating the bugcache when I change the values of severity, version, etc. in the control panel, so the originally installed options are appearing on the screen. Any suggestions?

in edit template, the below line is unecessary and causing a javascript error as the description box is uneditable (it should though, just to fix the typos)

if(document.cpform.description.value == "")
{
alert("<phrase 1='$vbphrase[description]'>$vbphrase[vbugs_please_enter_x]</phrase>");
document.cpform.description.focus();
return false;
}

whats the difference between the standard and pro version as i just installed this on my test forum and its very interesting :)

Downloaded and installed and it works great :) It took quite awhile to install though since my extension for vB is .html and all your links and such were .php :nervous:

Take a look @ http://www.vbwar.com/

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?

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.

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

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.

:eek:

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.

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

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.

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

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.

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.

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.

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)

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? :)

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:
REPLACE WITH:

FIND:

REPLACE WITH:

SAVE admincp/vbug_install.php

EDIT /vbugs.php

FIND BOTH INSTANCES (There are two) OF:

AND REPLACE WITH

SAVE vbugs.php

This fixed it for me and I like the results.

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.

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

WORKS AWESOME BRO...thanks.

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)

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.

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.

Okay, I've got it all worked out.

Edit includes/adminfunctions_vbugs.php

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

Hopefully everything should work now.

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.

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:

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
And add ")" to the end of the one that doesn't have it.

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

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?

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.

Yes.

Thanks. It is working fine now.

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