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