Hello Everyone….Its been a while since I posted because EE has been running great!...

But I just switched to a new host and I upgraded to EE 1.1…I created a database with the same name as on the old host as well as a database user. When I tried to import my backed up database with phpMyAdmin I get the “table already created error. I also tried the backup utility in cPanel and just replaced the database and I get all kinds of errors when trying to access the site.

Would it be possible to upload the database using the backup utility in cPanel giving the DB a different name and then use the pMachine Import Utility to get my data into the new database. Or is there a better way to get the data into the new DB…

Thx

OK…I found the infor in the knowledgebase but when I try to access the site I get this:

Error: Unable to delete the following file: 1a1975756ab93fbedb0640240ac030b7

Would it be possible to try my original idea with the pmachine import utility?

You should be able to do an export from phpMyAdmin (optimize your tables and clean out the exp_revision_tracker table), and then import all of the data into the new database.

The file is a cache file in the system/cache folder somewhere.  I would suggest you simply delete the copied over folder and upload the one from a recently downloaded copy of EE.  Make sure to give it 777 permission too.

Thx paul thats what I ended up doing…however now I have some cosmetic issues…it looks OK in ForeFox but its messed up in IE (What isnt!).. http://www.mikespe.com/physedexpress

What I think I might do is a fresh install of EE 1.1 and then retry the old database…This way I’ll try a new template and see how creative I can get…What I originaly forgot to do was check the “Add Drop Tables” and “Add If Not Exists” checkboxes in phpMyAdmin…

I have about 4 databases I am trying to move over…this one was the most challenging

Thx again

Ok…I reinstalled EE 1.1 (fresh install) and used the old database to sql the new one to get the data into the db…I am now getting this error when I try to access the site:

MySQL ERROR:

Error Number: 1054

Description: Unknown column ‘exp_templates.save_template_file’ in ‘field list’

Query: SELECT exp_templates.template_name, exp_templates.template_id, exp_templates.template_data, exp_templates.template_type, exp_templates.save_template_file, exp_templates.cache, exp_templates.refresh, exp_templates.no_auth_bounce, exp_templates.allow_php, exp_templates.php_parse_location, exp_templates.hits, exp_template_groups.group_name FROM exp_template_groups, exp_templates WHERE exp_template_groups.group_id = exp_templates.group_id AND exp_templates.template_name = ‘index’ AND exp_template_groups.is_site_default = ‘y’

Anyone have an idea how to solve this error?

Thx

Is the old database from 1.0 and not 1.1?  Looks like your imported database doesn’t have all the changes that were introduced in 1.1.

Try following the upgrade instructions if that’s the case.

I did try the upgrade chris…it said I was already running v1.1…

I just did ANOTHER fresh install of 1.1…now how do I get the data into the dayabase without screwing up…please provide steps needed

I apologize I am just getting very frustrated right now. I did not have this kind of difficulty with phpBB, or my guestbook data…EE is really being a pain on this issue..

Well, the problem is that you’re first installing EE v1.1 when the database you want to use is still in 1.0 format.  So you have part of your system on one version and part on another, which is what causes the issues.

Do you still have your files from your 1.0 version of EE?  If so, I would restore that, restore the database and get that working.  Then simply follow the regular upgrade instructions to go from 1.0 to 1.1.

well chris I did what you said and transfered my old files…ran the update script and I get this when running the update script:

MySQL ERROR:

Error Number: 1060

Description: Duplicate column name ‘comment_expiration’

Query: ALTER TABLE exp_weblogs ADD COLUMN comment_expiration int(4) unsigned NOT NULL default ‘0’

I have to be honest I am real close to giving up on EE…switching servers should not be this difficult

chris I apologize…I reupped the old database and it worked…however now my page is a little screwy in IE…if you scroll all the way to the bottom you’ll see what I mean..

www.mikespe.com/physedexpress

and my password does not work and when I click Forgot my password to send it to me I don’t get the email…I tried 3 times

Are you sure that the new server is correctly set up to send email via PHP?  Can you successfully send an email via the Post Office section of the pM Control Panel?

You might try setting pM to use a different email protocol in your config.php file.  See the Post Office section of the manual for information.

I eventually got it all working chris…sorry for my frustration…I still had the same email address on my old server. I deleted them and reconfigured Outlook Express and it worked.

I ended up changing the templates. The one’s I had just didn’t work for me. I need to change the colors of the new templates but the format is much better…and a little “bigger” so it doesn’t look crowded…

Thx for your help!