Canon Digital Photography Forums  

P.O.T.N. SUPPORT SHOP IS OPEN, check it out now!

Go Back   Canon Digital Photography Forums > Exhibit Engine > EE 2 Installation
Register Rules FAQ Members List Search Today's Posts Mark Forums Read



Reply
 
Thread Tools Display Modes
Old 4th of October 2006 (Wed)   #16
Faustini
Member
 
Faustini's Avatar
 
Join Date: Feb 2006
Location: Vitória (ES) - Brazil
Posts: 32
Question Re: Exhibit Engine 2 upgrade instructions

Hi!

This is the only error I got after upgrade:

"alter ee_backup_info ...... Table 'name-of-database.ee_backup_info' doesn't exist"

I guess that's why I have never used EE's backup command before (my server doesn't allow me, only in CGI mode). Should I worry about it? I mean, will it cause any further problems in the structure or functioning of my gallery?

Thanks!
Faustini is offline   Reply With Quote
This ad block will go away when you log in as member
Old 4th of October 2006 (Wed)   #17
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

Quote:
Originally Posted by Faustini View Post
Hi!

This is the only error I got after upgrade:

"alter ee_backup_info ...... Table 'name-of-database.ee_backup_info' doesn't exist"

I guess that's why I have never used EE's backup command before (my server doesn't allow me, only in CGI mode). Should I worry about it? I mean, will it cause any further problems in the structure or functioning of my gallery?

Thanks!
No that should not be a problem. EE Backup creates its tables if they do not exist.
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------
Pekka is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #18
GvdM
Junior Member
 
Join Date: Sep 2006
Location: Colorado
Posts: 24
Default Re: Exhibit Engine 2 upgrade instructions

Quote:
Originally Posted by Pekka View Post
No that should not be a problem. EE Backup creates its tables if they do not exist.
That is directly relatd to my problem that we fixed. Edit admin/backup/ee_backup_prefs/preferences.php
__________________
George van der Merwede
Photojournalist / Editorial Photography
Photojournalism Forums: http://forums.phototroph.net
GvdM is offline   Reply With Quote
This ad block will go away when you log in as member
Old 4th of October 2006 (Wed)   #19
Faustini
Member
 
Faustini's Avatar
 
Join Date: Feb 2006
Location: Vitória (ES) - Brazil
Posts: 32
Default Re: Exhibit Engine 2 upgrade instructions

May we apply to EE version 2.0 the same language files we used in version 1.5 RC 4? I did it, but I noted that some buttons and drop-down menus have no text... As more contents were added in version 2, I guess we'll need updated language files, won't we?

Thanks for now, as always.
Faustini is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #20
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

Quote:
Originally Posted by Faustini View Post
May we apply to EE version 2.0 the same language files we used in version 1.5 RC 4? I did it, but I noted that some buttons and drop-down menus have no text... As more contents were added in version 2, I guess we'll need updated language files, won't we?

Thanks for now, as always.
Sorry for forgetting to mention this. All language data has been moved to global.php in each language folder. There is also custom.php loaded where you can add your own customisations.

You can see in Install Checker if the language keys are found and if files are there.

If you have e.g. Italy language from 1.5, basically you can copy all old language strings to languages/ita/global.php, then run in install check to see what more you need. Or the most correct way is to open languages/eng/global.php and build a new language to a new file line by line from old data.

I'll add all contributed language files for download here.
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------
Pekka is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #21
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

Added "ALSO NOTE THAT EE 2 REQUIRES MYSQL LOCK PRIVILEGES" to instructions.
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------
Pekka is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #22
Faustini
Member
 
Faustini's Avatar
 
Join Date: Feb 2006
Location: Vitória (ES) - Brazil
Posts: 32
Wink Re: Exhibit Engine 2 upgrade instructions

Quote:
Originally Posted by Pekka View Post
Or the most correct way is to open languages/eng/global.php and build a new language to a new file line by line from old data.

I'll add all contributed language files for download here.
Hi again! As a contribution, I'll work on the translation of the english language files into brazilian portuguese, OK? In time:

1 - May I include the " (quote) character in comment lines (//)?

2 - How to insert quotes in the text of translated sentences (so PHP doesn't interpret the first one as the one that is ending the "tag")? For example:

$translated["custom_footer"] = "Thanks for being here in my "digital nestle"!";

3 - Sugestion: what about starting a "Language translations" thread?

Peace,

Faustini
Faustini is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #23
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

[quote=Faustini;2077990]Hi again! As a contribution, I'll work on the translation of the english language files into brazilian portuguese, OK? In time:

Quote:
1 - May I include the " (quote) character in comment lines (//)?
Yes.

Quote:
2 - How to insert quotes in the text of translated sentences (so PHP doesn't interpret the first one as the one that is ending the "tag")? For example:

$translated["custom_footer"] = "Thanks for being here in my "digital nestle"!";
Add a slash before the quote:

Code:
"Thanks for being here in my \"digital nestle\"!"
Quote:
3 - Sugestion: what about starting a "Language translations" thread?
Will do soon. Thanks!
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------

Last edited by Pekka : 4th of October 2006 (Wed) at 20:16.
Pekka is offline   Reply With Quote
Old 4th of October 2006 (Wed)   #24
Faustini
Member
 
Faustini's Avatar
 
Join Date: Feb 2006
Location: Vitória (ES) - Brazil
Posts: 32
Question Re: Exhibit Engine 2 upgrade instructions

Still:

1 - What's the "$s_charset" (ISO #) to brazilian portuguese?

2 - How do I set the item "setlocale (LC_TIME , "english");"?

3 - May I use [ ]s and ( )s in the text of the sentences? For example:

make_flash ("\"fill\" (preenchimento)");

Sincerely,

Faustini
Faustini is offline   Reply With Quote
Old 5th of October 2006 (Thu)   #25
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

Quote:
Originally Posted by Faustini View Post
Still:

1 - What's the "$s_charset" (ISO #) to brazilian portuguese?
ISO 8859-1 should work ok.

Quote:
2 - How do I set the item "setlocale (LC_TIME , "english");"?
use

"setlocale (LC_TIME , "portuguese");"

or

"setlocale (LC_TIME , "pt_BR");"

or

"setlocale (LC_TIME , "pt_BR.iso-8859-1");"

This setting affects only the date and time setting in EE 2 "Global Settings", when you select "Preferred date representation of current language" choices.

Quote:
3 - May I use [ ]s and ( )s in the text of the sentences? For example:

make_flash ("\"fill\" (preenchimento)");
yes.
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------
Pekka is offline   Reply With Quote
Old 5th of October 2006 (Thu)   #26
hbeumer
Junior Member
 
Join Date: Oct 2006
Posts: 9
Default Re: Exhibit Engine 2 upgrade instructions

During the upgrade procedure I encountered the following errors. The error can be reproduced (after restore of database backup).

Upgrading from 1.5RC4 to 2.0
PHP version 5.1.4
MySQL version 5.0.22
MySQL lock privileges are set

Upgrade log follows:
-----------------------------------------------------------------------
DROP TABLE IF EXISTS `ee_uncookied` ...... OK
CREATE TABLE `ee_uncookied` ...... OK
DROP TABLE IF EXISTS `ee_uncookied_settings` ...... OK
DROP TABLE IF EXISTS `ee_message` ...... OK
DROP TABLE IF EXISTS `ee_message` ...... OK
CREATE TABLE `ee_message` ...... OK
DROP TABLE IF EXISTS `ee_link_to_group` ...... OK
CREATE TABLE `ee_link_to_group` ...... OK
DROP TABLE IF EXISTS `ee_error` ...... OK
CREATE TABLE `ee_error` ...... OK
DROP TABLE IF EXISTS `ee_login` ...... OK
CREATE TABLE `ee_login` ...... OK
DROP TABLE IF EXISTS `ee_order_to_group` ...... OK
CREATE TABLE `ee_order_to_group` ...... OK
DROP TABLE IF EXISTS `ee_order_to_link` ...... OK
CREATE TABLE `ee_order_to_link` ...... OK
DROP TABLE IF EXISTS `ee_resultcache` ...... OK
CREATE TABLE `ee_resultcache` ...... OK
DROP TABLE IF EXISTS `ee_session` ...... OK
CREATE TABLE `ee_session` ...... OK
DROP TABLE IF EXISTS `ee_shorthand` ...... OK
CREATE TABLE `ee_shorthand` ...... OK
DROP TABLE IF EXISTS `ee_structure_cache` ...... OK
CREATE TABLE `ee_structure_cache` ...... OK
DROP TABLE IF EXISTS `ee_structure_lang_cache` ...... OK
CREATE TABLE `ee_structure_lang_cache` ...... OK
DROP TABLE IF EXISTS `ee_thumb_size` ...... OK
CREATE TABLE `ee_thumb_size` ...... OK
DROP TABLE IF EXISTS `ee_upload_folder` ...... OK
CREATE TABLE `ee_upload_folder` ...... OK
DROP TABLE IF EXISTS `ee_uploader_cache` ...... OK
CREATE TABLE `ee_uploader_cache` ...... OK
DROP TABLE IF EXISTS `ee_user` ...... OK
CREATE TABLE `ee_user` ...... OK
DROP TABLE IF EXISTS `ee_viewerstyle` ...... OK
CREATE TABLE `ee_viewerstyle` ...... OK
DROP TABLE IF EXISTS `ee_frame` ...... OK
CREATE TABLE `ee_frame` ...... OK
DROP TABLE IF EXISTS `ee_debug_timer` ...... OK
CREATE TABLE `ee_debug_timer` ...... OK
DROP TABLE IF EXISTS `ee_debug_report` ...... OK
CREATE TABLE `ee_debug_report` ...... OK
DROP TABLE IF EXISTS `ee_prevnext_cache` ...... OK
CREATE TABLE `ee_prevnext_cache` ...... OK
DROP TABLE IF EXISTS `ee_style_template` ...... OK
CREATE TABLE `ee_style_template` ...... OK
DROP TABLE IF EXISTS `ee_group` ...... OK
CREATE TABLE `ee_group` ...... OK
DROP TABLE IF EXISTS `ee_group_eng` ...... OK
CREATE TABLE `ee_group_eng` ...... OK
DROP TABLE IF EXISTS `ee_link` ...... OK
CREATE TABLE `ee_link` ...... OK
DROP TABLE IF EXISTS `ee_group_to_group` ...... OK
CREATE TABLE `ee_group_to_group` ...... OK
DROP TABLE IF EXISTS `ee_batch_cache` ...... OK
CREATE TABLE `ee_batch_cache` ...... OK
DROP TABLE IF EXISTS `ee_style` ...... OK
CREATE TABLE `ee_style` ...... OK
DROP TABLE IF EXISTS `ee_admin_log` ...... OK
DROP TABLE IF EXISTS `ee_settings` ...... OK
DROP TABLE IF EXISTS `ee_settings` ...... OK
CREATE TABLE `ee_settings` ...... OK
INSERT INTO ee_uncookied_settings () VALUES () ...... OK
INSERT INTO `ee_order_to_group` (index group order) ...... OK
ALTER TABLE `ee_size` (add ee_size_protected) ...... OK
ALTER TABLE `ee_photo_size` (add index ee_photo_id) ...... OK
ALTER TABLE `ee_photo_size` (add ee_viewerstyle_id) ...... OK
ALTER TABLE `ee_photo_size` (add ee_viewerstyle_use_vars) ...... OK
ALTER TABLE `ee_photo_size` (add ee_viewerstyle_vars) ...... OK
ALTER TABLE `ee_photo_size` (add ee_size_x) ...... OK
ALTER TABLE `ee_photo_size` (add ee_size_y) ...... OK
ALTER TABLE `ee_photo_size` (add ee_size_bytes) ...... OK
ALTER TABLE `ee_photo_size` (add ee_size_filename) ...... OK
ALTER TABLE `ee_photo_size` (add index ee_size_id) ...... OK
ALTER TABLE `ee_photo_size` (add index ee_viewerstyle_id) ...... OK
ALTER TABLE `ee_news` (add ee_news_photo_id) ...... OK
ALTER TABLE `ee_news` (add ee_news_exhibition_id) ...... OK
INSERT INTO `ee_viewerstyle` (insert VIEWERSTYLE_default.php) ...... OK
INSERT INTO `ee_viewerstyle` (insert VIEWERSTYLE_flash.php) ...... OK
INSERT INTO `ee_viewerstyle` (insert VIEWERSTYLE_pt_panorama.php) ...... OK
INSERT INTO `ee_viewerstyle` (insert VIEWERSTYLE_pt_crypt.php) ...... OK
INSERT INTO `ee_viewerstyle` (insert VIEWERSTYLE_win_media.php) ...... OK
ALTER TABLE `ee_resizemethod` (change ee_resizemethod_usm_amount) ...... OK
INSERT DEFAULT TEMPLATE DATA ...... OK
ALTER TABLE `ee_exhibition` (add ee_exhibition_is_virtual) ...... OK
ALTER TABLE `ee_exhibition` (add ee_exhibition_virtual_parameters) ...... OK
ALTER TABLE `ee_exhibition` (add ee_exhibition_indexlink) ...... OK
ALTER TABLE `ee_exhibition` (add ee_exhibition_indexlink_active) ...... OK
INSERT INTO `ee_group` (INDEX group) ...... OK
INSERT INTO `ee_group_eng` (INDEX group) ...... OK
INSERT INTO `ee_group` (move old index group) ...... OK
INSERT INTO `ee_order_to_group` (move old index group) ...... OK
INSERT INTO `ee_group_eng` (move old index group) ...... OK
INSERT INTO `ee_link` (default links) ...... OK
INSERT INTO `ee_link` (default links) ...... OK
INSERT INTO `ee_link` (default links) ...... OK
INSERT INTO `ee_link` (default links) ...... OK
INSERT INTO `ee_link` (default links) ...... OK
INSERT INTO `ee_link` ...... OK
INSERT INTO `ee_link` (default links) ...... OK
DROP TABLE IF EXISTS `ee_link_eng` ...... OK
CREATE TABLE `ee_link_eng` ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_link_eng` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_order_to_link` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
INSERT INTO `ee_link_to_group` (default links) ...... OK
ALTER TABLE `ee_exhibition_to_group` DROP INDEX ...... OK
ALTER TABLE `ee_exhibition_to_group` DROP INDEX ...... OK
ALTER TABLE `ee_exhibition_to_group` CHANGE ...... OK
UPDATE `ee_exhibition_to_group` ...... OK
ALTER TABLE `ee_exhibition_to_group` ADD INDEX ...... OK
ALTER TABLE `ee_exhibition_to_group` ADD INDEX ...... OK
INSERT INTO `ee_frame` (example frame passepartout_4) ...... OK
INSERT INTO `ee_frame` (example frame passepartout_3) ...... OK
INSERT INTO `ee_frame` (example frame passepartout_2) ...... OK
INSERT INTO `ee_frame` (example frame passepartout_1) ...... OK
INSERT INTO `ee_frame` (example frame passepartout_5) ...... OK
INSERT INTO `ee_frame` (example frame passepartout_6) ...... OK
INSERT INTO `ee_frame` (example frame plain_1) ...... OK
INSERT INTO `ee_frame` (example frame dark_1) ...... OK
INSERT INTO `ee_frame` (example frame rosy_1) ...... OK
INSERT INTO `ee_batch_cache` ...... OK
INSERT INTO `ee_batch_cache` ...... OK
ALTER TABLE `ee_photo_size` ...... OK
DROP TABLE IF EXISTS `ee_size_custom_menutext_eng` ...... OK
CREATE TABLE `ee_size_custom_menutext_eng` ...... OK
ALTER TABLE `ee_ftp` (drop ee_ftp_servertype) ...... OK
ALTER TABLE `ee_ftp` (drop ee_ftp_idletime) ...... OK
ALTER TABLE `ee_ftp` (add ee_ftp_nobuffer) ...... OK
ALTER TABLE `ee_counter` (drop ee_counter_group) ...... OK
ALTER TABLE `ee_debug_report` (change ee_debug_pagewasrun) ...... OK
ALTER TABLE `ee_exhibition` (drop ee_exhibition_pass) ...... OK
ALTER TABLE `ee_exhibition_feedback` (change ee_exhibition_feedback_timestamp) ...... OK
ALTER TABLE `ee_exhibition_feedback` (add ee_exhibition_feedback_user_agent) ...... OK
ALTER TABLE `ee_exhibition_feedback` (add ee_exhibition_feedback_ip) ...... OK
ALTER TABLE `ee_exhibition_feedback` (add ee_exhibition_feedback_checksum) ...... OK
ALTER TABLE `ee_exhibition_feedback` (change ee_exhibition_feedback_name) ...... OK
ALTER TABLE `ee_news` (change ee_news_photo_id) ...... OK
ALTER TABLE `ee_order_to_exhibition` (drop index ee_photo_id) ...... OK
ALTER TABLE `ee_order_to_exhibition` (drop index ee_exhibition_id) ...... OK
ALTER TABLE `ee_order_to_exhibition` (add multi index) ...... OK
ALTER TABLE `ee_order_to_exhibition` (add multi index) ...... OK
ALTER TABLE `ee_owner` (drop index ee_country_id) ...... OK
ALTER TABLE `ee_owner` (drop index ee_location_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_photo_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_light_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_counter_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_country_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_location_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_workflow_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_lens_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_owner_id) ...... OK
ALTER TABLE `ee_photo` (drop index ee_camera_id) ...... OK
ALTER TABLE `ee_photo` (drop ee_photo_foo) ...... OK
ALTER TABLE `ee_photo_comment` ...... OK
ALTER TABLE `ee_photo_comment` ...... OK
ALTER TABLE `ee_photo_eng` (drop index ee_photo_id) ...... OK
ALTER TABLE `ee_photo_to_accessory` (add index ee_photo_id) ...... OK
ALTER TABLE `ee_photo_to_accessory` (add index ee_accessory_id) ...... OK
ALTER TABLE `ee_photo_to_exhibition` (drop index ee_photo_id) ...... OK
ALTER TABLE `ee_photo_to_exhibition` (drop index ee_exhibition_id) ...... OK
ALTER TABLE `ee_photo_to_exhibition` (add index ee_photo_id) ...... OK
ALTER TABLE `ee_resizemethod` (drop ee_resizemethod_safetynet) ...... OK
ALTER TABLE `ee_session` (change ee_login_session_id) ...... OK
ALTER TABLE `ee_session` (add index ee_login_session_id) ...... OK
INSERT INTO `ee_upload_folder` (base row) ...... OK
ALTER TABLE `ee_uploader_cache` ...... OK
ALTER TABLE `ee_uploader_cache` (change ee_uploader_data) ...... OK
INSERT INTO `ee_uploader_cache` (user public) ...... OK
ALTER TABLE `ee_user` (add ee_user_totalcount_cache) ...... OK
ALTER TABLE `ee_user` (add ee_user_totalcount_cache_update) ...... OK
ALTER TABLE `ee_user` (add ee_user_totalcount_cache_timestamp) ...... OK
INSERT INTO `ee_style` default styles ...... OK
DROP TABLE IF EXISTS `ee_exhibition_group_eng` ...... OK
ALTER TABLE `ee_photo_to_exhibition` (add index ee_exhibition_id) ...... OK
UPDATE `ee_exhibition` (all styles to 1) ...... OK
INSERT INTO ee_settings () VALUES () ...... OK
TRUNCATE TABLE ee_performance (remove stale data) ...... OK
INSERT INTO `ee_resizemethod` (netpbm thumb slot) ...... OK
INSERT INTO `ee_resizemethod` (netpbm microthumb slot) ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
UPDATE table comment ...... OK
ALTER TABLE `ee_settings_eng` ...... Lost connection to MySQL server during query
ALTER TABLE `ee_settings_eng` ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
UPDATE table comment ...... MySQL server has gone away
CHANGE ee_exhibition ...... MySQL server has gone away
DROP `ee_simplenavigation_search` ...... MySQL server has gone away
DROP `ee_simplenavigation_sort` ...... MySQL server has gone away
DROP `ee_simplenavigation_perpage` ...... MySQL server has gone away
ALTER TABLE `ee_exhibition` CHANGE `ee_detaillist_1` ...... MySQL server has gone away
ALTER TABLE `ee_exhibition` CHANGE `ee_detaillist_2` ...... MySQL server has gone away
DROP `ee_activate_links_list` ...... MySQL server has gone away
restore some of the old settings ...... MySQL server has gone away
UPDATE `ee_group` ...... MySQL server has gone away
UPDATE `ee_group` ...... MySQL server has gone away
UPDATE `ee_group` ...... MySQL server has gone away
ALTER TABLE `ee_admin` ...... MySQL server has gone away
INSERT INTO `ee_batch_cache` ...... MySQL server has gone away
INSERT INTO `ee_batch_cache` ...... MySQL server has gone away
fixing category tables... .....FINISHED.
update ee_list_perpage ...... MySQL server has gone away
alter ee_photo_exif_shutter ...... MySQL server has gone away
update ee_photo_for_www yes ...... MySQL server has gone away
update ee_photo_for_www no ...... MySQL server has gone away
alter ee_photo_for_www ...... MySQL server has gone away
update ee_settings ee_installed_gd ...... MySQL server has gone away
update ee_settings ee_installed_imagick ...... MySQL server has gone away
alter ee_backup_info ...... MySQL server has gone away
alter admin table defaults ...... MySQL server has gone away
alter admin table defaults ...... MySQL server has gone away
alter admin table defaults ...... MySQL server has gone away
alter admin table defaults ...... MySQL server has gone away
alter admin table defaults ...... MySQL server has gone away
alter ee_detaillist_1 defaults ...... MySQL server has gone away
alter ee_detaillist_2 defaults ...... MySQL server has gone away
alter ee_photodetailrow ...... MySQL server has gone away
alter ee_photo ...... MySQL server has gone away
update ee_version number to 2.0 ...... MySQL server has gone away
hbeumer is offline   Reply With Quote
Old 5th of October 2006 (Thu)   #27
Pekka
El General Moderator
 
Pekka's Avatar
 
Join Date: Mar 2001
Location: Hellsinki, Finland
Posts: 14,093
Default Re: Exhibit Engine 2 upgrade instructions

This probably means your mysql has quite short connect timeout value.

One solution (untested) is changing ee_install function in upgrade.php line 345 to

PHP Code:
function ee_install ($query,$name,$report="1") {
    global 
$servername;
    global 
$username;
    global 
$password;
    global 
$databasename;
    global 
$ee_mysql_connection;
    
// test connection
    
$test mysql_query("SELECT 1+1");
    if (!
$test) {
        include (
$toroot "basecode/SCRIPT_connect.php");
    }
    
$update mysql_query($query);
    if (
$report == "1") {
        
ee_error ($update,$query,$name);
    }
    if (
$update) {
        print 
"<br><b>" $name "</b> ...... <span style=\"color: #00BB00;\">OK</span>";
    }
    if (!
$update) {
        print 
"<br><b>" $name "</b> ...... <span style=\"color: #FF0000;\">" mysql_error() . "</span>";
    }
    
flush();
    return;

Other option is to add reconnect code

PHP Code:
@mysql_close();
include (
$toroot "basecode/SCRIPT_connect.php"); 
to line 3508

Please let me know if either one helped.
__________________
This signature signifies my significance significantly
Photo Gallery

----------------------------
Pekka is offline   Reply With Quote
Old 6th of October 2006 (Fri)   #28
tommykjensen
The Admin Dane
"Nobody is safe!"
 
tommykjensen's Avatar
 
Join Date: Mar 2004
Location: Copenhagen, Denmark.
Posts: 20,611
Default Re: Exhibit Engine 2 upgrade instructions

Ok ran the upgrade and everything went fin until the point of updating the photosize database.

When I select a few photos and click on start the page refresh partially and stops.

Then if I click on all in the top to get the menu again and click on retrieve photo sizes again. Then I can click on continue last batch and some photos are processed. Then there is the option to click on next photo or continue nonstop. If I click on next photo the same happens with the partial page refresh. But if I click on continue nonstop one photo is processed.

I am using IE6.

ee2error1.jpg
__________________
Best Regards Tommy
My Photos -=- about.me -=- My Facebook, if you add me please send me a pm also
GAPS Africa I 2007 photos -=- GAPS Africa II 2008 photos -=- GAPS Africa IV 2011 photos -=- GAPS = Great African Photo Safari

My marketplace feedback click here.

IMPORTANT: Image posting rules updated - please read.

"PERSONAL MESSAGING REGARDING SELLING OR BUYING ITEMS WITH MEMBERS WHO HAVE NO POSTS IN FORUMS AND/OR WHO YOU DO NOT KNOW FROM FORUMS IS HEREBY DECLARED STRICTLY STUPID AND YOU WILL GET BURNED."
tommykjensen is offline   Reply With Quote
Old 6th of October 2006 (Fri)   #29
tommykjensen
The Admin Dane
"Nobody is safe!"
 
tommykjensen's Avatar
 
Join Date: Mar 2004
Location: Copenhagen, Denmark.
Posts: 20,611
Default Re: Exhibit Engine 2 upgrade instructions

Ok forget above. I just updated with the files for 2.01 which I thought was in the original zipfile. Now the page refreshed correctly and continue automatically when clicking on continue nonstop.
__________________
Best Regards Tommy
My Photos -=- about.me -=- My Facebook, if you add me please send me a pm also
GAPS Africa I 2007 photos -=- GAPS Africa II 2008 photos -=- GAPS Africa IV 2011 photos -=- GAPS = Great African Photo Safari

My marketplace feedback click here.

IMPORTANT: Image posting rules updated - please read.

"PERSONAL MESSAGING REGARDING SELLING OR BUYING ITEMS WITH MEMBERS WHO HAVE NO POSTS IN FORUMS AND/OR WHO YOU DO NOT KNOW FROM FORUMS IS HEREBY DECLARED STRICTLY STUPID AND YOU WILL GET BURNED."
tommykjensen is offline   Reply With Quote
Old 6th of October 2006 (Fri)   #30
tommykjensen
The Admin Dane
"Nobody is safe!"
 
tommykjensen's Avatar
 
Join Date: Mar 2004
Location: Copenhagen, Denmark.
Posts: 20,611
Default Re: Exhibit Engine 2 upgrade instructions

How do I get the batch photo size checker to continue for more than 30 seconds a time?

My php timeout is set to 6000 seconds


From server info
Quote:
PHP maximum script execution time: 6000 seconds
__________________
Best Regards Tommy
My Photos -=- about.me -=- My Facebook, if you add me please send me a pm also
GAPS Africa I 2007 photos -=- GAPS Africa II 2008 photos -=- GAPS Africa IV 2011 photos -=- GAPS = Great African Photo Safari

My marketplace feedback click here.

IMPORTANT: Image posting rules updated - please read.

"PERSONAL MESSAGING REGARDING SELLING OR BUYING ITEMS WITH MEMBERS WHO HAVE NO POSTS IN FORUMS AND/OR WHO YOU DO NOT KNOW FROM FORUMS IS HEREBY DECLARED STRICTLY STUPID AND YOU WILL GET BURNED."
tommykjensen is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
EXHIBIT ENGINE 2.0 UPGRADE: DOWNLOAD Pekka EE 2 Installation 15 4th of September 2010 (Sat) 04:27
DOWNLOAD EXHIBIT ENGINE 2.0 UPGRADE HERE Pekka Version 1.0-1.5 discussion 18 4th of October 2006 (Wed) 22:05
What is Exhibit Engine? Pekka EE 2 Manual 0 3rd of October 2006 (Tue) 11:40
Now using Exhibit Engine shogton Presentation 0 18th of August 2004 (Wed) 08:07
Exhibit Engine 1.21 Pekka Version 1.0-1.5 discussion 9 14th of June 2002 (Fri) 14:40


All times are GMT -5. The time now is 01:54.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
This forum is not affiliated with Canon in any way and is run as a free user helpsite by Pekka Saarinen, Helsinki Finland. You will need to register in order to be able to post messages. Cookies are required for registering and posting. HTML in messages is not allowed, plain website addresses are automatically made active by the board.