OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



URGENT - DB Error: Column 'file_id' cannot be null

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
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

URGENT - DB Error: Column 'file_id' cannot be null

Postby miguelbraga » Sun Oct 28, 2012 9:32 am

Dear OJS Support,

I've came across the following error after trying to uoload a file under LAYOUT > GALLEY:
"DB Error: Column 'file_id' cannot be null"
I'm using the latest stable version, OJS 2.3.8.0, but it happened under 2.3.7.0.
Is this error being generated by ArticleGalleyForm.inc.php??
Please help me out, this is a very important, worldwide, OJS website and we need to have this fixed ASAP.


Best regards,
Miguel
miguelbraga
 
Posts: 10
Joined: Sun Oct 28, 2012 9:24 am

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby jmacgreg » Sun Oct 28, 2012 10:39 pm

Hi Miguel,

I haven't heard of that problem before. Have you upgraded recently? Are you working from a stock version of OJS? I'm not quite sure I understand whether this is happening in two different versions of OJS, or the same version that was upgraded.

Cheers,
James
jmacgreg
 
Posts: 4191
Joined: Tue Feb 14, 2006 10:50 am

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby miguelbraga » Mon Oct 29, 2012 2:18 am

Hi James,

I have upgraded recently, 2 weeks ago to be precise, from OJS version 2.2.1 to 2.3.7.
I can give you the admin account and FTP access if you need to see it for yourself.

mod_security is also reporting the following:
[Sun Oct 28 12:22:35 2012] [error] [client 188.80.160.43] ModSecurity: Access denied with code 406 (phase 2). Match of "rx (^application/x-www-form-
urlencoded|^multipart/form-data;|^text/xml).*$" against "REQUEST_HEADERS:Content-Type" required. [file "/usr/local/apache/conf/modsec2.user.conf"] [line "13"] [id "90001"] [hostname "www.iseki-food-ejournal.com"] [uri "/ojs/index.php/e-journal/editor/moveIssue"] [unique_id "UI0ji0@Psw4ABwlIrVsAAAAA"]
[Sun Oct 28 12:22:41 2012] [error] [client 188.80.160.43] ModSecurity: Access denied with code 406 (phase 2). Match of "rx (^application/x-www-form-urlencoded|^multipart/form-data;|^text/xml).*$" against "REQUEST_HEADERS:Content-Type" required. [file "/usr/local/apache/conf/modsec2.user.conf"] [line "13"] [id "90001"] [hostname "www.iseki-food-ejournal.com"] [uri "/ojs/index.php/e-journal/editor/moveIssue"] [unique_id "UI0jkU@Psw4ABwllsTYAAAAI"]
[Sun Oct 28 12:24:11 2012] [error] [client 188.80.160.43] ModSecurity: Access denied with code 406 (phase 2). Match of "rx (^application/x-www-form-urlencoded|^multipart/form-data;|^text/xml).*$" against "REQUEST_HEADERS:Content-Type" required. [file "/usr/local/apache/conf/modsec2.user.conf"] [line "13"] [id "90001"] [hostname "www.iseki-food-ejournal.com"] [uri "/ojs/index.php/e-journal/editor/moveIssue"] [unique_id "UI0j60@Psw4ABwp5yjYAAAAd"]
[Sun Oct 28 12:24:47 2012] [error] [client 188.80.160.43] ModSecurity: Access denied with code 406 (phase 2). Match of "rx (^application/x-www-form-urlencoded|^multipart/form-data;|^text/xml).*$" against "REQUEST_HEADERS:Content-Type" required. [file "/usr/local/apache/conf/modsec2.user.conf"] [line "13"] [id "90001"] [hostname "www.iseki-food-ejournal.com"] [uri "/ojs/index.php/e-journal/editor/moveArticleToc"] [unique_id "UI0kD0@Psw4ABxBF7l8AAAAc"]
[Sun Oct 28 12:25:29 2012] [error] [client 188.80.160.43] ModSecurity: Access denied with code 406 (phase 2). Match of "rx (^application/x-www-form-urlencoded|^multipart/form-data;|^text/xml).*$" against "REQUEST_HEADERS:Content-Type" required. [file "/usr/local/apache/conf/modsec2.user.conf"] [line "13"] [id "90001"] [hostname "www.iseki-food-ejournal.com"] [uri "/ojs/index.php/e-journal/editor/moveArticleToc"] [unique_id "UI0kOU@Psw4ABxGL9MMAAAAF"]

Regards,
Miguel
miguelbraga
 
Posts: 10
Joined: Sun Oct 28, 2012 9:24 am

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby jmacgreg » Wed Nov 07, 2012 5:47 pm

Hi Miguel,

Apologies for not following up earlier. What kind of file are you trying to upload, and are you running into problems with all/any file upload types? Any chance that you are using the XML Galleys plugin?

Cheers,
James
jmacgreg
 
Posts: 4191
Joined: Tue Feb 14, 2006 10:50 am

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby miguelbraga » Thu Nov 08, 2012 4:16 am

Hi James,

I was trying to upload a small pdf file. This only happens under LAYOUT > GALLEY.
I'n not using the XML Galleys Plugin, it's disabled. Should i enable it?
There's been also some security issues, mod_security is also reporting the code I've pasted in my last post.


Thanks for your help,
Miguel
miguelbraga
 
Posts: 10
Joined: Sun Oct 28, 2012 9:24 am

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby mreedks » Mon Dec 22, 2014 1:58 pm

Did anyone ever find the solution for this? I'm getting the same error.
mreedks
 
Posts: 3
Joined: Mon Dec 22, 2014 1:54 pm

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby asmecher » Mon Dec 22, 2014 2:01 pm

Hi mreedks,

What version of OJS are you using?

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

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby mreedks » Mon Dec 22, 2014 2:08 pm

2.3.8.0
mreedks
 
Posts: 3
Joined: Mon Dec 22, 2014 1:54 pm

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby mreedks » Mon Dec 22, 2014 2:11 pm

I am trying to upload a file to a previously published article that did not have a file attached. The system either times out and just returns me to the Editing screen without uploading the file, or it gives me this error.

I am able to open the file outside of OJS and page through the entire document, so the file appears to be OK.
mreedks
 
Posts: 3
Joined: Mon Dec 22, 2014 1:54 pm

Re: URGENT - DB Error: Column 'file_id' cannot be null

Postby asmecher » Mon Dec 22, 2014 3:18 pm

Hi mreedks,

That's a very old version of OJS -- I'd suggest putting some time into upgrading, as that'll likely solve the problem. We've had no reports of similar problems in anything since 2.3.x.

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: No registered users and 4 guests