vb.org Archive
Page 1 of 4 1 23 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   [HTL] & [very simple TXT] vB-Bugs (https://vborg.vbsupport.ru/showthread.php?t=61167)

Andreas 02-03-2004 10:00 PM
[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 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
Code:
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
PHP Code:
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....5&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

Code:
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!

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

Code:

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/...min.php?do=add
Referer: http://www.hiphop-battles.com/forum/...dex.php?do=nav
please help

StarBuG

MindTrix 02-04-2004 06:39 PM
Change

PHP Code:
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
Quote:
Originally Posted by MindTrix
Change
PHP Code:
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:
Code:
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/inde...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
Code:
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
PHP Code:
"WHERE usergroupid IN ($admingroups)" 
Tp
PHP Code:
"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

Code:
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/...min.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?

Quote:
Originally Posted by KirbyDE
> 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

Quote:
Originally Posted by KirbyDE
@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
Quote:
Originally Posted by StarBuG
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
Quote:
Originally Posted by StarBuG
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....1&postcount=24

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

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

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

Code:
<!-- 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
Quote:
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 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
Quote:
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 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
Quote:
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 02-05-2004 12:33 PM
This is awesome. Will install soon.

Tarion 02-05-2004 12:44 PM
Quote:
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.


All times are GMT. The time now is 04:48 PM.
Page 1 of 4 1 23 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01423 seconds
  • Memory Usage 1,867KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_code_printable
  • (5)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete