[HTL] & [very simple TXT] vB-Bugs

OK, this is my first Hack release, so please forgive me if it's crap.

vB-Bugs
Version: 0.1f Alpha
vB-version: 3.0.0 Release Candidate 2
Developer: Kirby
Install difficulty: Easy
File edits: 1
Template edits: 0

Description of the Hack:
This is a basic vBulletin-powered Bug-Tracker
It is based on vB-Todolist originalli created by RekiM who kindly gave me permission to make this "port".

Features

• User-definable Types, Severities and States
• Front-End fully phrased
• XHTML-Compliant
• Various possibilities to Filter/Search

Requirements

• vBulletin 3 RC2
• mySQL > 4.0.2

Please note that this is an alpha release only and I can't and
won't take any responsibilities. Use it as-is at you own risk.


HACK INSTALLATION DETAILS:
New files for this Hack:
bugs.php
admincp/bugsadmin.php

Files modified for this Hack:
admincp/index.php

New templates for this Hack:
bugs_addbug
bugs_addbugnote
bugs_listbit
bugs_bugnote
bugs_details
bugs_list
BUGS

New DB tables for this Hack:
bugs
bugnotes
bugtypes
bugseverities
bugstates


This post was generated by the Hack Tracking Log

[tilight]

Darn im getting this error (sent via email) the page that tired to load had a DB error:

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_vbbugs AS phrasegroup_vbbugs,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0,
1, user.languageid))
WHERE user.userid = 1

mysql error: Unknown column 'language.phrasegroup_vbbugs' in 'field list'

mysql error number: 1054

Anyone have any idea?

[Shane]

Umm... wait till I release the new version?

[tilight]

Yay new version thanks Shane, btw great job I love it.

[edit]BTW is there a file attaching capability? If not, it should be added to a future version [/edit]

BTW I found a bug, it doesnt strip /'s when you submit a bug in the AdminCP I dont know if it does when using the bugs.php.

[Shane]

Creating new thread for it as we speak

[jwpexe2]

I just installed this and bug.php shows a blank screen. I read in an earlier post that there was a problem with ie but I also tried it in mozilla no luck.

bugsadmin.php works fine. Any ideas

Thanks

[xmitchx]

Woo how long until this thing is ready for release? Its looking great but I wont really trust it until its in the release section :nervous:

[Oldfart]

I've had it installed for a few months now and I have upgraded my board twice so far and I haven't come across any "bugs" or problems with it yet. Seems to work fine for me anyways...

[xmitchx]

Originally Posted by Oldfart

I've had it installed for a few months now and I have upgraded my board twice so far and I haven't come across any "bugs" or problems with it yet. Seems to work fine for me anyways...

Thanks for the feedback I'll be sure to think about it.

[Stadler]

Originally Posted by xmitchx

Thanks for the feedback I'll be sure to think about it.

I've applied some fixes and restructured most of the code (Layout only. Mainly no functionality changes). Additionally, I've managed to get it to work with MySQL 3 and MySQL 4 (It uses the setting in the vBulletin Options now whether to use FULLTEXT-Searching or to usual postindex)

The next I need to do is to work myself through /admincp/bugsadmin.php and to update the script bugnotestoposts.php to add a fake forum to bypass removal of the bugnotes, when you're running find orphan threads.

Oh and Shane: Can you take a look at http://sourceforge.net/forum/forum.p...orum_id=368467 please?

[Dark_Wizard]

Well I haven't seen much of this project's status so I am rewriting it as this version has too many bugs for my taste and Natch and I are needing something to track bugs. vbBug Tracker will be available soon on this site and can be viewed at vBWar.com, please remember that it isn't complete.