upgrade problem

[agentsmith]

I am trying to upgrade from 2.0.1 (at least that is what it says in the docs/release-notes) to 2.1 but when i try the manual upgrade i get DB Error: Table 'ojs.article_search_object_keywords' doesn't exist. Is it possible that the version I am currently using isn't really 2.0.1 is there anyway i can know for sure? Has anybody else had this problem?

Thanks
J

[asmecher]

Hi J,

Upgrading is a two-step process; the first step is upgrading the code, and the second step is upgrading the database. It sounds to me like you haven't completed the second step. Try using the tools/upgrade.php script as follows (after backing everything up, of course):

Code: Select all

php tools/upgrade.php upgrade

Regards,
Alec Smecher
Open Journal Systems Team

[agentsmith]

thanks,

i tried to do an upgrade with what you suggested and got this:

$ php tools/upgrade.php upgrade

[load: upgrade.xml]
[version: 2.1.1.0]
[data: upgrade/2.0.2_preupdate.xml]

ERROR: Upgrade failed: DB: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I get the same error when upgrading use the automatic button of the web interface.
I have tried it with both mysql 5.0 and 4.1.1

[asmecher]

Hi J,

This is probably caused by a failed attempt to upgrade. You can get around it by commenting out the following lines in dbscripts/xml/upgrade/2.0.2_preupdate.xml:

Code: Select all

        <sql>
                <rename table="subscription_types" column="public" to="pub" />
        </sql>

However, if the previous upgrade attempt only partially completed, you may have other similar problems. The best way to ensure a clean upgrade is to start from your pre-upgrade backup and try again, reporting error messages here.

Regards,
Alec Smecher
Open Journal Systems Team