[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

[StarBuG]

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]

Originally Posted by KirbyDE

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

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

Thx for your quick support!

I´ll wait for the other fixes.

Greetings

Star

[PranK]

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]

Originally Posted by PranK

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]

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

Originally Posted by KirbyDE

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

This is awesome. Will install soon.

[Tarion]

Originally Posted by TheComputerGuy

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.