A serious issue with registration - Please help

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
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.
vthung
Posts: 3
Joined: Mon Dec 10, 2007 7:32 pm

A serious issue with registration - Please help

Postby vthung » Tue Dec 18, 2007 8:41 pm

Hi asmecher and all,
When the users of my OCS site click on Register button, the below error message is shown:
DB Error: Field 'key_hash' doesn't have a default value.

Can you give me some hints to troubleshoot this issue?

Any suggestions are much appreciated.

Cheers,
Vu

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: A serious issue with registration - Please help

Postby asmecher » Wed Dec 19, 2007 12:15 am

Hi Vu,

See http://pkp.sfu.ca/support/forum/viewtopic.php?f=3&t=2276. To remove the column, run the following in MySQL:

Code: Select all

ALTER TABLE queued_payments DROP COLUMN key_hash;
Regards,
Alec Smecher
Public Knowledge Project Team

manson_soup
Posts: 29
Joined: Mon May 19, 2008 8:06 pm

Re: A serious issue with registration - Please help

Postby manson_soup » Thu Oct 23, 2008 7:38 pm

Dear Alec Smecher,

I'm using OJS 2.2.2 and Postgresql 8, When I click the button "donation", it prompt this message.

"DB Error: ERROR: null value in column "key_hash" violates not-null constraint"

Do I need to drop the column key_hash?

Thanks
Manson

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: A serious issue with registration - Please help

Postby asmecher » Mon Oct 27, 2008 8:58 am

Hi Manson,

Yes, you can safely drop that column. I'll file a Bugzilla entry so that this is corrected in future releases.

Regards,
Alec Smecher
Public Knowledge Project Team


Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 23 guests