I sent the form with the login details. FYI, it’s SFTP, not FTP.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
July 08, 2011 6:56pm
Subscribe [7]#16 / Jul 26, 2011 9:35pm
I sent the form with the login details. FYI, it’s SFTP, not FTP.
#17 / Jul 27, 2011 1:01pm
Hey Adam,
Thanks for the login info. Before we dive in, let me get you to try something. Since the server itself is the common denominator with the sites that are getting the same error, can I get you to migrate this particular site to a separate server for the sake of trying the upgrade under a different server environment? If the same site has no problem being upgraded on a server that’s not running Mac OS X Server, that helps us narrow it down to a server issue.
#18 / Jul 27, 2011 6:19pm
Hi Kevin,
I’ll try it on another server and let you know how it goes.
Assuming it is a server issue, any thoughts on what could be causing it?
#19 / Jul 28, 2011 3:11pm
Hi Adam,
Offhand, no, but we’ll do our best to track it down if that turns out to be the case. Keep us posted.
#20 / Jul 29, 2011 7:28pm
No dice. I attempted the upgrade on a different server (Mediatemple Grid Server) with the same results.
#21 / Aug 01, 2011 5:55pm
Try something for me, Adam. Go back through an upgrade as you have been (making sure the DB has been cleared and then restored, of course), but make this change in the ./system/installer/updates/ud_009.php file first.
Change this, at line 40:
$id = $DB->insert_id;to this:
$id = $this->EE->db->insert_id();Let me know if that takes care of it.
Edit: Corrected the PHP above.
#22 / Aug 02, 2011 10:56pm
Still no luck. I’m getting these two errors:
A PHP Error was encountered
Severity: Notice
Message: Undefined property: CI_DB_mysql_driver::$insert_id
Filename: updates/ud_009.php
Line Number: 40A Database Error Occurred
Error Number: 1060
Duplicate column name 'can_search'
ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default 'n'
Filename: updates/ud_009.php
Line Number: 112#23 / Aug 03, 2011 5:42pm
That’s my fault, Adam. I’ve corrected the code in the post above. I just forgot to add () to the end of the function.
Could you try again? Thanks so much for your patience on this.
#24 / Aug 03, 2011 7:49pm
That took care of one of the errors. Just this one remains:
A Database Error Occurred
Error Number: 1060
Duplicate column name 'can_search'
ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default 'n'
Filename: updates/ud_009.php
Line Number: 113#25 / Aug 04, 2011 2:23pm
Weird.
I suspect we’re going to keep running into these errors, so let’s try something else. The update file ud_009.php is only called by the Upgrade Wizard when it cannot access the config.php and database.php file. Do you have permissions on those files set to at least 666?
#26 / Aug 04, 2011 8:48pm
That’s really interesting. Both the config and database files are set to 666.
#27 / Aug 05, 2011 5:28pm
Yep, this is odd. Ok, so in your config.php file before upgrading, what’s the value of this config item?
$config['app_version']#28 / Aug 08, 2011 8:25pm
$config['app_version'] = "214";
Early on before I brought this issue up for support, I had searched through the forums to see if I could come up with any solutions and a lot of similar errors seem to be related to the app version, specifically, having the wrong one listed.
I use a lot of custom config values, so I thought it could be possible that I copied a config.php file from another site and forgot to adjust the app version.
I did attempt the upgrade process with several different values (213, 215, etc.) in there with the same results. Is there a way to rule that out 100%?
#29 / Aug 09, 2011 6:37pm
Oh! Custom config.php… that might be a clue to this.
Removing sensitive information, post everything above
// END EE config itemsin your config.php file. Thanks!
#30 / Aug 10, 2011 8:03pm
Here’s the custom config items. Just so you are aware, I have a nearly identical config file for another site that I was able to successfully upgrade.
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/*
|--------------------------------------------------------------------------
| ExpressionEngine Config Items
|--------------------------------------------------------------------------
|
| The following items are for use with ExpressionEngine. The rest of
| the config items are for use with CodeIgniter.
|
*/
//global settings
$config['site_label'] = "somesite.com";
$config['app_version'] = "214";
$config['install_lock'] = "";
$config['license_number'] = "";
$config['doc_url'] = "http://ellislab.com/expressionengine/user-guide/";
$config['doc_url'] = "http://ellislab.com/expressionengine/user-guide/";
$config['is_system_on'] = "y";
$config['cookie_prefix'] = "";
$config['allow_extensions'] = "y";
$config['multiple_sites_enabled'] = "n";
$config['hidden_template_indicator'] = "_";
$config['autosave_interval_seconds'] = "0";
$conf['protect_javascript'] = "n";
// Dynamic paths for cross-server compatibility
$protocol = (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] == "on") ? "https://" : "http://";
$base_url = $protocol . $_SERVER['HTTP_HOST'];
$base_path = $_SERVER['DOCUMENT_ROOT'];
$system_folder = "notrealsystemfolder";
$images_folder = "images";
$images_path = $base_path . "/" . $images_folder;
$images_url = $base_url . "/" . $images_folder;
$config['index_page'] = "";
$config['base_url'] = $base_url . "/beta/";
$config['site_url'] = $config['base_url'];
$config['cp_url'] = $config['base_url'] . $system_folder . "/index.php";
$config['theme_folder_path'] = $base_path . "/notrealdirectory/themes/";
$config['theme_folder_url'] = $base_url . "/notrealdirectory/themes/";
$config['tmpl_file_basepath'] = $base_path . "/notrealdirectory/themes/site_themes/";
//CE image
$config['ce_image_image_permissions'] = 0644;
$config['ce_image_dir_permissions'] = 0777;
$config['ce_image_document_root']= $base_path . "/notrealdirectory/";
// basic preferences
$config['minimee_cache_path'] = $base_path . "/notrealdirectory/themes/site_themes/default_site/cache";
$config['minimee_cache_url'] = $base_url . "/notrealdirectory/themes/site_themes/default_site/cache";
// advanced prefernces
$config['minimee_debug'] = 'n'; // 'n' or 'y'
$config['minimee_disable'] = 'y'; // 'n' or 'y'
$config['minimee_remote_mode'] = 'auto'; // 'auto', 'curl' or 'fgc'
$config['emoticon_path'] = $images_url . "/smileys/";
$config['captcha_path'] = $images_path . "/captchas/";
$config['captcha_url'] = $images_url . "/captchas/";
$config['avatar_path'] = $images_path . "/avatars/";
$config['avatar_url'] = $images_url . "/avatars/";
$config['photo_path'] = $images_path . "/member_photos/";
$config['photo_url'] = $images_url . "/member_photos/";
$config['sig_img_path'] = $images_path . "/signature_attachments/";
$config['sig_img_url'] = $images_url . "/signature_attachments/";
$config['prv_msg_upload_path'] = $images_path . "/pm_attachments/";
// Control Panel Theme
$config['cp_theme'] = "nerdery";
// Debugging and performance
$config['show_profiler'] = "n"; # y/n
$config['template_debugging'] = "n"; # y/n
$config['debug'] = "1"; # 0: no PHP/SQL errors shown. 1: Errors shown to Super Admins. 2: Errors shown to everyone. Keep this at 1 or mapping doesn't work
$config['disable_all_tracking'] = "y"; # y/n
$config['enable_sql_caching'] = "n"; # Cache Dynamic Channel Queries?
$config['email_debug'] = "n"; # y/n
$conf['protect_javascript'] = "y";
$config['ip2nation'] = "y";
$config['ip2nation_db_date'] = "1290177198";
$config['enable_db_caching'] = "n";
$config['admin_session_type'] = "c";
// END EE config items