vb.org Archive - vBug Tracker Lite 3.5.1

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBug Tracker Lite 3.5.1 (https://vborg.vbsupport.ru/showthread.php?t=96888)

precharge

08-08-2006 12:30 AM

Would like regular users to be able to submit bugs but not view them. The only way they seem to be able to add is to have view access. Is there a fix to this?

Trevor Hannant

08-10-2006 10:51 PM

Has anyone requested a 3.6 version of this?

MThornback

08-22-2006 10:27 PM

Quote:

Originally Posted by jluerken

It has problems since vb3.6 with those lines in vbugs.php

PHP Code:


		
			
foreach ($bugcache['severity'] as $key => $entry) {

  $selected = iif($vbulletin->GPC['vbug_severityid'] == $key, 'selected="selected"');

  $val = $entry['title'];

  eval('$severitybits .= "' . fetch_template('userfield_select_option') . '";');

}

foreach ($bugcache['type'] as $key => $entry) {

  $selected = iif($vbulletin->GPC['vbug_typeid'] == $key, 'selected="selected"');

  $val = $entry['title'];

  eval('$typebits .= "' . fetch_template('userfield_select_option') . '";');

}

foreach ($bugcache['version'] as $key => $entry) {

  $selected = iif($vbulletin->GPC['vbug_versionid'] == $key, 'selected="selected"');

  $val = $entry['title'];

  eval('$versionbits .= "' . fetch_template('userfield_select_option') . '";');

}

foreach ($bugcache['status'] as $key => $entry)

{

        $statuscount = $db->query_first("

        SELECT count(*) AS status

        FROM " . TABLE_PREFIX . "vbug

        WHERE vbug_statusid = $key

        ");

  $numstatuses = $statuscount['status'];

  $selected = iif($vbulletin->GPC['vbug_statusid'] == $key, 'selected="selected"');

  $val = $entry['title']. "&nbsp;(" .$numstatuses. ")";

  eval('$statusbits .= "' . fetch_template('userfield_select_option') . '";');

}

The foreeach statement is wrong but I am not a programer to say what has changes with 3.6 and how those lines need to look now. :(

Attached is our work around....it suppressed the errors...dunno if its a 100% fix

jluerken

08-22-2006 10:51 PM

Quote:

Originally Posted by MThornback

Attached is our work around....it suppressed the errors...dunno if its a 100% fix

Loool oh no. A few hours to late. Now I spend money for this
http://www.visionscripts.com/?page=p...vsproductid=10
:(

akanevsky

08-23-2006 01:35 AM

Quote:

Originally Posted by jluerken

Loool oh no. A few hours to late. Now I spend money for this
http://www.visionscripts.com/?page=p...vsproductid=10
:(

That was a good investment though. You won't regret it. ;)

Adrian Schneider

08-23-2006 01:41 AM

I switched to Mantis and I am very pleased with it.

akanevsky

08-23-2006 12:26 PM

Mantis has no vBulletin integration. Which makes it great for other purposes, but not for vBulletin developers / designers.

Zelda-King

08-23-2006 02:29 PM

Quote:

Originally Posted by MThornback

Attached is our work around....it suppressed the errors...dunno if its a 100% fix

One error less;

Quote:

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

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

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

Delphiprogrammi

08-24-2006 08:40 AM

you don't need to modify any source files to get this working with 3.6.x .If you import the product and goto the tracker page (vbugs.php) then you will get those foreach() errors Zelda-King posted above.

open the product xml and you will see it trys to run an INSERT query on the datastore table (actually 2 of them) but the product disables database errors sow if anything goes wrong MySQL won't show you anything

the datastore for the bugcache will fail and that is why you get that foreach() errors (it is missing in the database)

you can manually query your database to add it and then this will work fine...

one question left is it safe to use ?

Zelda-King

08-24-2006 10:45 PM

You mean this?

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('vbug_version', 's:5:\"3.5.1\"')");

                        $db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");

Delphiprogrammi

08-25-2006 06:36 AM

Quote:

Originally Posted by Zelda-King

You mean this?

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('vbug_version', 's:5:\"3.5.1\"')");

            $db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");

yeah this query

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('vbug_version', 's:5:\"3.5.1\"')");

is there in the database (afteryou import the product xml)

while this one

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");

will give a "values count don't match column count at row 1" error the attribute for the serialize column is missing in this query

Code:

INSERT INTO vb3_datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

would fix that note the bold part

issa	09-01-2006 07:11 AM

I'm not sure I follow your explanation, but I've tried replacing this query

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");

with

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

but this still fails. Am I not understanding you?

Zelda-King

09-01-2006 08:52 PM

No the instructions were instead of having the script make the query, run it yourself in vBulletin's query manager.

Noxious

09-04-2006 01:16 PM

right ok, so far i have

Downloaded the file vBug Tracker Lite 3.5.1a.zip
Downloaded the file vbugs.php
Uploaded and extracted vBug Tracker Lite 3.5.1a.zip
Overwritten the original vbugs.php file with the vbugs.php file in this thread
Ran the product file and then manually entered the query

Code:

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

and i still getting the same errors

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

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

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

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

what did i miss?

murdo

09-04-2006 02:36 PM

Ok, to clarify the process:

Downloaded the file vBug Tracker Lite 3.5.1a.zip
Extract vBug Tracker Lite 3.5.1a.zip

Edit "product-vBug_lite.xml"
- Look for line:

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");

and replace with

Code:

$db->query_write("INSERT INTO " . TABLE_PREFIX . "datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}', '0')");

Save the xml file.

Upload relavent files to your forum directory.

Install the "product-vBug_lite.xml" and you should be good to go!

(Too lazy? I've attached a fixed version of the archive!)

Noxious

09-04-2006 02:42 PM

yup now our vbugs works great, doesnt it murdo m8 :)

murdo

09-04-2006 02:44 PM

indeedy! great team effort :)

Zelda-King

09-04-2006 07:32 PM

Fixed here too, but just a note to others:

An XML upgrade (allow overwrite) doesn't fix it (not for me anyway). You need to uninstall the product THEN install the new version.

Backup the vbug tables and then when the product is reinstalled, select edit for one of your types/versions then save in order to update the dropdowns.

Noxious

09-09-2006 01:27 PM

Quote:

Originally Posted by Zelda-King

yes thats something we were unable to test as ours was a new installation

akanevsky

09-09-2006 01:58 PM

Quote:

You need to uninstall the product THEN install the new version.

lol... But uninstalling the product erases all the data from the database. Which makes it pointless to use this bugtracker in the first place.

Noxious

09-09-2006 05:31 PM

Quote:

Originally Posted by Zelda-King

Backup the vbug tables and then when the product is reinstalled, select edit for one of your types/versions then save in order to update the dropdowns.

may i point to the quoted highlighted part

akanevsky

09-09-2006 05:41 PM

Of course, but if there is a difference in table structure between the new and old versions, there could be a problem.

Noxious

09-09-2006 07:07 PM

ah stop crying your only moaning because you expect people to be ripped off by you, if you wanna upgrade from vb3.5 to vb3.6 and keep the bug system all you have to do is manually enter this sql code

Code:

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

otherwise if its a new installation, the altered files me and murdo did in this post are fine.

quite simple really isn't it much better than being ripped off $35 for one, wouldn't you say. Lets all boycot VisonScripts and shut this fool up once and for all, says everything about him his sig do not expect any of my free 3.5 hacks to become available on 3.6 anytime soon! get a life stop trying to rip people off

Delphiprogrammi

09-09-2006 07:23 PM

Quote:

Originally Posted by Noxious

ah stop crying your only moaning because you expect people to be ripped off by you, if you wanna upgrade from vb3.5 to vb3.6 and keep the bug system all you have to do is manually enter this sql code

Code:

INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:5:\"title\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:9:\"Won''t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:5:\"title\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:5:\"title\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:5:\"title\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:5:\"title\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:5:\"title\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:5:\"title\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:5:\"title\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:5:\"title\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:5:\"title\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:5:\"title\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:5:\"title\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:5:\"title\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:5:\"title\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:5:\"title\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}',0);

hmmm "being ripped off" i use two scripts provided by visonscripts and i have never been ripped off.This bugtracker is nothing compared to the Vs bugtracker ...If he chooces not to update his free hacks that's his right nothing you can say about that.

Zelda-King

09-09-2006 11:16 PM

Quote:

Originally Posted by Psionic Vision

Of course, but if there is a difference in table structure between the new and old versions, there could be a problem.

Possible. I haven't found one yet. What I do have is a cosmetic problem as reported in this post. It looks alright when a new bug is submitted then goes awry (see attachment in link) when an admin edits/assigns the bug.

akanevsky

09-10-2006 02:00 AM

Quote:

do not expect any of my free 3.5 hacks to become available on 3.6 anytime soon!

The reason I have that in my signature is because I do have a life and unfortunately, due to a variety of personal reasons that exist outside of the internet, this particular year have almost no spare time. I won't get into details as to why since you probably don't care anyway...

P.S. It seems that there is a slight difference between the datastore table in vBulletin 3.5 and vBulletin 3.6... Also, foreach is not just a cosmetic problem, but instead it a rather significant sign that there is a problem within the script, and that problem is causing an array of information not to be built properly. I wouldn't know the reason though since I am not the author of this script...

alfaowner

11-21-2006 06:55 PM

I get this every time I try to update the usergroups permissions:

Love to use this... any help out there... its ugp in field list unknown??

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Admin',
`opentag` = '<span style=\"color: #FF7D01; font-weight: bold; text-decoration: none;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pagerpermissions` = '13',
`pagerquota` = '100',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '10000',
`pagersendmax` = '100',
`pagersendmaxchar` = '500',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '3',
`pmsendmax` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '23',
`adminpermissions` = '3',
`genericpermissions` = '205520895',
`genericoptions` = '23',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`advanced_bbcode_usergroup_on` = '1',
`advanced_bbcode_usergroup_permissions` = '121',
`advanced_bbcode_usergroup_permissions_custom` = 'a1024',
`googlemappermissions` = '1',
`vbugpermissions` = '7',
`ugp` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugp' in 'field list'
Error Number : 1054
Date : Tuesday, November 21st 2006 @ 08:51:59 PM
Script : /faqtests/admincp/usergroup.php
Referrer : http:///faqtests/admincp/usergroup.p...&usergroupid=6
Username : alfaown
Classname : vb_database

BTW - I installed this one as well, still get same error - vBug Tracker Lite 3.5.1a (with 3.6 support).zip

midihead

02-08-2007 06:49 PM

Been a while since last post. Any support still for this?

Thanks,

M

midihead

02-08-2007 06:57 PM

Any fix yet for the blank page issue? I get a blank page when I check the "subscribe" box and submit a message. This only occurs if I'm REPLYING to an existing bug, not when I post one.

I see others have experienced the same thing. Would be nice to have a fix. Also, it appears to be posting the reply, but twice. Any ideas?

One more thing: How can I set it up so that an Admin is notified every time a new bug or reply is posted?

Thanks,

M

akanevsky

02-09-2007 04:06 PM

This project has long been dead, you may want to check out vS-Bug Tracker instead. You can find the link in my signature.

midihead

02-09-2007 04:31 PM

Quote:

Originally Posted by Psionic Vision (Post 1178481)

This project has long been dead, you may want to check out vS-Bug Tracker instead. You can find the link in my signature.

Yea, I was afraid of that. I checked out your version and it looks great, but I can't seem to get ionCube working on our server. We installed some support and ticketing software that we gave up on after 2 weeks of hell with ionCube.

Cheers,

M

akanevsky

02-09-2007 04:56 PM

Quote:

Originally Posted by midihead (Post 1178513)

Who's your hosting provider?

tanyeri24

02-24-2007 08:51 PM

screenshot or a working demo?

akanevsky

02-24-2007 10:57 PM

Quote:

Originally Posted by tanyeri24 (Post 1189973)

screenshot or a working demo?

Might want to read the last couple of posts. Esspecially post #270.

Xplorer4x4

02-24-2007 10:59 PM

Quote:

Here is a port of my vBug Tracker hack from vb 3.0.x. This mimics the Bug Tracker found at vBulletin.

Quoted from second line of the post

tanyeri24

02-25-2007 02:18 PM

Quote:

Originally Posted by Psionic Vision (Post 1190018)

Might want to read the last couple of posts. Esspecially post #270.

But it was not your release, thats because I asked.. Anyway thanks for answer.

ThomasR

04-10-2007 08:14 AM

Psionic Vision: as i posted on your forum, no support for the attachment yet? It's a big problem for us to don't have this feature.

Xplorer4x4

04-10-2007 08:28 AM

Quote:

Originally Posted by ThomasR (Post 1223985)

Psionic Vision: as i posted on your forum, no support for the attachment yet? It's a big problem for us to don't have this feature.

You realize this is a completely different hack then the one PV makes right?

chatzworld

05-23-2007 09:08 AM

i only hve 1 major problem with this bug tracker, when a user goes to view bugs he/she can view ALL the bugs even if the bug is not theirs, now this is a MAJOR problem as you would not want users seeing stuff submited by other users aspecaly if its complaints!

how can i fix this?

Xplorer4x4

05-23-2007 09:12 AM

Quote:

Originally Posted by chatzworld (Post 1253173)

Um it's not a bug, all bug trackers are designed this way.
http://www.vbulletin.com/forum/proje...pliesgroupid=7
As you see you can see all bugs.

All times are GMT. The time now is 11:37 PM.

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01865 seconds Memory Usage 2,004KB 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 (12)bbcode_code_printable (1)bbcode_php_printable (19)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
Messages: