vb.org Archive
Page 15 of 20 « First 51314 15 1617 Last »
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)

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


All times are GMT. The time now is 06:44 PM.
Page 15 of 20 « First 51314 15 1617 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.01309 seconds
  • Memory Usage 1,813KB
  • 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
  • (2)bbcode_code_printable
  • (8)bbcode_php_printable
  • (4)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