Hi,

I've just switched from 1.3.4 to 1.4.0RC1, and here are my first impressions:

- the overall impression is very good, the design of the templates has really improved, etc. Congrats devs.

- i've had several warnings when running the upgrade script. No idea whether it is important or not, but anyway, here they are (note that it is on a free.fr web account, running mysql-4.0.22 and php-4.3.10) :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/free.fr/0/1/XXXXXXXXX/galerie/install/upgrade_1.3.4.php on line 40

Code:

ALTER TABLE raninfoto_categories
  CHANGE COLUMN site_id site_id tinyint(4) unsigned default '1',
  ADD COLUMN commentable enum('true','false') NOT NULL default 'true',
  ADD COLUMN global_rank varchar(255) default NULL,
  DROP INDEX id_uppercat,
  ADD INDEX categories_i2 (id_uppercat)
;
[mysql error 1091] Can't DROP 'id_uppercat'. Check that column/key exists

ALTER TABLE raninfoto_favorites
  DROP INDEX user_id,
  ADD PRIMARY KEY (user_id,image_id)
;
[mysql error 1091] Can't DROP 'user_id'. Check that column/key exists

ALTER TABLE raninfoto_history
  ADD INDEX history_i1 (date)
;
[mysql error 1061] Duplicate key name 'history_i1'

ALTER TABLE raninfoto_image_category
  DROP INDEX image_id,
  DROP INDEX category_id,
  ADD INDEX image_category_i1 (image_id),
  ADD INDEX image_category_i2 (category_id)
;
[mysql error 1091] Can't DROP 'image_id'. Check that column/key exists

ALTER TABLE raninfoto_images
  CHANGE COLUMN tn_ext tn_ext varchar(4) default '',
  ADD COLUMN path varchar(255) NOT NULL default '',
  ADD COLUMN date_metadata_update date default NULL,
  ADD COLUMN average_rate float(5,2) unsigned default NULL,
  ADD COLUMN representative_ext varchar(4) default NULL,
  DROP INDEX storage_category_id,
  ADD INDEX images_i1 (storage_category_id),
  ADD INDEX images_i2 (date_available),
  ADD INDEX images_i3 (average_rate),
  ADD INDEX images_i4 (hit),
  ADD INDEX images_i5 (date_creation)
;
[mysql error 1091] Can't DROP 'storage_category_id'. Check that column/key exists

ALTER TABLE raninfoto_sessions
  DROP COLUMN ip
;
[mysql error 1091] Can't DROP 'ip'. Check that column/key exists

ALTER TABLE raninfoto_sites
  DROP INDEX galleries_url,
  ADD UNIQUE sites_ui1 (galleries_url)
;
[mysql error 1091] Can't DROP 'galleries_url'. Check that column/key exists

DROP TABLE raninfoto_user_category
;
[mysql error 1051] Unknown table 'raninfoto_user_category'

ALTER TABLE raninfoto_users
  DROP COLUMN long_period,
  DROP COLUMN short_period,
  DROP COLUMN forbidden_categories,
  ADD COLUMN recent_period tinyint(3) unsigned NOT NULL default '7',
  DROP INDEX username,
  ADD UNIQUE users_ui1 (username)
;
[mysql error 1091] Can't DROP 'long_period'. Check that column/key exists

CREATE TABLE raninfoto_rate (
  user_id smallint(5) unsigned NOT NULL default '0',
  element_id mediumint(8) unsigned NOT NULL default '0',
  rate tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,element_id)
) TYPE=MyISAM
;
[mysql error 1050] Table 'raninfoto_rate' already exists

CREATE TABLE raninfoto_user_forbidden (
  user_id smallint(5) unsigned NOT NULL default '0',
  need_update enum('true','false') NOT NULL default 'true',
  forbidden_categories text,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM
;
[mysql error 1050] Table 'raninfoto_user_forbidden' already exists

- my old history items from 1.3.4 are now all timestamped 01/01/1970

- despite what was written in the upgrade summary ("only thumbnails prefix and webmaster mail address have been saved from previous configuration"), both my thumbnails prefix and mail address were cleared after the upgrade

- i miss the detailed history in the admin interface a bit. Would it be possible to get that feature back?

- i think it was possible in 1.3.4 to delete an image from the admin pages (but i'm not sure tho, i've just used it during 2 days). In 1.4.0RC1, i can't find such an option. Would it be possible to add that?

- the "Thumbnails" page in the admin interface is really very empty, that's disturbing. If i understand correctly, thumbnails are now generated automatically when you add a new image and sync the DB, or something like that. Maybe this page should be removed, or if it is still used, there should probably a small message saying that "no thumbnails are missing", or something like that.

- the "PHP informations" page in admin interface is much too wide (more than 3 screens here). That seems to be because of the "_ENV["HTTP_COOKIE"]" and "_SERVER["HTTP_COOKIE"]" variables which are very long. Would it be possible to limit cells sizes in the CSS, or something like that?

- and finally a feature request: would it be possible to have a page to set some options for all users? For instance, after the upgrade all my users were set to using en_US langage, whereas they are french. I've modified that in phpmyadmin, but that would have been more convenient to do it in the admin interface.


Thanks for your work, and if you have specific tests that you would like me to run on this RC, don't hesitate to ask.