Hi Jenea,
The OJS schema is described in the dbscripts/xml/ojs_schema.xml file. In it, you will find the users table described as follows:
- Code: Select all
<!--
*
* TABLE users
*
-->
<table name="users">
<field name="user_id" type="I8">
<KEY/>
<AUTOINCREMENT/>
</field>
<field name="username" type="C2" size="32">
<NOTNULL/>
</field>
(...more fields below...)
Find the field called "interests":
- Code: Select all
<field name="interests" type="C2" size="255"/>
Change this line to:
- Code: Select all
<field name="interests" type="X"/>
Changing the descriptor doesn't do anything in and of itself, but when you follow the process below, it'll make sure that OJS doesn't truncate the data in the interests field back down to 255 characters.
When you need to upgrade OJS, I'd suggest following these steps:
- Download and extract a stock installation of the version you're upgrading from
- Use the "diff" tool to compare this stock installation against your modified version and generate a patch:
- Code: Select all
diff -u -r /path/to/stock/version /path/to/modified/version
(You'll probably need to make liberal use of the -X option to the diff tool in order to avoid comparing the public directory, cache directory, etc.) - Review and keep that generated patch so that you have a reference of the changes you made before.
Now that you know what you changed over the period that the old version was installed, you can go ahead with the upgrade process. You have two options:
- Use the patch-based method, which will maintain your modifications unless they conflict with changes made in the update
- Replace the files in your installation with the files from the new version, and then manually re-add the changes described in the patch file you saved earlier.
See the docs/UPGRADE document for further details.
The key, of course, is to back absolutely everything up before tinkering with something like an upgrade.
Regards,
Alec Smecher
Open Journal Systems Team