OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Plain Text Program: Size restricted?

Are you a Director, Presenter, Reviewer or Conference Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael

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.

Plain Text Program: Size restricted?

Postby Achim » Sat Oct 12, 2013 9:56 am

Hello,

I copied text into the field for the "Plain Text Program". But only the upper part is shown.
The size of the text as HTML is 146 KB. Only approx. 64 KB are shown.

Is there a size limit which can be adjusted? I didn't find anything?
Or did I miss something else?

Cheers,
Achim
Achim
 
Posts: 8
Joined: Thu Oct 25, 2012 3:55 pm

Re: Plain Text Program: Size restricted?

Postby asmecher » Tue Oct 22, 2013 9:14 am

Hi Achim,

What release of OCS are you using?

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

Re: Plain Text Program: Size restricted?

Postby Achim » Thu Oct 31, 2013 1:52 am

Hi Alec,

The OCS release is 2.3.4.0.

Sorry about the slow response. I was busy on a workshop.

Cheers,
Achim
Achim
 
Posts: 8
Joined: Thu Oct 25, 2012 3:55 pm

Re: Plain Text Program: Size restricted?

Postby asmecher » Thu Oct 31, 2013 3:50 pm

Hi Achim,

The limitation is in MySQL's "TEXT" data type, which is used for the relevant column ('setting_value' in the 'sched_conf_settings' table). That type stores up to 64KB.

If you change the data type to LONGTEXT, you'll get up to 4GB, which "ought to be enough for anyone" -- use the following query for that:
Code: Select all
ALTER TABLE sched_conf_settings CHANGE COLUMN setting_value setting_value LONGTEXT;
I haven't tested this, so please back up your database before you start and give your site a quick explore to make sure there aren't unexpected ramifications.

FYI, next time you run an upgrade, the database schema sync will see the LONGTEXT column and attempt to turn it back into a TEXT column, in keeping with the database descriptor (dbscripts/xml/ocs_schema.xml); in order to prevent that from happening, change the type of the column in that descriptor from "X" to "XL".

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

Re: Plain Text Program: Size restricted?

Postby Achim » Mon Nov 04, 2013 7:41 am

Hi Alec,

Thank you for the detailed answer. This is helpful.

Cheers,
Achim
Achim
 
Posts: 8
Joined: Thu Oct 25, 2012 3:55 pm


Return to OCS Conference Support and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest