Recent Topics

1 Jan 11, 2012 20:28    

My b2evolution Version: 4.0.x

Ok, I had an odd problem with my server in that most of the database tables were deleted, I don't know how. My host restored them, but it was giving me the error that the schema was invalid, so I downloaded the new version and tried updating it. Now, the updating process is giving me this error:


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

I have absolutely no idea how to fix this.

What I did do is reinstall 4.0.5, which is what I was running before the crash. That worked, so I tried to update, and got the same error.

2 Feb 22, 2012 22:17

Bump. I really want to fix this so I can get the upgrade working!

3 Feb 25, 2012 16:03

Ok, update. My site kept loading a blank page and I was unable to make new posts. So I installed the latest version in a subdirectory on a new database, just to see if it worked. It worked fine once my host switched me over the PHP5. Now, the 4.0.5 version won't work at all or lags horribly. I really want to get this upgrade working so I don't have to manually redo all my posts.

4 Feb 26, 2012 09:48

Please post here a complete database scheme. Log into phpmyadmin, click Export, select all tables and check "structure only". Do not post the data, only the table layout.

Otherwise it's not possible for me to guess where the upgrade process stopped.

5 Feb 27, 2012 03:34


-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Feb 26, 2012 at 09:33 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=2950 ;

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

--
-- 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=1985 ;

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

--
-- 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_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=18 ;

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

--
-- 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=49 ;

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

--
-- 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','draft','trash') 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=410 ;

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

--
-- 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_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_users` enum('none','view','edit') NOT NULL DEFAULT 'none',
  `grp_perm_spamblacklist` varchar(50) DEFAULT NULL,
  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=301872 ;

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

--
-- 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=866 ;

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

--
-- 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=264369 ;

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

--
-- 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=44 ;

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

--
-- 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=561 ;

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

--
-- 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=128 ;

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

--
-- 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=318 ;

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

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

6 Feb 27, 2012 05:25

Ok thanks. I will check it tomorrow.

7 Feb 27, 2012 05:28

Thanks for your help. ^_^

8 Feb 28, 2012 05:51

Download the latest version 4.1.2 and edit the installer as follows

/install/_functions_evoupgrade.php starting from line 2751
Find the following code, make sure the numbers match

if( $old_db_version < 10100 )
{	// 4.1

Delete everything staring from that line up to

task_begin( 'Upgrading filetypes table...' );
// get allowed filetype ids

The updated code should look like this

if( $old_db_version < 10100 )
{	// 4.1
	task_begin( 'Upgrading filetypes table...' );
	// get allowed filetype ids
	$sql = 'SELECT ftyp_ID
				FROM T_filetypes
				WHERE ftyp_allowed != 0';
	$allowed_ids = implode( ',', $DB->get_col( $sql, 0, 'Get allowed filetypes' ) );



etc...

Then try to upgrade again. Make sure you have a backup of both files and the database before you start.

9 Feb 28, 2012 17:22

Ok, got past that and ended up with this:


MySQL error!

Duplicate entry 'smart_hit_count' for key 'PRIMARY'(Errno=1062)

Your query:

INSERT INTO evo_settings (set_name, set_value)

VALUES ( "smart_hit_count", 1 )

10 Feb 28, 2012 17:32

You are almost there.
Run this last query manually in phpmyadmin

ALTER TABLE evo_coll_settings CHANGE COLUMN cset_value cset_value   VARCHAR( 10000 ) NULL COMMENT "The AdSense plugin wants to store very long snippets of HTML"

And then set DB version to 10200

UPDATE evo_settings SET set_value = 10200 WHERE set_name = "db_version"

You are done :)

11 Feb 28, 2012 18:22

Ok, I ran both of those through phpMyadmin, and no errors. But now I have a blank page.

www.dubird.net

I cleared out my cache and tried again, still blank. Even my test directory, which was working perfectly fine with the latest version, is showing blank. I really don't know what to do now.

12 Feb 28, 2012 19:53

- Rename .htaccess and php.ini files in website root directory if you have them.
- check error logs

13 Feb 28, 2012 19:58

Disregard my previous post.
I found a problem. You are using PHP 4.4.9 which is very old. See if you can select PHP 5 in your hosting control panel.

14 Feb 28, 2012 20:01

If there's no way for you to switch to PHP 5 then you need to upgrade to v4.1.3 which fixes PHP 4 compatibility issues.

It's a pre-release version so you may want to upgrade again to official v4.1.3 when it comes out.

15 Feb 29, 2012 06:04

Ok, I talked to my host and they switched me back to PHP5, and it's working again! So thank you so much for your help, I'm happy to finally have this back up and running. ^_^


Form is loading...