Installing Blojsom 3.0 locally

Graham-

As far as the character set is concerned, it is pretty
important to have the
tables as UTF8 to support international text. Maybe an ALTER
TABLE command
would work:

  ALTER TABLE blog CONVERT TO CHARACTER SET utf8;

I had the table as 4kb to accommodate larger plugin chains.
255 characters
could work, although maybe TEXT could work as a column type.

Thanks for looking into this.

On 6/14/06 5:34 PM, "Graham Reeds"
<grahamrntlworld.com> wrote:

> I've exported the database from MySQL 5.0 using the
mysqldump tool with
>   --compatible=mysql40.  Interestingly it didn't
export the charset as
> character set - it doesn't mention anywhere to use
UTF8 but that
> shouldn't be too hard to fix.
> 
> One error did crop up:
> ERROR 1074: Too big column length for column
'plugin_value' (max = 255).
> Use BLOB instead
> ERROR 1146: Table 'blojsom.plugin' doesn't exist
> ERROR 1146: Table 'blojsom.plugin' doesn't exist
> ERROR 1146: Table 'blojsom.plugin' doesn't exist
> 
> Not being to au fair about the plugin architecture but
does plugin_value
> it need 4kb?  Can it be reduced to 255?
> 
> I've attached the output (but you should be able to
run it yourself with
> no problems (don't forget the --compatible=mysql40
switch).
> 
> Thanks, G.
> -- MySQL dump 10.10
> --
> -- Host: localhost    Database: blojsom
> --
------------------------------------------------------
> -- Server version 5.0.18-nt
> /*!40103 SET OLD_TIME_ZONE=TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET OLD_UNIQUE_CHECKS=UNIQUE_CHECKS,
UNIQUE_CHECKS=0 */;
> /*!40014 SET OLD_FOREIGN_KEY_CHECKS=FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET OLD_SQL_MODE=SQL_MODE,
> SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
> /*!40111 SET OLD_SQL_NOTES=SQL_NOTES, SQL_NOTES=0 */;
> 
> --
> -- Table structure for table `blog`
> --
> 
> DROP TABLE IF EXISTS `blog`;
> CREATE TABLE `blog` (
>   `blog_id` varchar(50) NOT NULL,
>   PRIMARY KEY  (`blog_id`)
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `blog`
> --
> 
> 
> /*!40000 ALTER TABLE `blog` DISABLE KEYS */;
> LOCK TABLES `blog` WRITE;
> INSERT INTO `blog` VALUES ('default');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `blog` ENABLE KEYS */;
> 
> --
> -- Table structure for table `category`
> --
> 
> DROP TABLE IF EXISTS `category`;
> CREATE TABLE `category` (
>   `category_id` int(11) NOT NULL,
>   `blog_id` varchar(50) NOT NULL,
>   `parent_category_id` int(11) default NULL,
>   `name` text NOT NULL,
>   `description` text,
>   PRIMARY KEY  (`category_id`),
>   KEY `category_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `category_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES
> `blog` (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `category`
> --
> 
> 
> /*!40000 ALTER TABLE `category` DISABLE KEYS */;
> LOCK TABLES `category` WRITE;
> INSERT INTO `category` VALUES
>
(1,'default',NULL,'/uncategorized/','Uncategorized');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `category` ENABLE KEYS */;
> 
> --
> -- Table structure for table `categorymetadata`
> --
> 
> DROP TABLE IF EXISTS `categorymetadata`;
> CREATE TABLE `categorymetadata` (
>   `category_id` int(11) NOT NULL,
>   `metadata_key` text NOT NULL,
>   `metadata_value` text,
>   KEY `categorymetadata_category_categoryidfk`
(`category_id`),
>   CONSTRAINT `categorymetadata_category_categoryidfk`
FOREIGN KEY
> (`category_id`) REFERENCES `category` (`category_id`)
ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `categorymetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `categorymetadata` DISABLE KEYS
*/;
> LOCK TABLES `categorymetadata` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `categorymetadata` ENABLE KEYS */;
> 
> --
> -- Table structure for table `comment`
> --
> 
> DROP TABLE IF EXISTS `comment`;
> CREATE TABLE `comment` (
>   `comment_id` int(11) NOT NULL,
>   `entry_id` int(11) NOT NULL,
>   `author` text,
>   `author_url` text,
>   `author_email` text,
>   `comment` text,
>   `date` datetime NOT NULL,
>   `ip` varchar(100) default NULL,
>   `status` varchar(255) default NULL,
>   `comment_parent` int(11) default NULL,
>   `blog_id` varchar(50) NOT NULL,
>   PRIMARY KEY  (`comment_id`),
>   KEY `comment_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `comment_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog`
> (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `comment`
> --
> 
> 
> /*!40000 ALTER TABLE `comment` DISABLE KEYS */;
> LOCK TABLES `comment` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `comment` ENABLE KEYS */;
> 
> --
> -- Table structure for table `commentmetadata`
> --
> 
> DROP TABLE IF EXISTS `commentmetadata`;
> CREATE TABLE `commentmetadata` (
>   `comment_id` int(11) NOT NULL,
>   `metadata_key` text NOT NULL,
>   `metadata_value` text,
>   KEY `commentmetadata_comment_commentidfk`
(`comment_id`),
>   CONSTRAINT `commentmetadata_comment_commentidfk`
FOREIGN KEY (`comment_id`)
> REFERENCES `comment` (`comment_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `commentmetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `commentmetadata` DISABLE KEYS */;
> LOCK TABLES `commentmetadata` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `commentmetadata` ENABLE KEYS */;
> 
> --
> -- Table structure for table `dbuser`
> --
> 
> DROP TABLE IF EXISTS `dbuser`;
> CREATE TABLE `dbuser` (
>   `user_id` int(11) NOT NULL,
>   `user_login` varchar(50) NOT NULL,
>   `user_password` varchar(64) NOT NULL,
>   `user_name` varchar(250) NOT NULL,
>   `user_email` varchar(100) NOT NULL,
>   `user_registered` datetime NOT NULL,
>   `user_status` varchar(64) NOT NULL,
>   `blog_id` varchar(50) NOT NULL,
>   PRIMARY KEY  (`user_id`),
>   KEY `user_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `user_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog`
> (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `dbuser`
> --
> 
> 
> /*!40000 ALTER TABLE `dbuser` DISABLE KEYS */;
> LOCK TABLES `dbuser` WRITE;
> INSERT INTO `dbuser` VALUES
(1,'default','default','Default
> User','default_owneremail.com','2006-06-14
21:50:36','','default');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `dbuser` ENABLE KEYS */;
> 
> --
> -- Table structure for table `dbusermetadata`
> --
> 
> DROP TABLE IF EXISTS `dbusermetadata`;
> CREATE TABLE `dbusermetadata` (
>   `user_metadata_id` int(11) NOT NULL,
>   `user_id` int(11) NOT NULL,
>   `metadata_key` varchar(255) NOT NULL,
>   `metadata_value` text,
>   PRIMARY KEY  (`user_metadata_id`),
>   KEY `usermetadata_user_useridfk` (`user_id`),
>   CONSTRAINT `usermetadata_user_useridfk` FOREIGN KEY
(`user_id`) REFERENCES
> `dbuser` (`user_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `dbusermetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `dbusermetadata` DISABLE KEYS */;
> LOCK TABLES `dbusermetadata` WRITE;
> INSERT INTO `dbusermetadata` VALUES
(1,1,'all_permissions_permission','true');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `dbusermetadata` ENABLE KEYS */;
> 
> --
> -- Table structure for table `entry`
> --
> 
> DROP TABLE IF EXISTS `entry`;
> CREATE TABLE `entry` (
>   `entry_id` int(11) NOT NULL,
>   `blog_id` varchar(50) NOT NULL,
>   `title` text,
>   `description` text,
>   `entry_date` datetime NOT NULL,
>   `blog_category_id` int(11) NOT NULL,
>   `status` text,
>   `author` text,
>   `allow_comments` int(11) default '1',
>   `allow_trackbacks` int(11) default '1',
>   `allow_pingbacks` int(11) default '1',
>   `post_slug` text NOT NULL,
>   `modified_date` datetime NOT NULL,
>   PRIMARY KEY  (`entry_id`),
>   KEY `entry_blog_blogidfk` (`blog_id`),
>   KEY `entry_category_categoryidfk`
(`blog_category_id`),
>   CONSTRAINT `entry_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog`
> (`blog_id`) ON DELETE CASCADE,
>   CONSTRAINT `entry_category_categoryidfk` FOREIGN KEY
(`blog_category_id`)
> REFERENCES `category` (`category_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `entry`
> --
> 
> 
> /*!40000 ALTER TABLE `entry` DISABLE KEYS */;
> LOCK TABLES `entry` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `entry` ENABLE KEYS */;
> 
> --
> -- Table structure for table `entrymetadata`
> --
> 
> DROP TABLE IF EXISTS `entrymetadata`;
> CREATE TABLE `entrymetadata` (
>   `entry_id` int(11) NOT NULL,
>   `metadata_key` text NOT NULL,
>   `metadata_value` text,
>   KEY `entrymetadata_entry_entryidfk` (`entry_id`),
>   CONSTRAINT `entrymetadata_entry_entryidfk` FOREIGN
KEY (`entry_id`)
> REFERENCES `entry` (`entry_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `entrymetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `entrymetadata` DISABLE KEYS */;
> LOCK TABLES `entrymetadata` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `entrymetadata` ENABLE KEYS */;
> 
> --
> -- Table structure for table `pingback`
> --
> 
> DROP TABLE IF EXISTS `pingback`;
> CREATE TABLE `pingback` (
>   `pingback_id` int(11) NOT NULL,
>   `entry_id` int(11) NOT NULL,
>   `title` text,
>   `excerpt` text,
>   `url` text,
>   `blog_name` text,
>   `trackback_date` datetime NOT NULL,
>   `blog_id` varchar(50) NOT NULL,
>   `ip` varchar(100) default NULL,
>   `status` varchar(255) default NULL,
>   `source_uri` text NOT NULL,
>   `target_uri` text NOT NULL,
>   PRIMARY KEY  (`pingback_id`),
>   KEY `pingback_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `pingback_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES
> `blog` (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `pingback`
> --
> 
> 
> /*!40000 ALTER TABLE `pingback` DISABLE KEYS */;
> LOCK TABLES `pingback` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `pingback` ENABLE KEYS */;
> 
> --
> -- Table structure for table `pingbackmetadata`
> --
> 
> DROP TABLE IF EXISTS `pingbackmetadata`;
> CREATE TABLE `pingbackmetadata` (
>   `pingback_id` int(11) NOT NULL,
>   `metadata_key` text NOT NULL,
>   `metadata_value` text,
>   KEY `pingbackmetadata_pingback_pingbackidfk`
(`pingback_id`),
>   CONSTRAINT `pingbackmetadata_pingback_pingbackidfk`
FOREIGN KEY
> (`pingback_id`) REFERENCES `pingback` (`pingback_id`)
ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `pingbackmetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `pingbackmetadata` DISABLE KEYS
*/;
> LOCK TABLES `pingbackmetadata` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `pingbackmetadata` ENABLE KEYS */;
> 
> --
> -- Table structure for table `plugin`
> --
> 
> DROP TABLE IF EXISTS `plugin`;
> CREATE TABLE `plugin` (
>   `blog_id` varchar(50) NOT NULL,
>   `plugin_flavor` varchar(50) NOT NULL,
>   `plugin_value` varchar(4096) default NULL,
>   KEY `plugin_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `plugin_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES `blog`
> (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `plugin`
> --
> 
> 
> /*!40000 ALTER TABLE `plugin` DISABLE KEYS */;
> LOCK TABLES `plugin` WRITE;
> INSERT INTO `plugin` VALUES
('default','html','meta, tag-cloud, date-format,
> referer-log, calendar-gui, calendar-filter, comment,
trackback, simple-search,
> emoticons, macro-expansion, days-since-posted,
word-count, simple-obfuscation,
> nofollow, rss-enclosure,
>
technorati-tags'),('default','default','conditional-ge
t, meta, nofollow,
> rss-enclosure'),('default','admin','admin');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `plugin` ENABLE KEYS */;
> 
> --
> -- Table structure for table `properties`
> --
> 
> DROP TABLE IF EXISTS `properties`;
> CREATE TABLE `properties` (
>   `blog_id` varchar(50) NOT NULL,
>   `property_name` varchar(255) NOT NULL,
>   `property_value` longtext,
>   KEY `properties_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `properties_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES
> `blog` (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `properties`
> --
> 
> 
> /*!40000 ALTER TABLE `properties` DISABLE KEYS */;
> LOCK TABLES `properties` WRITE;
> INSERT INTO `properties` VALUES
> ('default','blog-url','http://loc
alhost:8080/blojsom/blog/default'),('default'
> ,'blog-admin-url','http://loc
alhost:8080/blojsom/blog/default'),('default','bl
> og-base-url','http://localhost:8080/b
lojsom'),('default','blog-language','en')
> ,('default','blog-name','NAME YOUR
> BLOG'),('default','blog-description','DESCRIBE
YOUR
>
BLOG'),('default','blog-entries-display','15'),('def
ault','blog-owner','Defaul
> t 
>
Owner'),('default','blog-owner-email','default_owneremail.com'),('default','b
>
log-comments-enabled','true'),('default','blog-trackba
cks-enabled','true'),('d
>
efault','blog-email-enabled','true'),('default','blo
g-default-flavor','html'),
>
('default','plugin-comment-autoformat','true'),('defa
ult','linear-navigation-e
>
nabled','true'),('default','comment-moderation-enabled
','true'),('default','tr
>
ackback-moderation-enabled','true'),('default','blog-p
ing-urls','http://rpc.pi
>
ngomatic.com'),('default','blojsom-extension-metaweblog-
accepted-types','image
> /jpeg, image/gif, image/png,
>
img'),('default','xmlrpc-enabled','true'),('default
','blog-pingbacks-enabled',
> 'true');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `properties` ENABLE KEYS */;
> 
> --
> -- Table structure for table `template`
> --
> 
> DROP TABLE IF EXISTS `template`;
> CREATE TABLE `template` (
>   `blog_id` varchar(50) NOT NULL,
>   `template_flavor` varchar(50) NOT NULL,
>   `template_value` varchar(255) default NULL,
>   KEY `template_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `template_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES
> `blog` (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `template`
> --
> 
> 
> /*!40000 ALTER TABLE `template` DISABLE KEYS */;
> LOCK TABLES `template` WRITE;
> INSERT INTO `template` VALUES
('default','rss','rss.vm,
>
text/xml;charset=UTF-8'),('default','rsd','rsd.vm,
>
application/rsd+xml;charset=UTF-8'),('default','html',
'asual.vm,
>
text/html;charset=UTF-8'),('default','atom','atom.vm,
>
application/atom+xml;charset=UTF-8'),('default','rss2',
'rss2.vm,
>
text/xml;charset=UTF-8'),('default','rdf','rdf.vm,
>
text/xml;charset=UTF-8'),('default','admin','org/blojs
om/plugin/admin/template
> s/admin.vm, text/html;charset=UTF-8');
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `template` ENABLE KEYS */;
> 
> --
> -- Table structure for table `trackback`
> --
> 
> DROP TABLE IF EXISTS `trackback`;
> CREATE TABLE `trackback` (
>   `trackback_id` int(11) NOT NULL,
>   `entry_id` int(11) NOT NULL,
>   `title` text,
>   `excerpt` text,
>   `url` text,
>   `blog_name` text,
>   `trackback_date` datetime NOT NULL,
>   `blog_id` varchar(50) NOT NULL,
>   `ip` varchar(100) default NULL,
>   `status` varchar(255) default NULL,
>   PRIMARY KEY  (`trackback_id`),
>   KEY `trackback_blog_blogidfk` (`blog_id`),
>   CONSTRAINT `trackback_blog_blogidfk` FOREIGN KEY
(`blog_id`) REFERENCES
> `blog` (`blog_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `trackback`
> --
> 
> 
> /*!40000 ALTER TABLE `trackback` DISABLE KEYS */;
> LOCK TABLES `trackback` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `trackback` ENABLE KEYS */;
> 
> --
> -- Table structure for table `trackbackmetadata`
> --
> 
> DROP TABLE IF EXISTS `trackbackmetadata`;
> CREATE TABLE `trackbackmetadata` (
>   `trackback_id` int(11) NOT NULL,
>   `metadata_key` text NOT NULL,
>   `metadata_value` text,
>   KEY `trackbackmetadata_trackback_trackbackidfk`
(`trackback_id`),
>   CONSTRAINT
`trackbackmetadata_trackback_trackbackidfk` FOREIGN KEY
> (`trackback_id`) REFERENCES `trackback`
(`trackback_id`) ON DELETE CASCADE
> ) TYPE=InnoDB;
> 
> --
> -- Dumping data for table `trackbackmetadata`
> --
> 
> 
> /*!40000 ALTER TABLE `trackbackmetadata` DISABLE KEYS
*/;
> LOCK TABLES `trackbackmetadata` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `trackbackmetadata` ENABLE KEYS
*/;
> /*!40103 SET TIME_ZONE=OLD_TIME_ZONE */;
> 
> /*!40101 SET SQL_MODE=OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;
> /*!40111 SET SQL_NOTES=OLD_SQL_NOTES */;
> 
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

-- 
David Czarnecki

http://www.blojsom.com/b
log/ | http://blojsom.sf.net




_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers