vb.org Archive
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBug Tracker 1.0.3 (https://vborg.vbsupport.ru/showthread.php?t=69600)

Natch 11-15-2004 01:05 AM
Visit vbwar.com :)

linuxgurugamer 11-17-2004 01:14 AM
I just installed vbug on my system. Looks nice, but I ran into a problem with the vbug_install.php.

I have a table prefix for all my tables. In vbug_install.php, there are several references to the datastore table without the table prefix. This causes the install to fail if there is a table prefix.

Let me know if you want a fixed version of it.

Also, I see that you don't use the table prefix for the vbug tables. I think you should, otherwise it would be very difficult to run more than one forum on a single system.


JBB

theArchitect 11-18-2004 04:16 AM
I am having a problem with user group preferences.

When I scroll down to the section in the user group manager for the bug tracker and change the preferences the system is not remembering these preferences. As a result my Registered Users have the power to administer bugs.

Any thoughts.

Natch 11-18-2004 10:35 PM
I would recommend in thi sinstance (until the author comes back from a cruise ;)) that you backup your bug and comments tables, then uninstall and reinstall the script...

Zachariah 11-25-2004 05:33 PM
Mr. Wizard - nice dude.

Found some stuff: ver. - 1.02 (11.25.04 download)

1) Edit Bug template in AdminCP - missing phrase (Bug Version)
2) vbugs_footer (1) - 1 queries for uncached templates

The Wise One 11-25-2004 06:00 PM
real nice hack. been looking for something like this for quite awhile.

i am xperiencing a couple of problems...

when viewing vbugs.php? in the browser, i enter a text search term in the "Enter a bug ID or terms to search for:" box and get an error. i know the exact search term exists in one of the bug posts.

this is the error:


Code:
Database error in vBulletin 3.0.3:

Invalid SQL:
        SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
        FROM vbugs
        LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
        LEFT JOIN user AS admin ON (vbugs.adminid = admin.userid)
        LEFT JOIN user ON (vbugs.userid = user.userid)
        LEFT JOIN user AS lastreply ON (vbugs.lastreplyuid = lastreply.userid)
        LEFT JOIN vbug_type ON (vbugs.vbug_typeid = vbug_type.vbug_typeid)
        LEFT JOIN vbug_version ON (vbugs.vbug_versionid = vbug_version.vbug_versionid)
        LEFT JOIN vbug_severity ON (vbugs.vbug_severityid = vbug_severity.vbug_severityid)
       
        WHERE 1 AND MATCH (title, description) LIKE '%search error%'
        ORDER BY lastedit desc
        LIMIT 0, 15
       
mysql error: You have an error in your SQL syntax near 'LIKE '%search error%'
        ORDER BY lastedit desc
        LIMIT 0, 15
        ' at line 12

mysql error number: 1064

Date: Thursday 25th of November 2004 02:33:21 PM
Script: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=search+error
Referer: http://forums.pcper.com/vbugs.php?s=&do=list&textsearch=
Username: The Wise One
IP Address: *********
i get the same error if i use the EXACT title of a bug...word for word. searching using the options below the bug list works fine except if i try to use the field to enter text to search by.

also...even tho i (and others) have ticked the subscribed box...email notifies dont function when someone replies.

what i think would be great to add to this would be a way to edit the content of individual posts in the tracker.

any ideas?

Zachariah 11-25-2004 06:09 PM
Same for me Wise One.

I did a little adminCP/index.php menu edit also.

1 dropdown menu vs. 5
- To me having 5 dropdowns vs. 1 is a waste of space.

Code:
// vBug Tracker
// *************************************************

if ($permissions['vbugpermissions'] & CANADMINBUGS)
{
  if ($printhr == true)
  {
    construct_nav_spacer();
  }
  construct_nav_option("Add","vbugs_admin.php?do=add");
  construct_nav_option("Modify","vbugs_admin.php?do=modify");
  construct_nav_option("Moderate","vbugs_admin.php?do=moderate");
  construct_nav_option("<b><u>vBug Status</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addstatus");
  construct_nav_option("Modify","vbugs_admin.php?do=modifystatus");
  construct_nav_option("<b><u>vBug Severities</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addseverity");
  construct_nav_option("Modify","vbugs_admin.php?do=modifyseverity");
  construct_nav_option("<b><u>vBug Versions</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addversion");
  construct_nav_option("Modify","vbugs_admin.php?do=modifyversion");
  construct_nav_option("<b><u>vBug Types</u></b>","");
  construct_nav_option("Add","vbugs_admin.php?do=addtype");
  construct_nav_option("Modify","vbugs_admin.php?do=modifytype");
  construct_nav_group("vBug Bugs");
        if ($printhr == true)
  {
    construct_nav_spacer();
  }
}
// vBug Tracker

The Wise One 11-25-2004 06:26 PM
nice. much cleaner. thanks! :)

peterska2 11-25-2004 08:41 PM
OK open to ideas

Code:
Warning: Invalid argument supplied for foreach() in
/path to/vbugs.php on line 104

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

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

Warning: Invalid argument supplied for foreach() in
/path to/vbugs.php on line 119
Theres a table prefix which was a bugger to work around with this but I got there in the end. I need this fixing tonight though :(

peterska2 11-26-2004 09:34 PM
anyone?????

I'm getting stressed about this as I just can't get a workaround going.

tkeil69575 11-26-2004 11:27 PM
as far as I can see this line

LEFT JOIN user ON (vbugs.userid = user.userid)

should read

LEFT JOIN user AS user ON (vbugs.userid = user.userid)

at least it fixed the mysql error I got when I first called vbugs.php

regards
Tina

ps. has to be fixed in 2 instances in vbugs.php

peterska2 11-26-2004 11:33 PM
I've tried that already but it didn't have any effect

tkeil69575 11-27-2004 12:44 AM
Quote:
Originally Posted by peterska2
I've tried that already but it didn't have any effect
peterska2 ... the fix i mention does not relate to your problem. i'd say you have missing templates or something like that ... id probably uninstall and try again ... probably something went wrong during the install.

tina

The Wise One 11-27-2004 01:22 AM
Quote:
Originally Posted by tkeil69575
as far as I can see this line

LEFT JOIN user ON (vbugs.userid = user.userid)

should read

LEFT JOIN user AS user ON (vbugs.userid = user.userid)

at least it fixed the mysql error I got when I first called vbugs.php

regards
Tina

ps. has to be fixed in 2 instances in vbugs.php
thanks for that :) unfortunately...it didnt fix my problem (thats assuming you posted that possible fix in response to my post).

peterska2 11-27-2004 09:13 PM
Quote:
Originally Posted by tkeil69575
peterska2 ... the fix i mention does not relate to your problem. i'd say you have missing templates or something like that ... id probably uninstall and try again ... probably something went wrong during the install.

tina
Damn,

I guess I'd best drop the table prefix throughout the vB and start again from scratch eh?

john_rsd 11-28-2004 01:27 AM
I have set general permissions in usergroups for those who can / cannot post to bugtracker.

but I would have liked to have kept it private using forum password or just using custom usergroup settings on that forum pointing to vbugs.php

If i tell the forum to have password it is not applied. I can access the forum anytime even with password set.

I cannot define custom usergroup settings either per forum. So it is not possible for me to exclude groups.

Is this by design?

Small example 1. I have guests set in default usergroup premissions as being able to add bugs/see bugs.

For now i want to keep forum private for testing.

So I edit the guest usergroup in that forum and change the forum permissions to custom and leave only view forum=yes, but turn off all other options (see others threads, post et all)

I do not see any possiblity for custom settings for vbugs here.

Guests can still see, post, add bugs without a problem!

Small example 2. I have password set for forum to which points to vbugs.php.

For now i want to keep forum private for testing.

So I set password

Guests can still see, post, add bugs without a problem! No password required.

Possible I am missing something simple here?

Dark_Wizard 01-06-2005 06:32 PM
Ok...I'm back, after my cruise and the holidays I will start on the next version for those few little bugs. I am also going to complete the Pro version which can be obtained only from vbwar.com...

Next release will have all of the table prefixes redone....

PixelFx 01-06-2005 07:49 PM
Please let me know as soon as its out, and what paypal to use... glad ya had a good vacation.

if you need beta testers my team is very good at finding bugs...

Abe1 01-07-2005 01:13 AM
Here is a real bug:

When an admin chooses to make a bug 'private' when he is making a new bug, it doesn't make the bug private. You have to edit the bug after to make it private.

Here is the solution to fix it:

Find:
PHP Code:
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT)); 
Replace with:
PHP Code:
globalize($_POST, array('title' => STR, 'vbug_typeid' => INT, 'vbug_versionid' => INT, 'vbug_severityid' => INT, 'vbug_statusid' => INT, 'description' => STR, 'moderate' => INT, 'subscribe' => INT, 'private' => INT)); 

Find:
PHP Code:
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid) 
    VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid]) 

Replace with:
PHP Code:
INSERT INTO vbugs (userid, adminid, title, description, vbug_statusid, postdate, vbug_severityid, vbug_typeid, vbug_versionid, moderate, lastedit, lastreplyuid, private) 
    VALUES ('$bbuserinfo[userid]', '$adminid', '" . addslashes($title). "', '" . addslashes($description) . "', '$vbug_statusid', '" . TIMENOW . "', '$vbug_severityid', '$vbug_typeid', '$vbug_versionid', '$moderate', " . TIMENOW . ", $bbuserinfo[userid], '$private') 
Basicly, you forgot to make the 'do=insert' add the private variable.

For thouse who don't realize, the file I'm talking about is: vbugs.php

Eric1776 01-07-2005 04:39 PM
When trying to do a search I get this error.
Code:
Database error in vBulletin 3.0.5:

Invalid SQL:
        SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
        FROM vbugs
        LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
        LEFT JOIN user AS admin ON (vbugs.adminid = admin.userid)
        LEFT JOIN user ON (vbugs.userid = user.userid)
        LEFT JOIN user AS lastreply ON (vbugs.lastreplyuid = lastreply.userid)
        LEFT JOIN vbug_type ON (vbugs.vbug_typeid = vbug_type.vbug_typeid)
        LEFT JOIN vbug_version ON (vbugs.vbug_versionid = vbug_version.vbug_versionid)
        LEFT JOIN vbug_severity ON (vbugs.vbug_severityid = vbug_severity.vbug_severityid)
       
        WHERE 1 AND MATCH (title, description) LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
        ORDER BY lastedit desc
        LIMIT 0, 20
       
mysql error: You have an error in your SQL syntax near 'LIKE '%test%'  AND vbugs.vbug_typeid = '18' AND vbugs.vbug_statusid = '2'
        ORDER' at line 12

mysql error number: 1064

Date: Friday 07th of January 2005 01:43:20 PM
Script: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=test&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Referer: http://www.ezresources.net/forums/vbugs.php?do=list&s=&textsearch=&vbug_typeid=18&vbug_statusid=2&vbug_severityid=0&vbug_versionid=0&assignment=0&sortfield=lastedit&sortorder=desc
Username: Aragorn
IP Address: 160.136.49.104

Vman 01-09-2005 06:42 PM
I am now getting this error since I upgraded to 3.0.5....


--------------------------------------

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php

-------------------------------------


what do i need to do to correct this!!!

reteep 01-10-2005 07:42 AM
Quote:
Originally Posted by BBCVman
I am now getting this error since I upgraded to 3.0.5....
--------------------------------------
Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT usergroupid, (vbugpermissions & CANADMINBUGS) AS CANADMINBUGS
FROM usergroup

mysql error: Unknown column 'CANADMINBUGS' in 'field list'

mysql error number: 1054

Date: Sunday 09th of January 2005 02:40:35 PM
Script: http://www.fitnessgeared.com/forum/vbugs.php
-------------------------------------
what do i need to do to correct this!!!
You forgot to reedit the init.php:

Quote:
find:
**************************************************
// ### INSERT PLUGIN USERGROUP PERMISSIONS BITFIELDS HERE ###
**************************************************

add above:
**************************************************
// vBug Tracker Permissions
$_BITFIELD['usergroup']['vbugpermissions'] = array(
'canadminbugs' => 1,
'canaddbugs' => 2,
'canviewbugs' => 4
);

**************************************************
save, close and upload includes/init.php
**************************************************

FASherman 01-17-2005 05:04 PM
When is this hack going to support prefixed tables?

ccunnin71 01-18-2005 04:55 PM
Speaking of prefixed tables! The install hosed up... Yes, I do have the vb3_ prefixed table setup. How do I get around this? Better yet how do I uninstall this now? I see at the end of the 'vbug_install" is an uninstall option. What do I have to do to make this work?

Big bummer! I was really looking forward to using this mod. :tired: Should have spent more time on the older threads on this (of course I am reading them after the fact).

Thanks for any help in this situation.

PixelFx 01-18-2005 06:46 PM
I'm waiting for the pro version ;)

ccunnin71 01-18-2005 07:35 PM
I 2nd that :). Ok, restored from backup that I made before installing the mod. Yes, I have tripped up before and learned from my mistakes.

Ok Dark Wizard, look forward to your coding efforts.

FASherman 01-20-2005 12:32 AM
Quote:
Originally Posted by FASherman
When is this hack going to support prefixed tables?
I'll answer my own question: NOW.

Instructions to make this hack work with prefixed tables.

1. EDIT THE INSTALL SCRIPT (admincp/vbug_install.php)
--------------------------------------
FIND:
PHP Code:
    $DB_site->query("INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:10:\"statusname\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:10:\"statusname\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:10:\"statusname\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:10:\"statusname\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:10:\"statusname\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:10:\"statusname\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:10:\"statusname\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:10:\"statusname\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:10:\"statusname\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:10:\"statusname\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:12:\"severityname\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:12:\"severityname\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:12:\"severityname\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:12:\"severityname\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:8:\"typename\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:8:\"typename\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:11;a:2:{s:8:\"typename\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:12;a:2:{s:8:\"typename\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:13;a:2:{s:8:\"typename\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:14;a:2:{s:8:\"typename\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:15;a:2:{s:8:\"typename\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:16;a:2:{s:8:\"typename\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:17;a:2:{s:8:\"typename\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:18;a:2:{s:8:\"typename\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:19;a:2:{s:8:\"typename\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:20;a:2:{s:8:\"typename\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:11:\"versionname\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')"); 
REPLACE WITH
PHP Code:
    $DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:10:\"statusname\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:10:\"statusname\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:10:\"statusname\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:10:\"statusname\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:10:\"statusname\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:10:\"statusname\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:10:\"statusname\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:10:\"statusname\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:10:\"statusname\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:10:\"statusname\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:12:\"severityname\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:12:\"severityname\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:12:\"severityname\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:12:\"severityname\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:8:\"typename\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:8:\"typename\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:11;a:2:{s:8:\"typename\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:12;a:2:{s:8:\"typename\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:13;a:2:{s:8:\"typename\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:14;a:2:{s:8:\"typename\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:15;a:2:{s:8:\"typename\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:16;a:2:{s:8:\"typename\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:17;a:2:{s:8:\"typename\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:18;a:2:{s:8:\"typename\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:19;a:2:{s:8:\"typename\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:20;a:2:{s:8:\"typename\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:11:\"versionname\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')"); 
-------------------------------------
FIND:
PHP Code:
        $DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')"); 
REPLACE WITH:
PHP Code:
        $DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')"); 
SAVE INSTALL SCRIPT
================================================== ========

2. EDIT vbugs.php
---------------------------------
FIND:
PHP Code:
    SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname 
    FROM vbugs
    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
    LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid) 
REPLACE WITH:
PHP Code:
    SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname 
    FROM vbugs
    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid) 
----------------------------------
FIND:
PHP Code:
    SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
    FROM vbugs
    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
    LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid) 
REPLACE WITH:
PHP Code:
    SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
    FROM vbugs
    LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
    LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid) 
SAVE vbugs.php
================================================== ========

3. Follow the instructions contained in the install.txt file

ccunnin71 01-25-2005 03:40 PM
FASHerman Thanks! One small note... Your code change nearly did it. It also brought on "Parse error: parse error, unexpected T_STRING ...."

To correct goto top of you vbugs.php and add an additional line...


FIND
Code:
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'vbugs');
Add this right bellow
Code:
define('TABLE_PREFIX', 'vb3_');  //Your table prefix

That corrected things for me.

Dark_Wizard 01-25-2005 04:00 PM
Quote:
Originally Posted by PixelFx
I'm waiting for the pro version ;)
A beta test of this is coming soon...table prefixes done and alot of extra features not found in this version.

PixelFx 02-08-2005 01:13 PM
can;t wait for it :)

SpeedStreet 02-11-2005 09:05 PM
<schnap>

Fresh Install on Fresh Board in private testing environment:

Code:
Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in c:\wamp\www\admincp\vbugs_admin.php on line 125

SpeedStreet 02-12-2005 04:59 PM
Does anyone have an idea? I've poured over this code and I cannot find anything that is inherently wrong with it. I should also say I am using the new 3.0.6. Everything appears fine in the front end (bugs can be added, etc. It's only when the admincp tries to access vbugs_admin.php

SpeedStreet 02-16-2005 04:03 PM
Sad that this hack seems to have died the closer we all get to vbugs pro. I wanted to test out the lite version for my company looking to integrate it into their intranet, but it looks like I will have to go to an open source, more fully supported product :(

ccunnin71 02-17-2005 03:09 PM
I am running it on 3.0.6 with prefixed tables. Works fine... I made the changes that FlashCode suggested with my one fix. It's a pretty limited system but workable.

I would go over your install again and see if you got one of the steps mixed up. Be sure you gave your admin rights as well.

Dark Shogun 02-18-2005 12:53 PM
Quote:
Originally Posted by SpeedStreet
<schnap>

Fresh Install on Fresh Board in private testing environment:

Code:
Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in c:\wamp\www\admincp\vbugs_admin.php on line 125
I have the exact same problem. I am running my board on a private system and get the same exact error when I try to add/change any of the vbug dropdowns in the admincp. Can someone please help us out?

Dark Shogun

SpeedStreet 02-18-2005 06:46 PM
I just reinstalled and I am now using table prefixes...so I will see if this works.

SpeedStreet 02-18-2005 08:04 PM
vBug Tracker 1.02 works with vBulletin 3.0.6
=================================

I now have the system up and running.

It's quite slick. Though my concerns now lie in the support sector if I were to purchase this for our Intranet.

In order to have this work properly for your board, you MUST make some changes.

Fasherman's Add dB Prefixes: HERE

StormBlast's init.php fix:
HERE

And for a cleaner UI, I reccomend HarryButt's little nugget: HERE

Unfortunately, I cannot speak to how this will work on a dB without prefixes, though I assume it should flesh out OK.

Good Luck everyone!

Dark_Wizard 02-19-2005 03:44 PM
Well...I'm back and now there is an updated version that fixes one small bug that fell unnoticed and table prefixes have been updated and tested on vB 3.0.6.

I'm sorry that I haven't been around as I have been busy with my Gold release of vBWar 3.0 and some other various projects. FYI, the Pro version is back in full swing and will be available for beta testing within the next few weeks but can only be obtained at vbwar.com.

PixelFx 02-19-2005 04:10 PM
Quote:
Originally Posted by Dark_Wizard
Well...I'm back and now there is an updated version that fixes one small bug that fell unnoticed and table prefixes have been updated and tested on vB 3.0.6.

I'm sorry that I haven't been around as I have been busy with my Gold release of vBWar 3.0 and some other various projects. FYI, the Pro version is back in full swing and will be available for beta testing within the next few weeks but can only be obtained at vbwar.com.
let me know if you need beta testers, I have 6000 developers that could test the crap out of it ;)

Dark_Wizard 02-19-2005 04:12 PM
Quote:
Originally Posted by PixelFx
let me know if you need beta testers, I have 6000 developers that could test the crap out of it ;)
ROFLMAO...you are already at the top of my list...I will keep you posted!


All times are GMT. The time now is 05:49 PM.
Page 4 of 5 « First 23 4 5
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.01594 seconds
  • Memory Usage 1,946KB
  • 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
  • (8)bbcode_code_printable
  • (12)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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