Exhibit Engine 2 upgrade instructions

[Pekka]

Download from http://photography-on-the.net/forum/...d.php?t=223287
For first two weeks the download link is available for forum users only.

Upgrading to version 2.0

System requirement change is that EE 2.0 requires PHP version 4.1.0 or later. MySQL 4 or later is recommended. Upgrade works only on untampered EE databases. ALSO NOTE THAT EE 2 REQUIRES MYSQL LOCK PRIVILEGES. Consult your server admin if you have these requirements set or not.

Upgrade should done by following basic scheme, aiming for maximum data safety and easy recover of old installation in case of problems. If you do not understand the instructions, ask more information. Do not perform the upgrade unless you know how to do all these steps.

1. Make file backup of your EE database and download the file.
2. Unzip EE upgrade packet locally.
3. Edit PRIMARY SETTINGS section of "basecode/SETUP_settings.php" locally: insert current add/connect php database connection info, edit $ee_ident and $s_admin_path.
4. Rename current EE folder on your server to something else.
5. Create new folder EE2 on server.
6. Upload all EE 2.0 files and folders to server folder EE2. MAKE SURE YOU USE ASCII TRANSFER FOR ALL PHP FILES!
7. Rename admin folder to what you set $s_admin_path to.
8. Set permissions inside admin folder to 777 (world writeable) for these folders only:
   admin/temp
   admin/UPLOAD
   admin/UPLOAD/ee_temp_upload
   admin/UPLOAD/test
9. If you had photo or thumb folders inside EE program folder, copy those photo and thumb folder to EE2 folder.
10. Browse to updater script http://www.yourserver.com/eegallery/upgrade/upgrade.php and perform upgrade.
11. If all went fine, browse to your server folder EE2 and see that you see EE index page (without exhibitions - this is normal).
12. rename EE2 folder to your original EE folder name.

If you got errors during upgrade (anything in red color), copy them and post in http://photography-on-the.net/forum/...splay.php?f=94 . Before you retry upgrade, you must clean all tables and restore old EE database.

After upgrade you should also upload your custom watermark photos back to watermark folder. Not also that EE Backup .php files has also been upgraded, but the preferences file is identical format so there is no need to upgrade that.

For the hasty ones, a simple quick method, if you have backups of all, is to delete all EE related files and folders in your gallery folder EXCEPT PHOTOS AND THUMBS, and upload all EE 2 files there. Then edit "basecode/SETUP_settings.php", set permissions and start the upgrade.

It is important that you delete all old EE's .php files and folders. Leaving them on server might be a security risk.

Delete upgrade folder after succesful upgrade.



Loggin in to admin area (editor)

Address to your EE's admin area is http://www.yourdomain.com/youEEgalleryfoldername/yourEEadminfoldername/

Admin folder name should be set in "basecode/SETUP_settings.php".
Default login is

username: admin
pass: pass

After upgrade use your old logins. If EE sees that you have either of the default login strings, it will urge you to change them ASAP and it is wise to do so: well chosen name of your EE admin folder, well chosen admin username and well chosen admin pass build together a firewall which will block out unwanted visitors who try to hack into your EE.



First things to do in editor after upgrade

After upgrade EE 2 will not show any exhibitions or groups in public area, this is not an error. Your group id 1 has been moved to end of group list and group id 1 is now called INDEX.

What you need to do now is to create a site structure and give users permissions to exhibitions. User public is "all those who are not logged in". You do not have to assign any exhibitions to public view if you want to keep your galleries fully private.

The editor must be used with a modern web browser that has Javascript on. I recommend latest Firefox.

Adding user permission to view exhibitions:

1. Click on the top left: "daily" or "all" to show editor menus we need.
2. On the left menu click item: "User editor"
3. See that username"public" is selected (i.e. in inverse color), then select all exhibitions you want to show for those who are not logged in. Keep CTRL key down when selecting, this way you can add to or remove from selection.
4. Click "save user".

Creating EE site structure:

1. On the left menu click item: "Structure".
2. In structure editor
- click in GROUP column: "INDEX"
- CTRL-select in "CONTAINS EXHIBITIONS" column those exhibitions you want to show on index page
- click "SAVE THIS GROUP"

You can see below a Structure Viewer a tree view how public users will see their EE.

Now you see public exhibitions on EE index page and all data they have. Some counters show zero, they will update to correct amount in few of minutes time.

Updating photo size database:

1. Click on the top left: "setup" or "all" to show editor menus we need.
2. On the left menu click item: "Retrieve Photo Sizes".
3. Select display filter: "only photos with some unset/zero size",
4. Select photos (better to do this few dozen at a time).
5. Hit "start". On next screen you have a option to continue to next photo ro continue nonstop.

Do this procedure until all photo sizes are stored. Now you can change in "basecode/SETUP_settings.php" variable
$s_use_notavailable = "1";
This enables all features in EE which use photo size data (defaul photo size, missing photo image, thumbsize limiters, multiarea navigation...). On upload EE stores photo sizes automatically.



All EE 1.5 settings are preserved on upgrade. Nevertheless it is adviced to check out main settings:

1. Click on the top left: "setup" or "all" to show editor menus we need.
2. On the left menu click item: "FTP servers".
- do ftp test and verify that all works. Choose EE internal FTP ENGINE for maximum features.
3. On the left menu click item: "Server tools".
- do each test and verify that the needed apps work. The paths and settings should be same as before upgrade.
4. On the left menu click item: "Paths".
- check that each path has correct ftp server chosen (if you did changes to ftp servers above).
5. On the left menu click item: "Resize methods".
- check that they work and settings are what works for you. If you had IMAGICK resizemethods, they are now changed to IMAGEMAGICK.
6. On the left menu click item: "Global settings".
- make sure that "HTTP address (URL) to gallery" is correct.
7. On the left menu click item: "Install check".
- wait for the check to complete and look at the results.

[segal3]

'Exhibition Order' isn't saving, nor displaying the correct order even based on the current numbering - may have gotten it to work by resorting with 'Reset to selected' and then reordering, but it rounds everything to the tens (no matter if i put in order as #17 or #23, it'll change it to whatever fits between, so if there was a #20 and a #30, then the #30->#40, and then #23->#30. Weird.

[Ewan]

Originally Posted by Pekka

Upgrade works only on untampered EE databases.

I've added a handful of text fields to the ee_photo table to display extra information on the photo pages. Is this likely to cause problems with the upgrade?

Thanks.

[GvdM]

For some unknown reason my 1.5 rc4 database doesn't have the ee_backup and ee_backup_info tables. So obviously they do not exist in my 2.0 upgrade.

Can someone post the schema for these two tables so I can create them myself?

Thanks in advance.

[Pekka]

Originally Posted by GvdM

For some unknown reason my 1.5 rc4 database doesn't have the ee_backup and ee_backup_info tables. So obviously they do not exist in my 2.0 upgrade.

Can someone post the schema for these two tables so I can create them myself?

Thanks in advance.

If you open EE Backup it will create those tables for the target database that is selected.

[Pekka]

Originally Posted by Ewan

I've added a handful of text fields to the ee_photo table to display extra information on the photo pages. Is this likely to cause problems with the upgrade?

Thanks.

No, I don't think so.

[Ewan]

Thanks for the prompt reply Pekka. I bit the bullet and did the upgrade. All data seems intact

Phew!

[afterburn]

Thanks Pekka for all the work, upgrade went smoothly and quickly, without any problems.

[Pekka]

I have moved problem reports not related to actual upgrade process into http://photography-on-the.net/forum/...splay.php?f=99

[GvdM]

Originally Posted by Pekka

If you open EE Backup it will create those tables for the target database that is selected.

I get this:

Unable to connect to the selected database server at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.
Why do you get this error? Maybe because:

• The database server has not been activated for you domain
• your username/password is wrong.
• The database server in offline for some reason.
• The server name is incorrect.
• Server firewall rejects the connect.

If you get this error, contact your server administrator and check if MySQL is indeed running on your server. This error message can also mean that the MySQL server is overloaded - can easily happen in shared hosting where 250 sites fight for one CPU and same system resources.
(Info by EE Backup)

Server: localhost
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Everything else is working fine....

[::John::]

Pekka,

1. Make file backup of your EE database and download the file.

Being the sort of person I am, I opened and read the downloaded file.

Towards the bottom there were a LOT of lines like:

INSERT INTO `ee_uncookied` VALUES ('529', '}‘Qn… EWão£bk_Ût
d”QHyoà³võ¥†¦?:9÷Ì*b—¦óŸª±þ÷üS¶íg2»/+ö+4Ah2R„ŸR
Ê)º%*
ëJ»T:P:hÊã:zú`ùÀ}##RolM*@ÃmN�Åyrö˜?
Má¼¼¿&ï^Ð,0c¥«³(qïz\"sµÅ¢ê2¹E0£ä†¶bÐ:ó³Ã¯qtœ V·¬.ÉOAur½¶X‰U_X„8Áª³3â3[2î<O{<*òE’£‡£àJü‘È÷;§iú/â®p;ç<9«þí', '1')|EE|BACKUP|

I decided that it wasn't prudent to procede any further until I could see a clean backup so I went into the admin section of my gallery and ran the Purge Uncookied Data in Server Info.

I performed another backup to file and downloaded it. It was clean.

I am wondering, if people are going to be rushing to upgrade their galleries, how many other people may have a backup with similar issues, whether those issues would produce problems when restoring (if necessary) and whether they aren't taking some unwitting risk with their desire to upgrade?

I suspect I may be completely wrong but would appreciate some clarification.

Thanks,
John

[Pekka]

Originally Posted by GvdM

I get this:

Unable to connect to the selected database server at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.
Why do you get this error? Maybe because:

• The database server has not been activated for you domain
• your username/password is wrong.
• The database server in offline for some reason.
• The server name is incorrect.
• Server firewall rejects the connect.

If you get this error, contact your server administrator and check if MySQL is indeed running on your server. This error message can also mean that the MySQL server is overloaded - can easily happen in shared hosting where 250 sites fight for one CPU and same system resources.
(Info by EE Backup)

Server: localhost
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Everything else is working fine....

Edit admin/backup/ee_backup_prefs/preferences.php

[GvdM]

Originally Posted by Pekka

Edit admin/backup/ee_backup_prefs/preferences.php

Perfect.....

Did I miss those edit instructions somewhere??

Thanks Pekka

[Pekka]

Originally Posted by GvdM

Perfect.....

Did I miss those edit instructions somewhere??

Thanks Pekka

I missed them so you missed them

[gillyworld]

Originally Posted by Pekka

I missed them so you missed them

I think You also need to set the permissions on the ee_backup_files folder as well in order to do a backup.

Alan