ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Error Number 1050 when upgrading to 2.1 (database errors)

July 15, 2010 10:13am

Subscribe [9]
  • #31 / Aug 05, 2010 6:54pm

    jbriggs

    38 posts

    I have the same issue PJCweb.  exp_snippets is still there even after I roll back to a database that doesn’t have that table.  A list of the new tables would be helpful.

  • #32 / Aug 06, 2010 5:49am

    John Henry Donovan

    12339 posts

    jbriggs,

    exp_snippets is still there even after I roll back to a database that doesn’t have that table

    That doesn’t make sense to me. Do you mean the error still appears after rolling back to a database without that table?


    PJCweb,

    Lets see how much of your database was upgraded.

    Take a look in your EE database at the exp_password_lockout table. Does it have a field called ‘username’?

  • #33 / Aug 06, 2010 10:24am

    PJCweb

    41 posts

    Nope, it has user_agent, but no username field.

  • #34 / Aug 06, 2010 12:35pm

    PJCweb

    41 posts

    Alright, I was able to update to 2.1.  I cleaned out the table entries that weren’t supposed to be there by comparing it to an old database we had and went from there.  The installer completed and updated to 2.1.  However, at the moment I’m unable to login to the control panel, i’m getting an error:

    Unable to load the requested file: account/login.php

  • #35 / Aug 06, 2010 4:44pm

    PJCweb

    41 posts

    Aha, fixed that one, the theme folder hadn’t copied over for some reason. 

    99% working, the only problem is that the theme is not showing up quite correctly.  The CSS says its pointed to the main site url (i’m working on the staging area) using the variable cp_theme_url.  Where is this set?  I’ve already checked over expressionengine/config/config.php and it was nowhere to be found (added it anyway, just as an attempt, but that didn’t work). 

    Can you tell me where i can find this variable to set it?

    Thanks

  • #36 / Aug 07, 2010 2:59pm

    Greg Salt

    3988 posts

    Hi PJCweb,

    Sorry, can you clarify what you mean by ‘the theme is not showing up quite correctly’? It’s only partially working? What is the relationship between your main site URL and your staging area? Did you create the ‘cp_theme_url’ using path.php in 1.x?

    Cheers

    Greg

  • #37 / Aug 07, 2010 5:12pm

    PJCweb

    41 posts

    The dropdown menus in the control panel are not displaying any images (the text floats in space). 

    The page is looking for the background images for the dropdown menus (http://www.foo.com/images/whatever) as opposed to the staging area (staging.foo.com/images/whatever).  Further inspection shows that the built-in global.css that is being used uses cp_theme_url to find the location of the image, but I cannot find where that variable is set. 

    I did not explicitly set cp_theme_url using path.php in 1.x (didn’t even know it existed until now).  Does that mean you don’t know where the variable is set by default?

  • #38 / Aug 08, 2010 3:11pm

    Greg Salt

    3988 posts

    Hi PJCweb,

    I think I understand now. Please try adding this two lines to your system/expressionengine/config/config.php file:

    $config['theme_folder_path'] = '/system/path/to/your/theme/folder/';
    $config['theme_folder_url'] = 'http://staging.foo.com/themes/';

    Cheers

    Greg

  • #39 / Aug 10, 2010 7:20pm

    PJCweb

    41 posts

    Hmm odd… i’d added one of those earlier, and when i went back to add the other, it was working properly. however when i checked immediately after the change it wasn’t.  Must’ve been a caching thing i suppose?  In either case, thanks, it seems to be working now

  • #40 / Aug 11, 2010 8:37pm

    Brandon Jones

    5500 posts

    Thanks for the update, PJCweb. Closing this one out.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases