vb.org Archive
Page 26 of 30 « First 162425 26 2728 Last »
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)

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


All times are GMT. The time now is 04:50 PM.
Page 26 of 30 « First 162425 26 2728 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.01489 seconds
  • Memory Usage 1,841KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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