OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



DB Error when director makes his decision

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

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

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. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

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 OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

DB Error when director makes his decision

Postby ozcelik » Mon Sep 24, 2007 8:01 pm

Hi,

I have discovered another error. When a Track Director makes his/her decision on a submitted conference paper by clicking on one of the options in the drop-down menu (Accept Submission, Revisions Required, Decline Submission), I get the following error:

DB Error: Field 'type' doesn't have a default value

How can I fix this error? There is no info about the location of the field...

Regards,

Jason
ozcelik
 
Posts: 26
Joined: Sun Sep 23, 2007 9:25 pm

Re: DB Error when director makes his decision

Postby asmecher » Mon Sep 24, 2007 8:31 pm

Hi Jason,

This field isn't used -- remove it by running the following in MySQL:
Code: Select all
ALTER TABLE edit_decisions DROP COLUMN type;
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8315
Joined: Wed Aug 10, 2005 12:56 pm

Re: DB Error when director makes his decision

Postby ozcelik » Tue Sep 25, 2007 8:29 am

Hi Alec,

Thank you very much for your prompt reply. Your suggestion has solved the problem regarding the drop-down menu. Now, there is another related problem with email attachments. If Track Director tries to attach a file to his/her email to notify author about the decision, I get exactly the same error:

DB Error: Field 'type' doesn't have a default value

If it helps, the error appears on the page .../trackDirector/emailDirectorDecisionComment/send in the browser. I think, there is another 'type' field somewhere. Could you please tell me where it is.

Regards,

Jason
ozcelik
 
Posts: 26
Joined: Sun Sep 23, 2007 9:25 pm

Re: DB Error when director makes his decision

Postby asmecher » Tue Sep 25, 2007 8:52 am

Hi Jason,

This one appears in the temporary_files directory; use:
Code: Select all
ALTER TABLE temporary_files DROP COLUMN type;
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8315
Joined: Wed Aug 10, 2005 12:56 pm


Return to OCS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests