Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. [4.0.5] Parameter «edited_grp_perm_admin» is required!

[4.0.5] Parameter «edited_grp_perm_admin» is required!

1 Jan 12, 2012 20:31    

My b2evolution Version: 4.1.x

After a database crash and partial recovery, I was trying to make some changes to the skins listing, when I noticed that the Administator account didn't have permission for it. When I tried to change it, I got this error:


Bad Request!

The parameters of your request are invalid.

If you have obtained this error by clicking on a link INSIDE of this site, please report the bad link to the administrator.

Go back to home page
Additional information about this error:
Parameter «edited_grp_perm_admin» is required!

Edit: I'm still using 4.0.5. I thought I had upgraded, but I hadn't. So I tried to upgrade, got database errors, and just downgraded for now until I can find out why or someone answers the questions I posted/replied to.

Back to top

2 Jan 23, 2012 21:43

So, still waiting on answer. Any suggestions? Help please?

Back to top

3 Jan 23, 2012 22:44

What errors do you get trying to upgrade?

Back to top

4 Jan 23, 2012 22:48

The full topic is [url=http://forums.b2evolution.net/viewtopic.php?t=23388]here[/url], but here's the first error I got:


MySQL error!

Unknown column 'grp_perm_spamblacklist' in 'field list'(Errno=1054)

Your query: Get groups converted permissions

SELECT grp_ID, grp_perm_spamblacklist, grp_perm_slugs, grp_perm_files, grp_perm_options, grp_perm_templates

  FROM evo_groups

When I downgraded to 4.0.5, I was able to get it functional again except for the error in the OP. When I try to upgrade from 4.0.5, I'm getting that same error.

Back to top

5 Jan 23, 2012 23:16

You seem to have a half-upgraded database. Please export the database scheme from phpmyadmin and post it here.

Do not export data!

Back to top

6 Jan 23, 2012 23:45


-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jan 23, 2012 at 05:44 PM
-- Server version: 5.1.56
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `b2news`
--

-- --------------------------------------------------------

--
-- Table structure for table `evo_antispam`
--

CREATE TABLE IF NOT EXISTS `evo_antispam` (
  `aspm_ID` bigint(11) NOT NULL AUTO_INCREMENT,
  `aspm_string` varchar(80) NOT NULL,
  `aspm_source` enum('local','reported','central') NOT NULL DEFAULT 'reported',
  PRIMARY KEY (`aspm_ID`),
  UNIQUE KEY `aspm_string` (`aspm_string`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2918 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_basedomains`
--

CREATE TABLE IF NOT EXISTS `evo_basedomains` (
  `dom_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `dom_name` varchar(250) NOT NULL DEFAULT '',
  `dom_status` enum('unknown','whitelist','blacklist') NOT NULL DEFAULT 'unknown',
  `dom_type` enum('unknown','normal','searcheng','aggregator') NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`dom_ID`),
  UNIQUE KEY `dom_name` (`dom_name`),
  KEY `dom_type` (`dom_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1455 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_bloggroups`
--

CREATE TABLE IF NOT EXISTS `evo_bloggroups` (
  `bloggroup_blog_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `bloggroup_group_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `bloggroup_ismember` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_poststatuses` set('published','deprecated','protected','private','draft','redirected') NOT NULL DEFAULT '',
  `bloggroup_perm_edit` enum('no','own','lt','le','all','redirected') NOT NULL DEFAULT 'no',
  `bloggroup_perm_delpost` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_edit_ts` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_depr_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_publ_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_draft_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_cats` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_properties` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_admin` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_media_upload` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_media_browse` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_media_change` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_page` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_intro` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_podcast` tinyint(4) NOT NULL DEFAULT '0',
  `bloggroup_perm_sidebar` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bloggroup_blog_ID`,`bloggroup_group_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_blogs`
--

CREATE TABLE IF NOT EXISTS `evo_blogs` (
  `blog_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `blog_shortname` varchar(255) DEFAULT '',
  `blog_name` varchar(255) NOT NULL DEFAULT '',
  `blog_owner_user_ID` int(11) unsigned NOT NULL DEFAULT '1',
  `blog_advanced_perms` tinyint(1) NOT NULL DEFAULT '0',
  `blog_tagline` varchar(250) DEFAULT '',
  `blog_description` varchar(250) DEFAULT '',
  `blog_longdesc` text,
  `blog_locale` varchar(20) NOT NULL DEFAULT 'en-EU',
  `blog_access_type` varchar(10) NOT NULL DEFAULT 'extrapath',
  `blog_siteurl` varchar(120) NOT NULL DEFAULT '',
  `blog_urlname` varchar(255) NOT NULL DEFAULT 'urlname',
  `blog_notes` text,
  `blog_keywords` tinytext,
  `blog_allowcomments` varchar(20) NOT NULL DEFAULT 'post_by_post',
  `blog_allowtrackbacks` tinyint(1) NOT NULL DEFAULT '0',
  `blog_allowblogcss` tinyint(1) NOT NULL DEFAULT '1',
  `blog_allowusercss` tinyint(1) NOT NULL DEFAULT '1',
  `blog_skin_ID` int(10) unsigned NOT NULL DEFAULT '1',
  `blog_in_bloglist` tinyint(1) NOT NULL DEFAULT '1',
  `blog_links_blog_ID` int(11) DEFAULT NULL,
  `blog_media_location` enum('default','subdir','custom','none') NOT NULL DEFAULT 'default',
  `blog_media_subdir` varchar(255) DEFAULT NULL,
  `blog_media_fullpath` varchar(255) DEFAULT NULL,
  `blog_media_url` varchar(255) DEFAULT NULL,
  `blog_UID` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`blog_ID`),
  UNIQUE KEY `blog_urlname` (`blog_urlname`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_blogusers`
--

CREATE TABLE IF NOT EXISTS `evo_blogusers` (
  `bloguser_blog_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `bloguser_user_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `bloguser_ismember` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_poststatuses` set('published','deprecated','protected','private','draft','redirected') NOT NULL DEFAULT '',
  `bloguser_perm_edit` enum('no','own','lt','le','all','redirected') NOT NULL DEFAULT 'no',
  `bloguser_perm_delpost` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_edit_ts` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_depr_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_publ_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_draft_cmts` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_cats` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_properties` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_admin` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_media_upload` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_media_browse` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_media_change` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_page` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_intro` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_podcast` tinyint(4) NOT NULL DEFAULT '0',
  `bloguser_perm_sidebar` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`bloguser_blog_ID`,`bloguser_user_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_categories`
--

CREATE TABLE IF NOT EXISTS `evo_categories` (
  `cat_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_parent_ID` int(10) unsigned DEFAULT NULL,
  `cat_name` varchar(255) NOT NULL,
  `cat_urlname` varchar(255) NOT NULL,
  `cat_blog_ID` int(10) unsigned NOT NULL DEFAULT '2',
  `cat_description` varchar(255) DEFAULT NULL,
  `cat_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`cat_ID`),
  UNIQUE KEY `cat_urlname` (`cat_urlname`),
  KEY `cat_blog_ID` (`cat_blog_ID`),
  KEY `cat_parent_ID` (`cat_parent_ID`),
  KEY `cat_order` (`cat_order`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_coll_settings`
--

CREATE TABLE IF NOT EXISTS `evo_coll_settings` (
  `cset_coll_ID` int(11) unsigned NOT NULL,
  `cset_name` varchar(30) NOT NULL,
  `cset_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cset_coll_ID`,`cset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_comments`
--

CREATE TABLE IF NOT EXISTS `evo_comments` (
  `comment_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `comment_type` enum('comment','linkback','trackback','pingback') NOT NULL DEFAULT 'comment',
  `comment_status` enum('published','deprecated','protected','private','draft','redirected') NOT NULL DEFAULT 'published',
  `comment_author_ID` int(10) unsigned DEFAULT NULL,
  `comment_author` varchar(100) DEFAULT NULL,
  `comment_author_email` varchar(255) DEFAULT NULL,
  `comment_author_url` varchar(255) DEFAULT NULL,
  `comment_author_IP` varchar(23) NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `comment_content` text NOT NULL,
  `comment_rating` tinyint(1) DEFAULT NULL,
  `comment_featured` tinyint(1) NOT NULL DEFAULT '0',
  `comment_nofollow` tinyint(1) NOT NULL DEFAULT '1',
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_spam_karma` tinyint(4) DEFAULT NULL,
  `comment_allow_msgform` tinyint(4) NOT NULL DEFAULT '0',
  `comment_secret` varchar(32) DEFAULT NULL,
  `comment_notif_status` enum('noreq','todo','started','finished') NOT NULL DEFAULT 'noreq' COMMENT 'Have notifications been sent for this comment? How far are we in the process?',
  `comment_notif_ctsk_ID` int(10) unsigned DEFAULT NULL COMMENT 'When notifications for this comment are sent through a scheduled job, what is the job ID?',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_date` (`comment_date`),
  KEY `comment_type` (`comment_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=407 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_country`
--

CREATE TABLE IF NOT EXISTS `evo_country` (
  `ctry_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ctry_code` char(2) NOT NULL,
  `ctry_name` varchar(40) NOT NULL,
  `ctry_curr_ID` int(10) unsigned DEFAULT NULL,
  `ctry_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ctry_ID`),
  UNIQUE KEY `ctry_code` (`ctry_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=248 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_cron__log`
--

CREATE TABLE IF NOT EXISTS `evo_cron__log` (
  `clog_ctsk_ID` int(10) unsigned NOT NULL,
  `clog_realstart_datetime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `clog_realstop_datetime` datetime DEFAULT NULL,
  `clog_status` enum('started','finished','error','timeout') NOT NULL DEFAULT 'started',
  `clog_messages` text,
  PRIMARY KEY (`clog_ctsk_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_cron__task`
--

CREATE TABLE IF NOT EXISTS `evo_cron__task` (
  `ctsk_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ctsk_start_datetime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `ctsk_repeat_after` int(10) unsigned DEFAULT NULL,
  `ctsk_name` varchar(50) NOT NULL,
  `ctsk_controller` varchar(50) NOT NULL,
  `ctsk_params` text,
  PRIMARY KEY (`ctsk_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_currency`
--

CREATE TABLE IF NOT EXISTS `evo_currency` (
  `curr_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `curr_code` char(3) NOT NULL,
  `curr_shortcut` varchar(30) NOT NULL,
  `curr_name` varchar(40) NOT NULL,
  `curr_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`curr_ID`),
  UNIQUE KEY `curr_code` (`curr_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=164 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_files`
--

CREATE TABLE IF NOT EXISTS `evo_files` (
  `file_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `file_root_type` enum('absolute','user','collection','shared','skins') NOT NULL DEFAULT 'absolute',
  `file_root_ID` int(11) unsigned NOT NULL DEFAULT '0',
  `file_path` varchar(255) NOT NULL DEFAULT '',
  `file_title` varchar(255) DEFAULT NULL,
  `file_alt` varchar(255) DEFAULT NULL,
  `file_desc` text,
  PRIMARY KEY (`file_ID`),
  UNIQUE KEY `file` (`file_root_type`,`file_root_ID`,`file_path`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_filetypes`
--

CREATE TABLE IF NOT EXISTS `evo_filetypes` (
  `ftyp_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ftyp_extensions` varchar(30) NOT NULL,
  `ftyp_name` varchar(30) NOT NULL,
  `ftyp_mimetype` varchar(50) NOT NULL,
  `ftyp_icon` varchar(20) DEFAULT NULL,
  `ftyp_viewtype` varchar(10) NOT NULL,
  `ftyp_allowed` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ftyp_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_global__cache`
--

CREATE TABLE IF NOT EXISTS `evo_global__cache` (
  `cach_name` varchar(30) NOT NULL,
  `cach_cache` mediumblob,
  PRIMARY KEY (`cach_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_groups`
--

CREATE TABLE IF NOT EXISTS `evo_groups` (
  `grp_ID` int(11) NOT NULL AUTO_INCREMENT,
  `grp_name` varchar(50) NOT NULL DEFAULT '',
  `grp_perm_admin` enum('none','hidden','visible') NOT NULL DEFAULT 'visible',
  `grp_perm_blogs` enum('user','viewall','editall') NOT NULL DEFAULT 'user',
  `grp_perm_bypass_antispam` tinyint(1) NOT NULL DEFAULT '0',
  `grp_perm_xhtmlvalidation` varchar(10) NOT NULL DEFAULT 'always',
  `grp_perm_xhtmlvalidation_xmlrpc` varchar(10) NOT NULL DEFAULT 'always',
  `grp_perm_xhtml_css_tweaks` tinyint(1) NOT NULL DEFAULT '0',
  `grp_perm_xhtml_iframes` tinyint(1) NOT NULL DEFAULT '0',
  `grp_perm_xhtml_javascript` tinyint(1) NOT NULL DEFAULT '0',
  `grp_perm_xhtml_objects` tinyint(1) NOT NULL DEFAULT '0',
  `grp_perm_stats` enum('none','user','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_spamblacklist` enum('none','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_slugs` enum('none','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_options` enum('none','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_users` enum('none','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_templates` tinyint(4) NOT NULL DEFAULT '0',
  `grp_perm_files` enum('none','view','add','edit','all') NOT NULL DEFAULT 'none',
  PRIMARY KEY (`grp_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_groups__groupsettings`
--

CREATE TABLE IF NOT EXISTS `evo_groups__groupsettings` (
  `gset_grp_ID` int(11) unsigned NOT NULL,
  `gset_name` varchar(30) NOT NULL,
  `gset_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gset_grp_ID`,`gset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_hitlog`
--

CREATE TABLE IF NOT EXISTS `evo_hitlog` (
  `hit_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hit_sess_ID` int(10) unsigned DEFAULT NULL,
  `hit_datetime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `hit_uri` varchar(250) DEFAULT NULL,
  `hit_referer_type` enum('search','blacklist','spam','referer','direct','self','admin') NOT NULL,
  `hit_referer` varchar(250) DEFAULT NULL,
  `hit_referer_dom_ID` int(10) unsigned DEFAULT NULL,
  `hit_keyphrase_keyp_ID` int(10) unsigned DEFAULT NULL,
  `hit_serprank` int(10) unsigned DEFAULT NULL,
  `hit_blog_ID` int(11) unsigned DEFAULT NULL,
  `hit_remote_addr` varchar(40) DEFAULT NULL,
  `hit_agent_type` enum('rss','robot','browser','unknown') NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`hit_ID`),
  KEY `hit_blog_ID` (`hit_blog_ID`),
  KEY `hit_uri` (`hit_uri`),
  KEY `hit_referer_dom_ID` (`hit_referer_dom_ID`),
  KEY `hit_remote_addr` (`hit_remote_addr`),
  KEY `hit_sess_ID` (`hit_sess_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=278604 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__item`
--

CREATE TABLE IF NOT EXISTS `evo_items__item` (
  `post_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `post_parent_ID` int(11) unsigned DEFAULT NULL,
  `post_creator_user_ID` int(11) unsigned NOT NULL,
  `post_lastedit_user_ID` int(11) unsigned DEFAULT NULL,
  `post_assigned_user_ID` int(11) unsigned DEFAULT NULL,
  `post_dateset` tinyint(1) NOT NULL DEFAULT '1',
  `post_datestart` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `post_datedeadline` datetime DEFAULT NULL,
  `post_datecreated` datetime DEFAULT NULL,
  `post_datemodified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `post_status` enum('published','deprecated','protected','private','draft','redirected') NOT NULL DEFAULT 'published',
  `post_pst_ID` int(11) unsigned DEFAULT NULL,
  `post_ptyp_ID` int(10) unsigned NOT NULL DEFAULT '1',
  `post_locale` varchar(20) NOT NULL DEFAULT 'en-EU',
  `post_content` mediumtext,
  `post_excerpt` text,
  `post_excerpt_autogenerated` tinyint(4) DEFAULT NULL,
  `post_title` text NOT NULL,
  `post_urltitle` varchar(210) NOT NULL,
  `post_canonical_slug_ID` int(10) unsigned DEFAULT NULL,
  `post_tiny_slug_ID` int(10) unsigned DEFAULT NULL,
  `post_titletag` varchar(255) DEFAULT NULL,
  `post_metadesc` varchar(255) DEFAULT NULL,
  `post_metakeywords` varchar(255) DEFAULT NULL,
  `post_url` varchar(255) DEFAULT NULL,
  `post_main_cat_ID` int(11) unsigned NOT NULL,
  `post_notifications_status` enum('noreq','todo','started','finished') NOT NULL DEFAULT 'noreq',
  `post_notifications_ctsk_ID` int(10) unsigned DEFAULT NULL,
  `post_views` int(11) unsigned NOT NULL DEFAULT '0',
  `post_wordcount` int(11) DEFAULT NULL,
  `post_comment_status` enum('disabled','open','closed') NOT NULL DEFAULT 'open',
  `post_commentsexpire` datetime DEFAULT NULL,
  `post_renderers` text NOT NULL,
  `post_priority` int(11) unsigned DEFAULT NULL COMMENT 'Task priority in workflow',
  `post_featured` tinyint(1) NOT NULL DEFAULT '0',
  `post_order` double DEFAULT NULL,
  `post_double1` double DEFAULT NULL COMMENT 'Custom double value 1',
  `post_double2` double DEFAULT NULL COMMENT 'Custom double value 2',
  `post_double3` double DEFAULT NULL COMMENT 'Custom double value 3',
  `post_double4` double DEFAULT NULL COMMENT 'Custom double value 4',
  `post_double5` double DEFAULT NULL COMMENT 'Custom double value 5',
  `post_varchar1` varchar(255) DEFAULT NULL COMMENT 'Custom varchar value 1',
  `post_varchar2` varchar(255) DEFAULT NULL COMMENT 'Custom varchar value 2',
  `post_varchar3` varchar(255) DEFAULT NULL COMMENT 'Custom varchar value 3',
  `post_editor_code` varchar(32) DEFAULT NULL COMMENT 'Plugin code of the editor used to edit this post',
  PRIMARY KEY (`post_ID`),
  UNIQUE KEY `post_urltitle` (`post_urltitle`),
  KEY `post_datestart` (`post_datestart`),
  KEY `post_main_cat_ID` (`post_main_cat_ID`),
  KEY `post_creator_user_ID` (`post_creator_user_ID`),
  KEY `post_status` (`post_status`),
  KEY `post_parent_ID` (`post_parent_ID`),
  KEY `post_assigned_user_ID` (`post_assigned_user_ID`),
  KEY `post_ptyp_ID` (`post_ptyp_ID`),
  KEY `post_pst_ID` (`post_pst_ID`),
  KEY `post_order` (`post_order`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=862 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__itemtag`
--

CREATE TABLE IF NOT EXISTS `evo_items__itemtag` (
  `itag_itm_ID` int(11) unsigned NOT NULL,
  `itag_tag_ID` int(11) unsigned NOT NULL,
  PRIMARY KEY (`itag_itm_ID`,`itag_tag_ID`),
  UNIQUE KEY `tagitem` (`itag_tag_ID`,`itag_itm_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__prerendering`
--

CREATE TABLE IF NOT EXISTS `evo_items__prerendering` (
  `itpr_itm_ID` int(11) unsigned NOT NULL,
  `itpr_format` enum('htmlbody','entityencoded','xml','text') NOT NULL,
  `itpr_renderers` text NOT NULL,
  `itpr_content_prerendered` mediumtext,
  `itpr_datemodified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`itpr_itm_ID`,`itpr_format`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__status`
--

CREATE TABLE IF NOT EXISTS `evo_items__status` (
  `pst_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pst_name` varchar(30) NOT NULL,
  PRIMARY KEY (`pst_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__tag`
--

CREATE TABLE IF NOT EXISTS `evo_items__tag` (
  `tag_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tag_name` varbinary(50) NOT NULL,
  PRIMARY KEY (`tag_ID`),
  UNIQUE KEY `tag_name` (`tag_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__type`
--

CREATE TABLE IF NOT EXISTS `evo_items__type` (
  `ptyp_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ptyp_name` varchar(30) NOT NULL,
  PRIMARY KEY (`ptyp_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5001 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_items__version`
--

CREATE TABLE IF NOT EXISTS `evo_items__version` (
  `iver_itm_ID` int(10) unsigned NOT NULL,
  `iver_edit_user_ID` int(10) unsigned DEFAULT NULL,
  `iver_edit_datetime` datetime NOT NULL,
  `iver_status` enum('published','deprecated','protected','private','draft','redirected') DEFAULT NULL,
  `iver_title` text,
  `iver_content` mediumtext,
  KEY `iver_itm_ID` (`iver_itm_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_links`
--

CREATE TABLE IF NOT EXISTS `evo_links` (
  `link_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `link_datecreated` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `link_datemodified` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `link_creator_user_ID` int(11) unsigned NOT NULL,
  `link_lastedit_user_ID` int(11) unsigned NOT NULL,
  `link_itm_ID` int(11) unsigned NOT NULL,
  `link_cmt_ID` int(11) unsigned DEFAULT NULL COMMENT 'Used for linking files to comments (comment attachments)',
  `link_dest_itm_ID` int(11) unsigned DEFAULT NULL,
  `link_file_ID` int(11) unsigned DEFAULT NULL,
  `link_ltype_ID` int(11) unsigned NOT NULL DEFAULT '1',
  `link_external_url` varchar(255) DEFAULT NULL,
  `link_title` text,
  `link_position` varchar(10) NOT NULL,
  `link_order` int(11) unsigned NOT NULL,
  PRIMARY KEY (`link_ID`),
  UNIQUE KEY `link_itm_ID_order` (`link_itm_ID`,`link_order`),
  KEY `link_itm_ID` (`link_itm_ID`),
  KEY `link_dest_itm_ID` (`link_dest_itm_ID`),
  KEY `link_file_ID` (`link_file_ID`),
  KEY `link_cmt_ID` (`link_cmt_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_locales`
--

CREATE TABLE IF NOT EXISTS `evo_locales` (
  `loc_locale` varchar(20) NOT NULL DEFAULT '',
  `loc_charset` varchar(15) NOT NULL DEFAULT 'iso-8859-1',
  `loc_datefmt` varchar(20) NOT NULL DEFAULT 'y-m-d',
  `loc_timefmt` varchar(20) NOT NULL DEFAULT 'H:i:s',
  `loc_startofweek` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `loc_name` varchar(40) NOT NULL DEFAULT '',
  `loc_messages` varchar(20) NOT NULL DEFAULT '',
  `loc_priority` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `loc_enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`loc_locale`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='saves available locales';

-- --------------------------------------------------------

--
-- Table structure for table `evo_messaging__contact`
--

CREATE TABLE IF NOT EXISTS `evo_messaging__contact` (
  `mct_from_user_ID` int(10) unsigned NOT NULL,
  `mct_to_user_ID` int(10) unsigned NOT NULL,
  `mct_blocked` tinyint(1) DEFAULT '0',
  `mct_last_contact_datetime` datetime NOT NULL,
  PRIMARY KEY (`mct_from_user_ID`,`mct_to_user_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_messaging__message`
--

CREATE TABLE IF NOT EXISTS `evo_messaging__message` (
  `msg_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msg_author_user_ID` int(10) unsigned NOT NULL,
  `msg_datetime` datetime NOT NULL,
  `msg_thread_ID` int(10) unsigned NOT NULL,
  `msg_text` text,
  PRIMARY KEY (`msg_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_messaging__thread`
--

CREATE TABLE IF NOT EXISTS `evo_messaging__thread` (
  `thrd_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `thrd_title` varchar(255) NOT NULL,
  `thrd_datemodified` datetime NOT NULL,
  PRIMARY KEY (`thrd_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_messaging__threadstatus`
--

CREATE TABLE IF NOT EXISTS `evo_messaging__threadstatus` (
  `tsta_thread_ID` int(10) unsigned NOT NULL,
  `tsta_user_ID` int(10) unsigned NOT NULL,
  `tsta_first_unread_msg_ID` int(10) unsigned DEFAULT NULL,
  KEY `tsta_user_ID` (`tsta_user_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_pluginevents`
--

CREATE TABLE IF NOT EXISTS `evo_pluginevents` (
  `pevt_plug_ID` int(11) unsigned NOT NULL,
  `pevt_event` varchar(40) NOT NULL,
  `pevt_enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pevt_plug_ID`,`pevt_event`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_plugins`
--

CREATE TABLE IF NOT EXISTS `evo_plugins` (
  `plug_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `plug_priority` tinyint(4) NOT NULL DEFAULT '50',
  `plug_classname` varchar(40) NOT NULL DEFAULT '',
  `plug_code` varchar(32) DEFAULT NULL,
  `plug_apply_rendering` enum('stealth','always','opt-out','opt-in','lazy','never') NOT NULL DEFAULT 'never',
  `plug_version` varchar(42) NOT NULL DEFAULT '0',
  `plug_name` varchar(255) DEFAULT NULL,
  `plug_shortdesc` varchar(255) DEFAULT NULL,
  `plug_status` enum('enabled','disabled','needs_config','broken') NOT NULL,
  `plug_spam_weight` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`plug_ID`),
  UNIQUE KEY `plug_code` (`plug_code`),
  KEY `plug_status` (`plug_status`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_pluginsettings`
--

CREATE TABLE IF NOT EXISTS `evo_pluginsettings` (
  `pset_plug_ID` int(11) unsigned NOT NULL,
  `pset_name` varchar(30) NOT NULL,
  `pset_value` text,
  PRIMARY KEY (`pset_plug_ID`,`pset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_pluginusersettings`
--

CREATE TABLE IF NOT EXISTS `evo_pluginusersettings` (
  `puset_plug_ID` int(11) unsigned NOT NULL,
  `puset_user_ID` int(11) unsigned NOT NULL,
  `puset_name` varchar(30) NOT NULL,
  `puset_value` text,
  PRIMARY KEY (`puset_plug_ID`,`puset_user_ID`,`puset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_plugin_lj_crosspost_16_ids`
--

CREATE TABLE IF NOT EXISTS `evo_plugin_lj_crosspost_16_ids` (
  `lj_ID` int(11) NOT NULL,
  `post_ID` int(11) NOT NULL,
  `user_ID` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`lj_ID`),
  KEY `post_ID` (`post_ID`),
  KEY `user_ID` (`user_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `evo_postcats`
--

CREATE TABLE IF NOT EXISTS `evo_postcats` (
  `postcat_post_ID` int(11) unsigned NOT NULL,
  `postcat_cat_ID` int(11) unsigned NOT NULL,
  PRIMARY KEY (`postcat_post_ID`,`postcat_cat_ID`),
  UNIQUE KEY `catpost` (`postcat_cat_ID`,`postcat_post_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_sessions`
--

CREATE TABLE IF NOT EXISTS `evo_sessions` (
  `sess_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sess_key` char(32) DEFAULT NULL,
  `sess_hitcount` int(10) unsigned NOT NULL DEFAULT '1',
  `sess_lastseen` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `sess_ipaddress` varchar(39) NOT NULL DEFAULT '',
  `sess_user_ID` int(10) DEFAULT NULL,
  `sess_data` mediumblob,
  PRIMARY KEY (`sess_ID`),
  KEY `sess_user_ID` (`sess_user_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=244397 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_settings`
--

CREATE TABLE IF NOT EXISTS `evo_settings` (
  `set_name` varchar(30) NOT NULL,
  `set_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`set_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_skins__container`
--

CREATE TABLE IF NOT EXISTS `evo_skins__container` (
  `sco_skin_ID` int(10) unsigned NOT NULL,
  `sco_name` varchar(40) NOT NULL,
  PRIMARY KEY (`sco_skin_ID`,`sco_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_skins__skin`
--

CREATE TABLE IF NOT EXISTS `evo_skins__skin` (
  `skin_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `skin_name` varchar(32) NOT NULL,
  `skin_type` enum('normal','feed','sitemap') NOT NULL DEFAULT 'normal',
  `skin_folder` varchar(32) NOT NULL,
  PRIMARY KEY (`skin_ID`),
  UNIQUE KEY `skin_folder` (`skin_folder`),
  KEY `skin_name` (`skin_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_slug`
--

CREATE TABLE IF NOT EXISTS `evo_slug` (
  `slug_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slug_title` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `slug_type` char(6) NOT NULL DEFAULT 'item',
  `slug_itm_ID` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`slug_ID`),
  UNIQUE KEY `slug_title` (`slug_title`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=553 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_subscriptions`
--

CREATE TABLE IF NOT EXISTS `evo_subscriptions` (
  `sub_coll_ID` int(11) unsigned NOT NULL,
  `sub_user_ID` int(11) unsigned NOT NULL,
  `sub_items` tinyint(1) NOT NULL,
  `sub_comments` tinyint(1) NOT NULL,
  PRIMARY KEY (`sub_coll_ID`,`sub_user_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_track__goal`
--

CREATE TABLE IF NOT EXISTS `evo_track__goal` (
  `goal_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goal_name` varchar(50) DEFAULT NULL,
  `goal_key` varchar(32) DEFAULT NULL,
  `goal_redir_url` varchar(255) DEFAULT NULL,
  `goal_default_value` double DEFAULT NULL,
  PRIMARY KEY (`goal_ID`),
  UNIQUE KEY `goal_key` (`goal_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_track__goalhit`
--

CREATE TABLE IF NOT EXISTS `evo_track__goalhit` (
  `ghit_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ghit_goal_ID` int(10) unsigned NOT NULL,
  `ghit_hit_ID` int(10) unsigned NOT NULL,
  `ghit_params` text,
  PRIMARY KEY (`ghit_ID`),
  KEY `ghit_goal_ID` (`ghit_goal_ID`),
  KEY `ghit_hit_ID` (`ghit_hit_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_track__keyphrase`
--

CREATE TABLE IF NOT EXISTS `evo_track__keyphrase` (
  `keyp_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `keyp_phrase` varchar(255) NOT NULL,
  PRIMARY KEY (`keyp_ID`),
  UNIQUE KEY `keyp_phrase` (`keyp_phrase`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_users`
--

CREATE TABLE IF NOT EXISTS `evo_users` (
  `user_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(20) NOT NULL,
  `user_pass` char(32) NOT NULL,
  `user_firstname` varchar(50) DEFAULT NULL,
  `user_lastname` varchar(50) DEFAULT NULL,
  `user_nickname` varchar(50) DEFAULT NULL,
  `user_icq` int(11) unsigned DEFAULT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_url` varchar(255) DEFAULT NULL,
  `user_ip` varchar(15) DEFAULT NULL,
  `user_domain` varchar(200) DEFAULT NULL,
  `user_browser` varchar(200) DEFAULT NULL,
  `dateYMDhour` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  `user_level` int(10) unsigned NOT NULL DEFAULT '0',
  `user_aim` varchar(50) DEFAULT NULL,
  `user_msn` varchar(100) DEFAULT NULL,
  `user_yim` varchar(50) DEFAULT NULL,
  `user_locale` varchar(20) NOT NULL DEFAULT 'en-EU',
  `user_idmode` varchar(20) NOT NULL DEFAULT 'login',
  `user_allow_msgform` tinyint(4) NOT NULL DEFAULT '2',
  `user_notify` tinyint(1) NOT NULL DEFAULT '0',
  `user_notify_moderation` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Notify me by email whenever a comment is awaiting moderation on one of my blogs',
  `user_unsubscribe_key` varchar(32) NOT NULL DEFAULT '' COMMENT 'A specific key, it is used when a user wants to unsubscribe from a post comments without signing in',
  `user_showonline` tinyint(1) NOT NULL DEFAULT '1',
  `user_gender` char(1) DEFAULT NULL,
  `user_grp_ID` int(4) NOT NULL DEFAULT '1',
  `user_validated` tinyint(1) NOT NULL DEFAULT '0',
  `user_avatar_file_ID` int(10) unsigned DEFAULT NULL,
  `user_ctry_ID` int(10) unsigned DEFAULT NULL,
  `user_source` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`user_ID`),
  UNIQUE KEY `user_login` (`user_login`),
  KEY `user_grp_ID` (`user_grp_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_users__fielddefs`
--

CREATE TABLE IF NOT EXISTS `evo_users__fielddefs` (
  `ufdf_ID` int(10) unsigned NOT NULL,
  `ufdf_type` char(8) NOT NULL,
  `ufdf_name` varchar(255) NOT NULL,
  PRIMARY KEY (`ufdf_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_users__fields`
--

CREATE TABLE IF NOT EXISTS `evo_users__fields` (
  `uf_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uf_user_ID` int(10) unsigned NOT NULL,
  `uf_ufdf_ID` int(10) unsigned NOT NULL,
  `uf_varchar` varchar(255) NOT NULL,
  PRIMARY KEY (`uf_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `evo_users__usersettings`
--

CREATE TABLE IF NOT EXISTS `evo_users__usersettings` (
  `uset_user_ID` int(11) unsigned NOT NULL,
  `uset_name` varchar(30) NOT NULL,
  `uset_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uset_user_ID`,`uset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `evo_widget`
--

CREATE TABLE IF NOT EXISTS `evo_widget` (
  `wi_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `wi_coll_ID` int(11) unsigned NOT NULL,
  `wi_sco_name` varchar(40) NOT NULL,
  `wi_order` int(10) NOT NULL,
  `wi_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `wi_type` enum('core','plugin') NOT NULL DEFAULT 'core',
  `wi_code` varchar(32) NOT NULL,
  `wi_params` text,
  PRIMARY KEY (`wi_ID`),
  UNIQUE KEY `wi_order` (`wi_coll_ID`,`wi_sco_name`,`wi_order`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=295 ;

-- --------------------------------------------------------

--
-- Table structure for table `T_items__subscriptions`
--

CREATE TABLE IF NOT EXISTS `T_items__subscriptions` (
  `isub_item_ID` int(11) unsigned NOT NULL,
  `isub_user_ID` int(11) unsigned NOT NULL,
  `isub_comments` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'The user wants to receive notifications for new comments on this post',
  PRIMARY KEY (`isub_item_ID`,`isub_user_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I will comment that aside from the problem I had in the OP, it works perfectly fine.

Back to top

7 Feb 22, 2012 22:07

Bump. I'd really like to get this fixed so I can upgrade!

Back to top


Form is loading...