PDA

View Full Version : [HTL] & [very simple TXT] vB-Bugs


Andreas
02-03-2004, 10:00 PM
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 (rekim@geb-team.de) 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 (https://vborg.vbsupport.ru/showthread.php?t=60735)

StarBuG
02-04-2004, 05:10 PM
FIRST

Thank you SOOOOO much!!!

/me clicks install

Greetings

Star

StarBuG
02-04-2004, 05:24 PM
I need a little help!

I installed the HTL file works like a charm

BUT the index.php change did not!

I get this error:

admincp/index.php on line 561

line 561

if (is_member_of($bbuserinfo, $vboptions['bugadmingroup']) {


Please help

one thing to improve your readme.txt instructions

It would be better to separate the htl from the normal instructions

this a) b) thing is confusing

StarBuG

Cyricx
02-04-2004, 05:28 PM
Can we see SS's? :)

So I don't have to install, then go "Hey, this ain't what I want."

Shaz

gmarik
02-04-2004, 05:29 PM
Glad to things like these

Andreas
02-04-2004, 05:36 PM
@StarBug
Seems like a copy & Paste Error.

Try

if (is_member_of($bbuserinfo, $vboptions['bugadmingroup'])) {


I'll change the readme and update the htl l8er.
Must go now, i'm already too late.

@Cyricx
https://vborg.vbsupport.ru/showpost.php?p=471885&postcount=28

Koutaru
02-04-2004, 05:39 PM
Very niiice. I'm definately installing.

StarBuG
02-04-2004, 05:41 PM
And one other thing.
(your fixe worked by the way)

Could you please give some instructions how to use it

I found the options settings for vBugs and changed it to my usergroup (can there be more then one usergroup specified? I would need this!)

But where do I say wich forums are my support forums (I have 2 so I would need to specify 2 forums. Is this possible?)?
Where do I specify wich different kind of bug status i can offer and such?

We need Instructions! :D

Greetings

Star

StarBuG
02-04-2004, 05:45 PM
And there is more


error_reporting(7);
$specialtemplates = array('bugcache');
require("./global.php");
chdir('/var/www/web2/html/demos/forum/admincp/');
include("./todoconfig.php");
$vBugs_version = "0.1 Alpha";


this is in bugadmin.php right at the start
I think that was not itendet to and makes the file not working!


Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /somepath/forum/admincp/bugsadmin.php on line 8
Warning: main(./todoconfig.php) [function.main]: failed to create stream: No such file or directory in /somepath/forum/admincp/bugsadmin.php on line 9
Warning: main() [function.main]: Failed opening './todoconfig.php' for inclusion (include_path='.:/usr/lib/php') in /somepath/forum/admincp/bugsadmin.php on line 9


and the DB error:



Database error in vBulletin 3.0.0 Release Candidate 2:
Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
mysql error: You have an error in your SQL syntax near ') ORDER BY username' at line 1
mysql error number: 1064
Date: Wednesday 04th of February 2004 08:50:57 PM
Script: http://www.hiphop-battles.com/forum/admincp/bugsadmin.php?do=add
Referer: http://www.hiphop-battles.com/forum/admincp/index.php?do=nav


please help

StarBuG

MindTrix
02-04-2004, 06:39 PM
Change


chdir('/var/www/web2/html/demos/forum/admincp/');


To point to your forum's admincp.

This step needs to be added to the instructions :p

StarBuG
02-04-2004, 06:48 PM
Change
chdir('/var/www/web2/html/demos/forum/admincp/');
To point to your forum's admincp.
This step needs to be added to the instructions do you know that it is intentionaly put there just missed to change the path?
Cause what about "todoconfig.php" it was not included in the zip it kinda looks like his todo
If you remove the line (include.. ) and change path the first part of the error is gone but the db error stays

MORE errors:

Bug-States - modify:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 376

Bug-States - sort:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 411

Bugs - Modify:
Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /somepath/forum/includes/db_mysql.php on line 370

Bug-Severities - Modify:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 549

Bug-Severities - Sort:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 584

Bug-Types - Modify:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 723

Bug-Types - Sort:
Warning: Invalid argument supplied for foreach() in /somepath/forum/admincp/bugsadmin.php on line 759

Greetings Star

GovGaming
02-04-2004, 06:59 PM
How do I import the vbbugs_settings.xml file? I've imported the templates and phrases...just need to do the settings.
Hack looks great...read-me could use a little work, though.

TheAnt
02-04-2004, 07:44 PM
excellen! will def. install

Dean C
02-04-2004, 08:03 PM
Screenshots :)?

NTLDR
02-04-2004, 08:07 PM
Screenshots are in the zip file. Note that if you install this its pretty un-useable at the moment as not all the templates are in the XML file for starters. Also no mater which method you install from the datastore isn't setup correctly so you get lots of errors everywhere from that too.

KuraFire
02-04-2004, 09:06 PM
May I ask, what exactly is so complicated about this that it requires MySQL 4 ?????

NTLDR
02-04-2004, 09:29 PM
I believe it uses MySQL 4's fulltext search.

Princeton
02-04-2004, 09:44 PM
thanks for the info NTLDR ... I think I'll wait just a little bit.
It sounds good.

Link14716
02-05-2004, 12:33 AM
This hack doesn't even work for ++++ing sakes, at least not the admin part.

First of all, you chdir to the admincp directory (but it's an invalid path for everyone else). Why? You might as well have included files in the includes directory.

Secondly, todoconfig.php doesn't even exist in the zip, so you can change whatever path you want, but it won't matter.

And lastly, the big fat MySQL error that will probably go away if todoconfig.php existed:
Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT * FROM bugs WHERE online = 1 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 1

mysql error number: 1064

Date: Wednesday 04th of February 2004 09:29:58 PM
Script: http://utt.rpgjunto.com/admincp/bugsadmin.php?$session[sessionurl]do=modifystate
Referer: http://utt.rpgjunto.com/admincp/index.php?do=nav&hacksnav=1
Username: Link14716
IP Address: 24.240.122.139


And the front-ends seems to need todoconfig.php as well. I guess I can't scream at you, since this was released in the Beta Hacks forum. ;)

Andreas
02-05-2004, 01:56 AM
Hehe, looks like I messed up everything.
todoconfig.php isn't really needed, that was smth. left over from vB-Todolist ... and I forgot to remove it.
That's also the reason the chdir was in place.

I've modified the setup and removed those unnecessary things.
Should be working now, update-instructions are in the ZIP.

Sorry @ all. Slap me please :D

@KuraFire
Because the search function uses fulltext-search in boolean mode, which is only available in mySQL-Versions > 4.0.2

@StarBug
> can there be more then one usergroup specified? I would need this!
No. May I ask why you would need more then 1 group?

> But where do I say wich forums are my support forums
> I have 2 so I would need to specify 2 forums. Is this possible?
Hmm. Seems like I don't understand this question.
Which forums do you want to specify? And what for?

> Where do I specify wich different kind of bug status i can offer and such?
In the ACP under Bug-States.

squawell
02-05-2004, 04:20 AM
i got this error when i click add bug in admincp

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
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 ') ORDER BY username' at line 1

mysql error number: 1064



any idea thankz...:D

KuraFire
02-05-2004, 07:58 AM
you can have fulltext searches in mysql 3 :)

providing you know how to hack mysql and write that in yourself. :D


*sigh* ahwell, guess I can't use this then, and neither can EvB then...

PranK
02-05-2004, 08:05 AM
awesome!

/me clicks install!

Thanks!

Andreas
02-05-2004, 08:53 AM
@squawell

Lines 163 & 187 in bugsadmin.php

Change

"WHERE usergroupid IN ($admingroups)"


Tp

"WHERE usergroupid=$vboptions[bugadmingroup] OR $vboptions[bugadmingroup] IN (membergroupids)"


@KuraFire
Why not just upgrade mySQL? ;)
I think this would be good anyway (=> Query Cache, reduced load on our server significantly).
You could also use this with mySQL 3 with some modifications:
- modify the definition for table bugs in the setup
- change bugs.php sql

StarBuG
02-05-2004, 09:04 AM
Sorry but after i deleted the hack in the HTL menu and updated as you said I still get this mysql errer when i go to:

Bugs - Add


Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
mysql error: You have an error in your SQL syntax near ') ORDER BY username' at line 1

mysql error number: 1064

Date: Thursday 05th of February 2004 12:02:53 PM
Script: http://www.hiphop-battles.com/forum/admincp/bugsadmin.php?do=add


I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

It?s not in Options, it?s not in Manage Forums, it?s not an admin menu like you added 4 so where do I have to look?


> But where do I say wich forums are my support forums
> I have 2 so I would need to specify 2 forums. Is this possible?
Hmm. Seems like I don't understand this question.
Which forums do you want to specify? And what for?

I have a multilanguage Project and I have a German Support Category with a Bug Forum in it and an English Support Category with also a Bug Forum in it.
First I need to know where to specify the Forums and I realy would need to have these 2 Forums both as bug Forums
if you wanna have a look http://www.hiphop-battles.com/forum/index.php


@StarBug
> can there be more then one usergroup specified? I would need this!
No. May I ask why you would need more then 1 group?

I am Admin, from my developers some are Admin some are just Developers.
And I will have a support Crew in the future where I defenetly don?t want to give them admin rights or let them see our Developer Forums in full but I would like to have them decide what kind of bug it is, if they can help help users then change the status of the bug so I don?t have to do all the work alone.

Can?t be to hard to make it possible to define more then one usergroup and more then one bug forum!! PLEASE ;)

Is this possible?

Greetings

Star

NTLDR
02-05-2004, 09:16 AM
I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

It?s not in Options, it?s not in Manage Forums, it?s not an admin menu like you added 4 so where do I have to look?

This has nothing to do with forums, it doesn't use them at all. Its a bug tracker just like the one at vB.com.

StarBuG
02-05-2004, 09:24 AM
DOH :D

But I found another bug

I added a few Bug Types and wanted to remove one.
After clicking yes i got this:

Invalid SQL: DELETE FROM bugtypes WHERE typeid=
mysql error: You have an error in your SQL syntax near '' at line 1

The Type is still there!

Also when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

Greetings

Star

Andreas
02-05-2004, 09:25 AM
Sorry but after i deleted the hack in the HTL menu and updated as you said I still get this mysql errer when i go to:

Bugs - Add

https://vborg.vbsupport.ru/showpost.php?p=473131&postcount=24


I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

Nowhere, as this has nothing to do with forums - it's just a generic bug tracker that uses vB's database for user stuff and some vB-functions for the GUI.


I am Admin, from my developers some are Admin some are just Developers.
And I will have a support Crew in the future where I defenetly don?t want to give them admin rights or let them see our Developer Forums in full but I would like to have them decide what kind of bug it is, if they can help help users then change the status of the bug so I don?t have to do all the work alone.

Well, you could just create a new usergroup that has no rights at all and put all your members you want to become bug admins in this group (as membership group) :)

Nevertheless i'll modify the code to allow several groups.
An updated ZIP will come later.

> Can?t be to hard to make it possible to define more then one usergroup
Yes. As stated above i'll do that.

> and more then one bug forum!! PLEASE ;)
I'm sorry but this is not possible (I even don't understand what you want to achieve).

StarBuG
02-05-2004, 09:34 AM
the forum thing was because i did not understand the idea completly now i do :D

But I have more bugs:

when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

If I click on Edit Bug I get an empty page just the navbar and your copyright text.

Add Bugnote is also not possible same as above

I added a few Bug Types and wanted to remove one.
After clicking yes i got this:

Invalid SQL: DELETE FROM bugtypes WHERE typeid=
mysql error: You have an error in your SQL syntax near '' at line 1

The Type is still there!


Greetings

Star

Andreas
02-05-2004, 09:46 AM
when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

There should definitly be a text ...
Take a look at template bugs_addbug:


<input type="submit" value="$vbphrase[submit]" name="submit" />

Varname "submit" belongs to phrasegroup GLOBAL and thus is available everywhere ...

> If I click on Edit Bug I get an empty page just the navbar and your copyright text.
> Add Bugnote is also not possible same as above
Hmm. Not reproducable here.
Do you have Template Names as comments in HTML turned on?
If so would it be possible to check if the template bugs_addbug or bugs_adbugnote actually get's called?

StarBuG
02-05-2004, 09:56 AM
I have the code you said in bugs_addbug but there is no submit

http://www.hiphop-battles.com/forum/bugs.php?do=add

see for yourself

your second fix also does not work I still get

Invalid SQL: DELETE FROM bugtypes WHERE typeid=
mysql error: You have an error in your SQL syntax near '' at line 1

when I click remove then yes

when I click on edit bug with template names turned on i get this:


<!-- END TEMPLATE: navbar -->

<table cellpadding="0" cellspacing="0" border="0" class="tborder" width="100%" align="center"><tr><td>
<table cellpadding="6" cellspacing="1" border="0" width="100%">
<tr><td>

</td></tr></table>
</td></tr></table>
<p align="right" class="smallfont"></p>
<p align="center" class="smallfont">
vB-Bugs 0.1 Alpha (C) 2004 by <a href="http://www.planet-liebe.de/vbb/member.php?u=2610" target="_new">Kirby</a></p>
<!-- BEGIN TEMPLATE: footer -->


so it seems it does not call your templates

Greetings

Star

KuraFire
02-05-2004, 10:05 AM
@KuraFire
Why not just upgrade mySQL? ;)
I think this would be good anyway (=> Query Cache, reduced load on our server significantly).
You could also use this with mySQL 3 with some modifications:
- modify the definition for table bugs in the setup
- change bugs.php sql
1) mysql 4 != officially stable; we're a webhost with Debian Woody's only (for client servers anyway).
2) mysql 4's Query Cache is really not all that bright, so I'm hearing. It helps, sure, but not as much as it could have with more intelligent implementation. (for details on that, though, you'll have to bug my boss cos he's the database expert - for instance, he wrote mysql 3 Fulltext indexes himself :)).

I think I'll wait a bit, thanks though :)

Andreas
02-05-2004, 10:18 AM
> I have the code you said in bugs_addbug but there is no submit
You are right. RC2 does not have "submit" in phrasegroup GLOBAL, RC3 does - DOH!
To fix this: Add a phrase submit with text Submit to phrasegroup vB-Bugs or GLOBAL.

I'll take a look into the other problems.

@KuraFire
Uh?
"MySQL 4.0 Downloads
[...]
This is the current production release of the MySQL database server. It is recommended for most users"
So i'd assume this is the current stable production release?
We also use woody and don't have any problems with the database.

StarBuG
02-05-2004, 10:20 AM
Thx for your quick support!

I´ll wait for the other fixes.

Greetings

Star

PranK
02-05-2004, 11:22 AM
Kirby - sorry to harrass you, but i get this;

Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
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 ') ORDER BY username' at line 1

i read your other posts and tried to do the fix you suggested, however there is no ""WHERE usergroupid IN ($admingroups)"" on line 163, or anywhere else in the code according to dreamweaver/homesite and phpED...

Any suggestions?

Thanks in advance!

Christian

daFish
02-05-2004, 11:37 AM
Kirby - sorry to harrass you, but i get this;

Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
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 ') ORDER BY username' at line 1

i read your other posts and tried to do the fix you suggested, however there is no ""WHERE usergroupid IN ($admingroups)"" on line 163, or anywhere else in the code according to dreamweaver/homesite and phpED...

Any suggestions?

Thanks in advance!

Christian
There are in the files. Try to search for them. The linenumbers are wrong.

Andreas
02-05-2004, 12:08 PM
@PranK
The line numbers depend on the Version you have. But the text should be there.
Nevertheless, i've also uploaded a new ZIP which should contain the fixes already.
Just replace bugs.php and bugsadmin.php

KuraFire
02-05-2004, 12:26 PM
> I have the code you said in bugs_addbug but there is no submit
You are right. RC2 does not have "submit" in phrasegroup GLOBAL, RC3 does - DOH!
To fix this: Add a phrase submit with text Submit to phrasegroup vB-Bugs or GLOBAL.

I'll take a look into the other problems.

@KuraFire
Uh?
"MySQL 4.0 Downloads
[...]
This is the current production release of the MySQL database server. It is recommended for most users"
So i'd assume this is the current stable production release?
We also use woody and don't have any problems with the database.

mysql 4 is generally pretty stable, yup, but you won't find it in a Woody package by default yet. :)

TheComputerGuy
02-05-2004, 12:33 PM
This is awesome. Will install soon.

Tarion
02-05-2004, 12:44 PM
This is awesome. Will install soon.
when i hit the bugnote button in the detailed buglist the skript take me to the edit bug page and not to the bugnote page.

Andreas
02-05-2004, 02:38 PM
when i hit the bugnote button in the detailed buglist the skript take me to the edit bug page and not to the bugnote page.
This is a problem with IE not being standards compliant ...

Template bugs_details, FIND

<form action="bugs.php" method="post" style="margin-bottom: 0px">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="id" value="$bug[id]" />
<button type="submit" name="do" value="addbugnote">$vbphrase[add_bugnote]</button>
<if condition="is_member_of($bbuserinfo, $vboptions[bugadmingroup])">
&nbsp;<button type="submit" name="do" value="editbug">$vbphrase[edit_bug]</button>
</if>
</form>


REPLACE with

<form action="bugs.php" method="post" style="margin-bottom: 0px">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="id" value="$bug[id]" />
<input type="hidden" name="do" value="addbugnote">
<input type="submit" value="$vbphrase[add_bugnote]">
</form>
<if condition="is_member_of($bbuserinfo, $vboptions[bugadmingroup])">
<form action="bugs.php" method="post" style="margin-bottom: 0px">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="id" value="$bug[id]" />
<input type="hidden" name="do" value="editbug">
<input type="submit" value="$vbphrase[edit_bug]">
</form>
</if>

daFish
02-05-2004, 03:50 PM
If you submit a new bug, there is only one choice on the assignment list.
If you edit the bug, there are the names of all administrators in it. Maybe a bug?

Tarion
02-05-2004, 04:23 PM
THX worked fine for me nice work

PranK
02-05-2004, 08:17 PM
@PranK
The line numbers depend on the Version you have. But the text should be there.
Nevertheless, i've also uploaded a new ZIP which should contain the fixes already.
Just replace bugs.php and bugsadmin.php

thanks Kirby, i'll give it a go. :)

Christian

Olate
02-05-2004, 08:50 PM
Suggestion: Allow hidden tasks, or an internal task list so this can be used to assign development tasks and track them. See https://vborg.vbsupport.ru/showthread.php?t=61207

GovGaming
02-05-2004, 09:19 PM
Step two of install I get this error:
-------------------------------------------------------------
Current Step: Insert Hack Phrases
This step inserts all the new phrases for vB-Bugs. It creates one new phrase group on the language table, phrasegroup_vbbugs.
---------------------------------------------------------------

Could not add a Phrase group in the System!

Link14716
02-05-2004, 09:57 PM
Bug resulting in uncached template (fix):

In bug.php, find:'showdetails' => array('bugs_bugnote_bugnote',Replace with:'showdetails' => array('bugs_bugnote',

Dark_Wizard
02-05-2004, 10:27 PM
It's a shame I can't use this and it would be nice to have but I don't have MySQL 4.x yet and not planning to due to some issues with it. Any chance on making this 3.x complaint?

squawell
02-05-2004, 10:50 PM
@squawell

Lines 163 & 187 in bugsadmin.php

Change

"WHERE usergroupid IN ($admingroups)"


Tp

"WHERE usergroupid=$vboptions[bugadmingroup] OR $vboptions[bugadmingroup] IN (membergroupids)"


thankz fix that~BUT i have another problem~when i import the phrase file~it successed but cant see the new phrase group name vBugsbut i can find all phrase~and when i go to bug page all phrase did not show up...any idea?thankz:D

daFish
02-06-2004, 05:26 AM
It's a shame I can't use this and it would be nice to have but I don't have MySQL 4.x yet and not planning to due to some issues with it. Any chance on making this 3.x complaint?
I'm using the hack with MySQL 3.xx and i'm having no problems with it. :)

Zelda-King
02-06-2004, 06:15 AM
You don't? I tried it with MySQL 3 and there's no 'submit new bug' option. The only place bugs can be added is the admin CP. The only thing I see on bugs.php is the filter options.

daFish
02-06-2004, 06:55 AM
You don't? I tried it with MySQL 3 and there's no 'submit new bug' option. The only place bugs can be added is the admin CP. The only thing I see on bugs.php is the filter options.
No problems.
I've checked the installed MySQL version: 3.23.57

I can submit new bugs in the normal form and in the acp too.

gmarik
02-06-2004, 08:56 AM
Man, those errors are really killing us.
How about XMLizing templates?

NTLDR
02-06-2004, 01:01 PM
No problems.
I've checked the installed MySQL version: 3.23.57

I can submit new bugs in the normal form and in the acp too.

The only limitation with using MySQL 3 and this hack should be your ability to search for bugs by using keywords.

Olate
02-06-2004, 06:58 PM
Out of interest, how is development going on this? I would really like a stable release so would be willing to help out.

Zelda-King
02-07-2004, 12:31 PM
I found my problem with 'Submit New Bug' not appearing. It's the colours. I have to highlight to see it in some styles.

Zelda-King
02-07-2004, 10:05 PM
There's a typo in bugs.php resulting in an an uncached template.

Change 'addbugnote' => array('bugst_addbugnote'),
to'addbugnote' => array('bugs_addbugnote'),

Zelda-King
02-08-2004, 12:41 AM
Another error resulting in an uncached template;

In bugs.php, replace:('bugs_bugnote_bugnote',
with
('bugs_bugnote',

Link14716
02-08-2004, 12:49 AM
Another error resulting in an uncached template;

In bugs.php, replace:('bugs_bugnote_bugnote',
with
('bugs_bugnote',
Already posted that one. :p

Zelda-King
02-08-2004, 01:28 AM
Oh right. I thought he'd have updated the thread with any fixes. I have to admit I've been too busy upgrading and stuff to read much through the many hacks I've installed this last week. :/

Other observations:

- The table class in some of the templates might be better made as tbody or something rather than tborder (the page with the 'Submit New Bug'). That's where my text viewing problem was.

- The all_reports and all_states (or is it severities? I forget) phrases have typos.

Some things I've spotted but haven't fixed;

- When someone submits a bug it doesn't show in the list of bugs to moderate (admin CP).

- In the 'Last Reply' column, the time goes off the table on low resolutions (tested at 600x800).

- When posting a new bug, administrators see a status dropdown but it doesn't work. It will always start as 'unassigned' until you edit the bug. Also, the 'assignment' one only has one option. I realise those aren't needed things when SUBMITTING a new bug. It just seems weird having options that don't change anything.

That aside I appreciate this release. I've been wanting a bug tracker. :)

tomshawk
02-09-2004, 06:01 AM
I like the looks of this alot, but

I dont have and dont necessarily want HTL

so

in your readme file, you talk about importing the XML files.

Could you explain, how

I dont see options to import any of them other then to replace existing templates, which is not what I want to do, I assume.

Any help would be greatly appriciated.

Thank you

Andreas
02-09-2004, 05:13 PM
@GovGaming
Check your database if table language contains a column phrasegroup_vbbugs and if table phrasetype contains a record where fieldname=vbbugs. If so: delete that and try again.

@ZeldaKing
> - When someone submits a bug it doesn't show in the list of bugs to moderate (admin CP).
It does only show up there if it's not online. So if your default online-status is yes they new bugs won't show up there.

> - In the 'Last Reply' column, the time goes off the table on low resolutions (tested at 600x800).
I've never seen such a resolution so far?

All other problems mentioned so far should be fixed (except the CSS-class change, as it looks just fine with the default style).

teksigns
02-09-2004, 05:18 PM
any possible way to make it so that the

system administrator gets a email when there is a new
bug posted .?

Andreas
02-09-2004, 05:38 PM
This is planned for future versions.

Zelda-King
02-09-2004, 06:34 PM
@ZeldaKing
> - In the 'Last Reply' column, the time goes off the table on low resolutions (tested at 600x800).
I've never seen such a resolution so far?Here, I'll show you it. I sometimes see this. Other times I'll refresh the page or revisit it and it'll look fine.

tomshawk
02-10-2004, 03:48 AM
Anybody??

I like the looks of this alot, but

I dont have and dont necessarily want HTL

so

in your readme file, you talk about importing the XML files.

Could you explain, how

I dont see options to import any of them other then to replace existing templates, which is not what I want to do, I assume.

Any help would be greatly appriciated.

Thank you

SB2002
02-10-2004, 12:12 PM
I just have to say, for your first hack this is very proffessional looking and fantastic. I've been put in charge of setting up a helpdesk for our company to use to report faults with IT equipment, and up until now it looked like i was going to have to use the VB2 helpdesk, which although very good, lacked the extras that VB3 has to offer. But i've just installed this using HTL (another great timesaving hack) and it's working a treat.

thanks for the great hack :D

Andreas
02-10-2004, 01:30 PM
@tomshawk
Installing this manually is a bit tricky

Phrases
----------
SELECT MAX(phrasetypeid) + 1 AS max FROM phrasetype WHERE phrasetypeid < 1000
Note down this value
INSERT INTO phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (phrasetypeid, 'vbbugs', 'vB-Bugs', 3)
Where phrasetypeid must be replaced by the value you noted down.
ALTER TABLE language ADD phrasegroup_vbbugs MEDIUMTEXT NOT NULL

Then import the phrases xml file "overwriting" an existing language. This won't (well, at least it shouldn't) kill other phrases in this language as type is phrases

Templates
-------------
"Overwrite" an existing style.

Settings
----------
Here you are out of luck, as vB's default functions do not allow to import custom settings - this would kill almost all vB standard settings.
You would have to go into debug mode to manually add the setting group and the settings according to the information in the XML-File. Or add them directly to the database.

@Zelda-King
Hmm ... could be a browser issue as I don't seem to be able to reproduce that.
Which browser do you use?

tomshawk
02-10-2004, 01:44 PM
So basically, it's not such a simple txt file as the title says :p Thank you for your honesty.

I want this, so I guess I'll download and install HTL tonight, then this hack.

Thank you and have a good one

Andreas
02-10-2004, 02:01 PM
The title is right - the textfile contains only VERY simple/basic instructions on how to install this manually ;)

Dark_Wizard
02-10-2004, 03:07 PM
So basically, it's not such a simple txt file as the title says :p Thank you for your honesty.

I want this, so I guess I'll download and install HTL tonight, then this hack.

Thank you and have a good one

You will be very happy with the HTL....

Dark_Wizard
02-10-2004, 03:08 PM
Kirby....just installed this and want to say great job....I needed this very badly.

Zelda-King
02-10-2004, 04:27 PM
@Zelda-King
Hmm ... could be a browser issue as I don't seem to be able to reproduce that.
Which browser do you use?Internet Explorer 6. So far I've failed to duplicate the problem on Firefox (which I'm currently giving a general trial) but I'll keep you posted.

Something else I just found: I can't UNassign bugs from the bugs page once they've been assigned (I can from the admin CP). The unassign is there in the dropdown but the status doesn't change.

Andreas
02-12-2004, 04:22 PM
@Olate
Suggestion: Allow hidden tasks, or an internal task list so this can be used to assign development tasks and track them. See https://vborg.vbsupport.ru/showthread.php?t=61207
You can set Bugs/Tasks to be "offline" - those are only visible to admins.

I think i'll change that so they'll be visible to "bug admins" and admins

@ZeldaKing
Seems like a CSS-Problem.
In Template bugs_listbit change

<span class="smallfont" style="float: $stylevar[left]">
<if condition="$todo[lastreplyuid]">


To

<span class="smallfont">
<if condition="$todo[lastreplyuid]">


Does that fix the problem?

Olate
02-12-2004, 04:24 PM
@KirbyDE
Yes, I just noticed that. Not very clear though - I had to test it first to see what it did.

Zelda-King
02-12-2004, 05:42 PM
@ZeldaKing
Seems like a CSS-Problem.
In Template bugs_listbit change

<span class="smallfont" style="float: $stylevar[left]">
<if condition="$todo[lastreplyuid]">


To

<span class="smallfont">
<if condition="$todo[lastreplyuid]">


Does that fix the problem?I've just applied that fix. Having given it a little test I'm seeing no further problems. It'll be a little while until I know for sure. It was a temperamental thing.

StarBuG
02-12-2004, 06:16 PM
Hi

There is one small but IMPORTANT thing missing:

An EDIT Button for bug comments (for author of the bug note and of course the ADMINS!)

I realy would need this

Greetings

Star

PranK
02-13-2004, 06:49 AM
those cached problems you guys posted, is that possibly the reason why i cannot add bugnote or edit it from bugs.php ?

i get the normal screen with no content. :(

Thanks for any help!

Andreas
02-13-2004, 06:53 AM
@PranK
I guess you are using IE ...
Did you install the latest version?

PranK
02-13-2004, 06:55 AM
when was the latest version released?

Christian

Andreas
02-13-2004, 06:57 AM
0.1f, 02-09-04 at 20:00

PranK
02-13-2004, 07:00 AM
well there ya go. :) nope i havent, do i just need to upload the new files? theres no other changes are there?

Andreas
02-13-2004, 07:05 AM
There are a few template changes (which should fix the display problem on IE, although it's clearly IE's fault) and some typos in phrases corrected.

PranK
02-13-2004, 07:16 AM
great - just did it, works perfectly!

Thanks Kirby!

Christian

Zelda-King
02-13-2004, 06:41 PM
It'll be a little while until I know for sure.OK, I've had some time to use this on a day to day basis now and the IE problem does seem fixed. I've had no other issues. Thanks for that!

Catch-22|BL
02-16-2004, 01:56 AM
I have it installed and working on a new forum some of us are putting together:

http://www.gamesorceress.com/index.php?

Click on the "List of things to do" and it goes to the bugs system.

http://www.gamesorceress.com/bugs.php?

I installed using HTL. Now what can needs to be done to get this thing out of alpha/beta?

Do you want people to suggest more features?

Anyway, it is working and was a simple install with HTL.

UOXDev
02-18-2004, 01:23 PM
Too bad its password protected :(

ixian
02-19-2004, 08:37 PM
I love this hack! Thanks!

A couple suggestions for the future (of course):

Bug Types should each have their own specific severities. Say you have the default - Bug, ToDo, and Feature Request.

For severity, you have trivial, minor, major, and so on.

It would be nice if you could create a specific class of severities for each Bug Type. For example, I could have a bug type of Hardware, and when that option is selected, only severities for that type are listed (in submit bugs). That way you could create severity levels specific to the type of bug. The hypothetical Hardware Bug Type could have it's own set like "Video Error" or "Hard Drive error", etc. Right now they will all be listed together, and that will get confusing for people submitting bugs.

Also - and perhaps I am missing this part - where can I configure specific permissions? It'd be nice if you could assign certain things to users, such as the ability to post only certain types of bugs, etc. Also, when submitting bugs it'd be nice to give certain usergroups the ability to only add a bug and make a comment, and not assign it to anyone or assign the state.

Other than that, this is well on the way to becoming a class-act bug tracking system. Thanks again.

Andreas
02-19-2004, 09:49 PM
> not assign it to anyone or assign the state.
Only members of the bug administrator group can change assignments, stetes, etc.

I don't think i'm gonna make different severities for each bug type. I want to keep this simple.
If you want a fulll-featured bug-tracker better go for BugZilla, Mantis or smth. like this.

obsidian
02-22-2004, 02:05 AM
Great Hack.....I installed the Hack Tracking Log and followed it with this one. Installing both took less than 10 min and everything works like a charm. Great feature for an engineering board :)

My only suggestion for improvement would be a couple of user defined fields that you could add items to. I am going to alter mine to add categories....versions...etc.

Allan
02-23-2004, 03:44 PM
good taf, great hack :)

but, how to import the file "vbbugs_settings.xml" ?

ixian
02-23-2004, 09:43 PM
> not assign it to anyone or assign the state.
Only members of the bug administrator group can change assignments, stetes, etc.

I don't think i'm gonna make different severities for each bug type. I want to keep this simple.
If you want a fulll-featured bug-tracker better go for BugZilla, Mantis or smth. like this.


Actually, I DON'T want something like Bugzilla, etc. I like this, integrated with vb.

You mind if I take a crack at an addon for creating different severities, etc? I think that's the only thing keeping this from being a truly kick butt mod:)

Catch-22|BL
02-24-2004, 03:10 AM
I stand by Kirby and agree we should keep it simple. People need something that is EASY to understand or else a feature such as this will not be accepted by the community.

One small request: Is it possible to have a rudimentary "upload' function so people can attach simple jpg or txt files? Sometimes people have screenshots or long error sequences that are necessary to describe the bug. Any attachment is fine but a thumbnail style preview would be a "nice to have" bonus.

SB2002
02-24-2004, 08:56 AM
Here's a question for anyone who can help. I've implimented this onto a test forum on my laptop and it works fantastic, 110%. I've been asked by my boss to impliment it onto our company website, but it uses vb3 with php3 extensions. Would this still work if i changed the extension, or is it likly to fubar?

Stadler
03-02-2004, 11:20 PM
Is there any hope for a MySQL3-Version in the future?

Andreas
03-02-2004, 11:26 PM
@SB2002
The filename is hardcoded into the php-file and templates. So if you change that you will have to change the php and templates also.

@Stadler
No - mySQL 3 does not support fulltext search in boolean mode.
You can use this with mySQL 3, but you will loose the ability to search for keywords.

Stadler
03-02-2004, 11:50 PM
@Stadler
No - mySQL 3 does not support fulltext search in boolean mode.
You can use this with mySQL 3, but you will loose the ability to search for keywords.Uhm, you could use vB's built in postindex. Just add bugid to the post-table, set the threadid to be 0 (or use a 'pseudo-Thread' that is being installed to make reindexing work) and when searching, use something like WHERE bugid <> 0 in the queries.

[Edit:]Oh, and if its too much work for ya I'd volunteer to do the change ;)

Andreas
03-02-2004, 11:59 PM
Sure I could but then it would be necessary to duplicate vB's search logic (which is not that good IMHO) and to update postindex when a bug(note) is being added or updated.

Using fulltext search in boolean mode makes things a LOT easier :)

Stadler
03-03-2004, 12:05 AM
I have some spare time. I could do it ... or I'd just release a how to, to get the search working with MYSQL3, so there would be a MySQL 4-Version and with a bit more hacking a MySQL 3-Version ...

Andreas
03-03-2004, 12:12 AM
I don't see a point in doing this as mySQL 3 is outdated anyway, so feel free to do that if you want.

But I think it'll require more then "a bit more" hacking.

ixian
03-03-2004, 12:31 PM
I stand by Kirby and agree we should keep it simple. People need something that is EASY to understand or else a feature such as this will not be accepted by the community.

One small request: Is it possible to have a rudimentary "upload' function so people can attach simple jpg or txt files? Sometimes people have screenshots or long error sequences that are necessary to describe the bug. Any attachment is fine but a thumbnail style preview would be a "nice to have" bonus.


There's something funny about you agreeing it needs to be kept simple and then asking for a new feature in the same post.

I don't understand this keep it simple mentality at all. This is a purpose-driven hack. It's going to get used by the people who need it and not used by the people who don't. Keeping it simple to have it be more "accepted" by the community really serves no purpose.

In any case, I'm not advocating turning it into something massively complex; I think it's a great hack and I'm offering suggestions to make it even better. Things like:

Subcats for bugs/trouble reasons

A way to edit bugnotes.

Email notification

Are not huge things, and in fact can use the stuff vb3 already has built in. I'm advocating change here for the good of everyone who uses this hack. Otherwise it's going to go the way of other hacks I have seen - everyone just goes off and does their own private modifications and the main hack itself dies. There must be 30+ vb2 hacks I've seen that happen to.

Let's work on making this thing better then. It's massively useful for a lot of vb owners.

Stadler
03-04-2004, 03:51 AM
I don't see a point in doing this as mySQL 3 is outdated anyway, so feel free to do that if you want.I disagree with you although I prefer MySQL 4 as well, but this isn't the right thread to discuss this ;)But I think it'll require more then "a bit more" hacking.You were right, but I've done it anyway ;) It looks to me, that all changes we're flawless so but I'm going though a bit more testing now, before I'll 'release' it here.

You could eMail me, if you want to take a look. :)

Roderik
03-04-2004, 10:35 PM
concerning the mySQL v3 - v4 questions that float throught this thread:

I'm running a forum on a virtual hosting with some company that isn't going to upgrade anytime soon. The host runs with 3.23.58 Since i really really really wanted this hack i went snooping throught the source and on the mySQL site.

The only fulltext search thing in the script is the "MATCH AGAINST IN BOOLEAN MODE". The mySQL manual stats


As of Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT. FULLTEXT indexes are used with MyISAM tables only and can be created from CHAR, VARCHAR, or TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. For large datasets, it will be much faster to load your data into a table that has no FULLTEXT index, then create the index with ALTER TABLE (or CREATE INDEX). Loading data into a table that already has a FULLTEXT index could be significantly slower.


Some pages back in this thread there is someone with 3.23.57 that uses it without problems so it works just fine on myISAM tables on a mySQL server > 3.23.23.

Andreas
03-04-2004, 10:43 PM
@Roderik

As of Version 4.0.1, MySQL can also perform boolean full-text searches using the IN BOOLEAN MODE modifier.

Therefore I don't think it'll work on mySQL-Versions < 4.0.1

@Stadler
If you want you can send me a copy - kirby(at)gmx.net

Roderik
03-04-2004, 11:58 PM
Damn :) should have kept reading till the botom of the page :)

Since i was bored i made a little function that makes a nice mySQL 3 string of where statements to "replace" the full text indexing.

Function works, didn't try the sql output but it's already 3.00 AM...

Hope you can do something with it to make the thing fully mySQL 3 compatible


<?php
/**
* Function that will handle the conversion from the boolean
* full text search that is only available for mySQL v4.0.1
* and higher to a mySQL v3 alternative.
*
* @param string $keywords (+xxx -yyy +zzz)
* @return string the string with the sql commands
* @author Roderik van der Veer <roderik@vanderveer.be>
* @version $Id$
*/


function mysqlVersionThreeFix($keywords){
$kw = explode(" ", $keywords);

$kwplus = array();
$kwmin = array();

for ($i=0; $i < sizeof($kw); $i++){
if ($kw[$i]{0} == '+'){
array_push($kwplus, substr($kw[$i], 1));
} else {
array_push($kwmin, substr($kw[$i], 1));
}
}

$sqlstring = 'AND (';

for ($i=0; $i < sizeof($kwplus); $i++){
if ($i != 0) {
$sqlstring .= ' AND ';
}
$sqlstring .= "(name LIKE '%".$kwplus[$i]."%' OR description LIKE '%".$kwplus[$i]."%')";
}
for ($i=0; $i < sizeof($kwmin); $i++){
$sqlstring .= " AND (name NOT LIKE '%".$kwmin[$i]."%' OR description NOT LIKE '%".$kwmin[$i]."%')";
}

$sqlstring .= ') ';

return $sqlstring;

}

$keywords = '+word1 +word2 -word3 +word4 -word5';

echo mysqlVersionThreeFix($keywords);

?>


Output:
AND ((name LIKE '%word1%' OR description LIKE '%word1%') AND (name LIKE '%word2%' OR description LIKE '%word2%') AND (name LIKE '%word4%' OR description LIKE '%word4%') AND (name NOT LIKE '%word3%' OR description NOT LIKE '%word3%') AND (name NOT LIKE '%word5%' OR description NOT LIKE '%word5%'))

Andreas
03-05-2004, 12:27 AM
Nice one :)
But I fear it's not fully compatible:

What about complete phrases enclosed by quotes?
I think your implementation will treat it as individual words.
What about asterisk?
I think this is a major problem. If I search for hack (with mySQL 4) it would not return rows containing hacks - your implementation would.
If I search for hack* (with mySQL 4) it would return rows containing hack, hacks, etc. - your implementation would return nothing.
What about negation?
It seems like you don't support this at all, treating it as part of a word.
Now if I search for ~vB3 (with mySQL 4) it would return rows that do not contain vB3, your implementation would return those only.
What about sub-expressions?
What if you do not put a plus/miuns in front of a word?
It seems link in this case your implementation would strip off the first character and treat them as NOT words.


Although I think the performance wouldn't be good. Anyway, it's in interesting point to start with.

Roderik
03-05-2004, 09:49 AM
as i said, was bored, didn't even install the mod yet zo i based what $keywords would be from the little example at the mySQL manual :)


* What about complete phrases enclosed by quotes?
I think your implementation will treat it as individual words.


it does indeed, and it will break if you try :) but that can be fixed by


$lastgood = 0;
$lastsign = true;

for ($i=0; $i < sizeof($kw); $i++){
if ($kw[$i]{0} == '+'){
array_push($kwplus, substr($kw[$i], 1));
$lastgood++;
$lastsign = true;
} else if ($kw[$i]{0} == '-'){
array_push($kwmin, substr($kw[$i], 1));
$lastgood++;
$lastsign = false;
} else {
if ($lastsign){
$kwplus[$lastgood] .= ' ' . $kw[$i];
} else {
$kwmin[$lastgood] .= ' ' . $kw[$i];
}
}
}




* What about asterisk?
I think this is a major problem. If I search for hack (with mySQL 4) it would not return rows containing hacks - your implementation would.
If I search for hack* (with mySQL 4) it would return rows containing hack, hacks, etc. - your implementation would return nothing.


indeed, also true :) , just stripping these special chars would do the trick, only thing, searching for hack* could be betaHacks as well.

But it can be fixed too :), by replacing * with % and in the code that builds of the sql we remove the %'s from the strings


* What about negation?
It seems like you don't support this at all, treating it as part of a word.
Now if I search for ~vB3 (with mySQL 4) it would return rows that do not contain vB3, your implementation would return those only.


you can use + and -, so the - does negation
name NOT LIKE '%".$kwmin[$i]."%'
so name won't contain $kwmin[$i]

what does the ~do other than de - ?


* What about sub-expressions?


yeah that doesn't work :) it's a backward fix, if everyting was so easy they would have put it in in version 1 :p


* What if you do not put a plus/miuns in front of a word?
It seems link in this case your implementation would strip off the first character and treat them as NOT words.


also correct, partially fixed in the code above. But it does indeed depend on the correct input from the script that calls it.

Roderik
03-05-2004, 01:20 PM
ok never mind my code

http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15665/

Red Blaze
03-05-2004, 01:45 PM
So is this hack stable now? Is it safe to install without having problems?

EDIT: I threw the risk and I'm glad I did. Worked flawlessly. Thanks alot. :)

daFish
03-09-2004, 03:32 PM
Hey Kirby,

any news on a news version or something else?
Maybe you can change the displayed location in the navbar based on the forum where the bugtrack is installed.

ixian
03-09-2004, 03:42 PM
I've picked up on a minor bug:

When you first create a bug, if you assign it a state/assign it to someone, it doesn't save it. You have to go back to the bug, edit it, and change things then in order for it to take.

Also, any ideas on how to make the default view not show closed tickets, instead of showing all tickets right now?

Stadler
03-10-2004, 08:25 PM
Hey Kirby,

any news on a news version or something else?
Maybe you can change the displayed location in the navbar based on the forum where the bugtrack is installed.
I have sent him my modified version some days ago. Dunno if he's busy atm.

ixian
03-10-2004, 08:46 PM
I have sent him my modified version some days ago. Dunno if he's busy atm.


Don't be shy dude, send it to me:) I'd love to take a look at it.

ix@maximumgamer.com

Thanks!

daFish
03-11-2004, 09:29 AM
I have sent him my modified version some days ago. Dunno if he's busy atm.
Good to hear.
Let's hope he finds the time to bring up a new version. :)

ixian
03-21-2004, 04:29 AM
I'm assuming this hack has been abandoned? Just want to be sure here.

Shane
04-04-2004, 11:24 PM
Screenshots are in the zip file. Note that if you install this its pretty un-useable at the moment as not all the templates are in the XML file for starters. Also no mater which method you install from the datastore isn't setup correctly so you get lots of errors everywhere from that too.
i.e. Where is the .txt file?

Shane
04-05-2004, 01:48 AM
i.e. Where is the .txt file?
nm.. didn't relzie there was another zip inside the zip..



Btw.. I loved it so much I gone and fixed most of the errors/templates. No idea if I am allowed to share them but I am going to fix the errors in the adminCP next.

netmax
04-05-2004, 11:52 AM
Hi,

first of all - this hack is great and exactly what i needed .

I discovered a bug: When you select Bugs-Modify in AdminCP, only the first xx (xx in the $perpage) Bugs are displayed - and no selector for the next page is displayed. How to get to the next page to see the other items?

Marco

Stadler
04-05-2004, 01:29 PM
I'm waiting for permission from Kirby to release my modification to make the hack work with MySQL 3

NTLDR
04-05-2004, 01:37 PM
i.e. Where is the .txt file?

readme.txt

Boofo
04-05-2004, 01:45 PM
What did you mean when you said "the datastore isn't set up correctly"? I'm just curious how it can get messed up that easily. ;)

Shane
04-07-2004, 07:20 AM
What did you mean when you said "the datastore isn't set up correctly"? I'm just curious how it can get messed up that easily. ;)
Just so you all know what I been working on...
there is a new option... "private" report. So only people in your "Bugs Reporting Group" can see the Bugs. I am sorta using it as a tracker also on my site. Alot of the bugs that I have seen I have removed and I am working on fixing more of them. There is some that deal with searching and I am going to fix that and add sorting "links" on the headers. I am also going to try an add the "extra" navbit to add "Unconfirmed" so that is a way to disaply all those posts.

Questions? Comments?

ixian
04-07-2004, 03:04 PM
Shane,

Sounds excellent, and I'd love it if you'd share your mods, even privately for now (hint).

IMHO there are two major things this hack is missing (besides the fixes you already mention):

Email notification

Color-coding bugs by priority. i.e. critical bugs are highlighted in red, new in yellow, etc etc. That's a huge help when viewing a lot of bugs.

If you want any help with this email me and we can put our heads together. This is a frustrating hack - so good, yet so far from being complete:)

Shane
04-07-2004, 04:04 PM
Shane,

Sounds excellent, and I'd love it if you'd share your mods, even privately for now (hint).

IMHO there are two major things this hack is missing (besides the fixes you already mention):

Email notification

Color-coding bugs by priority. i.e. critical bugs are highlighted in red, new in yellow, etc etc. That's a huge help when viewing a lot of bugs.

If you want any help with this email me and we can put our heads together. This is a frustrating hack - so good, yet so far from being complete:)
Yeah. Good ideas. I'll add that to the bugs/tracker list now :)

I was thinking about how I was going to implememte email notification. I might have to create a new "database" table for it.

Shane
04-07-2004, 04:05 PM
But... the servierys could be at different stages.

Shane
04-07-2004, 08:27 PM
I am going to try and gather you all together so we can work on this, because with all our changes, we are going to need a "cvs" server. I might signup a soruceforge project name vbhacks, for people to "control" there hack scripts. Sound interesting or do people like "secret" hacks? :)

Shane
04-08-2004, 02:23 PM
Just to keep ya all informed. I got rid of lots of bugs last night and almost totally re-wreiting the code more effecitly. Going to do one more sweep and then release it how I have it. Then I am going to started adding goodies... WYSIWUG edior and stuff into it :)

Shane
04-10-2004, 04:55 PM
If someone knows where I can get the "temporay" phrases list... that be very helpfull. That is the only thing keeping me from relasing the new version.

Stadler
04-10-2004, 11:00 PM
I'd love to share my MySQL3-Changes with you, but I'm still waiting for permission from Kirby.

btw: An option to notify admins, when a new Bug has been reported would be very useful. Dunno if this has already been suggested ...

escher
04-10-2004, 11:26 PM
I would love to see this ported to MySQL 3.x.

ixian
04-11-2004, 03:40 AM
If someone knows where I can get the "temporay" phrases list... that be very helpfull. That is the only thing keeping me from relasing the new version.


I'm not sure I understand what you are looking for?

Shane
04-11-2004, 04:18 AM
TO use HTL for everyone to has it installed, I need the temp files. It the hack I reluctlly had to install because lots of people have it. The "list" is to help the system download the correct files. I might just have to make it manually.

@Stadler: I am opening up my code once I get ym CVS server online so people can help out. If you want to send your code now to my email address bugs at bugssite dot org I can add the with the fixes I've done. If there was any template changes I would need those as well. I am as well waiting for Kirby to get back to me.

Email, Notification System is on hold till I can get this release out at least on my end. Otherwise right now I have totoally re-originized the code into vB.com format and functioniality. :) My users love it on http://forum.starfleets.net

Stadler
04-12-2004, 01:55 PM
@Stadler: I am opening up my code once I get ym CVS server online so people can help out. If you want to send your code now to my email address bugs at bugssite dot org I can add the with the fixes I've done. If there was any template changes I would need those as well. I am as well waiting for Kirby to get back to me.Ok, I've eMailed you the changes now.

Lets hope, Kirby replies here soon :)

Shane
04-12-2004, 05:18 PM
Aye, got the email. :)

13th_Disciple
04-15-2004, 12:21 AM
Would be nice if this hack could have multiple instances.. in other words, have multiple installs and assign seperate bug tracking areas to different projects within a single site.. this way, for something like what i would want, you can have one group with a project that has one bug tracking section, another group with a seperate bug tracking area to support another totally seperate project.. have so a prefix is attached to each seperate bug tracker instance so bug id's wouldn't be duplicated within the bug tracker tables..

can this hack support that? i have not seen it mentioned anywhere within the thread and doing a search for "multiple" within the thread returned zero results..

ixian
04-15-2004, 12:27 AM
Would be nice if this hack could have multiple instances.. in other words, have multiple installs and assign seperate bug tracking areas to different projects within a single site.. this way, for something like what i would want, you can have one group with a project that has one bug tracking section, another group with a seperate bug tracking area to support another totally seperate project.. have so a prefix is attached to each seperate bug tracker instance so bug id's wouldn't be duplicated within the bug tracker tables..

can this hack support that? i have not seen it mentioned anywhere within the thread and doing a search for "multiple" within the thread returned zero results..


We're just trying to get the bugs fixed right now dude, as the original author either isn't supporting it or cannot do so. What you want.....don't hold your breath for two long, if you know what I am saying.

Frankly, for that kind of complexity, you would be better off with something like Mantis or phpbugtracker.

Shane
04-15-2004, 12:37 AM
We're just trying to get the bugs fixed right now dude, as the original author either isn't supporting it or cannot do so. What you want.....don't hold your breath for two long, if you know what I am saying.

Frankly, for that kind of complexity, you would be better off with something like Mantis or phpbugtracker.
To beleive it or not I have thought of that and added to to a the "new feature" in my "To Do" tracker :D

With many devlopers for just one things, but as ixian said.. we are working on the fixes first and then we can go into MORE fun stuff. :)

13th_Disciple
04-15-2004, 01:12 AM
We're just trying to get the bugs fixed right now dude, as the original author either isn't supporting it or cannot do so. What you want.....don't hold your breath for two long, if you know what I am saying.

Frankly, for that kind of complexity, you would be better off with something like Mantis or phpbugtracker.
okay.. dude..

Catch-22|BL
04-15-2004, 10:26 AM
Six more weeks have passed so let's just move this thing into the full release section already. It delivers what it says on the outside of the box and that will be enough for most of us. I didn't know if he wanted new suggestions, I cannot remember now....I might even have exchanged messages with Kirby|DE. Maybe I am mistaken? But anyway, he clearly was not going to make this is a big deal so let's just consider it a finished product.

Shane
04-15-2004, 01:48 PM
Not always a good idea, but trying hard to get these phrases exported.

tilight
04-16-2004, 06:08 AM
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
04-16-2004, 11:47 AM
Umm... wait till I release the new version? :)

tilight
04-16-2004, 01:00 PM
Yay new version thanks Shane, btw great job I love it.

BTW is there a file attaching capability? If not, it should be added to a future version :)

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
04-16-2004, 05:14 PM
Creating new thread for it as we speak :)

jwpexe2
07-23-2004, 04:31 AM
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
07-23-2004, 09:24 PM
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
07-23-2004, 09:27 PM
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
07-25-2004, 05:16 AM
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
08-09-2004, 07:56 PM
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.php?thread_id=1072582&forum_id=368467 please? :)

Dark_Wizard
09-06-2004, 10:39 PM
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 (http://www.vbwar.com/forums/bugs.php), please remember that it isn't complete.

mikaelweb
01-24-2005, 05:29 PM
i have problems whit install of this hack im using vBulletin 3.0.6 and having more problems whit admincp this part i have problem whit in admincp

construct_nav_group($vbphrase['options'], '<hr />');
}
if ($printhr == true)
{
construct_nav_spacer();
}

// *************************************************

BELOW that ADD:
------------
if (is_member_of($bbuserinfo, $vboptions['bugadmingroup'])) {
if ($printhr == true)
{
construct_nav_spacer();
}
construct_nav_option("Add","bugsadmin.php?$session[sessionurl]do=add");
construct_nav_option("Modify","bugsadmin.php?$session[sessionurl]do=modify");
construct_nav_option("Moderate","bugsadmin.php?$session[sessionurl]do=moderate");
construct_nav_group("Bugs");
construct_nav_option("Add","bugsadmin.php?$session[sessionurl]do=addstate");
construct_nav_option("Modify","bugsadmin.php?$session[sessionurl]do=modifystate");
construct_nav_option("Sort","bugsadmin.php?$session[sessionurl]do=orderstates");
construct_nav_group("Bug-States");
construct_nav_option("Add","bugsadmin.php?$session[sessionurl]do=addseverity");
construct_nav_option("Modify","bugsadmin.php?$session[sessionurl]do=modifyseverity");
construct_nav_option("Sort","bugsadmin.php?$session[sessionurl]do=orderseverities");
construct_nav_group("Bug-Severities");
construct_nav_option("Add","bugsadmin.php?$session[sessionurl]do=addtype");
construct_nav_option("Modify","bugsadmin.php?$session[sessionurl]do=modifytype");
construct_nav_option("Sort","bugsadmin.php?$session[sessionurl]do=ordertypes");
construct_nav_group("Bug-Types");
if ($printhr == true)
{
construct_nav_spacer();
}
}

and the install cant get it working PLEASE HELP

whb
03-25-2006, 04:24 PM
Hello, works with vBulletin 3.5.4 ???

Andreas
03-26-2006, 11:14 PM
Definitly not.

gavinzac
04-09-2006, 06:12 PM
any plans to convert it, or any similar hacks existing?