[osmosis-dev] [OSM-dev] Problem in rake db:migrate with postgre

[Brett Henderson]

Hi Shaun,

I haven't had a chance to get a working rails installation running.  I need
an updated schema to make the Osmosis changes.  Are you able to run the
following command against a newly created database and provide me with the
resultant SQL file?

pg_dump -O -v -f "apidb_0.6.sql" api06

In the above command, replace the final api06 with the name of your
database.

Brett

On Sun, Jun 13, 2010 at 9:48 AM, Shaun McDonald
<shaun at shaunmcdonald.me.uk>wrote:

> Hi Brett,
>
>
> http://git.openstreetmap.org/?p=rails.git;a=blob;f=db/migrate/051_add_status_to_user.rb;h=cc8a2f23848af8ffaf86dc6f5bb65cb42597d2d3;hb=180228b7e36224fefd5540306d7fb77799d4b827
>
> It's now a status column rather than active and visible.
>
> Shaun
>
> On 12 Jun 2010, at 17:30, Brett Henderson wrote:
>
> The Osmosis error message seems to indicate that the "active" column on the
> users table no longer exists.  I haven't checked the recent migrations to
> figure out exactly what has changed.
>
> Currently when populating a datatabase, Osmosis creates any required users
> and makes them active (active = 1 I think).  If active no longer exists, the
> replacement column will need to be populated with an equivalent value.
>
> Brett
>
> On Fri, Jun 11, 2010 at 6:43 PM, M Naveed Akram <cmnajs at gmail.com> wrote:
>
>> Brett: the issue is still there in the latest build of osmosis..
>> can u please guide a little if i want to resolve it
>>
>>
>> On Mon, Jun 7, 2010 at 12:44 PM, M Naveed Akram <cmnajs at gmail.com> wrote:
>>
>>> can anyone tell me that to which schema migration version number the new
>>> osmosis works fine
>>>
>>>
>>> On Sun, Jun 6, 2010 at 7:35 AM, Brett Henderson <brett at bretth.com>wrote:
>>>
>>>> On Fri, Jun 4, 2010 at 10:38 PM, Ævar Arnfjörð Bjarmason <
>>>> avarab at gmail.com> wrote:
>>>>
>>>>> On Fri, Jun 4, 2010 at 09:40, M Naveed Akram <cmnajs at gmail.com> wrote:
>>>>> > thanks to all
>>>>> > UTF8 issue resolved.
>>>>> > but now its osmosis
>>>>>
>>>>> Last I checked osmosis hadn't been fixed to work with the latest
>>>>> schema changes in the rails port, I run the Debian osmosis version,
>>>>> but it wasn't fixed in trunk either (at least the newest user group
>>>>> thing).
>>>>>
>>>>> Maybe that's what's going on, I just use an older version of the rails
>>>>> port for my importing purposes.
>>>>>
>>>>> Due to the way osmosis does imports it's fairly susceptible to
>>>>> breaking like this due to relatively small schema changes.
>>>>>
>>>>
>>>> I wasn't aware of the breakage until now.  The database I use for unit
>>>> tests is ancient.  I won't get to this for a while, but if anybody else
>>>> wants to take a look I'd appreciate it muchly.
>>>>
>>>> Brett
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards
>>> M Naveed Akram
>>> http://www.google.com/profiles/cmnajs
>>>
>>>
>>
>>
>> --
>> Regards
>> M Naveed Akram
>> http://www.google.com/profiles/cmnajs
>>
>>
> _______________________________________________
> osmosis-dev mailing list
> osmosis-dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/osmosis-dev
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20100624/923cfa17/attachment.html>