vb.org Archive - Major Additions - GRPS: Groups Commune 2.0.x

hambil: As far as I can tell, you didn't look very hard or read the instructions. By "I've looked in the product.xml, and everywhere else", you must surely mean, "I've looked in the product.xml, and didn't bother looking anywhere else". Try looking in the grps_installer.php file in the ROOT/groups/tools directory of the product's zip file. You know, the one you run to finish installing GRPS, as described in the install.txt file.

To make it clearer, here's an excerpt from install.txt (the bold text is a clue):

Quote:

now go to your "groups/include/config_grps.php" and edit it accordingly. if you are having problems using your relative path, then please try your full path.

================

Now upload the files. and you're good to go (after running adding the product ofcourse).

--------

I need to advise you to back up your database before attempting anyway sort of database manipulation.

--------

You will now need to run groups/tools/grps_installer.php.

Excerpt from grps_installer.php:

PHP Code:


		
			
$db->query_write("

    ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `grpspermissions` INT(10)  UNSIGNED DEFAULT 0 NOT NULL

");



$db->query_write("

    ALTER TABLE `" . TABLE_PREFIX . "user` ADD `grps` MEDIUMTEXT NULL

");



$db->query_write("

    CREATE TABLE `grps` (

        `groupid` mediumint(9) NOT NULL auto_increment,

        `title` varchar(50)  NOT NULL default '',

        `description` varchar(250)  NOT NULL default '',

        `catid` smallint(2) NOT NULL default '0',

        `approved` enum('0','1')  default NULL,

        `create_date` int(10) unsigned NOT NULL default '0',

        `replycount` int(10) unsigned NOT NULL default '0',

        `lastpost` int(11) NOT NULL default '0',

        `membercount` int(10) unsigned NOT NULL default '0',

        `leaderid` int(10) default NULL,

        PRIMARY KEY  (`groupid`)

    )

");



$db->query_write("

    CREATE TABLE `grps_categories` (

        `catid` tinyint(3) unsigned NOT NULL auto_increment,

        `title` varchar(25)  NOT NULL default '',

        `description` varchar(250)  default NULL,

        PRIMARY KEY  (`catid`)

    )

");



$db->query_write("

    CREATE TABLE `grps_grouptext` (

        `groupid` mediumint(9) unsigned NOT NULL default '0',

        `pagetext` mediumtext  NOT NULL,

        `allowsmilie` enum('1','0')  default '1',

        `parseurl` enum('1','0')  default '1',

        `edit_reason` varchar(200)  default NULL,

        `edit_dateline` int(10) unsigned default NULL,

        `edit_userid` tinyint(4) default NULL,

        `edit_username` varchar(50)  default NULL,

        PRIMARY KEY  (`groupid`)

    )

");



$db->query_write("

    CREATE TABLE `grps_post` (

        `postid` int(10) unsigned NOT NULL auto_increment,

        `threadid` int(10) NOT NULL default '0',

        `groupid` mediumint(9) unsigned NOT NULL default '0',

        `parentid` int(10) unsigned default NULL,

        `username` varchar(50)  NOT NULL default '',

        `userid` int(10) unsigned NOT NULL default '0',

        `title` varchar(250)  NOT NULL default '',

        `dateline` int(10) unsigned NOT NULL default '0',

        `pagetext` mediumtext  NOT NULL,

        `ipaddress` varchar(16)  NOT NULL default '',

        `iconid` smallint(5) unsigned NOT NULL default '0',

        `visible` smallint(6) NOT NULL default '0',

        `attach` smallint(5) unsigned NOT NULL default '0',

        `allowsmilie` enum('1','0')  default NULL,

        `showsignature` enum('0','1')  NOT NULL default '0',

        `edit_username` varchar(50)  default NULL,

        `edit_userid` int(10) default NULL,

        `edit_reason` varchar(200)  default NULL,

        `edit_dateline` int(10) unsigned default NULL,

        `delete_username` varchar(50)  default NULL,

        `delete_userid` int(10) default NULL,

        `delete_reason` varchar(200)  default NULL,

        PRIMARY KEY  (`postid`),

        KEY `threadid` (`threadid`),

        FULLTEXT KEY `title` (`title`,`pagetext`)

    ) ENGINE=MyISAM

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (1, 'Automotive', 'For groups pertaining to cars, bikes or such')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (2, 'Computers', 'For groups referring to computers, whether hardware, software or modding')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (3, 'Education', 'For groups regarding learning, whether it be help studying or school activities')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (4, 'Entertainment', 'For groups surrounding anything entertaining, visual or audio')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (5, 'Games', 'For groups surrounding games you love, digital, card or board')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (6, 'Health & Fitness', 'For groups pertaining to well-being')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (7, 'Home & Families', 'For groups regarding the home life')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (8, 'Lifestyles', 'For groups surrounding lifestyles whether it be goths, hippies, etc')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (9, 'Places & Travel', 'For groups referring to towns, cities and holidays')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (10, 'Religion & Belief', 'For groups surrounding christianity, islam, buddism, etc')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (11, 'Sports & Recreation', 'For groups referring to sports, whether it be Football, Cricket or Baseball teams')

");



$db->query_write("

    INSERT INTO `grps_categories` VALUES (12, 'Others', 'For everything else')

");



$db->query_write("

    CREATE TABLE `grps_setting` (

        `groupid` mediumint(9) unsigned NOT NULL default '0',

        `image_name` varchar(50)  default NULL,

        `private_posts` enum('0','1')  default '0',

        `moderate_members` enum('0','1')  default '0',

        `hidden_group` enum('0','1')  default '0',

        `hide_image` enum('0','1')  default '0',

        `edit_details` enum('1','0')  default '1',

        `leaderonly_threads` enum('0','1')  NOT NULL default '0',

        PRIMARY KEY  (`groupid`)

    )

");



$db->query_write("

    CREATE TABLE `grps_user` (

        `recordid` mediumint(9) NOT NULL auto_increment,

        `groupid` mediumint(9) NOT NULL default '0',

        `userid` int(10) NOT NULL default '0',

        `in_mod_queue` enum('0','1')  NOT NULL default '0',

        `join_date` int(10) unsigned NOT NULL default '0',

        PRIMARY KEY  (`recordid`)

    )

");



$db->query_write("

    CREATE TABLE `grps_thread` (

        `threadid` int(10) unsigned NOT NULL auto_increment,

        `groupid` int(10) NOT NULL default '0',

        `userid` int(10) NOT NULL default '0',

        `username` varchar(250)  NOT NULL default '',

        `title` varchar(250)  NOT NULL default '',

        `dateline` varchar(15)  NOT NULL default '',

        `iconid` int(10) NOT NULL default '0',

        `lastposterid` varchar(250)  NOT NULL default '',

        `lastpostdateline` varchar(250)  NOT NULL default '',

        `replies` int(10) NOT NULL default '0',

        `firstpostid` int(10) default NULL,

        `closed` enum('0','1') NOT NULL default '0',

        `stuck` enum('0','1') NOT NULL default '0',

        PRIMARY KEY  (`threadid`),

        KEY `groupid` (`groupid`,`lastposterid`)

    )

");

Those lines of code are called database table entries. If you don't see this, download the zip file again and start over.

Also, had you bothered to look, that database error you snidely referred to was fixed almost immediately by sabret00the, 13 minutes later, four posts below the original error report, on the same page, as noted here. That means it was fixed 7 months, 29 days, 23 hours, and 47 minutes ago (by your math).

So, in a nutshell, to install the database tables you're missing, run the grps_installer.php script, as described in the install.txt file.

Did that help you understand? :rolleyes:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02487 seconds Memory Usage 1,810KB 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 (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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
Messages: