PKP Bugzilla – Bug 4494
Creating a new registration type results in error
Last modified: 2009-11-18 06:49:57 PST
If I try to create a new registration type, I get the following error and the registration type isn't created:
DB Error: Unknown column 'cost' in 'field list'
Courtesy of http://pkp.sfu.ca/support/forum/viewtopic.php?f=3&t=4665&p=18153#p18153. I tried this on a fresh install of 2.1.2. Tried changing the registration options in Website Management 2.5, but that didn't have an effect.
I started to take a look at this and noticed that there were some major and minor updates to the registration code for 2.1.2 -- Juan or Matt since these enhancements/bug fixes were mainly yours would you mind taking a look at this? (will be faster than me trying to track this down).
It looks like this is related to bug 4416 -- Should that column ever have been taken out of the schema? I don't think I ever worked with this code (at least not in the stable branch), so I'm not sure what exactly is going on.
Created attachment 2062 [details]
Patch against OCS 2.1.2-0
This can also be corrected by executing the following in MySQL:
ALTER TABLE registration_types ADD COLUMN cost FLOAT;
This was caused by the "cost" column being removed from registration_types instead of registration_options. It's been restored to registration_types and removed from registration_options as it should've been for bug #4416.
*** Bug 4762 has been marked as a duplicate of this bug. ***
Created attachment 2603 [details]
Patch against OCS 2.1.2