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
[EMAIL PROTECTED]
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
