OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



setting_value of table journal_setting is too short

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

setting_value of table journal_setting is too short

Postby jnavalon » Mon Sep 02, 2013 2:19 am

Hello,

we have found a problem in our instance of OJS (2.3.6) in our institution.

The field setting_value of the table journal_settings is of text type, text type allow text up to 64kbytes of size.

This value may not be enougth for certains settings, like about, so we have changed the type from text to mediumtext, that allows text up to 16Mbytes.

Did you have this problem?

In later versions (>2.3.6), this field have been changed?

Can cause this change of the type inconsistences or problems in the database of OJS?

Thank you from now.

Best regards.
Jose Angel Navalón.
University of Valencia (Spain).
jnavalon
 
Posts: 3
Joined: Mon May 04, 2009 7:27 am

Re: setting_value of table journal_setting is too short

Postby asmecher » Tue Sep 03, 2013 9:02 am

Hi Jose,

New releases of OJS still use the "text" type. We're using ADODB for database abstraction, and unfortunately it doesn't allow as much flexibility in data types as MySQL does (since it needs to abstract support for several DBMSs, not just MySQL). However, your modification should work without problems. Beware that if/when you run an upgrade, the database descriptor will by synced against the database, which may mean that the data type is reverted and the data is chopped down to fit.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 3 guests