Thread

When I just tried to upgrade ee1 to ee2 (not sure what version. the upgrade instructions do not differentiate) It goes along quite nicely looking like it is updating just fine then it snags with this error message:

A Database Error Occurred

“Error Number: 1060

Duplicate column name ‘show_sidebar’

ALTER TABLE exp_members ADD show_sidebar char(1) NOT NULL default ‘y’ AFTER quick_tabs

Filename: E:\Websites\bibleframework.com - ee2\wwwroot\bf-system\codeigniter\system\database\DB_driver.php

Line Number: 330”

Does anyone know how to fix this?

———————————————————-

NOTE: I just learned I was on version 1.6.8. I also found a previous post asking that the site be upgraded to version 1.7 then try the upgrade. I will try that now. If anyone has any feedback on the above error it is welcome. I will report back how it goes.

Thanks,

Barney

I updated to version 1.7 successfully and then tried the update to EE2.

I get this error now:

“{"error":"

Error Number: 1050
\n\n

Table 'exp_snippets' already exists
\n\n

CREATE TABLE `exp_snippets` (\n `snippet_id` int(10) unsigned NOT NULL auto_increment,\n `site_id` int(4) NOT NULL,\n `snippet_name` varchar(75) NOT NULL,\n `snippet_contents` text NULL,\n PRIMARY KEY (`snippet_id`),\n KEY `site_id` (`site_id`)\n )
\n\n

Filename: E:\\Websites\\bibleframework.com - ee2\\wwwroot\\bf-system\\codeigniter\\system\\database\\DB_driver.php
\n\n

Line Number: 330
"}”

Can someone please shed some light on this?

Thanks,

Barney

I have tried everything I have found in the forums so far. I have even set my max_execution in php to be 0 which should prevent it from timing out but I still get the same error.

Someone please help. I have several EE1.x sites I wish to purchase upgrades for but I can’t get an upgrade to even work at this point which will leave a lot of my clients unhappy to be “stuck in the past”

I was able to get the site to do the full upgrade and thought I had a great success. However, even though the index.php file loaded just fine I am unable to login to my control panel. I am getting this error now:

Unable to load the requested file: _shared/menu/item_parent.php

I have read some other posts talking about this but I have not been able to unravel it for my site.  It is on a windows server running server 2008 and IIS7. I have several EE2 sites running quite successfully on the server but the upgraded site is still giving me fits.

I am also getting this error on internal pages. Obviously there are some 3rd party addons that need to be turned back on but I am unable to even login to the control panel because of the issue above. It talks about having the add-ons available in the upgrade instructions but doesn’t really inform me of when to install the updates.

After implementing the fix found in another post to my config.php file:

$config['theme_folder_path'] = "/path/to/public_html/themes/";
$config['cp_theme'] = 'default';

I am now getting this error.

“A PHP Error was encountered

Severity: Warning

Message: include(/websites/bibleframework.com - ee2/wwwroot/themes/cp_themes/default/homepage.php) [function.include]: failed to open stream: No such file or directory

Filename: core/Loader.php

Line Number: 677”

when I check the “core” folder for a file named “loader.php” non exists. The file in the core folder is called “ee_loader.php”

Hopefully someone will read this thread and respond soon. Just talking to myself is getting me caught in circular reasoning! 😊

Hi, Green Tent.

Your path to the themes folder is one you’d use if you had a Unix box, you’re on Windows, so your server path needs to be something else c:\something\else\themes\cp_themes\

Does that help?

Thanks Sue, that did the trick!

I had to jump through a lot of hoops to get the upgrade to work for me - working my way through several posts - so I will recap what I had to do to accomplish a successful upgrade on a Windows Server 2008 using IIS7.  I have admin access to the server so I was able to adjust the PHP max_execution_time from point 3 below myself.

1. I recommend duplicating your site (I use dev.websitedomain.xxx) and also duplicate your database to a new name. This will prevent your live site from being down due to complications during the upgrade. Even if the upgrade goes perfect it will still take you time to install and update the add-ons.

2. Make sure you have a good backup copy of the 1.x database. (there is a good chance you may have to restore it)

3. Check the PHP max_execution_time on your server. By default it is often set to 30 (30 seconds) which on my server was not long enough and caused the update to time out in the middle. You can find the setting in the php.ini file if you have access or may have to ask your host to temporarily set it to 0 so you can complete the update.

I used: max_execution_time = 0 (which means no time limit)

4. If you have a failed upgrade I HIGHLY RECOMMEND that you delete all of the tables in your database and restore the backup of your 1.x backup from step 2 above. A failed upgrade leaves new tables in the db that may cause it to fail your next attempt too.

5. In order for me to be able to login to the admin panel I had to add the following two lines to the config.php file after the upgrade was successful.

$config['theme_folder_path'] = "e:/path/to/your/themes/";
$config['cp_theme'] = 'default';

NOTE: On Unix servers you would not need the drive letter in the “theme folder path”.

Thanks for sharing your solution with us, and glad to see that worked for you. Please don’t hesitate to post again as needed.