Upgrade problem #2 -rc2 to -rc3

[Hubert Figuière]

I upgraded from the 4.0.2-rc2 to -rc3.

Now when I reach the home page I get this PHP error:

{severity:warn, description:"Query error: SQLSTATE[42S22]: Column not
found: 1054 Unknown column 'active' in 'where clause' - SELECT
op_photo.* FROM `op_photo` WHERE `op_photo`.`owner`='h...@figuiere.net'
and `active`=1 ORDER BY dateSortByDay DESC, dateTaken ASC LIMIT 1 ",
additional:}


Also I get broken thumbnails.

If I click on one of the picture (missing) I get these errors:

{severity:warn, description:"Query error: SQLSTATE[42S22]: Column not
found: 1054 Unknown column 'active' in 'where clause' - SELECT `id`,
`dateTaken`, `dateUploaded`, `dateSortByDay` FROM `op_photo` WHERE
`op_photo`.`owner`='h...@figuiere.net' and `active`=1 AND `dateUploaded`
> :sortColumn ORDER BY `dateUploaded` asc, `id` asc LIMIT 2", additional:}
{severity:warn, description:"Query error: SQLSTATE[42S22]: Column not
found: 1054 Unknown column 'active' in 'where clause' - SELECT
op_photo.* FROM `op_photo` WHERE `op_photo`.`owner`='h...@figuiere.net'
and `active`=1 ORDER BY dateSortByDay DESC, dateTaken ASC LIMIT 1 ",
additional:}

*sigh*

Hub

[Hubert Figuière]

On 09/05/14 11:16 PM, Hubert Figuière wrote:
> I upgraded from the 4.0.2-rc2 to -rc3.
>
> Now when I reach the home page I get this PHP error:
>
> {severity:warn, description:"Query error: SQLSTATE[42S22]: Column not
> found: 1054 Unknown column 'active' in 'where clause' - SELECT
> op_photo.* FROM `op_photo` WHERE `op_photo`.`owner`='h...@figuiere.net'
> and `active`=1 ORDER BY dateSortByDay DESC, dateTaken ASC LIMIT 1 ",
> additional:}

I reverted to -rc2 and it works again. Minus

>
> Also I get broken thumbnails.

I traced that to the undo code that seems to come with a schema update. NOT.

For a -rc3 that's a hell lot of changes, that's very misleading. You
could have called that 4.1 or something.

Hub

[Jaisen Mathai]

Out of town but I see these alter table commands which might not have run
in your machine. Could you check the schema?

ALTER TABLE `album` ADD `dateLastPhotoAdded` INT NOT NULL DEFAULT '0';

ALTER TABLE `photo` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;

ALTER TABLE `elementAlbum` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;

ALTER TABLE `elementTag` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;

ALTER TABLE `shareToken` CHANGE `type` `type` ENUM( 'album', 'photo',
'photos', 'video', 'upload' ) NOT NULL;

--
You received this message because you are subscribed to the Google Groups "OpenPhoto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openphoto+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
-- Snet form my mobl phoone

[Hubert Figuière]

On 10/05/14 01:59 AM, Jaisen Mathai wrote:
> ALTER TABLE `album` ADD `dateLastPhotoAdded` INT NOT NULL DEFAULT '0';
>
> ALTER TABLE `photo` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;
>
> ALTER TABLE `elementAlbum` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;
>
> ALTER TABLE `elementTag` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE ;
>
> ALTER TABLE `shareToken` CHANGE `type` `type` ENUM( 'album', 'photo',
> 'photos', 'video', 'upload' ) NOT NULL;

These tables don't exist....

Hub

[Hubert Figuière]

Also I don't see any upgrade code in the *HUGE* diff between -rc2 and
-rc3....

This mean it is not in.

Hub

[Jaisen Mathai]

Adding upgrade code to an RC4.

The diff should only contain changes from @walkah to bcrypt passwords and a few related bug fixes. Running `git diff 4.0.2-rc2 4.0.2-rc3` shows that.

Hub

[Jaisen Mathai]

Also I don't see any upgrade code in the *HUGE* diff between -rc2 and
-rc3....

This mean it is not in.

This looks more sane, https://github.com/photo/frontend/compare/4.0.2-rc2...4.0.2-rc4