[yoyoyoyo]

cool, thanks for the release

[cygy2k]

I uploaded and set permissions, etc but get a SQL error when trying to add an item to a project....

Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO tracker_items
(assignedid, threadid, projectid, versionid, severityid, typeid, statusid)
VALUES
(
,
16399,
1,
'1',
1,
1,
1
);
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 '
16399,
1,
'1',
1,
1,
1
)' at line 5
Error Number : 1064
Date : Monday, November 19th 2007 @ 09:10:16 AM
Script : http://www.xxx.com/forum/tracker.php...em&projectid=1
Referrer : http://www.xxx.com/forum/tracker.php?projectid=1
IP Address : xxx
Username : xxx
Classname : vb_database

[cygy2k]

I figured out the problem was that I hadn't tried assigning the item to a member. Can we get an error message pop-up or page stating all fields aren't completed instead of a generic SQL message?

[Darkwaltz4]

*ahem* bleeding edge thanks

in tracker.php find twice:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

replace both with:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

zip updated as well

[cygy2k]

Well I don't know why there are only 4 downloads - this is an amazing mod. Thank you so much!!!

[cygy2k]

Another database error issue. When editing a post outside of the project designated forum (i.e. completely different category and everything) gives the below message...

Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE tracker_items AS items LEFT JOIN tracker_statuses AS status ON (items.statusid = status.statusid) SET items.active = IF (status.final, , items.active) WHERE items.threadid = 16427;
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 ' items.active) WHERE items.threadid = 16427' at line 1
Error Number : 1064
Date : Monday, November 19th 2007 @ 01:57:00 PM
Script : http://www.xxx.com/forum/editpost.php

Referrer : http://www.xxx.com/forum/state-rival...ot-friend.html

IP Address : xxx
Username : xxx
Classname : vb_database

[Darkwaltz4]

thanks for your carefulness as well as praise - i tried to make the lite version still have the essence of the pro one

to fix that error, replace the contents of the vBTracker - Define Active Open plugin with

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

also, another error, in tracker.php find

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

and replace with

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

updating the zip. anything else?

[PixelFx]

Another toy for vb.org members to enjoy , its really helped with managing my own projects as well. I can't begin to say how powerful this new script is. I could of used it 3 years ago with one of my game development sites. We needed something that could track bugs, projects, and development teams. This little script can do multiple versions of all that. !!

[cygy2k]

Just put the fixes in place and will do some testing and let you know. Thanks so much again!

[ERuiz]

I installed it as per your instructions, but I don't see any options in the usergroups, to control their permissions for vbTracker. I have VB 3.6.7 installed.

EDIT: Nevermind, just noticed that the Usergroups feature is for the PRO version only.

[Darkwaltz4]

as noted the following permissions are hardcoded for the lite version:

A = admins, S = super mods, M = mods, R = registered users

can see and browse tracker projects: RASM
can post and reply: ASM
can edit own responses: AS
can edit all responses: A
can be assigned to submissions: AS
can manage submissions (update properties): A

[projectego]

Awesome!

/me clicks install

[trancetopia]

I've followed the instructions, rechcked them but no matter what I change the setting to I continue to get the following message:

Sorry, there are no projects available for you to browse at this time.

I have created the initial project as per your notes but it's not being identified!

[Darkwaltz4]

the order for the project has to be greater than 0. using a value of 0 will not prevent access if you accessed a direct link, but removes from the project directory.