You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Charles Baker <ch...@datastream.net> on 2006/01/12 21:58:03 UTC
import 0.9.8.2 roller data to roller 2.0
I've successfully imported data from all the 0.9.8.2 tables to 2.0
tables except for the weblogentry, webpage and website tables. It
appears that the structure of these tables is too different for a
straight data dump and restore. To further complicate matters, the old
db is mysql 4.1.x and the new db is mysql 5.x. For example, below is the
log of my attempted import of webpage. If I change the indicated error
(Incorrect datetime value: 'ing:-pa-dd 5') to a proper date, I get
constraint related errors. Has anyone successfully made this leap?
Should I upgrade mysql first, then run those various upgrade scripts
that are supplied with roller?
[2006-01-12 15:53:55] [Msg] Import start
[2006-01-12 15:53:55] [Msg] Import type - Text file
[2006-01-12 15:53:55] [Msg] Import from - C:\Documents and
Settings\bakerc\webpages_20060112.TXT
[2006-01-12 15:53:55] [Msg] Import table [webpage]
[2006-01-12 15:53:55] [Err] 1062 - Duplicate entry
'8a81509efd76f86b00fd76f9b29a000f' for key 1
[2006-01-12 15:53:55] [Err] insert into webpage
(id,name,description,link,websiteid,template,updatetime) values
('8a81509efd76f86b00fd76f9b29a000f','_day','_day','_day','8a81509efd76f8
6b00fd76f9b29a0003','\n<div class=entry>\n
#showDayPermalink( $day )\n #showEntryDate( $day
)\n</div>\n\n#foreach( $entry in $entries )\n<p>\n <a
name=$entry.anchor id=$entry.anchor></a>\n <b>$entry.title</b>
$entry.text\n <span
class=dateStamp>($entry.pubTime)</span>\n #showEntryPermalink( $entry
)\n #showCommentsPageLink( $entry
)\n</p>\n#end\n \n#showLinkbacks( $day )\n','2004-6-30 15:13:21')
[2006-01-12 15:53:55] [Err] 1292 - Incorrect datetime value: 'ing:-pa-dd
5' for column 'updatetime' at row 1
[2006-01-12 15:53:55] [Err] insert into webpage
(id,name,description,link,websiteid,template,updatetime) values
('8a81509efd76f86b00fd76f9b29a0010','_css','_css','_css','8a81509efd76f8
6b00fd76f9b29a0003','\nA { color:
#CC6633; text-decoration: none; } \nA:link { color: #CC6633;
text-decoration: none; } \nA:visited { color:
#CC6633; text-decoration: none; } \nA:active { color: #FF9966; }
\nA:hover { color: #FF9966; } \ntd.body {
padding:20px;}\n\nbody { \n margin-top: 0px; \n margin-left: 0px;
\n margin-right: 0px; \n
background-color:#ffffff;\n}\ntd.title { \n padding:20px; \n
font-family: verdana, sans-serif; \n
font-size: 16px; \n color: #666666; \n font-weight:bold; \n
letter-spacing:.1em; \n}\ntd.links { \n
padding:8px; \n font-family: verdana, sans-serif; \n font-size:
10px; \n color: #336699; \n
line-height:16px;\n}\ntd.search {\n','ing:-pa-dd
5'),('8a81509efd76f86b00fd76f9b29a0011','Weblog','Weblog','Weblog','8a81
509efd76f86b00fd76f9b29a0003','<!DOCTYPE
html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>\n\n<html>\n
<head>\n <meta name=generator content=HTML
Tidy, see www.w3.org>\n <title>#showWebsiteTitle()</title>\n<script
type=text/javascript
language=JavaScript>\n<!--\nif
(!((navigator.appVersion.indexOf(\'MSIE\')!=-1) ||
(parseInt(navigator.appVersion)!=4))) \n{\n document.write(<STYLE
TYPE=\\text/css\\>);\n document.write(BODY {
margin-top: -8px; margin-left: -8px; }); \n
document.write(<\\/style>);\n};\n// -->\n</script>\n\n<style
type=text/css>\n#includePage(_css)\n</style>\n<script
type=text/javascript
src=$ctxPath/theme/scripts/roller.js>\n</script>\n\n</head>\n\n<body>\n
<table border=0 cellspacing=0 cellpadding=0
width=\n 100%>\n <tbody>\n <tr>\n <td width=100%
bgcolor=#666666>\n </td>\n
</tr>\n\n <tr>\n <td width=100% bgcolor=#ffffff>\n
</td>\n </tr>\n\n <tr>\n
<td class=title width=100% bgcolor=#cccc99\n
valign=top>#showWebsiteTitle()<br>\n
<font class=descrip>#showWebsiteDescription()</font>\n </td>\n
</tr>\n\n <tr>\n
<td width=100% bgcolor=#000000>\n </td>\n </tr>\n
</tbody>\n </table>\n\n <table border=0
cellspacing=0 cellpadding=0 width=100%>\n <tbody>\n <tr>\n
<td valign=top width=555
class=body>\n #showWeblogCategoryChooser()<br />\n\n
#showWeblogEntries(_day 15)\n\n
<hr size=1>\n </td>\n\n <td width=1
bgcolor=#000000 rowspan=2>\n </td>\n\n
<td valign=top width=175>\n <table border=0
cellspacing=0 cellpadding=0\n
width=100%>\n <tbody>\n <tr>\n
<td bgcolor=#cccccc>\n
</td>\n </tr>\n
</tbody>\n </table>\n\n
<table border=0 cellspacing=0 cellpadding=0\n
width=100%>\n\n <tbody>\n
<tr>\n <td bgcolor=#cccccc><font class=\n
subhead>archives</font></td>\n </tr>\n
<tr>\n <td
bgcolor=#000000>\n </td>\n
</tr>\n <tr>\n
<td class=links>\n\n
#showWeblogCalendar()<br>\n
#showRSSBadge()<br>\n\n </td>\n
</tr>\n\n <tr>\n
<td bgcolor=#000000>\n </td>\n
</tr>\n
<tr>\n <td
class=search>\n',null),('8a81509efd76f86b00fd76ff208e0014','comments','c
omments','comments','8a81509efd76f86b00fd76f
9b29a0003','<?xml version=1.0 encoding=UTF-8?>\n#set( $comments =
$entry.comments
)\n$dateFormatter.applyPattern(MMMMM dd, yyyy \'at\' hh:mm aa
z)\n<comments
xmlns=http://www.joehewitt.com/content/blog.dtd\n
entryid=$entry.Id>\n#foreach( $comment in $comments )\n
<comment id=$comment.id>\n <author>$comment.name</author>\n
<email>$comment.email</email>\n
<url>$comment.url</url>\n
<timestamp>$dateFormatter.format($comment.postTime)</timestamp>\n
<body>$utilities.escapeHTML( $comment.content )</body>\n
</comment>\n#end\n</comments>\n','2004-6-30
15:19:17'),('8a81509efd76f86b00fd76ff208e0015','_entry','_entry','_entry
','8a81509efd76f86b00fd76f9b29a0003','#if($e
ntry.text.startsWith(!))\n #set( $wikiText =
$stringUtils.substring($entry.text,1))\n #set( $renderedText =
$wikiPlugin.render($wikiText))\n#else\n #set( $renderedText =
$entry.text ) \n#end\n#if( $entryLength == -1 )\n
$renderedText \n#else\n #set( $escapedText =
$utilities.removeHTML($renderedText) )\n $stringUtils.left(
$escapedText,$entryLength )...\n#end\n','2004-6-30 15:19:17')
[2006-01-12 15:53:55] [Msg] Processed:5, Added:0, Updated:0, Deleted:0,
Errors:5
[2006-01-12 15:53:55] [Msg] Finished - Unsuccessfully
----
Charles H. Baker
O: 864.422.5349 C: 864.201.8456
charles.baker@datastream.net
There's nothing wrong with getting a steady paycheck, unless it
interferes with your ability to earn what you're worth. There's the rub.
It usually does. -- T Harv Eker
Re: import 0.9.8.2 roller data to roller 2.0
Posted by Allen Gilliland <Al...@Sun.COM>.
I would highly suggest that you upgrade one version at a time since your database is so old. That is the only way that things are pretty much guaranteed to work (knock on wood).
It would definitely help to do the db switch separately as well. I would recommend doing the upgrade against the 4.1.x db and get Roller 2.0 working with that, then try to migrate the data to mysql 5.x.
-- Allen
On Thu, 2006-01-12 at 12:58, Charles Baker wrote:
> I've successfully imported data from all the 0.9.8.2 tables to 2.0
> tables except for the weblogentry, webpage and website tables. It
> appears that the structure of these tables is too different for a
> straight data dump and restore. To further complicate matters, the old
> db is mysql 4.1.x and the new db is mysql 5.x. For example, below is the
> log of my attempted import of webpage. If I change the indicated error
> (Incorrect datetime value: 'ing:-pa-dd 5') to a proper date, I get
> constraint related errors. Has anyone successfully made this leap?
> Should I upgrade mysql first, then run those various upgrade scripts
> that are supplied with roller?
>
> [2006-01-12 15:53:55] [Msg] Import start
> [2006-01-12 15:53:55] [Msg] Import type - Text file
> [2006-01-12 15:53:55] [Msg] Import from - C:\Documents and
> Settings\bakerc\webpages_20060112.TXT
> [2006-01-12 15:53:55] [Msg] Import table [webpage]
> [2006-01-12 15:53:55] [Err] 1062 - Duplicate entry
> '8a81509efd76f86b00fd76f9b29a000f' for key 1
> [2006-01-12 15:53:55] [Err] insert into webpage
> (id,name,description,link,websiteid,template,updatetime) values
>
> ('8a81509efd76f86b00fd76f9b29a000f','_day','_day','_day','8a81509efd76f8
> 6b00fd76f9b29a0003','\n<div class=entry>\n
>
> #showDayPermalink( $day )\n #showEntryDate( $day
> )\n</div>\n\n#foreach( $entry in $entries )\n<p>\n <a
>
> name=$entry.anchor id=$entry.anchor></a>\n <b>$entry.title</b>
> $entry.text\n <span
>
> class=dateStamp>($entry.pubTime)</span>\n #showEntryPermalink( $entry
> )\n #showCommentsPageLink( $entry
>
> )\n</p>\n#end\n \n#showLinkbacks( $day )\n','2004-6-30 15:13:21')
> [2006-01-12 15:53:55] [Err] 1292 - Incorrect datetime value: 'ing:-pa-dd
> 5' for column 'updatetime' at row 1
> [2006-01-12 15:53:55] [Err] insert into webpage
> (id,name,description,link,websiteid,template,updatetime) values
>
> ('8a81509efd76f86b00fd76f9b29a0010','_css','_css','_css','8a81509efd76f8
> 6b00fd76f9b29a0003','\nA { color:
>
> #CC6633; text-decoration: none; } \nA:link { color: #CC6633;
> text-decoration: none; } \nA:visited { color:
>
> #CC6633; text-decoration: none; } \nA:active { color: #FF9966; }
> \nA:hover { color: #FF9966; } \ntd.body {
>
> padding:20px;}\n\nbody { \n margin-top: 0px; \n margin-left: 0px;
> \n margin-right: 0px; \n
>
> background-color:#ffffff;\n}\ntd.title { \n padding:20px; \n
> font-family: verdana, sans-serif; \n
>
> font-size: 16px; \n color: #666666; \n font-weight:bold; \n
> letter-spacing:.1em; \n}\ntd.links { \n
>
> padding:8px; \n font-family: verdana, sans-serif; \n font-size:
> 10px; \n color: #336699; \n
>
> line-height:16px;\n}\ntd.search {\n','ing:-pa-dd
>
> 5'),('8a81509efd76f86b00fd76f9b29a0011','Weblog','Weblog','Weblog','8a81
> 509efd76f86b00fd76f9b29a0003','<!DOCTYPE
>
> html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>\n\n<html>\n
> <head>\n <meta name=generator content=HTML
>
> Tidy, see www.w3.org>\n <title>#showWebsiteTitle()</title>\n<script
> type=text/javascript
>
> language=JavaScript>\n<!--\nif
> (!((navigator.appVersion.indexOf(\'MSIE\')!=-1) ||
>
> (parseInt(navigator.appVersion)!=4))) \n{\n document.write(<STYLE
> TYPE=\\text/css\\>);\n document.write(BODY {
>
> margin-top: -8px; margin-left: -8px; }); \n
> document.write(<\\/style>);\n};\n// -->\n</script>\n\n<style
>
> type=text/css>\n#includePage(_css)\n</style>\n<script
> type=text/javascript
>
> src=$ctxPath/theme/scripts/roller.js>\n</script>\n\n</head>\n\n<body>\n
> <table border=0 cellspacing=0 cellpadding=0
>
> width=\n 100%>\n <tbody>\n <tr>\n <td width=100%
> bgcolor=#666666>\n </td>\n
>
> </tr>\n\n <tr>\n <td width=100% bgcolor=#ffffff>\n
> </td>\n </tr>\n\n <tr>\n
>
> <td class=title width=100% bgcolor=#cccc99\n
> valign=top>#showWebsiteTitle()<br>\n
>
> <font class=descrip>#showWebsiteDescription()</font>\n </td>\n
> </tr>\n\n <tr>\n
>
> <td width=100% bgcolor=#000000>\n </td>\n </tr>\n
> </tbody>\n </table>\n\n <table border=0
>
> cellspacing=0 cellpadding=0 width=100%>\n <tbody>\n <tr>\n
> <td valign=top width=555
>
> class=body>\n #showWeblogCategoryChooser()<br />\n\n
> #showWeblogEntries(_day 15)\n\n
>
> <hr size=1>\n </td>\n\n <td width=1
> bgcolor=#000000 rowspan=2>\n </td>\n\n
>
> <td valign=top width=175>\n <table border=0
> cellspacing=0 cellpadding=0\n
>
> width=100%>\n <tbody>\n <tr>\n
> <td bgcolor=#cccccc>\n
>
> </td>\n </tr>\n
> </tbody>\n </table>\n\n
>
> <table border=0 cellspacing=0 cellpadding=0\n
> width=100%>\n\n <tbody>\n
>
> <tr>\n <td bgcolor=#cccccc><font class=\n
>
>
> subhead>archives</font></td>\n </tr>\n
> <tr>\n <td
>
> bgcolor=#000000>\n </td>\n
> </tr>\n <tr>\n
>
> <td class=links>\n\n
> #showWeblogCalendar()<br>\n
>
> #showRSSBadge()<br>\n\n </td>\n
> </tr>\n\n <tr>\n
>
> <td bgcolor=#000000>\n </td>\n
> </tr>\n
>
> <tr>\n <td
>
> class=search>\n',null),('8a81509efd76f86b00fd76ff208e0014','comments','c
> omments','comments','8a81509efd76f86b00fd76f
>
> 9b29a0003','<?xml version=1.0 encoding=UTF-8?>\n#set( $comments =
> $entry.comments
>
> )\n$dateFormatter.applyPattern(MMMMM dd, yyyy \'at\' hh:mm aa
> z)\n<comments
>
> xmlns=http://www.joehewitt.com/content/blog.dtd\n
> entryid=$entry.Id>\n#foreach( $comment in $comments )\n
>
> <comment id=$comment.id>\n <author>$comment.name</author>\n
> <email>$comment.email</email>\n
>
> <url>$comment.url</url>\n
> <timestamp>$dateFormatter.format($comment.postTime)</timestamp>\n
>
> <body>$utilities.escapeHTML( $comment.content )</body>\n
> </comment>\n#end\n</comments>\n','2004-6-30
>
> 15:19:17'),('8a81509efd76f86b00fd76ff208e0015','_entry','_entry','_entry
> ','8a81509efd76f86b00fd76f9b29a0003','#if($e
>
> ntry.text.startsWith(!))\n #set( $wikiText =
> $stringUtils.substring($entry.text,1))\n #set( $renderedText =
>
> $wikiPlugin.render($wikiText))\n#else\n #set( $renderedText =
> $entry.text ) \n#end\n#if( $entryLength == -1 )\n
>
> $renderedText \n#else\n #set( $escapedText =
> $utilities.removeHTML($renderedText) )\n $stringUtils.left(
>
> $escapedText,$entryLength )...\n#end\n','2004-6-30 15:19:17')
> [2006-01-12 15:53:55] [Msg] Processed:5, Added:0, Updated:0, Deleted:0,
> Errors:5
> [2006-01-12 15:53:55] [Msg] Finished - Unsuccessfully
>
>
> ----
> Charles H. Baker
> O: 864.422.5349 C: 864.201.8456
> charles.baker@datastream.net
> There's nothing wrong with getting a steady paycheck, unless it
> interferes with your ability to earn what you're worth. There's the rub.
> It usually does. -- T Harv Eker
>