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

[miguelbraga]

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

[jmacgreg]

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

[miguelbraga]

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

[jmacgreg]

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

[miguelbraga]

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