Guy, forget the comment about specifying the database; I just re-read
your message and saw it this time. Sorry for missing it at first. I
think the statements below will probably get you running again.
-Eric
On Aug 20, 2007, at 7:02 AM, Eric Wittle wrote:
Guy,
The problem is likely that your database migration was incomplete
because of the error you mention getting when running the migration
scripts; it would help if you specify which database you're using.
At least for mysql, the script will stop executing on the first
statement that throws an error, and therefore the rest of the
migration script doesn't execute.
Take a look in the migration script 240-to-300-migration.sql and
run the sql statements that are present AFTER the statement that
adds the locale field. In the mysql scripts at least, this includes
the following:
-- add new column which holds the hidden status for a page, default
is false
alter table webpage add column hidden tinyint(1) default 0 not
null;
-- add new column which holds the hidden status for a page, default
is false
alter table webpage add column navbar tinyint(1) default 0 not
null;
update webpage set navbar=1;
update webpage set navbar=0 where name like '\_%';
-- add new column which holds the template language used for a page
-- then set template language to velocity for all templates
alter table webpage add column templatelang varchar(20) default
null;
update webpage set templatelang = 'velocity';
-- add new column which holds the decorator for a page
-- then set value to _decorator for all templates except decorators
alter table webpage add column decorator varchar(255) default
null;
update webpage set decorator = '_decorator' where name <>
'_decorator';
I would strongly recommend you take a database backup before trying
this (since I'm a roller user not a developer; my answer could be
incomplete). If you're using multiple locales, it would also be a
good idea to see if the index that this script creates on the
locale field is present in your database or not; if it isn't
present, you should run the index creation statement on the locale
field in your database as well. A missing index won't break roller,
but it might make it slower.
-Eric
On Aug 20, 2007, at 5:24 AM, Guy Katz wrote:
Hi; (using mysql5 and upgrading roller 2.3 to 3.1)
I have having some migration problems and hope someone can help.
My situation is pretty simple to describe:
After the migration process of the DB when starting roller I get a
page
stating that I need to choose the FrontPage blog (makes sense), after
that I was able to access the front page and I even see it as an
aggregation of all other blogs (I enabled this option via the server
administration form).
However, I cannot access individual blogs or posts.
For example for the blog with handle 'someName' I cannot access it
with
'http://localhost:8081/roller3_1/someName' as I get a http error
status
404. The weird thing is that I do see 'someName' posts on the
aggregated
front page.
Any suggestions or directions?
P.S: when running one of the upgrade script (240-to-300-
migration.sql) I
did have the following error but I did not know if it was
significant.
ERROR 1060 (42S21): Duplicate column name 'locale'
Thanks in advance.
