vBug Tracker Lite 3.5.1

[Dark_Wizard]

The XSS security flaw reported in this modification has been fixed by Staff and a new zip file (3.5.1a) uploaded.

Here is a port of my vBug Tracker hack from vb 3.0.x. This mimics the Bug Tracker found at vBulletin (http://www.vbulletin.com/forum/bugs35.php).

Details:

7 - table additions
96 - Phrases Added
3 - file additions
2 - xml files
8 - template additions
3 - Plugins


Please click install for support! For those interested, the Pro version is in development and should be out soon. It will be released at vb-scripts.com.

Sept 25, 2005
Bug fixes:

* Added Missing phrases for editing status, type & severity.
* Fixed bug in changing displayorder



Sept 26, 2005
Bug Fixes/Changes

* Fixed bugcache issue and tested
* Added admin usergroup permissions


Sept 27, 2005 (Part 1)
Bug Fixes:

* Fixed subscribe issues and missing phrases.


Sept 27, 2005 (Part 2)

* Complete rewrite of the subscription piece including the unsubscribe.
* Subscriptions fully tested and working from all aspects!



Nov 7, 2005

* Fixed missing table prefix when editing status.
* Fixed issue when editing severities.
* Now supports secondary usergroups.


Nov 24, 2005

* Fixed extra span tag in list template.
* Fixed searching on version.
* Added "unassigned" to dropdown.


Jul 11, 2006

* XSS Flaw fixed by Staff.


To upgrade:

Import the product xml and select "Allow Overwrite".
Upload all the files overwriting the old ones.

Lastly... Please follow the instructions exactly as they are outlined in the documents/install.txt and in the order as listed to avoid any problems.

Updated for vBulletin 3.7, Get it here (https://vborg.vbsupport.ru/showthread.php?t=179589)

[Logik]

Thanks :)

[Blaine0002]

GREAT JOB! installs

[Dan]

Thanks for this ;) Was looking for this for a new site I'm working on.

[hydrostatic]

How much will the pro version cost? Will there be an upgrade script if we install this right now?

Any significant extra features?

[Zelda-King]

Been waiting for this a looooong time. :)

[Dan]

Seeing a slight issue


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 Permissions section of the control panel.


Even if i select all to yes i still get the same message and there is a blank field where I am assuming Bug settings are under Admin Permissions.


Any help?

[Dark_Wizard]

How much will the pro version cost? Will there be an upgrade script if we install this right now?

Any significant extra features?

Not sure on price yet sorry. Upgrade, yes. As for features...


* Support for multiple projects.
* Passwording of Projects
* Adding of attachments when submitting bugs.
* WYSIWYG editor and Quoting of responses to bugs.
* Who's viewing this bug.
* plus many more features.

[Dark_Wizard]

Seeing a slight issue



Even if i select all to yes i still get the same message and there is a blank field where I am assuming Bug settings are under Admin Permissions.


Any help?

Strange...working for me fine. Any errors when saving the permissions?

[hydrostatic]

Not sure on price yet sorry. Upgrade, yes. As for features...


* Support for multiple projects.
* Passwording of Projects
* Adding of attachments when submitting bugs.
* WYSIWYG editor and Quoting of responses to bugs.
* Who's viewing this bug.
* plus many more features.


What do we upload? .svn, admincp, includes, and vbug.php correct?

[Dan]

Strange...working for me fine. Any errors when saving the permissions?

Might want to change that error message as it's under usergroup settings not Admin Permissions. Also when adding this I got this blank field under Admin Permissions screen.

[Dark_Wizard]

What do we upload? .svn, admincp, includes, and vbug.php correct?
.svn wasn't supposed to be there as I use a subversion repository for keeping track of all my projects and development. Disregard it and just upload everything else.

Edit: File updated...

[Dark_Wizard]

Might want to change that error message as it's under usergroup settings not Admin Permissions. Also when adding this I got this blank field under Admin Permissions screen.

Uhmm...this is for vbulletin 3.5.0 RC3 and those permissions don't belong to this hack nor are they part of it.

[Dan]

Uhmm...this is for vbulletin 3.5.0 RC3 and those permissions don't belong to this hack nor are they part of it.

I am running RC3 ;) But that only appeared after i installed this, but as i said the message needs changing since it's under usergroup and not admin settings....

[hydrostatic]

Nevermind... I figured it out.

In process of testing.

[Dark_Wizard]

Been waiting for this a looooong time. :)

Sorry...been juggling 6 projects at once including my main job during the day. Funny part is it only took me about 2 hours to port it over so my bad for not doing it sooner.

[Zelda-King]

Installed fine. Permissions seem fine. In the process of testing now. Presently the only thing I'm seeing wrong is options not showing in most of the dropdowns.

[Dark_Wizard]

Installed fine. Permissions seem fine. In the process of testing now. Presently the only thing I'm seeing wrong is options not showing in most of the dropdowns.

Go to your admincp and edit only one of each item i.e Version, type, status etc...and then your cache will be set. Let me update the installer so this won't happen again.

[Revan]

Installed. Btw, you still have an entire folder called "vBug Tracker Lite 3.5.0" which contains nothing but empty folders and .svn folders.
A tip for you: Use Export and not Checkout when you are releasing SVN based projects ;)

[mtha]

Warning: Unknown modifier '7' in /home/virtual/site1/fst/home/forums/forum350RC3/vbugs.php on line 52

install and get this msg. everything seems working fine

[timmed]

I'm getting an SQL error

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"red\"><b><i>',
`closetag` = '</i></b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '500',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472255',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`supportpermissions` = '0',
`vbugpermissions` = '7'
WHERE usergroupid=6;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, September 25th 2005 @ 04:24:54 PM
Script : url/admincp/usergroup.php
Referrer : url/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : HIDDEN
Username : Admin
Classname : vb_database

[Revan]

Another error: When editing statuses, the print_table_header phrase is empty.

[Dark_Wizard]

Another error: When editing statuses, the print_table_header phrase is empty.

Ok...let me look into it...

[Dark_Wizard]

I'm getting an SQL error

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"red\"><b><i>',
`closetag` = '</i></b></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '500',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '204472255',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`supportpermissions` = '0',
`vbugpermissions` = '7'
WHERE usergroupid=6;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, September 25th 2005 @ 04:24:54 PM
Script : url/admincp/usergroup.php
Referrer : url/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : HIDDEN
Username : Admin
Classname : vb_database

supportpermissions is another hack and isn't associated with vBug Tracker. Did you just uninstll a support hack? If so the uninstaller didn't remove it's permissions.

[timmed]

supportpermissions is another hack and isn't associated with vBug Tracker. Did you just uninstll a support hack? If so the uninstaller didn't remove it's permissions.

actually, yes i did, thanks

[Dark_Wizard]

install and get this msg. everything seems working fine

Are you running a branded free vbulletin? This line does a preg to add my info to the vbulletin footer.

[Zelda-King]

Go to your admincp and edit only one of each item i.e Version, type, status etc...and then your cache will be set. Let me update the installer so this won't happen again.That did the trick. Cheers!

Successfully posted a test bug too.

[hydrostatic]

Might want to change that error message as it's under usergroup settings not Admin Permissions. Also when adding this I got this blank field under Admin Permissions screen.

That's caused by another hack, not this one as I took the liberty to find out. It's caused by the RPG Inferno hack.

[Zelda-King]

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

[hydrostatic]

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

Yeah update order doesn't work on anything including severities etc. I think that's because there's no "redirect" thing. Also, I'm not sure if this is intended, the bar on top when you edit bug types is a little weird looking. Nothing major though. Other than that, no bugs & great hack. Thanks man.

[Dark_Wizard]

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

Ok...let me check it out...

[Zelda-King]

Yeah, yet to check that with other plugins disabled though.

[Dan]

That's caused by another hack, not this one as I took the liberty to find out. It's caused by the RPG Inferno hack.

funny thing is i don't have that hack installed nor would i touch it with a 10 foot pole.

[Dark_Wizard]

I found a little something: In 'Modify Bug Types' it doesn't save the orders if you edit them. To update the order you have to click on each bug type manually.

Fixed...updated the file, listed bug fixes and provided upgrade instructions in first post.

[jugo]

Great one DW. Thanks.

[Mone']

Great one DW. Thanks.

Installing right now :)

[hydrostatic]

funny thing is i don't have that hack installed nor would i touch it with a 10 foot pole.

Ok... anyways, it's not this hack that's causing it. I've even tried installing/uninstalling. Nothing. So it's probably something else you've installed.

Dark_Wizard: Thanks for the quick fix.

[Zelda-King]

Impressive fix. :) Looks fine and dandy now. I'll keep you posted if I discover anything else.

Even the style appears to have been coded correctly (no weird colours with my styles).

[Revan]

Your code lacks a check to see if the cache system functions properly.
Im getting foreach errors after something happened that I think broke the cache system (I dont have access to the table atm so I can't verify this), but you should code in a check to see if unserialize either fails or returns not an array, and also a rebuild function available in the main vbugs.php that will update the cache properly.
And yes, I did try saving all Statuses/etc.

PS: You should make an ACP option for the filename of the bugtracker, currently I have to rename it manually.

[Dark_Wizard]

Your code lacks a check to see if the cache system functions properly.
Im getting foreach errors after something happened that I think broke the cache system (I dont have access to the table atm so I can't verify this), but you should code in a check to see if unserialize either fails or returns not an array, and also a rebuild function available in the main vbugs.php that will update the cache properly.
And yes, I did try saving all Statuses/etc.

PS: You should make an ACP option for the filename of the bugtracker, currently I have to rename it manually.

Did you grab the latest file? There was a bug fix to the cache...

[Dan]

Did you grab the latest file? There was a bug fix to the cache...

Yea we tried that getting the same errors. Grabbed the latest batch uninstalled the old batch and reinstalled everything.

[The Wise One]

*installed

just one minor thing to note right off the bat...

right after install, but before user group permissions are set, when trying to set the vbug options, you are greeted with an error saying you dont have permission to do this and you should adujst admin settings. the link in the error takes you to the admin permissions under the usergroup menu but no settings are there to adjust permissions. the settings are in the administrators usergroup.

edit: sorry...didnt see that it was posted already

https://vborg.vbsupport.ru/showpost.php?p=779332&postcount=11

[Shack Networks]

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

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

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

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

Using vb3.05 RC2 Any idea on a fix pls

[Shack Networks]

Also just to add the options do not display either via the vbugs.php file..

[Gizmo5h1t3]

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

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

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

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

Using vb3.05 RC2 Any idea on a fix pls


gettin EXACTLY the same error when u click on the navbar link u create...
the page comes up, but all this is at the top of the screeen....any help plz??

BTW...im on RC3


also, when i try to add a test bug on the admin cp options, i get tyhis when i submit...

Invalid SQL:

INSERT INTO vbug
(title, description, vbug_statusid, vbug_severityid, vbug_versionid, vbug_typeid, postdate, lastedit, lastreplyuid, moderate, adminid, userid, private)
VALUES
('test bug', 'actual bug tracker page wont work?!?!?', 9, 1, 1, 2, 1127754962, 1127754962, , 0, 1, 0, 1);

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 ' 0, 1, 0, 1)' at line 4
Error Number : 1064
Date : Monday, September 26th 2005 @ 06:16:02 PM
Script : http://www.*********.co.uk/board//admincp/vbugs_admin.php
Referrer : http://www.*********.co.uk/board//admincp/vbugs_admin.php?do=add
IP Address : **.*.***.***
Username : Gizmo
Classname : vb_database


weird how the web address shows double slashes aftger "board"..????

[Dark_Wizard]

gettin EXACTLY the same error when u click on the navbar link u create...
the page comes up, but all this is at the top of the screeen....any help plz??

BTW...im on RC3


also, when i try to add a test bug on the admin cp options, i get tyhis when i submit...




weird how the web address shows double slashes aftger "board"..????

Fixed....file updated. Sorry for the delay been busy at work.

[Dark_Wizard]

*installed

just one minor thing to note right off the bat...

right after install, but before user group permissions are set, when trying to set the vbug options, you are greeted with an error saying you dont have permission to do this and you should adujst admin settings. the link in the error takes you to the admin permissions under the usergroup menu but no settings are there to adjust permissions. the settings are in the administrators usergroup.

edit: sorry...didnt see that it was posted already

https://vborg.vbsupport.ru/showpost.php?p=779332&postcount=11

This is not an error with this hack...this hack doesn't modify admin permissions for anything but vBug Tracker so you have an issue with another hack. Please chack your other hacks.

[timmed]

This is not an error with this hack...this hack doesn't modify admin permissions for anything but vBug Tracker so you have an issue with another hack. Please chack your other hacks.

I got the same thing on my production board that doesnt have any other hacks

[The Wise One]

This is not an error with this hack...this hack doesn't modify admin permissions for anything but vBug Tracker so you have an issue with another hack. Please chack your other hacks.
i dont think its a bug really. i think the url just needs changed in the error message to point to the correct page as it is pointing to "adminpermissions.php?do=modify". there are no settings to change for vbug on that page.

[Dark_Wizard]

I got the same thing on my production board that doesnt have any other hacks

Options/Settings are controlled by vBulletin permissions NOT vBug Tracker permissions...I have tested this over and over and I do not have any issues with this. Are you running RC3?

[timmed]

yes I do, here is a screenshot as well, I did fix this by going into the usergroup manager, this image is just to show the error

[Dark_Wizard]

yes I do, here is a screenshot as well, I did fix this by going into the usergroup manager, this image is just to show the error

That has nothing to do with the vBug Tracker settings...they are done inside the vboptions settings. The screen you see was normal as you need to set the permissions. Anyhow this has been updated in the new file so it sets the permissions ahead of time but ONLY FOR ADMINS, you have to change them for other usergroups.

[The Wise One]

getting this when trying to change permissions in the admin usergroup. i alter settings, hit update and get what is shown in the image below. the settings arent saved.

http://hel-razor.servegame.com/images/bug/vbug.gif

[The Wise One]

i dont think its a bug really. i think the url just needs changed in the error message to point to the correct page as it is pointing to "adminpermissions.php?do=modify". there are no settings to change for vbug on that page.
ok i think i get what you are saying. that is a default permissions error for vb. nevermind.

[The Wise One]

getting this when trying to change permissions in the admin usergroup. i alter settings, hit update and get what is shown in the image below. the settings arent saved.

http://hel-razor.servegame.com/images/bug/vbug.gif
*uninstalls

ill reinstall once this gets fixed.

[hydrostatic]

*uninstalls

ill reinstall once this gets fixed.

Rebuild bitfields... It's happened to me too.

[The Wise One]

Rebuild bitfields... It's happened to me too.
i was under the impression that the install process was to do this for you...or am i mistaken?

not sure how to manually rebuild bitfields.

[The Wise One]

nm. i found it in the how-to forum (nice writeup KirbyDE).

thanks hydrostatic. much appreciated.

*reinstalls

[Dark_Wizard]

i was under the impression that the install process was to do this for you...or am i mistaken?

not sure how to manually rebuild bitfields.

The install does rebuild the bitfields both during an install and also during an uninstall...you can check the coding!

Lastly...it's only you 2 that seem to be having this issue...you have a problem with another hack!

[Dan]

Found something that needs to be fixed.

Line 409

$adminlink = iif(($permissions['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canadminbugs']), "<a href=\"vbugs.php?do=edit&amp;vbug_id=" . $vbulletin->GPC['vbug_id'] . "\">[$vbphrase[vbug_edit_bug]]</a>", "<a href=\"vbugs.php?do=subscribe&amp;vbug_id=" . $vbulletin->GPC['vbug_id'] . "\">[$vbphrase[vbug_subscribe]]</a>");


As you can tell it doesn't use the new field you made to change the filename. But yea for now I manually changed it on my own but just so you know ;)

[The Wise One]

The install does rebuild the bitfields both during an install and also during an uninstall...you can check the coding!

Lastly...it's only you 2 that seem to be having this issue...you have a problem with another hack!
actually...i did look at the code and saw the neccessary code that rebuilds the bitfield. i disabled all other plugins and products before installing vbug tracker.

prior to this post and resulting fix:

https://vborg.vbsupport.ru/showpost.php?p=779852&postcount=45

the product worked fine for me as far as usergroup permissions until you updated to fix the above bug (which i also experienced).

not sure what else to say. the new upload you did, for some reason didnt rebuild the bitfields. doing it manually, as suggested by hydrostatic, fixed the issue.

[hydrostatic]

If you import the xml before you upload the files (like what I did because I was careless), then your bitfields won't be rebuilt. I think that's the issue. :) It's really no fault of anybody.

[The Wise One]

If you import the xml before you upload the files (like what I did because I was careless), then your bitfields won't be rebuilt. I think that's the issue. :) It's really no fault of anybody.
thanks for that bit of info. its very possible i may have done that. dont recall for sure though.

are you experiencing any issues with subscribing to a bug entry?

for me, when submitting a new bug and ticking the box for Subscribe, i get a DB error:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO vbug_subscribe (userid, vbug_id)
VALUES (1, );

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 2
Error Number : 1064
the bug is inserted fine, but the subscription doesnt take. when adding a response to an existing bug, and ticking the Subscribe box, i dont get an error...but the subscription doesnt take. nothing is entered, in either case, to the vbug_subscribe table. i verified this with phpmyadmin.

[Dark_Wizard]

If you import the xml before you upload the files (like what I did because I was careless), then your bitfields won't be rebuilt. I think that's the issue. :) It's really no fault of anybody.

That would be the issue. As stated in the install instructions:


2. Unzip the files to your forums directory as outlined in the zip file.

3. Open your admincp, select the Product Management System
(admincp->Plugin System->Manage Products) then select
Add/Import Product. Upload product-vBug_lite.xml.

4. Go to vBulletin options and set the vBug Tracker Options.


Instructions are provided for a reason and in a certain order to alleviate these types of problems.

Please update your posts and remove your fixes as you will confuse anyone downloading this hack.

[Dark_Wizard]

thanks for that bit of info. its very possible i may have done that. dont recall for sure though.

are you experiencing any issues with subscribing to a bug entry?

for me, when submitting a new bug and ticking the box for Subscribe, i get a DB error:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO vbug_subscribe (userid, vbug_id)
VALUES (1, );

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 2
Error Number : 1064
the bug is inserted fine, but the subscription doesnt take. when adding a response to an existing bug, and ticking the Subscribe box, i dont get an error...but the subscription doesnt take. nothing is entered, in either case, to the vbug_subscribe table. i verified this with phpmyadmin.

Fix is on the way...

[Shack Networks]

<a href="https://vborg.vbsupport.ru/showpost.php?p=779838&postcount=43" target="_blank">https://vborg.vbsupport.ru/showp...8&postcount=43</a>

Still need a fix for this if anyone wants to help a fatty

[Revan]

Found something that needs to be fixed.

Line 409

$adminlink = iif(($permissions['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canadminbugs']), "<a href=\"vbugs.php?do=edit&amp;vbug_id=" . $vbulletin->GPC['vbug_id'] . "\">[$vbphrase[vbug_edit_bug]]</a>", "<a href=\"vbugs.php?do=subscribe&amp;vbug_id=" . $vbulletin->GPC['vbug_id'] . "\">[$vbphrase[vbug_subscribe]]</a>");


As you can tell it doesn't use the new field you made to change the filename. But yea for now I manually changed it on my own but just so you know ;)Dark, ignore this message. This was Dan being a goddamn n00b and not realising I added that for the version we are running, since you ignored my suggestion about making bugtracker filename a vBOptions setting.

[Dan]

Oh ;) Sorry.

[Dark_Wizard]

Bug fixes and new file uploaded...please follow the instructions on upgrading in the first post.

[Gizmo5h1t3]

nope...still gettin the same error on my page..

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

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

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

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


and dont please make out im doing it wrong...i followed the instructions to the letter....and in the correct order.

[Dark_Wizard]

nope...still gettin the same error on my page..



and dont please make out im doing it wrong...i followed the instructions to the letter....and in the correct order.

Uninstall and reinstall...

[The Geek]

Uninstall and reinstall...

Working fine here.

Any way I can nudge you into putting in a handler for multiple products? (i.e. versions linked to a product and the product is selectable in the main page?)

Please ;)

[Dark_Wizard]

Working fine here.

Any way I can nudge you into putting in a handler for multiple products? (i.e. versions linked to a product and the product is selectable in the main page?)

Please ;)

This is in the Pro version only...

[Gryphon]

It doesn't appear that it uses permissions for secondary usergroups? At least I don't see their names in the drop down menu when assigning a bug.


There is still an error when submitting a bug from the admin panel which I see was reported earlier:
Invalid SQL:

INSERT INTO vb3_vbug
(title, description, vbug_statusid, vbug_severityid, vbug_versionid, vbug_typeid, postdate, lastedit, lastreplyuid, moderate, adminid, userid, private)
VALUES
('test', 'test', 1, 1, 1, 1, 1127851143, 1127851143, , 0, 4, 0, 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 ' 0, 4, 0, 0)' at line 4
Error Number : 1064

[The Wise One]

Bug fixes and new file uploaded...please follow the instructions on upgrading in the first post.
ok that fixed the subscribe issue when creating a new bug and subscribing. much thanks.

it is still not entering a subscription when adding a reply to an existing bug (that i am not originally subscribed to) into the vbug_subscribe table.

i am also still experiencing the DB error (the one listed in the post above) that Blackjack is experiencing when trying to add a bug from the ACP.

i dont see any options to delete certain responses in an existing bug (or edit). are these missing on purpose (only for inclusion into the pro version), are they there and im just not seeing them, or did you just not have time to put those features in yet?

[Gizmo5h1t3]

uninstalling and re installing worked...now works fine!!

[Dark_Wizard]

ok that fixed the subscribe issue when creating a new bug and subscribing. much thanks.

it is still not entering a subscription when adding a reply to an existing bug (that i am not originally subscribed to) into the vbug_subscribe table.

? Please clairfy as I'm not understanding what you mean.

i am also still experiencing the DB error (the one listed in the post above) that Blackjack is experiencing when trying to add a bug from the ACP.

Fixed...file will be uploaded shortly

i dont see any options to delete certain responses in an existing bug (or edit). are these missing on purpose (only for inclusion into the pro version), are they there and im just not seeing them, or did you just not have time to put those features in yet?

This is part of the Pro version...

[Boofo]

You can't edit or delete bugs existing bugs with this?

[The Wise One]

You can't edit or delete bugs existing bugs with this?
you can delete whole bugs only through the admin cp...but you cant edit or delete specific responses within an existing bug.

[The Wise One]

? Please clairfy as I'm not understanding what you mean.



Fixed...file will be uploaded shortly



This is part of the Pro version...
good deal on the fix. appreciated and awaiting the update.

for clarification on subscriptions:

if a user posts a bug in the tracker, and i go into the bug to add a response to the bug, i tick the box for Subscribe and hit submit to add my response. when doing this, all works as it should except my subscription isnt added.

[Dark_Wizard]

good deal on the fix. appreciated and awaiting the update.

for clarification on subscriptions:

if a user posts a bug in the tracker, and i go into the bug to add a response to the bug, i tick the box for Subscribe and hit submit to add my response. when doing this, all works as it should except my subscription isnt added.

Yep...found it...working on it now.

[Dark_Wizard]

You can't edit or delete bugs existing bugs with this?

Hey Boofo,

You can add, edit and delete bugs only through the admincp and responses cannot be edit with the Lite version. When deleting bugs in the admincp you also delete the responses as well.

The Pro version provides alot of functionality that the Lite version doesn't add and the list is large, you can add,edit and delete bugs as well as responses from the front end, you can also quote a response, add attachments and have the full editor based on what you have setup in your usercp, it supports multiple projects
and you can password protect projects etc.... This version was to mimic only what I could see at vbulletin.com and I converted it from my old 3.0.x hack and I really don't want to spend too much on this Lite version with all the enhancements I have done with the Pro version.

[Dark_Wizard]

Subscriptions rewritten and now works 100%! You can get the updated file from the first post and upgrade.

[The Wise One]

Subscriptions rewritten and now works 100%! You can get the updated file from the first post and upgrade.
perfect. works great now. adding a bug through ACP works now for me as well. much thanks and good work on this!

[off topic slightly]
i dont suspect you will be releasing your pro version of this until 3.5 goes gold. do you have a price set for it yet?
[/off topic slightly]

would you have any issues with someone adding in some functionality to the lite version (mainly just the editing and deleting)?

[Dark_Wizard]

perfect. works great now. adding a bug through ACP works now for me as well. much thanks and good work on this!

[off topic slightly]
i dont suspect you will be releasing your pro version of this until 3.5 goes gold. do you have a price set for it yet?
[/off topic slightly]

would you have any issues with someone adding in some functionality to the lite version (mainly just the editing and deleting)?

1. Thanks.
2. Not yet...
3. I would rather you didn't for obvious reasons.

[The Wise One]

running accross another issue here. not sure if it is a bug or something on my end...but here is what i am getting:

Problems with this Web page might prevent it from being displayed properly or functioning properly. In the future, you can display this message by double clicking the warning icon displayed in the status bar.

Line: 592
Char: 2
Error: 'document.cpform.description.value' is null or not an object
Code: 0
URL: /vbugs.php?do=edit&vbug_id=6
i get the above popup error when editing a bug (like changing status or severity). this happens in IE6. get the same error in FF 1.0.6 and 1.5 beta 1 except it states Line: as 539

[The Wise One]

1. Thanks.
2. Not yet...
3. I would rather you didn't for obvious reasons.
3. of course. understood. wasnt sure if you would allow it if it was kept private but i will respect your wishes.

[Revan]

3. I would rather you didn't for obvious reasons.I hope this isn't an attempt at preventing us from hacking in any functionality?
Because Im gonna modify this hack to suit my needs for my board, and Id prefer not having to do a complete recode to be able to add/remove what functionality I wish.

[Dark_Wizard]

I hope this isn't an attempt at preventing us from hacking in any functionality?
Because Im gonna modify this hack to suit my needs for my board, and Id prefer not having to do a complete recode to be able to add/remove what functionality I wish.

You can hack what you want for your needs but you cannot release it.

[Revan]

Ah, good. I just wanted to make sure you wasnt going to enforce some stupid TOS for using your hack :)

[theArchitect]

I am getting this error when I install the product.

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

I intially thought that it was because I use to run the bug tracker under 3.0 so I went in and removed all of the vbug tables from the DB and then tried the install again and got the same error.

[Gizmo5h1t3]

I am getting this error when I install the product.

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

I intially thought that it was because I use to run the bug tracker under 3.0 so I went in and removed all of the vbug tables from the DB and then tried the install again and got the same error.
TRY totally uninstalling the hack....everything, and re install the newer version, allowing overwrites just in case...it works fine now m8.

[twitch]

Nice work

[Guest190829]

* Guest190829 installs, nice job. :)

[theArchitect]

This is not working for me.

I have now upgraded to Gold and I removed every trace of vBug from my system, and deleted the MySQL tables.

When I install it I get the same error message

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

But now, when I try and go to the vbugs.php page instead of it being blank I get this error

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT DISTINCT vbug_severity.title AS svtitle, vbug_type.title AS ttitle, vbug_version.title AS vtitle, vbug_status.title AS stitle, vbug.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbug AS vbug
LEFT JOIN vbug_status AS vbug_status ON (vbug.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN user AS admin ON (vbug.adminid = admin.userid)
LEFT JOIN user AS user ON (vbug.userid = user.userid)
LEFT JOIN user AS lastreply ON (vbug.lastreplyuid = lastreply.userid)
LEFT JOIN vbug_type AS vbug_type ON (vbug.vbug_typeid = vbug_type.vbug_typeid)
LEFT JOIN vbug_version AS vbug_version ON (vbug.vbug_versionid = vbug_version.vbug_versionid)
LEFT JOIN vbug_severity AS vbug_severity ON (vbug.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
Error Number : 1064

Any thoughts would be apprecaited as I would like to have this hack on my board.

[jesus likes pie]

Thanks.

[jesus likes pie]

Hm it says I dont have permission.....but when I go to adminpermissions, I cant see any part about bugs or anything. Plus, everything is set to yes.

Any ideas?

[jesus likes pie]

nevermind. I fixed it by deleting the product and adding it again.

[Dark_Wizard]

This is not working for me.

I have now upgraded to Gold and I removed every trace of vBug from my system, and deleted the MySQL tables.

When I install it I get the same error message

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

But now, when I try and go to the vbugs.php page instead of it being blank I get this error

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT DISTINCT vbug_severity.title AS svtitle, vbug_type.title AS ttitle, vbug_version.title AS vtitle, vbug_status.title AS stitle, vbug.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbug AS vbug
LEFT JOIN vbug_status AS vbug_status ON (vbug.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN user AS admin ON (vbug.adminid = admin.userid)
LEFT JOIN user AS user ON (vbug.userid = user.userid)
LEFT JOIN user AS lastreply ON (vbug.lastreplyuid = lastreply.userid)
LEFT JOIN vbug_type AS vbug_type ON (vbug.vbug_typeid = vbug_type.vbug_typeid)
LEFT JOIN vbug_version AS vbug_version ON (vbug.vbug_versionid = vbug_version.vbug_versionid)
LEFT JOIN vbug_severity AS vbug_severity ON (vbug.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
Error Number : 1064

Any thoughts would be apprecaited as I would like to have this hack on my board.

This has been tested on 3 boards that were RC3 and upgraded with no issues. Also to uninstall this you should have gone through the Plugin System -> Manage Products....my suggestion is to install and then uninstall then install again and see what happens.

[theArchitect]

This has been tested on 3 boards that were RC3 and upgraded with no issues. Also to uninstall this you should have gone through the Plugin System -> Manage Products....my suggestion is to install and then uninstall then install again and see what happens.I am sorry, I wasn't doubting the competency of your coding and certainly not insinuating that there was something wrong with your product. But there is clearly a problem with the way in which my board is processing this hack (I should add that I have installed this onto a fresh test board with no problems at all. It just won't work on my live board).

I have used the product manager to uninstall this hack and then re-installed it using the overwrite option. but am still getting the same error:


Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

I was merely wondering if you might have had a solution to get around this problem so that I could use your excellent system.

[Dark_Wizard]

I am sorry, I wasn't doubting the competency of your coding and certainly not insinuating that there was something wrong with your product. But there is clearly a problem with the way in which my board is processing this hack (I should add that I have installed this onto a fresh test board with no problems at all. It just won't work on my live board).

I have used the product manager to uninstall this hack and then re-installed it using the overwrite option. but am still getting the same error:


Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062

I was merely wondering if you might have had a solution to get around this problem so that I could use your excellent system.

I can help if you provide the following in a PM:


* admincp access
* mysql access
* url where the hack is used

[ozmazdaclub]

how do i change the bug version from test to something else?

[ozmazdaclub]

Ignore my last post i found it... thanks!

[twitch]

If I try to delete one of the "statuses" in the admin panel, I get the following database error


Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT *
FROM vbug_status
WHERE vbug_statusid = 12;

MySQL Error : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date : Thursday, October 6th 2005 @ 01:18:48 PM
Script : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address : 206.174.3.123
Username : |s2tg|twitch
Classname : vb_database

[twitch]

Also, how would I go about changing the link text on the vgub page "submite bug" to be an image instead of text? Where would I edit for that?

Great job on vbugtracker!

[majorxp]

This working ok on gold?

[ozmazdaclub]

Yes i have it running on my vb3.5.0 Gold board with no problems

[twitch]

If I try to delete one of the "statuses" in the admin panel, I get the following database error


Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT *
FROM vbug_status
WHERE vbug_statusid = 12;

MySQL Error : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date : Thursday, October 6th 2005 @ 01:18:48 PM
Script : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address : 206.174.3.123
Username : |s2tg|twitch
Classname : vb_database


Thats the only unfixed problem I have found

[ozmazdaclub]

any chance you can get the tracker to email an email address when a new bug is added or any bug is updated?

[Whissi]

any chance you can get the tracker to email an email address when a new bug is added or any bug is updated?Yes! It would be nice If admins could configure vbug to report ne bug-reports.

User with bug-report subscription receiv their own answer... that's not good.

Another thing:

Line-breaks looks like "\r\n"
Option to edit bugs
WYSIWYG Support :nervous:

[Dark_Wizard]

Yes! It would be nice If admins could configure vbug to report ne bug-reports.

User with bug-report subscription receiv their own answer... that's not good.

Another thing:

Line-breaks looks like "\r\n"
Option to edit bugs
WYSIWYG Support :nervous:


This as well as many, many other enhancements is in the Pro version which will be released on vb-scripts.com when complete.

[theArchitect]

Nevermind... I figured it out.

In process of testing.

I have got it working (YA).

Though, the images seem a little strange. It is drawing the online and offline images to display the status of a bug. Are the alternate images? Or should I just make my own?

[HMBeaty]

I keep getting this when I change the settings in the "Usergroup Permissions" for vbug.....

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

Any help please?

[DS MrSinister]

looks like the same error i got with a another hackd and used this

try this it should fixd your problem




admincp/index.php?do=buildbitfields

[ManagerJosh]

looks like the same error i got with a another hackd and used this

try this it should fixd your problem




admincp/index.php?do=buildbitfields



Any chance there's a demo version floating around? :)

[DS MrSinister]

Any chance there's a demo version floating around? :)



http://www.sinisterslair.com/forums/vbugs.php

[Sparkz]

If I try to delete one of the "statuses" in the admin panel, I get the following database error


Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT *
FROM vbug_status
WHERE vbug_statusid = 12;

MySQL Error : Table 'clanvdqa_slave.vbug_status' doesn't exist
Error Number : 1146
Date : Thursday, October 6th 2005 @ 01:18:48 PM
Script : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=removestatus&vbug_statusid=12
Referrer : http://www.s2tg.com/forum/admincp/vbugs_admin.php?do=modifystatus
IP Address : 206.174.3.123
Username : |s2tg|twitch
Classname : vb_database


The fix here is to find
$status = $db->query_first("
SELECT *
FROM vbug_status
WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
");

and change that to
$status = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "vbug_status
WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
");

The code in question is around line 711 in admincp/vbugs_admin.php

[twitch]

Awesome, thank you for helping me out!

[Whissi]

...if you fill out an bugreport and put special signs like "&" in the title, these signs aren't converted... so you are getting an xhtml error ;)

Nothing special to fix it... but I think you should fix it :)

[ART]

The fix here is to find
$status = $db->query_first("
SELECT *
FROM vbug_status
WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
");

and change that to
$status = $db->query_first("
SELECT *
FROM " . TABLE_PREFIX . "vbug_status
WHERE vbug_statusid = " . $vbulletin->GPC['vbug_statusid'] . "
");

The code in question is around line 711 in admincp/vbugs_admin.php

a Table_prefix should also be added in the query around line 895 (in the "removeseverity" section) if we want this functionality ;)

in some templates the $session[sessionurl] / $session[sessionurl_q] is missing. And this is needed if a user's browser does not accept cookies.

with some little fixes vBug-lite works quite fine for me :) Thanks Dark_Wizard!

(me clicks install :D )

[timmed]

I've just upgraded to 3.5.1 and now this isn't working, the permissions are gone from the usergroup menus.

[Dark_Wizard]

I've just upgraded to 3.5.1 and now this isn't working, the permissions are gone from the usergroup menus.

Strange...let me get back to you as I will upgrade now myself.

[hydrostatic]

Strange...let me get back to you as I will upgrade now myself.

It's the product thing that's wrong... If you change it to "vbulletin" it works fine...

[timmed]

on a whim I took a look at the bitfield file for this hack, and another one thats working right, the product listed in this hacks bitfield is "vbugs" the one for the other is "vbulletin".

I made the edit and it works now.

[ManagerJosh]

Can this support multiple products? :) Or just one...

I need one that can support multiple products.

[Xplorer4x4]

It's the product thing that's wrong... If you change it to "vbulletin" it works fine...

I changed my product to vBulletin in the drop menu, yet it still does not work. No setting show up in user group nor are am I able to access the script. It gives me the typical permisions message.

[Ranma2k]

I changed my product to vBulletin in the drop menu, yet it still does not work. No setting show up in user group nor are am I able to access the script. It gives me the typical permisions message.

i had the same problem

to solve it
just edit the file bitfield_vbug.xml under /includes/xml/

and change

<bitfields product="vbug">


to


<bitfields product="vBug">

[Ranma2k]

i had the same problem

to solve it
just edit the file bitfield_vbug.xml under /includes/xml/

and change

<bitfields product="vbug">


to


<bitfields product="vBug">


forgot to mention that it's only happen when installed it on vb 3.5.1

[Xplorer4x4]

i had the same problem

to solve it
just edit the file bitfield_vbug.xml under /includes/xml/

and change

<bitfields product="vbug">


to


<bitfields product="vBug">


Wouldn;t it be easier to just change it in the vBug options? the option for version was set to vBug, so wouldn;t changing the version to vbug work alot easier? ;)

Also I think i can find this myself but if not, I want to change a few of the options in the drop down menu. For example There is no need for members to have Admin CP has an option lol, so I want to put an if condition around it for admins to see, not members. Plus I want to add an option or two.

[jluerken]

Thats the only unfixed problem I have found


In /admincp/vbugs_admin.php (~Line 63)

find:
FROM vbug_status

change to:
FROM " . TABLE_PREFIX . "vbug_status

[jluerken]

I found a small bug:

I added an additional usergroup and set this group as secondary group to some of my users.
Those users should be allowed to administrate bugs.

I gave the rights to that group but it is not working.
I cannot select people from this group to assign them calls.

It is working when I make this group a primary usergroup but I can't do this.

Please Dark_Wizard, how can I make also Secondary Usergroups work?

[SilverDawn]

I keep getting the below error when I do the "Add/Import Product" step. I did have the vBug Tracker 1.0.3 for vb 3.0 previously.

Any ideas?

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'vbug_bugsperpage',
'vbug',
'15',
'15',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==5,\'selected=\"selected\"\') . \">5</option>\r\n<option value=\\\"10\\\" \" . iif($setting[\'value\']==10,\'selected=\"selected\"\') . \">10</option>\r\n<option value=\\\"15\\\" \" . iif($setting[\'value\']==15,\'selected=\"selected\"\') . \">15</option>\r\n<option value=\\\"20\\\" \" . iif($setting[\'value\']==20,\'selected=\"selected\"\') . \">20</option>\r\n</select>',
10,
0,
1,
'vBug'
),
(
'vbug_status',
'vbug',
'1',
'1',
'free',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\" . eval(\'$states = $vbulletin->db->query_read(\"SELECT vbug_statusid, title FROM \" . TABLE_PREFIX . \"vbug_status\");\r\nwhile ($state = $vbulletin->db->fetch_array($states))\r\n{\r\n $options .= \"<option value=\\\"$state[vbug_statusid]\\\" \" . iif($setting[\\\'value\\\']==$state[\\\'vbug_statusid\\\'],\\\'selected=\"selected\"\\\') . \">$state[title]</option>\";\r\n}\r\nreturn $options;\') . \"</select>',
20,
0,
1,
'vBug'
),
(
'vbug_bug_moderate',
'vbug',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'vBug'
),
(
'vbug_versionname',
'vbug',
'vBug',
'vBug',
'',
'',
40,
0,
1,
'vBug'
),
(
'vbug_admin_legend',
'vbug',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'vBug'
);

MySQL Error : Duplicate entry 'vbug_status' for key 1
Error Number : 1062
Date : Saturday, November 5th 2005 @ 01:28:04 PM
Script : http://dfrsquad.com/forums/phpsuper/plugin.php
Referrer : http://dfrsquad.com/forums/phpsuper/plugin.php?do=productadd
IP Address : 24.243.43.250
Username : dfr.sd
Classname : vb_database

[Dark_Wizard]

I keep getting the below error when I do the "Add/Import Product" step. I did have the vBug Tracker 1.0.3 for vb 3.0 previously.

Any ideas?

There wasn't an updater included with this thus your error. Contact me via IM and I will help you through removing the old version so you can install the new version.

[Dark_Wizard]

I found a small bug:

I added an additional usergroup and set this group as secondary group to some of my users.
Those users should be allowed to administrate bugs.

I gave the rights to that group but it is not working.
I cannot select people from this group to assign them calls.

It is working when I make this group a primary usergroup but I can't do this.

Please Dark_Wizard, how can I make also Secondary Usergroups work?

I will look into this....

[theArchitect]

I have just upgraded to 3.5.1 and the uptions under User Groups to set if members can see/add etc. bugs have vanished.

I checked and the bitfield_vbug.xml file is in the includes directory. I have even re-imported the Product but still nothing.

[Dark_Wizard]

I have just upgraded to 3.5.1 and the uptions under User Groups to set if members can see/add etc. bugs have vanished.

I checked and the bitfield_vbug.xml file is in the includes directory. I have even re-imported the Product but still nothing.

Upgrade coming in about 15mins....

[Dark_Wizard]

New version released, sorry for the delay as I have been very busy lately.

[theArchitect]

New version released, sorry for the delay as I have been very busy lately.

The user group permissions have appeared ok, but I am getting this error message when I go to vbugs.php:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid, username
FROM user
WHERE usergroupid IN(5,6)
OR FIND_IN_SET(5,6, membergroupids);

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 ' membergroupids)' at line 4
Error Number : 1064

[Dark_Wizard]

The user group permissions have appeared ok, but I am getting this error message when I go to vbugs.php:

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT userid, username
FROM user
WHERE usergroupid IN(5,6)
OR FIND_IN_SET(5,6, membergroupids);

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 ' membergroupids)' at line 4
Error Number : 1064

One sec...looking into it. Stick around

[theArchitect]

One sec...looking into it. Stick around

I may have to catch your next update in the morning. I have the Flu, it is 12:23 am here and I have been working for the last 16 hours; so I don't know if I can keep my eyes open much longer.

[Dark_Wizard]

Ok...here was the issue, I wrote the coding for PHP 5.x/MySQL 4.x and forgot about backward compatability. It is now fixed so you can now download the new file.

[timmed]

I cannot assign anyone bugs if they have more than 1 secondary usergroup. I've created a usergroup so they can administer bugs, but if they are assigned to another one as well, it doesnt work.

Also, is there a way to edit a bug and leave it unassigned?

[theArchitect]

Ok...here was the issue, I wrote the coding for PHP 5.x and forgot about backward compatability. It is now fixed so you can now download the new file.

Many thanks. Installed and working as designed.

[Mone']

Many thanks. Installed and working as designed.

Hi Dark_Wizard,
any update on the PRO Version?
I've been checking your site and the pro version features are much better

[Dark_Wizard]

I cannot assign anyone bugs if they have more than 1 secondary usergroup. I've created a usergroup so they can administer bugs, but if they are assigned to another one as well, it doesnt work.

Also, is there a way to edit a bug and leave it unassigned?

So your saying you have more than one usergroup/secondary group that has admin rights to bugs?

You can edit the bug in the admincp.

[Dark_Wizard]

Hi Dark_Wizard,
any update on the PRO Version?
I've been checking your site and the pro version features are much better

Due to the extent of the features in the Pro version this is taking longer than anticipated, just keep checking the site as I won't commit or comment on any dates.

[Mone']

Due to the extent of the features in the Pro version this is taking longer than anticipated, just keep checking the site as I won't commit or comment on any dates.

will do :)
so far our user are enjoying the lite version and making life easier on our website

[timmed]

So your saying you have more than one usergroup/secondary group that has admin rights to bugs?

You can edit the bug in the admincp.

Here is an example of a user on the board

they usually have their primary usergroup as registered users
Secondary usergroups are based on what forums they can view, some can have as many as 5 or 10 different ones.

I currently have the administrator usergroup and a second one that can administer bugs. What I found is that if I put someone in that second group, and they have other secondary usergroups, they wont be able to be assigned to a bug. However, if they don't have another secondary usergroup they will be able.

[Dark_Wizard]

Here is an example of a user on the board

they usually have their primary usergroup as registered users
Secondary usergroups are based on what forums they can view, some can have as many as 5 or 10 different ones.

I currently have the administrator usergroup and a second one that can administer bugs. What I found is that if I put someone in that second group, and they have other secondary usergroups, they wont be able to be assigned to a bug. However, if they don't have another secondary usergroup they will be able.

Ok...will look into it.

[majorxp]

For what it is worth, I have the exact same configuration as timmed (although I have been still holding out actually running this on my live server).

[Mone']

Hi Dark_Wizard,
when you have a moment could you have a look at the subscription code on the 3.5.1 version.

When a user tick the subscribe box and post a reply to a bug, instead of showing the reply to the bug it goes to a blank page and no subscription are placed in the user subscription.

Cheers

Mone'

[The Wise One]

Hi Dark_Wizard,
when you have a moment could you have a look at the subscription code on the 3.5.1 version.

When a user tick the subscribe box and post a reply to a bug, instead of showing the reply to the bug it goes to a blank page and no subscription are placed in the user subscription.

Cheers

Mone'
i get the same thing. no subscription and a blank page. though the reply gets posted (at least in my case).

[Mone']

i get the same thing. no subscription and a blank page. though the reply gets posted (at least in my case).

same here, the reply get posted but it confuse the hell out of my users :P

[theArchitect]

i get the same thing. no subscription and a blank page. though the reply gets posted (at least in my case).

Yep, I meant to post that too. I don't get notified when a new reply is posted.

[Dark_Wizard]

Hi Dark_Wizard,
when you have a moment could you have a look at the subscription code on the 3.5.1 version.

When a user tick the subscribe box and post a reply to a bug, instead of showing the reply to the bug it goes to a blank page and no subscription are placed in the user subscription.

Cheers

Mone'

Will do...

[Mone']

Will do...

I'm also happy if you release your pro paid version............. hint , hint ;P
Cheer for the great hack

[MPDev]

Looks great - looking forward to seeing the pro version. One fix for bugs.php:

if ($vbulletin->GPC['vbug_versionid'])
{
$condition .= " AND vbug.vbug_versionid = " . $vbulletin->GPC['vbug_versionid'] . "";
}

Also notice an empty <span> tag in list template that is unecessary.

Probably not a bug, but seems if you edit a ticket, it assigns it to the first person in the dropdown, not leaving you the chance to leave it unassigned.

[Dark_Wizard]

Looks great - looking forward to seeing the pro version. One fix for bugs.php:

if ($vbulletin->GPC['vbug_versionid'])
{
$condition .= " AND vbug.vbug_versionid = " . $vbulletin->GPC['vbug_versionid'] . "";
}

Also notice an empty <span> tag in list template that is unecessary.

Probably not a bug, but seems if you edit a ticket, it assigns it to the first person in the dropdown, not leaving you the chance to leave it unassigned.

Thanks for the find, fixed and file updated.

[The Wise One]

thanks for the update. did you have any luck with this by chance?

https://vborg.vbsupport.ru/showpost.php?p=824098&postcount=152

and i keep getting this error when ever i try to edit a bug. it only appears when i submit the edit. it doesnt appear to affect anything as the edits are applied...but it continues to pop up.

line: 429
char: 2
error: 'document.cpform.description.value' is null or not an object
code: 0
URL: vbugs.php?do=edit&vbug_id=(X)

the id in the vbug doesnt matter as it happens regardless of which bug i try to edit.

[King Kovifor]

I edited everything, will I know have to reedit it?

[Dark_Wizard]

thanks for the update. did you have any luck with this by chance?

https://vborg.vbsupport.ru/showpost.php?p=824098&postcount=152

and i keep getting this error when ever i try to edit a bug. it only appears when i submit the edit. it doesnt appear to affect anything as the edits are applied...but it continues to pop up.

line: 429
char: 2
error: 'document.cpform.description.value' is null or not an object
code: 0
URL: vbugs.php?do=edit&vbug_id=(X)

the id in the vbug doesnt matter as it happens regardless of which bug i try to edit.

I cannot reproduce this, please give me the steps in which you followed to produce this.

[Dark_Wizard]

I edited everything, will I know have to reedit it?

Can you tell me what you edited so I can guide you?

[The Wise One]

I cannot reproduce this, please give me the steps in which you followed to produce this.
subscribe problem

1. click on "Submit New Bug".
2. fill in the fields (from top to bottom).
3. tick the "Subscribe" box.
4. click submit.

popup error

1. click on any bug from the list.
2. click on "Edit Bug".
3. make any change (series of changes...doesnt matter).
4. hit the submit button.

[Dark_Wizard]

subscribe problem

1. click on "Submit New Bug".
2. fill in the fields (from top to bottom).
3. tick the "Subscribe" box.
4. click submit.

popup error

1. click on any bug from the list.
2. click on "Edit Bug".
3. make any change (series of changes...doesnt matter).
4. hit the submit button.


Are you doing this as an admin or end user?

[Todi]

One thing i miss is the ability to edit/remove responses. Is that intended for the "Lite" version at all (or have i missed it somewhere?), or do i have to fix it myself?

[King Kovifor]

I Changed it from vBug.php to bugs.php - and the templates to inlude that.

[Dark_Wizard]

I Changed it from vBug.php to bugs.php - and the templates to inlude that.

Why?

[King Kovifor]

That's what the owner wanted, and it's currently down... so no big rush.

[The Wise One]

Are you doing this as an admin or end user?
as an admin. no other usergroup is setup to admin bugs.

[OneShot]

Nice Hack - clicks Install. One thing tho, and that has been mentioned before - Users who have more then one secondary Usergroup don't show up as expected in the "To Assign" Dropdown box. Only if they are selected as Primary Users for the Usergroup who can admin vBugs. And out of whatever reasons the cpnav_vbug.xml did not work with my ACP. I did some little fixes and now everything is perfect and works.

[boeserwolf]

Hi,

When will you roll out the Pro-Version of your bug-tracker hack?

I am very interested in this because I would need it for my software support forum.

And: How much will the Pro version cost? approximately?

yours

Markus

[Dark_Wizard]

Nice Hack - clicks Install. One thing tho, and that has been mentioned before - Users who have more then one secondary Usergroup don't show up as expected in the "To Assign" Dropdown box. Only if they are selected as Primary Users for the Usergroup who can admin vBugs. And out of whatever reasons the cpnav_vbug.xml did not work with my ACP. I did some little fixes and now everything is perfect and works.

It completely slipped my mind. This will be resolved in the next update within the next couple of days.

[Reynaldovb]

It would be nice if along of so many changes and additions an everything, you would include some info about what this mod is about.

[Mone']

Hi Dark_Wizard,
when you have a moment could you have a look at the subscription code on the 3.5.1 version.

When a user tick the subscribe box and post a reply to a bug, instead of showing the reply to the bug it goes to a blank page and no subscription are placed in the user subscription.

Cheers

Mone'Will Do...

don't want to be pushy just hoping you have not forgot about this problem :P

Thank you buddy

[Todi]

I'm having a layout issue when viewing the tracker in Firefox. Can someone perhaps give me a tip of how to resolve it? It's the float:right property that doesn't want to work like it should (or is it IE that shows it wrong?).

As one can see on the screenshot below, the date/time the bug was added doesn't want to line up with the bug name properly.

[OneShot]

Try this Template ... Its the modified vbug_listbit Template. Just copy & paste. If you use the Black & Gold 3.5 style I can even give you another Template mod and the fitting images for it.

Cheers
OS

[King Kovifor]

question: Which phrase is used for this:

phrase: vbug_indicate_moderate
text: Indicates moderated bug.

phrase: vbug_indicates_moderate_bug
text: Indicates Moderated Bug

Why do you need BOTH of these?

[denjiro]

Nevermind... I figured it out.

In process of testing.

Nice mod! thanks. The installation is very easy.
But i just uninstall it because i can't find anyway to customize.

How do i set multiple product? perhaps like vbulletin.com forum.

How to setup product's version. It keep says 'Test' in drop down. Is it suppose to be like '3.0', '3.5' ... right?

[Todi]

Thanks OneShot, that template worked much better for me =)

[lanc3lot]

Hello:)
Is there any info oridea if this will be updated so it can fix bugs like the white page bug that occurs when u post a reply in a bug?
I ask so i can know when i will install it:)

[tommykjensen]

Suggestion:

Would You consider adding a field to link to an exiting thread?

Of course it is possible to use the vbCode threadid in the text to link to it but for inexperinced users it might be easier for them to use the extra field rahter that remember the vbCode.

[Dark_Wizard]

Hello:)
Is there any info oridea if this will be updated so it can fix bugs like the white page bug that occurs when u post a reply in a bug?
I ask so i can know when i will install it:)

I am not seeing that issue but will look into anything that could cause it.

[lanc3lot]

I am not seeing that issue but will look into anything that could cause it.


Ok i test it again, the error is when u subscribe to a bug.

I test it at v3arcade vbug page, and it happens all the time. I assume its not v3arcade fault but of the script itself :)

[lanc3lot]

Hello again. I have also another problem. When a new bug is posted, it seems that where it says "Tittle, submitted by and date", in the bug under, it show everything opposite. First it has the submitted by, after it has the date and last the title :(

How can i fix this ?

(see the picture for more info)


Thnx again

[MThornback]

Here is an example of a user on the board

they usually have their primary usergroup as registered users
Secondary usergroups are based on what forums they can view, some can have as many as 5 or 10 different ones.

I currently have the administrator usergroup and a second one that can administer bugs. What I found is that if I put someone in that second group, and they have other secondary usergroups, they wont be able to be assigned to a bug. However, if they don't have another secondary usergroup they will be able.


DW, any luck on this? I'm having the same issue :)

[Noxious]

right i just tried to install this 3 times following whats said in the install.txt file and i can't get vbug to show in the admin permissions list so i can't admin it.

I've got the latest downloable version from this thread and using vBulltin 3.5.2

to install
1. Uploaded the files to the correct places
2. installed the plugin via the admin cp, using the xml file

The menu for vBug appears, i just can't get access to it as its not showing on the admin permissions. I would change it on the database but not sure what the page is looking for to allow access

can anyone help??

Regards Nox

[Noxious]

nevermind guys, solved it myself

g8 plugin dude

[Whissi]

The problem... withvbugs.php?do=subscribe&vbug_id=3is still present. You will get a white page and no subcribtion will be added.

[lanc3lot]

I believe that the hack is abandoned and not supported anymore...Its been days that problems like this have been mentioned...

Anyway, he may be busy:)

[King Kovifor]

I'm not using the title, vbugs.php. But I've gone THROUGH All templates, and changed, vbugs.php -> bugs.php. What's wrong? Navbar, submitting (It gets submitted though), and things like that.

[Dan]

did you go through the php file?

[King Kovifor]

Explain...

[Dan]

Open bugs.php and replace vbugs.php with bugs.php

[King Kovifor]

Every instance? So that means all my upgrades I'd have to do that? And I'd also have to edit the templates?!

[Dan]

Only when you upgrade this hack (if there is ever another update)

[King Kovifor]

OK. I'll get right on that!

[rwoelich]

Just a note that I'm having some issues with this. I uninstalled it after designing my own bug reporting system, and for some reason the rows for the vBug settings in the usergroup editor still show up, just without phrases, and when I go to make changes to a usergroup I get a database error because it's trying to save vBug settings to a column that doesn't exist anymore. I can't for the life of me figure out where the settings table row is coming from or the part with that query. Any ideas?

Edit: Never mind. Damn bitfields... :p

[Xplorer4x4]

I have a forum set up to redirect to bugs.php. Members must log in again before using it.

[Xplorer4x4]

Also I thought there was some sort of ntoification system built in?

[PalmNut]

Seems to be a bug with the moderation system. Even with the moderation option set to "Yes," all bugs submitted via vbugs.php are live for all users to see. I found a couple of issues in the code that address this. The vbugs.php is looking for the wrong option setting and bug moderation value, cleaning some global variables unnecessarily in the process.

Details for editing:

Starting at line 650 in
$vbulletin->input->clean_array_gpc('p', array(
'title' => TYPE_STR,
'vbug_typeid' => TYPE_UINT,
'vbug_versionid' => TYPE_UINT,
'vbug_severityid' => TYPE_UINT,
'vbug_statusid' => TYPE_UINT,
'description' => TYPE_STR,
'moderate' => TYPE_UINT,
'subscribe' => TYPE_UINT
));
remove
'vbug_statusid' => TYPE_UINT, and 'moderate' => TYPE_UINT,Then immediately below find if($vbulletin->options['vbug_moderated']) and change the line to if($vbulletin->options['vbug_bug_moderate'])
Below that find $db->query_write("
INSERT INTO " . TABLE_PREFIX . "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $db->escape_string($vbulletin->GPC['title']) . "', '" . $db->escape_string($vbulletin->GPC['description']) . "', " . $vbug_statusid . ", '" . TIMENOW . "', " . $vbulletin->GPC['vbug_severityid'] . ", " . $vbulletin->GPC['vbug_typeid'] . ", " . $vbulletin->GPC['vbug_versionid'] . ", " . $vbulletin->GPC['moderate'] . ", " . TIMENOW . ", " . $vbulletin->userinfo['userid'] . ")
");
and replace with
$db->query_write("
INSERT INTO " . TABLE_PREFIX . "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $db->escape_string($vbulletin->GPC['title']) . "', '" . $db->escape_string($vbulletin->GPC['description']) . "', " . $vbug_statusid . ", '" . TIMENOW . "', " . $vbulletin->GPC['vbug_severityid'] . ", " . $vbulletin->GPC['vbug_typeid'] . ", " . $vbulletin->GPC['vbug_versionid'] . ", " . $moderate . ", " . TIMENOW . ", " . $vbulletin->userinfo['userid'] . ")
");

[timmed]

It completely slipped my mind. This will be resolved in the next update within the next couple of days.

has there been any word on this update? I really need the ability to assign people with multiple usergroups to certain bugs.

[Todi]

PalmNut is correct, the bug won't be displayed in the listing, but it can still be viewed if you know the id (which is easy to guess).

Edit:

I wrote a fix:

vbugs.php

on line 401, between

$vbug_statusid = $bug['vbug_statusid'];

and

$assigned = iif($bug['adminid'], $bug['adminname'], $vbphrase['vbug_unassigned']);

add

if ($bug['private'] && !($permissions['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canadminbugs']))
{
$vbulletin->url = "vbugs.php?do=list";
eval(print_standard_redirect('redirect_postthanks' ));
}

Not sure if it's the best solution, but it works for me anyway, but it probably depends on who can admin your bugs?

Btw, found a bug (irony) in vbugs.php:

line 368, change

if (empty($exists))
{
$url = "vbugs.php?do=list";
eval(print_standard_redirect('redirect_postthanks' ));
}

to

if (empty($exists))
{
$vbulletin->url = "vbugs.php?do=list"; // $vbulletin->url
eval(print_standard_redirect('redirect_postthanks' ));
}


Otherwise it won't redirect to the correct place if the bug id doesn't exist, it will redirect to forumhome instead it seems. Minor, but irritating.

[PalmNut]

I wrote a fix:Good work. I'll use your fix for the private bug gap, which I didn't notice. To keep moderated bugs away from non-admins, the following (very similar) piece of code in vbugs.php works.

After:

if ($bug['private'] && !($permissions['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canadminbugs']))
{
$vbulletin->url = "vbugs.php?do=list";
eval(print_standard_redirect('redirect_postthanks' ));
}
Add:

if ($bug['moderate'] && !($permissions['vbugpermissions'] & $vbulletin->bf_ugp['vbugpermissions']['canadminbugs']))
{
$vbulletin->url = "vbugs.php?do=list";
eval(print_standard_redirect('redirect_postthanks' ));
}

[PalmNut]

Well, now I see that Todi's private check would work when the privacy flag is set from the admin panel, but doesn't do anything for bugs created from vbugs.php, which doesn't even insert data for that column.

So..... starting at line 650, assuming you've made my changes above for moderation, find:
$vbulletin->input->clean_array_gpc('p', array(
'title' => TYPE_STR,
'vbug_typeid' => TYPE_UINT,
'vbug_versionid' => TYPE_UINT,
'vbug_severityid' => TYPE_UINT,
'description' => TYPE_STR,
'subscribe' => TYPE_UINT
));
and replace with: $vbulletin->input->clean_array_gpc('p', array(
'title' => TYPE_STR,
'vbug_typeid' => TYPE_UINT,
'vbug_versionid' => TYPE_UINT,
'vbug_severityid' => TYPE_UINT,
'description' => TYPE_STR,
'subscribe' => TYPE_UINT,
'private' => TYPE_UINT
));
Then below find: $db->query_write("
INSERT INTO " . TABLE_PREFIX . "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid)
VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $db->escape_string($vbulletin->GPC['title']) . "', '" . $db->escape_string($vbulletin->GPC['description']) . "', " . $vbug_statusid . ", '" . TIMENOW . "', " . $vbulletin->GPC['vbug_severityid'] . ", " . $vbulletin->GPC['vbug_typeid'] . ", " . $vbulletin->GPC['vbug_versionid'] . ", " . $moderate . ", " . TIMENOW . ", " . $vbulletin->userinfo['userid'] . ")
");
and replace with: $db->query_write("
INSERT INTO " . TABLE_PREFIX . "vbug (userid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid, private)
VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $db->escape_string($vbulletin->GPC['title']) . "', '" . $db->escape_string($vbulletin->GPC['description']) . "', " . $vbug_statusid . ", '" . TIMENOW . "', " . $vbulletin->GPC['vbug_severityid'] . ", " . $vbulletin->GPC['vbug_typeid'] . ", " . $vbulletin->GPC['vbug_versionid'] . ", " . $moderate . ", " . TIMENOW . ", " . $vbulletin->userinfo['userid'] . ", " . $vbulletin->GPC['private'] . ")
");
Anything else? :)

[Todi]

I've included a patched vbugs.php, i think i got all of the fixes.. let me know if i missed anything. I hope this is ok, since no update has been released for 2,5 months?

[netmax]

Hi,

i have a problem ... in the vbug tracker admin under "bugs" you should be able to modify or delete the bugs - but it always shows only one page with the first 15 bugs :disappointed:

Anyone an idea or a fix how to get more "pages" to access the bugs after the first 15?

Thanks,

Marco

[netmax]

Another issue in vBug Tracker:

The sorting of the bugs won't work. Whatever i enter on the bottom of the page - search words, order etc - nothing works and every time the default order (last comment) is being displayed.

Anyone an idea?

[PalmNut]

I've corrected vbugs_admin.php to add previous/next buttons on the main bug page and populate the assignment option box for new bugs. The changes are fairly rough, but appear to work. So far here's what I have:

Find starting at line 313:

$pageoptions = array();
for ($i = 1; $i <= $numpages; $i++)
{
$pageoptions["$i"] = "$vbphrase[page] $i / $numpages";
}
and remove.

At line 370 (now 365), find

print_table_break();
print_table_footer(6, "
<input type=\"button\" class=\"button\" value=\"" . $vbphrase['vbug_add_bug'] . "\" tabindex=\"1\" onclick=\"window.location='vbugs_admin.php?$session[sessionurl]do=add';\" />
");
and replace with
print_table_break();

if ($vbulletin->GPC['pagenumber'] > 1) {
$prevpage = $vbulletin->GPC['pagenumber'] - 1;
$previous_page = "<input type=\"button\" class=\"button\" value=\"" . $vbphrase['prev_page'] . "\" tabindex=\"1\" onclick=\"window.location='vbugs_admin.php?$session[sessionurl]do=modify&pagenumber=$prevpage';\" />";
}
if ($vbulletin->GPC['pagenumber'] < $numpages) {
$nextpage = $vbulletin->GPC['pagenumber'] + 1;
$next_page = "<input type=\"button\" class=\"button\" value=\"" . $vbphrase['next_page'] . "\" tabindex=\"3\" onclick=\"window.location='vbugs_admin.php?$session[sessionurl]do=modify&pagenumber=$nextpage';\" />";
}

print_table_footer(6, "$previous_page
<input type=\"button\" class=\"button\" value=\"" . $vbphrase['vbug_add_bug'] . "\" tabindex=\"2\" onclick=\"window.location='vbugs_admin.php?$session[sessionurl]do=add';\" />
$next_page
");This only modifies the Bugs view. I'll add fixes for more bugs in separate posts.

[PalmNut]

These changes allow you to assign a new bug.

At line 90, find
print_select_row($vbphrase['vbug_assigned_to'], 'adminid', array('0' => $vbphrase['vbug_unassigned'], $users['userid'] => $users['username']));
and change to
makeassignmentchooser($vbphrase['vbug_assigned_to'], 'adminid', 'user', 'userid', 'username', 'username', "WHERE usergroupid IN($userarray[vbuggroupids]) OR FIND_IN_SET('$userarray[vbuggroupids]', membergroupids)", iif($bug['adminid'], $bug['adminid'], -1), $vbphrase['vbug_unassigned']);

[Boiler98]

Two things I'd really like to see added to this mod:
1) Follow the subscriptions rules of the forum, so I don't have to subscribe each time. Also, don't tell e-mail me when I replied to a bug. :)
2) Set default search criteria, or allow certain bug types to be hidden by default. For example - I don't want to see the closed and duplicate bugs anymore.

It's a great mod! It does a great job!

[nowrap]

is it possible to use vbugs 2 times in a forum for different purposes and "mount" them to different usergroups?

[Kayn]

Is this mod no longer supported?

[Moerphy]

very easy installation. Good job !!

I have the same question as "nowrap" two posts before. There must be a way because the german vbulletin board uses the vbug.php twice but is it quite easy to manage or a big change ???

Thanks for a answer...

[SupremeWeapon]

doesnt look like it. be nice if they woul dpass it on to someone to make work for 3.5.4 as well as finish the full pro version of it. their site has been dead for a year

[peterska2]

I can confirm it does work with 3.5.4 as I have it running although I don't use it very much.

[SupremeWeapon]

k, thanks for that peter.



the author doesnt support but maybe the community can,


i tested it and when you get to bug version it has


"any version"
and
"test"

how does I change those options?


the
Lastly... Please follow the instructions exactly as they are outlined in the documents/install.txt and in the order as listed to avoid any problems.

is a text file that is barey decent enough to call an install...

[Shaikan]

Hi guys,

At first I want to thank you for this great hack.
Secondly I want to ask for two features:
*) attachments?
*) I want to set a user who gets email notifications for every bug - mustnt be a user but at least a mail adress

Hope somebody can help me.

[Adrian Schneider]

A suggestion, if I may:

Store the # of bugs of each status somewhere... I'd assume the status table or the datastore. Have it update upon saving/removing/etc a bug (or via cron). A query on every page for every status seems a little excessive to me.

[MThornback]

has there been any word on this update? I really need the ability to assign people with multiple usergroups to certain bugs.

Is there anyone out there who can help us solve this? I can't figure it out either.... :tired:

[akanevsky]

I am about to finish the development of my own bugtracker. :)

EDIT @ JUN 9: Actually, already released.

[Dark_Wizard]

I'm back...will look into all the issues and post back the status...

[akanevsky]

LOL... Nice of you to be back right after my post. :)

[Dark_Wizard]

LOL... Nice of you to be back right after my post. :)

Amazing, it looks just like my Pro version which you had access to all my source code...and I mean identical in every detail..

[akanevsky]

Your is identical to jelsoft's in every details, but I am not claiming that you have their source code.

Don't worry - the one I have - I wrote from ground zero. It I was one of those people who steal others' source code, I wouldn't steal yours because yours is too messed up and buggy to begin with... In fact, I discarded all those files you sent me soon after you kicked me off...

Maybe the design is identical, but the interior isn't. If you look closely at admin screenshots, you'll see that they are very different from your tracker. If you need any proof that the interior does not utilize anything even similar to your code let me know.

By the way, what I find amazing is that after having apparently vanished for about a year, you have reappeared right after my post. :)




P.S: Mine is probably going to become visible source, rather than ioncubed, pretty soon, and then anyone who buys it can confirm that it's not like yours.

[majorxp]

I'm back...will look into all the issues and post back the status...Welcome back! We missed ya the last six months.. Are you going to resume support for the bug tracker?

[Dark_Wizard]

Welcome back! We missed ya the last six months.. Are you going to resume support for the bug tracker?

I have been very busy the last 6+ months but am back into the swing...
Yes I am...actually I am working on the Pro version which will be released here.

[akanevsky]

actually I am working on the Pro version which will be released here.

That's funny... :)

[SupremeWeapon]

I am about to finish the development of my own bugtracker. :)

EDIT @ JUN 9: Actually, already released.

where at?

Amazing, it looks just like my Pro version which you had access to all my source code...and I mean identical in every detail..

thats what they all say when a product is released that A) is better in every aspect. and B) doesn't allow someone to make loads of money off of it.

[akanevsky]

At my site. The link's in my signature... :)

[Todi]

A security flaw has been reported in this modification and the author has been contacted for a fix. Until the flaw has been fixed we have removed the files from download. Thank you for your understanding.
WTF? What is going on? How serious is this security flaw? Should everyone uninstall the mod? Why is there no information about this except a little notice at the top? I really don't like the sound of this... And since the coder has been MIA for so long, i find it unlikely that any fixes will be coming either. Please give us more information..

[Dark_Wizard]

WTF? What is going on? How serious is this security flaw? Should everyone uninstall the mod? Why is there no information about this except a little notice at the top? I really don't like the sound of this... And since the coder has been MIA for so long, i find it unlikely that any fixes will be coming either. Please give us more information..

I have been notified and it is being worked on...will be out this week with a new update...

[Dark_Wizard]

Issue has been resolved, waiting on a reply to my PM. Also additional bugs have been fixed and included in the update.

[majorxp]

A security flaw has been reported in this modification and the author has been contacted for a fix. Until the flaw has been fixed we have removed the files from download. Thank you for your understanding.


It would have been nice to send out an update to all installed users to notify them of the issue so we could uninstall until it is resolved.

/uninstalled
...

[Simplicity]

Looks like we may need to wait a while for the moderators to give this the go-ahead and allow the file download :(

[Paul M]

The XSS security flaw reported in this modification has been fixed [by Staff] and a new zip file (3.5.1a) uploaded, vbugs.php is the file that has changed.

[majorxp]

Thanks Paul!

[MThornback]

Thanks Alot Paul :D

[Zelda-King]

Since upgrading to 3.5.1a the "Title / Submitted By / Date" column in the listbit doesn't look right (see attachment).

Also, using this on vB 3.6 RC1 results in the following errors at the top of the page;

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

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

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

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

(I realise this isn't officially ready for 3.6 yet. Just leaving feedback to consider.)

[jluerken]

Zelda-King, I have the same
Warning: Invalid argument supplied for foreach() in /vbugs.php on line 123
...and so on.

Is there any fix available?

[jluerken]

It has problems since vb3.6 with those lines in vbugs.php

foreach ($bugcache['severity'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_severityid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$severitybits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['type'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_typeid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$typebits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['version'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_versionid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$versionbits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['status'] as $key => $entry)
{
$statuscount = $db->query_first("
SELECT count(*) AS status
FROM " . TABLE_PREFIX . "vbug
WHERE vbug_statusid = $key
");
$numstatuses = $statuscount['status'];
$selected = iif($vbulletin->GPC['vbug_statusid'] == $key, 'selected="selected"');
$val = $entry['title']. "&nbsp;(" .$numstatuses. ")";
eval('$statusbits .= "' . fetch_template('userfield_select_option') . '";');
}

The foreeach statement is wrong but I am not a programer to say what has changes with 3.6 and how those lines need to look now. :(

[precharge]

Would like regular users to be able to submit bugs but not view them. The only way they seem to be able to add is to have view access. Is there a fix to this?

[Trevor Hannant]

Has anyone requested a 3.6 version of this?

[MThornback]

It has problems since vb3.6 with those lines in vbugs.php

foreach ($bugcache['severity'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_severityid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$severitybits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['type'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_typeid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$typebits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['version'] as $key => $entry) {
$selected = iif($vbulletin->GPC['vbug_versionid'] == $key, 'selected="selected"');
$val = $entry['title'];
eval('$versionbits .= "' . fetch_template('userfield_select_option') . '";');
}
foreach ($bugcache['status'] as $key => $entry)
{
$statuscount = $db->query_first("
SELECT count(*) AS status
FROM " . TABLE_PREFIX . "vbug
WHERE vbug_statusid = $key
");
$numstatuses = $statuscount['status'];
$selected = iif($vbulletin->GPC['vbug_statusid'] == $key, 'selected="selected"');
$val = $entry['title']. "&nbsp;(" .$numstatuses. ")";
eval('$statusbits .= "' . fetch_template('userfield_select_option') . '";');
}

The foreeach statement is wrong but I am not a programer to say what has changes with 3.6 and how those lines need to look now. :(

Attached is our work around....it suppressed the errors...dunno if its a 100% fix

[jluerken]

Attached is our work around....it suppressed the errors...dunno if its a 100% fix

Loool oh no. A few hours to late. Now I spend money for this
http://www.visionscripts.com/?page=products&vsproductid=10
:(

[akanevsky]

Loool oh no. A few hours to late. Now I spend money for this
http://www.visionscripts.com/?page=products&vsproductid=10
:(

That was a good investment though. You won't regret it. ;)

[Adrian Schneider]

I switched to Mantis and I am very pleased with it.

[akanevsky]

Mantis has no vBulletin integration. Which makes it great for other purposes, but not for vBulletin developers / designers.

[Zelda-King]

Attached is our work around....it suppressed the errors...dunno if its a 100% fixOne error less;

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

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

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

[Delphiprogrammi]

you don't need to modify any source files to get this working with 3.6.x .If you import the product and goto the tracker page (vbugs.php) then you will get those foreach() errors Zelda-King posted above.

open the product xml and you will see it trys to run an INSERT query on the datastore table (actually 2 of them) but the product disables database errors sow if anything goes wrong MySQL won't show you anything

the datastore for the bugcache will fail and that is why you get that foreach() errors (it is missing in the database)

you can manually query your database to add it and then this will work fine...

one question left is it safe to use ?

[Zelda-King]

You mean this?
$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('vbug_version', 's:5:\"3.5.1\"')");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");