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.

mysql error upon migration of site

March 04, 2010 7:08pm

Subscribe [3]
  • #1 / Mar 04, 2010 7:08pm

    vibe9

    96 posts

    This question may be related to a resolved thread.

    I am in the process of migrating a site to an IIS server from a Linux server. I’ve followed all of the directions in the wiki for migrating a site, but when I try to access the CP or the homepage I get the following error:

    MySQL ERROR:
    Error Number: 1054
    Description: Unknown column 'y' in 'where clause'
    Query: SELECT * FROM exp_ff_fieldtypes WHERE enabled = "y"

    Any suggestions? Is this an EE problem or a server problem?

  • #2 / Mar 05, 2010 2:00am

    John Henry Donovan

    12339 posts

    vibe9,

    Before moving everything can you stop and run the server wizard on your new server.

    FieldFrame which you are running has specific requirements also including PHP5

    Alos take a look at this post in the related thread. Have you tried that add-on, Deeploy Helper?

  • #3 / Mar 08, 2010 2:18pm

    vibe9

    96 posts

    Thanks John.
    The server wizard was run before I moved anything over - all required items are supported, including php 5.2+. I believe the problem may be due to the Field Frame extension, so I have posted a question here for now; since whenever I turn extensions off in config.php everything works fine.

  • #4 / Mar 08, 2010 4:27pm

    Ingmar

    29245 posts

    Ah, that would make sense. Let us know if there’s anything else we can do for you.

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

ExpressionEngine News!

#eecms, #events, #releases