Sql command misspelled

Jeremy Monroe Posted in Technical Support 4 years ago

Trying to upgrade from 5.2 to 5.3. Getting this error because the column name is misspelled in the sql command. premission instead of permission.

OssnDatabaseException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'premission' in 'ossn_entities'
ALTER TABLE ossn_entities

Replies
German Michael Zülsdorff Replied 4 years ago

Jeremy,
could you please provide the contents of the row named upgrades which is part of the ossn_site_settings table from the database backup you did BEFORE upgrading?

Because what you reported would mean: Your upgrading triggered very old upgrades again, although they have been made already. In the early days of Ossn we actually had that misspelled column - so that old upgrade was made to correct the column name. But of course this correction needs to be done only ONE time. And any new attempt would lead to an error like you reported.

us Jeremy Monroe Replied 4 years ago

I've fixed the misspelling. Also, one of the upgrade files had version as 4.2 instead of 5.2 Had to correct that too and then it upgraded. Flush cache and version 5.3 is current version after that.