Symphony.

With the new installation of 2.0.7 I’ll get an error like this.

Duplicate column name 'language'

An error occurred while attempting to execute the following query

    * ALTER TABLE `sym_authors` ADD `language` VARCHAR(255) DEFAULT 'system'

How can I solve this problem?

What exactly did you do? A fresh install? An update?

First I tried to update from 2.0.6 to 2.0.7 but it failed, because a same kind of error. Now I did a clean install, everything seems to work, but when I go to /?debug I get the error.

And while I’m typing this comment I saw the issue, I put the permissions to 777.

I am not sure if I understand. The permissions should have nothing to do with the error you posted.

Does it work now?

It seems like you have been using Localisation Manager on Symphony 2.0.6 which added the language column.

If you’re updating from Symphony 2.0.6 you should uninstall the Localisation Manager first.

If you’re updating from Symphony 2.0.6 you should uninstall the Localisation Manager first.

Maybe this could be added to the readme. Or even better: The updater should work around this.

I am having the exact same issue as the one stated above. I’ve been running Symphony 2.0.7RC2 (fresh install) which was updated to 2.0.7 this morning.

Everything else seems to work fine but when I try to create a new user I get a fatal database error. This happens if I leave it on the default language or switch it to English. I didn’t try other languages as I couldn’t use them even if they worked.

I do not have the Localisation Manger extension installed.

I’ve attached my error page.

Attachments:

Symphony Fatal Error.pdf

Did you run update.php?

I did. It said this:

It appears that Symphony has already been installed at this location and is up to date.

I should mention that this is what happened when I updated from 2.0.7RC1 to 2.0.7RC2 so I didn’t think anything of it.

In your config file, you could try and set your Symphony version to 2.0.7RC2 and run update.php again.

It let me update after doing this but for some reason it still gives me the error when I have the default section selected.

I should also mention that it does this for both author and developer user-types.

I had the same error as

dougoftheabaci

I did a clean install and put my old files into the workspace. When I create an author it creates the error…

What’s your PHP version? (I have tried on PHP 5.3.0 on Mac OS X and had no problems.)

PHP Version 5.2.12. I don’t remember having this issue with 2.0.7RC2, but I could be wrong.

Right. Let’s see if I can clarify it a little.

Duplicate column name ‘language’

This happens in the updater when it tries to append a new column to the sym_authors table. The SQL is run if you are using RC1 or lower, so for whatever reason, you already have the language column, but are using RC1 or lower.

The solution for those on RC1 is to just change the version number in your config file to 2.0.7. There are no other database changes since 2.0.6. If you’re on an older version, you’ll need to remove the language column from that table and run the updater again. Or alternatively, comment out approx. line 208 and run the updater again:

$frontend->Database->query('ALTER TABLE `sym_authors` ADD `language` VARCHAR(15) NULL DEFAULT NULL');

Unknown column ‘language’ in ‘field list’

The updater either has not been run, or the version is reporting 2.0.7 which would mean the SQL is skipped. Solution here is to set the version in /manifest/config.php to 2.0.7RC1 and run the updater.

The updater should work around this.

Yes, I should have put some exception handling in there. An oversight on my part. Something I will look at doing.

I may be thinking of a copy of Symphony I was running locally.

I checked my database with PHPMyAdmin and there is no reference to language and nothing in the sym_authors section.

One thing I’d be willing to try is to manually add the piece in if you’d tell me all the information I need.

The SQL you need to run is:

ALTER TABLE `sym_authors` ADD `language` VARCHAR(15) NULL DEFAULT NULL

Be sure to change the table name to match the prefix you are using.

This is a bit strange, because I did a clean install of version 2.0.7. When I delete the table “language” and enable the “Localisation Manager” everything works perfect. Then when I change the language into “Dutch” I’ll get the error include this PDF. I went to the other pages of Symphony and then suddenly the language is changed. Weird stuff!! But is isn’t good that Symphony is making an error when I change the language.

Attachments:

Symphony Error.pdf

Which version of the Localisation Manager are you using? With Symphony 2.0.7 language management is built into the system and there is no longer a need for the manager besides for language file export.

If you just want to be able to change the system language you should uninstall the Localisation Manager before updating to Symphony 2.0.7. With the release of Symphony 2.0.7 translations should be released as separate extensions.

Localisation Manager 1.1 and lower and Symphony 2.0.7 are incompatible! (see announcement in the extension thread)

If you need the manager for translation work, please update to the latest version (1.2).

@Alistair: That did it for me. Everything works now just fine. Not sure what caused the error in the first place but now I can create authors with no issue.