vBug Tracker 1.0.3

[Dark_Wizard]

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 (https://vborg.vbsupport.ru/showpost.php?p=554097&postcount=28))
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 (https://vborg.vbsupport.ru/showpost.php?p=554556&postcount=46).

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 (http://www.vbwar.com/forums/vbugs.php)!

Additional support can be found here (http://www.vbwar.com/forums/vbugs.php?s=&do=list&vbug_projectid=7).

[chet]

Nice one, I will download now and install later

/me clicks install

[Surtain23]

Good hack!

I'll install it later and modify it to suit my needs.

[MrLister]

Few notes on this hack. First off it's a great hack, few instructions were unclear.

1. To anyone installing this make sure you go through your usergroups and select which ones can moderate the bugs and which ones can add otherwise you'll get bugs (default is no)

2. It uses print_cp_no_permission(); instead of print_no_permission();

You can either change it manually or download the file i attached with it already changed.

Otherwise I love this hack and I was about to make something similar.

[chet]

Do you have any screen shots of the Admin CP please

[Osterling]

like chet said, can we see some screen shots

[Dark_Wizard]

Few notes on this hack. First off it's a great hack, few instructions were unclear.


1. To anyone installing this make sure you go through your usergroups and select which ones can moderate the bugs and which ones can add otherwise you'll get bugs (default is no)

2. It uses print_cp_no_permission(); instead of print_no_permission();

You can either change it manually or download the file i attached with it already changed.

Otherwise I love this hack and I was about to make something similar.

New file uploaded...also at the end of the instructions it states to set the permissions....

[Logikos]

Great work! Screen shots would be great. Clicks install.

[Dark_Wizard]

Here are some admin screens....

[Osterling]

anyway i could see a workin version or screen shots on how it looks on the user side

[Dark_Wizard]

anyway i could see a workin version or screen shots on how it looks on the user side

Go to vbulletin.com and look at that one, this is identical in every way...I would send you to vbwar.com but I am working on the Pro version and thats all I have installed at the moment

[j_86]

DarkWizard you never fail to amaze me :)

[zajako]

good work ;) i needed one of these and just was too lazy er *coughs* busy to make one ;)

*clicks install*

[Rein Masamuri]

good work ;) i needed one of these and just was too lazy er *coughs* busy to make one ;)

*clicks install*

Hehe, Procrastonation, Zajako's best friend next to caffine.

[zajako]

lol and vanilla frosting! you cant forget the vanilla frosting

[Rein Masamuri]

lol and vanilla frosting! you cant forget the vanilla frosting
mmmm, a mountain dew-vanilla frosting shake

[zajako]

......nope :( girlfriend outlawed the dew :(

[Rein Masamuri]

Jolt-vanilla frosting shake?

[zajako]

now you're talking!... actualy thats would be kinda gross lol

[Blam Forumz]

Adding Table vbugs
Adding Table vbug_response
Adding Table vbug_severity
Adding Table vbug_status
Adding Table vbug_subscribe
Adding Table vbug_type
Adding Table vbug_version

vBug Tracker Tables Added!



There seems to have been a slight problem with the Lineage 2 database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


help

[Dark_Wizard]

Adding Table vbugs
Adding Table vbug_response
Adding Table vbug_severity
Adding Table vbug_status
Adding Table vbug_subscribe
Adding Table vbug_type
Adding Table vbug_version

vBug Tracker Tables Added!



There seems to have been a slight problem with the Lineage 2 database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


help

View the source of that page, copy and paste it here which will give me more details...

[Repec]

nice hack Dark Wizard, great job on it.

One thing though, when you edit a bug to update its status etc, it redirects to a blank page and when u check what it updated, it updated the bug status but didnt update the assigned to bit and it also deletes the bug title.

[Dark_Wizard]

nice hack Dark Wizard, great job on it.

One thing though, when you edit a bug to update its status etc, it redirects to a blank page and when u check what it updated, it updated the bug status but didnt update the assigned to bit and it also deletes the bug title.

Hmmm.....Is this on the front end or admincp? I don't see that here so I need to know.

I just tested on Natch's site and see no problems in the front end or the backend...please provide me details as outlined above.

[TheComputerGuy]

I get this error when I try to post a new bug Invalid SQL:
SELECT userid, username
FROM user
WHERE usergroupid IN()

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 ')' at line 3

mysql error number: 1064

[Dark_Wizard]

I get this error when I try to post a new bug Invalid SQL:
SELECT userid, username
FROM user
WHERE usergroupid IN()

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 ')' at line 3

mysql error number: 1064

As outlined in the instructions at the end it states "You will also need to set the vBug Tracker Permissions in each usergroup that uses vBug Tracker", this error is indicating you have no admins setup for vBug Tracker. Please do this and the error will not occur again. I will add some error checking in the next version.

[TheComputerGuy]

Thank you sir. I appreaciate it greatly.

[sinclac]

When i enter a bug and click subscribe i get an e-mail saying
Could not find phrase 'vbugs_new_subscribe'.

What should i do to fix it?

[Dark_Wizard]

When i enter a bug and click subscribe i get an e-mail saying
Could not find phrase 'vbugs_new_subscribe'.

What should i do to fix it?


Create a new phrase in the "Email Body Text" phrase group called vbugs_new_subscribe and add the following text:


Hello $username,

You are now subscribed to the following bug - $title.
$vboptions[bburl]/vbugs.php?do=view&$bug[vbugs_id]

Yours,
$vboptions[bbtitle] team

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:

To unsubscribe from this bug, please visit this link:
$vboptions[bburl]/vbugs.php?do=unsubscribe&vbugs_id=$bug[vbugs_id]


Please click install to obtain any further help....thx!

[zajako]

thanks, updated mine.

[Repec]

Hmmm.....Is this on the front end or admincp? I don't see that here so I need to know.

I just tested on Natch's site and see no problems in the front end or the backend...please provide me details as outlined above.

Its on the front end, it doesnt give me an error just a blank page.
I looked in the vbugs.php file and it seems the code for "Update Bug" is different from the rest.

[sinclac]

Create a new phrase in the "Email Body Text" phrase group called vbugs_new_subscribe and add the following text:


Hello $username,

You are now subscribed to the following bug - $title.
$vboptions[bburl]/vbugs.php?do=view&$bug[vbugs_id]

Yours,
$vboptions[bbtitle] team

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:

To unsubscribe from this bug, please visit this link:
$vboptions[bburl]/vbugs.php?do=unsubscribe&vbugs_id=$bug[vbugs_id]


Please click install to obtain any further help....thx!

Clicked INSTALL

Is there a way to set the e-mail subject to somthing other then blank?

[Dark_Wizard]

Clicked INSTALL

Is there a way to set the e-mail subject to somthing other then blank?

Damn...missed that in the phrases.xml file...I will fix it and put up a new version with upgrade instructions.

[dndog]

Awesome. Will install when I get time.

/dndog clicks install.

[Natch]

Wanted to add my support here - it's a great job mate - well done :D

[Mattius]

**************************************************
**************************************************
// includes/functions_online.php
**************************************************

Step 1 of 2
find:
**************************************************
Not done yet
**************************************************
add below:
**************************************************
Not done yet
**************************************************
Step 2 of 2
find:
**************************************************
Not done yet
**************************************************
below add:
**************************************************
Not done yet
**************************************************
save, close and upload includes/functions_online.php to your includes directory.
**************************************************

Found that in the latest 1.0.1 installer notes. What do i have to modify in functions_online.php?

Everything seems to install ok though :) but im still curious

[Polo]

thanks for sharing this nice mod!

[Dark_Wizard]

Found that in the latest 1.0.1 installer notes. What do i have to modify in functions_online.php?

Everything seems to install ok though :) but im still curious

That part wasn't complete yet but will be in the next version....

[Scutter]

nice hack Dark Wizard, great job on it.

One thing though, when you edit a bug to update its status etc, it redirects to a blank page and when u check what it updated, it updated the bug status but didnt update the assigned to bit and it also deletes the bug title.

I am also getting this, submit bugs fine, but when editing it to assign to someone it deletes the bug title and does not assign it to anyone. I have removed and re-installed but get the same result.

[Dark_Wizard]

I am also getting this, submit bugs fine, but when editing it to assign to someone it deletes the bug title and does not assign it to anyone. I have removed and re-installed but get the same result.

All fixed. Version 1.0.2 out...see first post.

[sinclac]

All fixed. Version 1.0.2 out...see first post.

To upgrade to 1.0.2 do we need to do all the edits and every thing in the install text?

[Mattius]

that b good question indeed

[Scutter]

Nice work dark, that got it. I now have the following problem, it displays fine when logged on as admin, but when logged on as a user with view and add permissions only, the screen looks like this...

[d3f]

Installed 1.0.1 had some errors followed the instructions to get to 1.0.2 but had a db error on each step, now im getting lots of..

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 123

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 1730

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
ORDER BY lastedit desc
LIMIT 0,

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 '' at line 13

mysql error number: 1064



and

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/admincp/vbugs_admin.php on line 177

ect, any help would be really apreciated.

[Dark_Wizard]

To upgrade to 1.0.2 do we need to do all the edits and every thing in the install text?

In the install.txt file are instructions to upgrade from earlier versions.

[Dark_Wizard]

Installed 1.0.1 had some errors followed the instructions to get to 1.0.2 but had a db error on each step, now im getting lots of..

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 123

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/includes/functions.php on line 1730

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
ORDER BY lastedit desc
LIMIT 0,

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 '' at line 13

mysql error number: 1064



and

Warning: Division by zero in /home/methlabs/domains/methlabs.org/public_html/forums/admincp/vbugs_admin.php on line 177

ect, any help would be really apreciated.

You didn't set the vBug Options in the admin control panel

[Dark_Wizard]

Nice work dark, that got it. I now have the following problem, it displays fine when logged on as admin, but when logged on as a user with view and add permissions only, the screen looks like this...

Edit your VBUGS template with the following:

find this:

$buglist
</tr></table>


change to this:

$buglist
</table>


Replace the entire contents of the vbugs_listbit with the following:

<tr>
<if condition="$admin">
<td class="alt1">$vbugs_id</td>
<td class="alt2">
<div>
<span style="float:right"></span>
<a href="vbugs.php?do=view&amp;vbugs_id=$bug[vbugs_id]">$title</a></span>
$moderateicon $privateicon $unassignedicon
</div>
<else />
<td class="alt1">$vbugs_id</td>
<td class="alt2">
<div>
<span style="float:right"></span>
<a href="vbugs.php?do=view&amp;vbugs_id=$bug[vbugs_id]">$title</a>
</div>
</if>
<div class="smallfont">
<span style="float:right">$date <span class="time">$time</span></span>
<strong onclick="window.location='member.php?u=$bug[userid]';" style="cursor:pointer">$username</strong>
</div>
</td>
<td class="alt1"><span class="smallfont">$typename: <strong>$statusname</strong><br /><em><if condition="$bug[adminid]">$adminname<else />$vbphrase[vbugs_unassigned]</if></em></span></td>
<td class="alt2"><div class="smallfont" style="white-space:nowrap">$lastreplydate <span class="time">$lastreplytime</span></div><div class="smallfont">by <a href="member.php?u=$bug[lastreplyuid]">$lastreplyname</a></div></td>
</tr>

[Scutter]

thanks vm

[Dark_Wizard]

thanks vm

your welcome....

[Boofo]

When I try to upgrade from version 1.0, I keep getting db errors for tables and settings and phrases that are already there. Duplicate. How do I upgrade without getting those? ;)

It seems I am running 1.0 beta version for some reason. How do I upgrade from that? ;)

[Dark_Wizard]

When I try to upgrade from version 1.0, I keep getting db errors for tables and settings and phrases that are already there. Duplicate. How do I upgrade without getting those? ;)


You shouldn't be getting that...it detects you earlier version and upgrades only whats needed...I just ran the script on another site and it works for me...can you PM me with more details?

[Mattius]

Ya i got too the same point as well. I get a duplicate error.

Attached is a screeny

[chet]

Hi there, I have installed this hack and I need to know where to add/remove or edit the bug types.

Thanks very much

Chet

[chet]

:squareeyed:

Found it, I should have looked harder

Chet

[sinclac]

Ok so where is it?

[chet]

Admin Control Panel

[dndog]

This thing had a bug in it and had to be upgraded?

The irony... :rolleyes:

[Mattius]

Anyone got a solution for this duplication problem upon installing 1.0.2?

[Dark_Wizard]

Anyone got a solution for this duplication problem upon installing 1.0.2?

Uninstall first as it isn't seeing the beta correctly...use this -> http://www.yourdomain.com/forums/admincp/index.php?loc=vbug_install.php?step=uninstall

Then reinstall...

[Mattius]

That worked :)

Thx Dark Wiz and grats on a superb hack btw

[GamerzWorld]

Since installing i cant upload any images. I simply get

Warning: move_uploaded_file(/home/merlin/public_html/mirzone/attachment/19aeaef8f86492e71637dd632239c7ea): failed to open stream: No such file or directory in /home/merlin/public_html/mirzone/forum/includes/functions_file.php on line 274

Warning: move_uploaded_file(): Unable to move '/tmp/php1Fki30' to '/home/merlin/public_html/mirzone/attachment/19aeaef8f86492e71637dd632239c7ea' in /home/merlin/public_html/mirzone/forum/includes/functions_file.php on line 274

Warning: filesize(): Stat failed for /home/merlin/public_html/mirzone/attachment/19aeaef8f86492e71637dd632239c7ea (errno=2 - No such file or directory) in /home/merlin/public_html/mirzone/forum/includes/functions_file.php on line 286

Any idea which file ive mucked up lol

[Natch]

You need to make sure you have CHMOD'ed your attachments upload folder to 777

[chet]

Is there a way to add the following to the mods control panel:

Vbug Bugs
- Add
- Modify
- Moderate

The reason I ask is because we have a number of trials forums and I would rather the mods of those forums allocate the bugs, apart from that this is a fantastic hack

Many thanks

Chet

[Dark_Wizard]

Is there a way to add the following to the mods control panel:

Vbug Bugs
- Add
- Modify
- Moderate

The reason I ask is because we have a number of trials forums and I would rather the mods of those forums allocate the bugs, apart from that this is a fantastic hack

Many thanks

Chet

Can you give them limited access to the admincp? If not I will consider it for the next version as I am currently still working on the vBug Tracker Pro version.

[chet]

:( I dont want to give them access to admin to at all, if you are busy is there anybody else here who could help me out

Thanks

Chet

[Dark_Wizard]

:( I dont want to give them access to admin to at all, if you are busy is there anybody else here who could help me out

Thanks

Chet


why not make them a vBug Admin and they can make the changes from the front end....

[chet]

OK no worries, I may even go for the pro version myself

Chet

[TheMayhem]

I get this error everytime I try to go in the admin cp and edit/add/ something in the vb bug admin file...

Parse error: parse error, unexpected T_PRIVATE, expecting ']' in /home/nodq/public_html/admincp/vbugs_admin.php on line 125

[djohn]

What will be new in vBug Tracker Pro?

[Dark_Wizard]

What will be new in vBug Tracker Pro?

The Pro version will contain the following features:

* Can handle Multiple Projects.
* Attachments
* Versions based on Projects, (i.e. I have several projects I am working on vBWar, vBug Tracker Pro and vBPool, each can have it's own versions.).
* Attachments can be moderated.
* Attachment uploads and downloads based on permissions.
* Bugs also based on a per project basis.


vBug Tracker Pro is running now on vBWar.com....

[Dark_Wizard]

Hmmm...over 200 downloads and only 28 people clicked installed?

[djohn]

* djohn clicked install ;)

ps: is vBug Tracker Pro going to be released here for free?

[Dark_Wizard]

* djohn clicked install ;)


ps: is vBug Tracker Pro going to be released here for free?

Sorry but no...it will only be available from vbwar.com and for a fee.

[LDEV]

Hmmm...over 200 downloads and only 28 people clicked installed?I haven't clicked Installed because I haven't installed it yet. :) But I will, once it's installed.

it will only be available from vbwar.com and for a fee.Do you know what the fee is going to be yet? If so, can you let us know. I'm very interested in the Pro version. We have an absolute need for file attachments.

Regards,
Rich

[Dark_Wizard]

Do you know what the fee is going to be yet? If so, can you let us know. I'm very interested in the Pro version. We have an absolute need for file attachments.

Regards,
Rich


I cannot discuss that here as it's against the forum rules. Please register at vbwar.com and ask there...thx!

[LDEV]

I cannot discuss that here as it's against the forum rules.Doh! I knew that, really, I did! :)

[Boofo]

Hmmm...over 200 downloads and only 28 people clicked installed?
But I clicked it 3 times myself. Did you count those? ;)

[Dark_Wizard]

But I clicked it 3 times myself. Did you count those? ;)

Smartass... :rolleyes:

[TTG]

Just installed and 'clicked' .. great, useful hack.https://vborg.vbsupport.ru/external/2005/01/2.gif

Thanks Dark Wizard ..

[Gary King]

There should really be a faster way to change values on bugs.

I think the values should be shown in a dropdown list with a button next to it so you can easily submit it ;)

[Dark_Wizard]

There should really be a faster way to change values on bugs.

I think the values should be shown in a dropdown list with a button next to it so you can easily submit it ;)


This hack was meant to duplicate exactly as it is on vb.com as alot of people wanted it. The Pro version will have alot more features than this version.

[nexialys]

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

[Dark_Wizard]

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.

[TheMayhem]

I get this weird text above my vbug tracker

Array ( [2] => Array ( [severityname] => Minor [displayorder] => 2 ) [3] => Array ( [severityname] => Major [displayorder] => 3 ) [4] => Array ( [severityname] => Critical [displayorder] => 4 ) [5] => Array ( [severityname] => Severe/URGENT [displayorder] => 5 ) )

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?

[GamerJunk.net]

Installed! Great.

[Dark_Wizard]

I get this weird text above my vbug tracker

Array ( [2] => Array ( [severityname] => Minor [displayorder] => 2 ) [3] => Array ( [severityname] => Major [displayorder] => 3 ) [4] => Array ( [severityname] => Critical [displayorder] => 4 ) [5] => Array ( [severityname] => Severe/URGENT [displayorder] => 5 ) )

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?

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.

[u2page]

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?

[Lionel]

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;
}

[msimplay]

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

[xmitchx]

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:

[Natch]

whats the difference between the standard and pro version as i just installed this on my test forum and its very interesting :)
Take a look @ http://www.vbwar.com/

[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/usergroup.php?s=&do=edit&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:"Closed (Fixed)";s:12:"displayorder";s:1:"3";}i:4;a:2:{s:10:"statusname";s:9:"Duplicate" ;s:12:"displayorder";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:"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:10:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severity";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:"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: "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:"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:"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:"typename";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]

: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.

[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:\"statusname\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confirmed\";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:\"displayorder\";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:\"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:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";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:\"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:\"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:\"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:\"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:\"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:\"typename\";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:\"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:"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:"displayorder";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:"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:10:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severity";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:"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:"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:"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:"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:"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:"typename";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:"displayorder";s:1:"1";}}}')
mysql error: Table 'divingan_vboard.datastore' doesn't exist

mysql error number: 1146


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:"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:"displayorder";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:"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:10:"statusname";s:11:"Style Issue";s:12:"displayorder";s:2:"12";}}s:8:"severity";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:"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:"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:"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:"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:"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:"typename";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:"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.

[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.

[FASherman]

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.

[FASherman]

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)

[zendiver]

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

[FASherman]

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:
$DB_site->query("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:\"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:\"displayorder\";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:\"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:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";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:\"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:\"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:\"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:\"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:\"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:\"typename\";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:\"displayorder\";s:1:\"1\";}}}')");


REPLACE WITH:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."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:\"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:\"displayorder\";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:\"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:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";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:\"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:\"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:\"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:\"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:\"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:\"typename\";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:\"displayorder\";s:1:\"1\";}}}')");


FIND:

$DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");

REPLACE WITH:

$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");

SAVE admincp/vbug_install.php

EDIT /vbugs.php

FIND BOTH INSTANCES (There are two) OF:

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

AND REPLACE WITH

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.

[zendiver]

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.

[Andreas]

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

[zendiver]

WORKS AWESOME BRO...thanks.

[zendiver]

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)


Database error in vBulletin 3.0.3:

Invalid SQL: SELECT typename, vbug_typeid FROM vb3_vbug_type ORDER BY displayorder
mysql error: Table 'divingan_vboard.vb3_vbug_type' doesn't exist

mysql error number: 1146

[FASherman]

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.

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.

[FASherman]

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.

[FASherman]

Okay, I've got it all worked out.

Edit includes/adminfunctions_vbugs.php

FIND

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

REPLACE WITH

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


FIND

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

REPLACE WITH

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


FIND

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

REPLACE WITH

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


FIND

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

REPLACE WITH

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


FIND

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

REPLACE WITH

$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]

EDIT /vbugs.php

FIND BOTH INSTANCES (There are two) OF:

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

AND REPLACE WITH

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
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]

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?

[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.

[tkeil69575]

as far as I can see this line

LEFT JOIN user ON (vbugs.userid = user.userid)

should read

LEFT JOIN user AS user ON (vbugs.userid = user.userid)

at least it fixed the mysql error I got when I first called vbugs.php

regards
Tina

ps. has to be fixed in 2 instances in vbugs.php

[peterska2]

I've tried that already but it didn't have any effect

[tkeil69575]

I've tried that already but it didn't have any effect
peterska2 ... the fix i mention does not relate to your problem. i'd say you have missing templates or something like that ... id probably uninstall and try again ... probably something went wrong during the install.

tina

[The Wise One]

as far as I can see this line

LEFT JOIN user ON (vbugs.userid = user.userid)

should read

LEFT JOIN user AS user ON (vbugs.userid = user.userid)

at least it fixed the mysql error I got when I first called vbugs.php

regards
Tina

ps. has to be fixed in 2 instances in vbugs.php
thanks for that :) unfortunately...it didnt fix my problem (thats assuming you posted that possible fix in response to my post).

[peterska2]

peterska2 ... the fix i mention does not relate to your problem. i'd say you have missing templates or something like that ... id probably uninstall and try again ... probably something went wrong during the install.

tina
Damn,

I guess I'd best drop the table prefix throughout the vB and start again from scratch eh?

[john_rsd]

I have set general permissions in usergroups for those who can / cannot post to bugtracker.

but I would have liked to have kept it private using forum password or just using custom usergroup settings on that forum pointing to vbugs.php

If i tell the forum to have password it is not applied. I can access the forum anytime even with password set.

I cannot define custom usergroup settings either per forum. So it is not possible for me to exclude groups.

Is this by design?

Small example 1. I have guests set in default usergroup premissions as being able to add bugs/see bugs.

For now i want to keep forum private for testing.

So I edit the guest usergroup in that forum and change the forum permissions to custom and leave only view forum=yes, but turn off all other options (see others threads, post et all)

I do not see any possiblity for custom settings for vbugs here.

Guests can still see, post, add bugs without a problem!

Small example 2. I have password set for forum to which points to vbugs.php.

For now i want to keep forum private for testing.

So I set password

Guests can still see, post, add bugs without a problem! No password required.

Possible I am missing something simple here?

[Dark_Wizard]

Ok...I'm back, after my cruise and the holidays I will start on the next version for those few little bugs. I am also going to complete the Pro version which can be obtained only from vbwar.com...

Next release will have all of the table prefixes redone....

[PixelFx]

Please let me know as soon as its out, and what paypal to use... glad ya had a good vacation.

if you need beta testers my team is very good at finding bugs...

[Abe1]

Here is a real bug:

When an admin chooses to make a bug 'private' when he is making a new bug, it doesn't make the bug private. You have to edit the bug after to make it private.

Here is the solution to fix it:

Find:
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT));

Replace with:
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT, 'private' => INT));


Find:
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid])


Replace with:
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid, private)
VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid], '$private')

Basicly, you forgot to make the 'do=insert' add the private variable.

For thouse who don't realize, the file I'm talking about is: vbugs.php

[Eric1776]

When trying to do a search I get this error.
Database error in vBulletin 3.0.5:

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 '%test%' AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
ORDER BY lastedit desc
LIMIT 0, 20

mysql error: You have an error in your SQL syntax near 'LIKE '%test%' AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
ORDER' at line 12

mysql error number: 1064

Date: Friday 07th of January 2005 01:43:20 PM
Script: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=test&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Referer: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Username: Aragorn
IP Address: 160.136.49.104

[Vman]

I am now getting this error since I upgraded to 3.0.5....


--------------------------------------

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php

-------------------------------------


what do i need to do to correct this!!!

[reteep]

I am now getting this error since I upgraded to 3.0.5....
--------------------------------------
Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php
-------------------------------------
what do i need to do to correct this!!!

You forgot to reedit the init.php:


find:
**************************************************
// ### INSERT PLUGIN USERGROUP PERMISSIONS BITFIELDS HERE ###
**************************************************

add above:
**************************************************
// vBug Tracker Permissions
$_BITFIELD['usergroup']['vbugpermissions'] = array(
'canadminbugs' => 1,
'canaddbugs' => 2,
'canviewbugs' => 4
);

**************************************************
save, close and upload includes/init.php
**************************************************

[FASherman]

When is this hack going to support prefixed tables?

[ccunnin71]

Speaking of prefixed tables! The install hosed up... Yes, I do have the vb3_ prefixed table setup. How do I get around this? Better yet how do I uninstall this now? I see at the end of the 'vbug_install" is an uninstall option. What do I have to do to make this work?

Big bummer! I was really looking forward to using this mod. :tired: Should have spent more time on the older threads on this (of course I am reading them after the fact).

Thanks for any help in this situation.

[PixelFx]

I'm waiting for the pro version ;)

[ccunnin71]

I 2nd that :). Ok, restored from backup that I made before installing the mod. Yes, I have tripped up before and learned from my mistakes.

Ok Dark Wizard, look forward to your coding efforts.

[FASherman]

When is this hack going to support prefixed tables?
I'll answer my own question: NOW.

Instructions to make this hack work with prefixed tables.

1. EDIT THE INSTALL SCRIPT (admincp/vbug_install.php)
--------------------------------------
FIND:
$DB_site->query("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:\"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:\"displayorder\";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:\"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:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";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:\"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:\"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:\"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:\"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:\"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:\"typename\";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:\"displayorder\";s:1:\"1\";}}}')");

REPLACE WITH
$DB_site->query("INSERT INTO ".TABLE_PREFIX."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:\"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:\"displayorder\";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:\"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:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";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:\"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:\"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:\"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:\"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:\"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:\"typename\";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:\"displayorder\";s:1:\"1\";}}}')");
-------------------------------------
FIND:
$DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");
REPLACE WITH:
$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");

SAVE INSTALL SCRIPT
================================================== ========

2. EDIT vbugs.php
---------------------------------
FIND:
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 " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)
REPLACE WITH:
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 " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)----------------------------------
FIND:
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 " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)
REPLACE WITH:
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 " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)

SAVE vbugs.php
================================================== ========

3. Follow the instructions contained in the install.txt file

[ccunnin71]

FASHerman Thanks! One small note... Your code change nearly did it. It also brought on "Parse error: parse error, unexpected T_STRING ...."

To correct goto top of you vbugs.php and add an additional line...


FIND
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'vbugs');


Add this right bellow
define('TABLE_PREFIX', 'vb3_'); //Your table prefix


That corrected things for me.

[Dark_Wizard]

I'm waiting for the pro version ;)

A beta test of this is coming soon...table prefixes done and alot of extra features not found in this version.

[PixelFx]

can;t wait for it :)

[SpeedStreet]

<schnap>

Fresh Install on Fresh Board in private testing environment:

Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in c:\wamp\www\admincp\vbugs_admin.php on line 125

[SpeedStreet]

Does anyone have an idea? I've poured over this code and I cannot find anything that is inherently wrong with it. I should also say I am using the new 3.0.6. Everything appears fine in the front end (bugs can be added, etc. It's only when the admincp tries to access vbugs_admin.php

[SpeedStreet]

Sad that this hack seems to have died the closer we all get to vbugs pro. I wanted to test out the lite version for my company looking to integrate it into their intranet, but it looks like I will have to go to an open source, more fully supported product :(

[ccunnin71]

I am running it on 3.0.6 with prefixed tables. Works fine... I made the changes that FlashCode suggested with my one fix. It's a pretty limited system but workable.

I would go over your install again and see if you got one of the steps mixed up. Be sure you gave your admin rights as well.

[Dark Shogun]

<schnap>

Fresh Install on Fresh Board in private testing environment:

Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in c:\wamp\www\admincp\vbugs_admin.php on line 125
I have the exact same problem. I am running my board on a private system and get the same exact error when I try to add/change any of the vbug dropdowns in the admincp. Can someone please help us out?

Dark Shogun

[SpeedStreet]

I just reinstalled and I am now using table prefixes...so I will see if this works.

[SpeedStreet]

vBug Tracker 1.02 works with vBulletin 3.0.6
=================================

I now have the system up and running.

It's quite slick. Though my concerns now lie in the support sector if I were to purchase this for our Intranet.

In order to have this work properly for your board, you MUST make some changes.

Fasherman's Add dB Prefixes: HERE (https://vborg.vbsupport.ru/showpost.php?p=598409&postcount=147)

StormBlast's init.php fix:
HERE (https://vborg.vbsupport.ru/showpost.php?p=592927&postcount=142)

And for a cleaner UI, I reccomend HarryButt's little nugget: HERE (https://vborg.vbsupport.ru/showpost.php?p=575984&postcount=127)

Unfortunately, I cannot speak to how this will work on a dB without prefixes, though I assume it should flesh out OK.

Good Luck everyone!

[Dark_Wizard]

Well...I'm back and now there is an updated version that fixes one small bug that fell unnoticed and table prefixes have been updated and tested on vB 3.0.6.

I'm sorry that I haven't been around as I have been busy with my Gold release of vBWar 3.0 and some other various projects. FYI, the Pro version is back in full swing and will be available for beta testing within the next few weeks but can only be obtained at vbwar.com.

[PixelFx]

Well...I'm back and now there is an updated version that fixes one small bug that fell unnoticed and table prefixes have been updated and tested on vB 3.0.6.

I'm sorry that I haven't been around as I have been busy with my Gold release of vBWar 3.0 and some other various projects. FYI, the Pro version is back in full swing and will be available for beta testing within the next few weeks but can only be obtained at vbwar.com.
let me know if you need beta testers, I have 6000 developers that could test the crap out of it ;)

[Dark_Wizard]

let me know if you need beta testers, I have 6000 developers that could test the crap out of it ;)

ROFLMAO...you are already at the top of my list...I will keep you posted!

[PitchouneN64ngc]

I have tested your update (1.0.3) and I find two little bugs with prefix tables.

In vbugs.php, find two times this:

FROM vbugs

And replace by this:

FROM " . TABLE_PREFIX . "vbugs AS vbugs

;)

[Dark_Wizard]

I have tested your update (1.0.3) and I find two little bugs with prefix tables.

In vbugs.php, find two times this:

FROM vbugs

And replace by this:

FROM " . TABLE_PREFIX . "vbugs AS vbugs

;)


Nice find...fixed, attachment updated!

[SpeedStreet]

was the little bug that was fixed the truncating of data in vbugsadmin when adding a new bug?

[ixian]

I have the exact same problem. I am running my board on a private system and get the same exact error when I try to add/change any of the vbug dropdowns in the admincp. Can someone please help us out?

Dark Shogun

This problem has returned for 3.0.7, I just ran a fresh install - on a fresh, unhacked board - and get this exact problem. Went back over the file edits with a fine toothed comb. Nope.

I don't use table prefixes but from what I read that shouldn't matter?

[ixian]

This problem has returned for 3.0.7, I just ran a fresh install - on a fresh, unhacked board - and get this exact problem. Went back over the file edits with a fine toothed comb. Nope.

I don't use table prefixes but from what I read that shouldn't matter?

Commenting out line 125 in vbugs_admin.php fixes the problem, though I am sure that isn't the final fix. At least it works this way.

[Dark_Wizard]

This problem has returned for 3.0.7, I just ran a fresh install - on a fresh, unhacked board - and get this exact problem. Went back over the file edits with a fine toothed comb. Nope.

I don't use table prefixes but from what I read that shouldn't matter?

What exactly is the error and the steps leading to it as I have checked the coding and there is nothing there that would cause any issues on line 125. Also what O/S are you using?

[ixian]

What exactly is the error and the steps leading to it as I have checked the coding and there is nothing there that would cause any issues on line 125. Also what O/S are you using?


Same error as reported earlier:

Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in c:\path\to\admincp\vbugs_admin.php on line 125

Steps are, I click any option in admincp - modify, add, or edit - and I get this error.

Redhat ES 3.x.

[Dark Shogun]

I am using a windows laptop.

Dark Shogun

[Creed]

I'm installing now :)

[Zachariah]

Vbugs.php
Find:

// pre-cache templates used by all actions
$globaltemplates = array(
'VBUGS',
'userfield_select_option'
);
Replace:

// pre-cache templates used by all actions
$globaltemplates = array(
'VBUGS',
'vbugs_footer',
'userfield_select_option'
);

[ccunnin71]

How does one do an uninstall? I see that the bottom of 'vbug.install.php' has code for an uninstall but I am not php savy. I am more of the cut&paste guy :) I want to reinstall this mod and start it from scratch. I was hoping to avoid a lot of manual table drops.

Ok... Days later. Support on this mod is sketchy. Will hold out for pro version.

For those who might want to know how-to uninstall the trigger to get the uninstall script to run. Execute the vbug_install.php file from your admincp (yes, you would have to ftp it back up) It will fail right away saying that tables already exist. Just change the step 1 = to uninstall.

I still had to manually pull the seven new tables it created. I like the app but it needs a lot more features. Lets hope the pro version gives us a more robust system.

chow

[PitchouneN64ngc]

I have found some errors in ACP with prefix tables.

In ./admincp/vbugs_admin.php, find:

$DB_site->query("
INSERT INTO vbugs

Replace by:

$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "vbugs

Then, find:

$DB_site->query("UPDATE vbugs SET title = '" . addslashes($title) . "', description = '" . addslashes($description) . "', vbug_statusid = '$vbug_statusid', moderate = '$moderate', adminid = '$adminid', vbug_versionid = '$vbug_versionid', vbug_severityid = '$vbug_severityid', vbug_typeid = '$vbug_typeid', lastedit = '" . TIMENOW . "', lastreplyuid = '$bbuserinfo[userid]', private = '$private' WHERE vbugs_id = $vbugs_id");

Replace by:

$DB_site->query("UPDATE " . TABLE_PREFIX . "vbugs SET title = '" . addslashes($title) . "', description = '" . addslashes($description) . "', vbug_statusid = '$vbug_statusid', moderate = '$moderate', adminid = '$adminid', vbug_versionid = '$vbug_versionid', vbug_severityid = '$vbug_severityid', vbug_typeid = '$vbug_typeid', lastedit = '" . TIMENOW . "', lastreplyuid = '$bbuserinfo[userid]', private = '$private' WHERE vbugs_id = $vbugs_id");

Then, find:

$bugs = $DB_site->query("
SELECT *
FROM vbugs
LIMIT " . (($page - 1) * $perpage) . ", $perpage
");

Replace by:

$bugs = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "vbugs
LIMIT " . (($page - 1) * $perpage) . ", $perpage
");

Then, find:

$versions = $DB_site->query("
SELECT *
FROM vbug_version
ORDER BY displayorder
");

Replace by:

$versions = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "vbug_version
ORDER BY displayorder
");

Then, find:

$status = $DB_site->query_first("
SELECT *
FROM vbug_status
WHERE vbug_statusid = $vbug_statusid
");

Replace by:

$status = $DB_site->query_first("
SELECT *
FROM " . TABLE_PREFIX . "vbug_status
WHERE vbug_statusid = $vbug_statusid
");

Then find:

$severity = $DB_site->query_first("
SELECT *
FROM vbug_severity
WHERE vbug_severityid = $vbug_severityid
");

Replace by:

$severity = $DB_site->query_first("
SELECT *
FROM " . TABLE_PREFIX . "vbug_severity
WHERE vbug_severityid = $vbug_severityid
");

Then find:

$type = $DB_site->query_first("
SELECT *
FROM vbug_type
WHERE vbug_typeid = $vbug_typeid
");

Replace by:

$type = $DB_site->query_first("
SELECT *
FROM " . TABLE_PREFIX . "vbug_type
WHERE vbug_typeid = $vbug_typeid
");

And all works ;)

[DS MrSinister]

I got this error when i upgraded to VB 3.0.6. I had ver. 1.0.2 installed.


Fatal error: Call to undefined function: fetch_state_array() in /includes/adminfunctions_options.php(96) : eval()'d code on line 1


I thought if i upgraded to ver 1.0.3 might go away Nope..

If i Uninstall this hack it goes away.

any idea on how to fix this?

[Dark_Wizard]

I got this error when i upgraded to VB 3.0.6. I had ver. 1.0.2 installed.


Fatal error: Call to undefined function: fetch_state_array() in /includes/adminfunctions_options.php(96) : eval()'d code on line 1


I thought if i upgraded to ver 1.0.3 might go away Nope..

If i Uninstall this hack it goes away.

any idea on how to fix this?

When you upgraded you forgot the file edits in admin_functions.php, please read the install.txt file for the vBug Tracker and make the changes.

[Dark_Wizard]

How does one do an uninstall? I see that the bottom of 'vbug.install.php' has code for an uninstall but I am not php savy. I am more of the cut&paste guy :) I want to reinstall this mod and start it from scratch. I was hoping to avoid a lot of manual table drops.

Ok... Days later. Support on this mod is sketchy. Will hold out for pro version.

For those who might want to know how-to uninstall the trigger to get the uninstall script to run. Execute the vbug_install.php file from your admincp (yes, you would have to ftp it back up) It will fail right away saying that tables already exist. Just change the step 1 = to uninstall.

I still had to manually pull the seven new tables it created. I like the app but it needs a lot more features. Lets hope the pro version gives us a more robust system.

chow

I will look into this and yes the Pro is more robust and has alot more features, new coding and has a new installer/uninstaller. Lastly...support isn't sketchy and has been requested that for faster support please visit vBWar.com. ;)

[Dark_Wizard]

Vbugs.php
Find:

// pre-cache templates used by all actions
$globaltemplates = array(
'VBUGS',
'userfield_select_option'
);
Replace:

// pre-cache templates used by all actions
$globaltemplates = array(
'VBUGS',
'vbugs_footer',
'userfield_select_option'
);

Thanks for the catch....

[scottct1]

Just installed this. :)

How do I change and add selectable versions in the versionid pull down?

Great mod!

[Dark_Wizard]

Just installed this. :)

How do I change and add selectable versions in the versionid pull down?

Great mod!

This is done in the admincp.

[Dark_Wizard]

Alot of people have been asking if this will be ported to vbulletin 3.5 and yes it will be...

[PitchouneN64ngc]

Thank you for this answer, I'm waiting for the vB 3.5 version :)

[Linkster]

Can this be used for Feature Requests too? If not, please put that on your feature suggestions list :) I'd love to have a single interface for users to request a feature or submit a bug report...same for viewing...view either feature requests or bug reports. shouldn't be that hard actually if its not already done. Also, I'd really love to buy/try the pro version. Please PM me if you are accepting beta testers.

[TTG]

Any chance of this being upgraded for use with vb 3.5.0 ?

[Logikos]

I'm creating a very nice one right now. I'll be finished with my Banners System in 2 more days or so then it will be about a week untill I finish my bug tracker.

[Dark_Wizard]

Any chance of this being upgraded for use with vb 3.5.0 ?

Yes....it is in progress.

[csidlernet]

thanks very much.

[scottct1]

I am having an issue, on my site I have it set so the users can view and add bugs in the AdminCP, however when the go to the vbugs.php they dont see any of the bugs (none are private)

I on my administrator account see them all fine.

The usergroup permission are set correctly, I have gone into the database and vbugpermissions for the usergroup is set to 6.

if they go and enter a bug number they can view those fine.

Any ideas of how I can let me users see all the non private bugs?

Thanks

[Dark_Wizard]

<a href="https://vborg.vbsupport.ru/showthread.php?t=96826" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=96826</a>

[timmed]

For some reason I cannot get the list any of the lists in vbugs.php to show the options, not even the default options.

[Dark_Wizard]

For some reason I cannot get the list any of the lists in vbugs.php to show the options, not even the default options.

Can you clarify this as I am not understanding what you mean. Also I tried going to your site that you have in your profile but it is down as I wanted to at least try to understand what you were saying.

[timmed]

The site I am using this version of the hack is http://www.webcadets.com/forum/ I am one of the staff administrators.

Attached is an image of what I'm having a problem with, this drop down menu is not listing any of the options.

[AaronBBrown]

When I try to visit any of the vBug control panels I end up with a blank screen in the right hand frame. View-Source just shows <html><body></body></html>

Any ideas? I'm using vB 3.0.8

[john_rsd]

Dark Wizard

I am unable to use the installer to remove 1.0.3

It creates duplicate tables and I cannot see any uninstall option.

Although it creates the databse tables I get a database connect error, but the forums are running fine.

[john_rsd]

I uploaded all the files again, CHMOD and ran the installer.

I get taken to the admincp, log in, all OK, but then when i click for the next step with the installer I get a database error.

<!--
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('vbugs', '1230', '0')
mysql error: Duplicate entry 'vbugs' for key 1

mysql error number: 1062

Date: Thursday 06th of October 2005 11:02:54 AM
Script: http://www.proteluser.com/admincp/vbug_install.php?step=1
Referer: http://www.proteluser.com/admincp/vbug_install.php?step=intro
Username: xxxxxxxx
IP Address: xxxxxxxx -->

</body></html>

Any ideas would be appreciated. I am trying to do an uninstall.

Everything seems OK, if i click in the admincp adn ask it to check/optimse the database all is well.

[zendiver]

John, you missed this last step....once logged into the AdminCP, you need to do this step before proceeding to the next install step:


Go to your admincp and set the vBug Settings under "vBulletin Options" then click save.
IF YOU DO NOT DO THIS YOU WILL GET ERRORS!

[john_rsd]

Hi

I did read that ;)

The mod was actually working. Before updating the forums (and because it was not being used) I decided to uninstall it.

But since the failed install/uninstall step, the settings at the bottom of my vBulletin pages now look like this.

Very strange

[Dark_Wizard]

Hey everyone,

This product hasn't been updated since vb 3.0.6. If I have the time this weekend I will look it over.

john_rsd <- it is impossible to create duplicate tables and MySQL will give errors when trying to create a table that already exists.

[john_rsd]

Dark Wizard

Yes you are right of course. Forgive my moment of insanity.

It was running on 3.0.7, but I can neither run the installer past the init phase as it seems to be unable to connect to the database. So I never get as far as the option to uninstall.

If I had updated from 3.0.6 to 3.0.7 and reverted all templates could this produce the result I see in the AdminCP? Would it explain the installer failure?

It was running since 1.01/1.02 and then 1.03 but i think all I did last time was update to 3.0.7 and apply the edits again, did not even look again at the admincp as it was already set up.

[imported_holocron]

Hi Dark_Wizard,

any progress on the vb 3.5.x version of this application? /me anxiously waits.

thanks.

edit: answered my own question.. https://vborg.vbsupport.ru/showthread.php?t=96888