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.