symfony propel:migrate (No such database)

[SilkBC]

Hello.

I am attempting to upgrade from IcA-Atom v1.08 to v1.1 and following
the guide at <http://qubit-toolkit.org/wiki/index.php?
title=Upgrading>. So far things have gone great until I am getting to
the "Migrate" part. When I execute:

php ./symfony propel:insert-sql

I get the following:

--- START ---
>> schema converting "/var/www/websites/ic...om-1.1/config/schema.yml" to XML
>> schema putting /var/www/websites/icaatom-1.1/config/generated-schema.xml
>> schema converting "/var/www/websites/ic...Plugin/config/schema.yml" to XML
>> schema putting /var/www/websites/icaato...generated-qbAclPlugin-schema.xml
>> file+ config/generated-qbAclPlugin-schema.xml
>> file- /var/www/websites/icaatom-1.1/pl...generated-qbAclPlugin-schema.xml

WARNING: The data in the database related to the connection name
propel will be removed.

Are you sure you want to proceed? (y/N)

y


Database "propel" does not exist.
--- END ---

When IcA-AtoM was setup, I was never prompted to setup a database
called "propel". When it displayed the warning about data in database
related to the connection name propel being removed, should I have
said "no"?? What can I do now??

Please advise. Thanks! :-)

[SilkBC]

OK, ignore this post for now; I seemed to have missed the part about
running the installer :-)

If I have further issues, I will post here again, otherwise all is
good :-)

[SilkBC]

OK, I got as far as the "propel:data-load" part, and now I get this
error:

--- START ---
Fatal error: Undefined class constant 'RELATION_NOTE_DATE_DISPLAY_ID'
in /usr/src/icaatom-20110215_1557.yml on line 24039
--- END ---

Thanks :-)

[SilkBC]

OK, once again, my bad. In the migration doc. I thought the filename
used (migrated_data_20100517141011.yml) was meant to refer to the same
file I originally exported, but I see that there really is a
"migrated_data...." file and it seems to be working now.

OK, as before, if I have additional issues, I will post, otherwise all
is good :-)

[David Juhasz]

Awesome, I love it when our users answer their own questions! ;) Glad
to hear that everything is working now.

Regards,

--
David Juhasz,
Software Engineer

Artefactual Systems Inc.
www.artefactual.com

[SilkBC]

> Awesome, I love it when our users answer their own questions! ;)  Glad
> to hear that everything is working now.

Actually, I am now getting a Segmentation Fault a long way into the
"data-load" process. I am guessing it is a Symfony error, so this may
not be the right place to post this.

I noticed the version of symfony v1.1 of ica-atom uses is 1.4.9-DEV,
while the version in 1.0.8.1 (last version we were running) is 1.2.9-
DEV.

Would there be any harm in attempting to do the data-load using that
version as opposed to the version in ica-atom 1.1?

[SilkBC]

It occurs to me that it might help if I post a little about the
environment I am running it it:

OS: Debian Lenny (as of 2:30pm PST it had all available updates)
PHP: 5.2.6-1+lenny9 with Suhosin-Patch 0.9.6.2 (cli)
Apache: Apache/2.2.9 (Debian)

[David at Artefactual]

Hmm, for some reason Jesús' reply got split into a separate
discussion, so I'll repost here:

On Feb 18, 12:14 am, Jesús García Crespo <je...@artefactual.com>
wrote:
> Hi,

>
> On Thu, Feb 17, 2011 at 11:35 PM, SilkBC <murrell.t...@gmail.com> wrote:
> > Actually, I am now getting a Segmentation Fault a long way into the
> > "data-load" process. I am guessing it is a Symfony error, so this may
> > not be the right place to post this.
>

> This segmentation fault is a known issue [1] related to the search index
> build. We use to disable the search index [2] and run data-load task again.
> Once you have imported the data you can build the index manually [3]. If the
> segmentation fault persists, you can try this patch [4], which makes
> possible to restart the build from the point where it segfaulted last time.
> Please, follow these instructions [5].

>
> I noticed the version of symfony v1.1 of ica-atom uses is 1.4.9-DEV,> while the version in 1.0.8.1 (last version we were running) is 1.2.9-
> > DEV. Would there be any harm in attempting to do the data-load using that
>
> version as opposed to the version in ica-atom 1.1?
>

> Don't worry about this, this is not the problem.
>
> [1] -http://code.google.com/p/qubit-toolkit/issues/detail?id=1128
> [2] -http://qubit-toolkit.org/wiki/index.php?title=Search#Disable_the_sear...
> [3] -http://qubit-toolkit.org/wiki/index.php?title=Search#Manually_buildin...
> [4] -http://www.sevein.com/tmp/icaatom11-segfault-populate.patch
> [5] -http://groups.google.com/group/ica-atom-users/msg/55159132fc7654bd
>
> Regards,
>
> --
> Jesús García Crespo,
> Software Engineer, Artefactual Systems Inc.http://www.artefactual.com| +1.604.527.2056

[David at Artefactual]

On Feb 17, 3:30 pm, SilkBC <murrell.t...@gmail.com> wrote:
> It occurs to me that it might help if I post a little about the
> environment I am running it it:
>
>   OS: Debian Lenny (as of 2:30pm PST it had all available updates)
>   PHP: 5.2.6-1+lenny9 with Suhosin-Patch 0.9.6.2 (cli)
>   Apache: Apache/2.2.9 (Debian)

Please note that ICA-AtoM Release 1.1 requires PHP5.3+
http://www.qubit-toolkit.org/wiki/index.php?title=Minimum_requirements#PHP_version

Hopefully this isn't a big barrier to upgrading. :(

David

[SilkBC]

I applied the patches in Jesus' post and everything appears to have
migrated just fine. I have the users checking it now, but so far so
good.

Thanks guys! :-)

On Feb 18, 9:49 am, David at Artefactual <da...@artefactual.com>
wrote:

> On Feb 17, 3:30 pm, SilkBC <murrell.t...@gmail.com> wrote:
>
> > It occurs to me that it might help if I post a little about the
> > environment I am running it it:
>
> >   OS: Debian Lenny (as of 2:30pm PST it had all available updates)
> >   PHP: 5.2.6-1+lenny9 with Suhosin-Patch 0.9.6.2 (cli)
> >   Apache: Apache/2.2.9 (Debian)
>

> Please note that ICA-AtoM Release 1.1 requires PHP5.3+http://www.qubit-toolkit.org/wiki/index.php?title=Minimum_requirement...