#269 Database errors upgrading from 1.5.7

[Barry Roberts]

I finally got tired of my computer type's not getting
saved and decided to try trunk_1.5.8 (29 June 2006).

I got a few errors in the DB upgrade. There were 2
columns it tried to add that already existed:

networking_ports.device_on
networking_ports.device_type

The database upgrade process also tried to insert a
bunch of records into the 'lookup_data' table which
didn't exist. I go the 'create table' statement from
database/install.php and created the table.

Finally, I had a location that had an apostrophe
(Baker's Rack) and if the code had created the table
correctly, it might have worked, I don't know, but
cutting and pasting it from the error page, it hadn't
properly escaped it to 'Baker\'s Rack'

FYI

Thanks

[Barry Roberts]

Logged In: YES
user_id=162868

Ok, I lied. I was connecting to the wrong database to fix
the update problems. It did create the lookup_data table,
it must have been the escaping causing the insert's of the
locations to fail.

[Amit]

Logged In: YES
user_id=1555162

yes, i faced the same problem. the lookup_data table doesnt
register the locations after the update. when i tried adding
fields with \', it gave me errors.

thanks,
amit