Oh, and I should mention that I ran the migration against my site ( rollerweblogger.org) and had to make a series of fixes to get it to run without errors. Most of those were due to my site having an early version of 5.1 installed, and the fact that my site is the oldest Roller site in existence. I did make a commit to remove some "drop index" for indexes that do not exist in my site, and therefore may not exist in other older Roller sites; also, that MS SQL Server issue.
I still have not upgraded rollerweblogger.org to the latest 5.1. I'll probably get to that this weekend. Also, I tested against the blogs.apache.org database and there were no errors there. - Dave On Mon, Jul 21, 2014 at 6:05 PM, Dave <[email protected]> wrote: > Sure, please go ahead. I'm setup to run the tests again with ease. > > - Dave > > > > On Mon, Jul 21, 2014 at 5:55 PM, Glen Mazza <[email protected]> wrote: > >> Hi Dave, I realize you may have finished your Apache blog migration >> tests, but before you update the team blog, could you tolerate one more >> minor DB change -- I'd like to rename WEBSITE to WEBLOG, as mentioned >> earlier. It's a one-line statement in the upgrade script. The Derby folks >> are making good progress on fixing their renaming issue ( >> https://issues.apache.org/jira/browse/DERBY-6672), but for the time >> being I'll mention on the team blog that automated upgrading for Derby >> users may not be possible due to this issue until the next release of Derby >> is out, that if Derby users have just a few blog entries they may wish to >> start with a fresh installation and manually copy the old blog entries >> over. Derby users generally don't have tons of blog entries, I'd rather >> have a clearer data model for 100% even if it means a little bit more work >> for some upgraders. >> >> Thanks, >> Glen >> >> >> On 07/20/2014 04:28 PM, Dave wrote: >> >>> On Mon, Jul 14, 2014 at 4:22 PM, <[email protected]> wrote: >>> >>> >>> Modified: roller/trunk/app/src/main/resources/sql/macros.vm >>>> URL: >>>> http://svn.apache.org/viewvc/roller/trunk/app/src/main/ >>>> resources/sql/macros.vm?rev=1610513&r1=1610512&r2=1610513&view=diff >>>> >>>> ============================================================ >>>> ================== >>>> --- roller/trunk/app/src/main/resources/sql/macros.vm (original) >>>> +++ roller/trunk/app/src/main/resources/sql/macros.vm Mon Jul 14 >>>> 20:22:00 >>>> 2014 >>>> @@ -82,6 +82,20 @@ Define non-null column with default valu >>>> #end >>>> #end >>>> >>>> +#** >>>> +Rename a table. >>>> +For Derby, will not work if there is a view or foreign key that >>>> references the table. >>>> +MySQL requires sp_rename command; unsure if works. >>>> +**# >>>> +#macro(renameTable $oldTableName $newTableName) >>>> +#if ($db.DBTYPE == 'POSTGRESQL' || $db.DBTYPE == 'HSQLDB') >>>> +alter table $oldTableName rename to $newTableName; >>>> +#elseif ($db.DBTYPE == 'MYSQL') >>>> +sp_rename '$oldTableName', '$newTableName'; >>>> +#else >>>> +rename table $oldTableName TO $newTableName; >>>> +#end >>>> +#end >>>> >>>> >>> Hi Glenn, >>> >>> The correct syntax for MySQL is "rename table a to b" and not sp_rename. >>> >>> Did you mean to use sp_rename for MS SQL Server instead? >>> >>> - Dave >>> >>> >> >
