OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Author Submission Step3 DB error

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.

Author Submission Step3 DB error

Postby eruthes » Tue Sep 26, 2006 6:26 am

Some Authors are having problems when uploading files in Step 3 of the Submission. they tell the following error:

Code: Select all
DB Error: ERRO: valor muito longo para tipo character varying(90)


This must be occurring therefore the fields file_name and original_file_name are being limited for 90 characters in the table article_files. This exactly error that occurred with the subject of emails already was corrected.

But the problem cannot be decided with simple truncate therefore would lose the extension of the file... I think...

This can be happening with the supplementary files, I did not test…

We are with the OJS 2.0.1 and Postgresql 7.4. We will make the update soon but I already verified that the error also occurs in version 2.1.


Eduardo Ruthes
eruthes
 
Posts: 26
Joined: Mon Nov 21, 2005 9:33 am
Location: Curitiba, Paraná - Brasil

Postby asmecher » Tue Sep 26, 2006 6:43 am

Hi Eduardo,

A few field lengths were corrected in OJS 2.1.1 where there was a mismatch between the HTML field maximum length and the database field length; however, you'll still see this error in situations where the database doesn't support UTF8 natively and the content the author enters contains a long title containing special characters. Ensure that your DBMS supports UTF8 natively and try enabling connection_charset and database_charset in config.inc.php; this should correct the problem.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby eruthes » Wed Sep 27, 2006 8:04 am

I have made a test whith a file named:
abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz.txt

It have 108 chars (whith .txt).

I don't thik this is a special chars problem.
eruthes
 
Posts: 26
Joined: Mon Nov 21, 2005 9:33 am
Location: Curitiba, Paraná - Brasil

Postby asmecher » Wed Sep 27, 2006 8:34 am

Hi Eduardo,

Absolutely right -- I re-read your posting more carefully and I understand the problem now. I've entered a bug entry for this (http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2411); this should be corrected in our next release, and when I fix the bug, I'll post a patch against OJS 2.1.1.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests