Closed (fixed)
Project:
Signup Status
Version:
5.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
28 Feb 2008 at 17:24 UTC
Updated:
4 Mar 2008 at 16:34 UTC
Just installed the latest 3 updates of signup_status, revision 1.1.2.38, .39 and .40 from http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/signup_stat...
Once the .38 version was installed, when viewing the node or signups getting query warning:
* user warning: Unknown column 'show_on_form' in 'where clause' query: SELECT * FROM signup_status_codes WHERE show_on_form = 1 in C:\Inetpub\webs\events\includes\database.mysql.inc on line 172.
* warning: Invalid argument supplied for foreach() in C:\Inetpub\webs\events\sites\all\modules\signup_status\signup_status.module on line 867.
Installed the following two (.39 and .40 versions) hoping it'll fix the error, it didn't, just line number for error changed.
Checked update.php file, there are no updated for status_module.
Previously created nodes, however, only display above warnings when I'm viewing Signups list.
Am I missing an option somewhere that I have to enable?
This is a great module! Thank you so much for all your work!
Comments
Comment #1
jrbeemanDid you also update the signup_status.install file? If not, just grab the entire dev release tarball and try running update.php. It should update your database schema for you.
Comment #2
tmichnik commentedHi,
Just grabbed the entire dev release and ran udate.php. I'm getting the following error:
user warning: Duplicate entry '0-1' for key 1 query: ALTER TABLE signup_status_node_limits DROP KEY nid, DROP KEY cid, ADD PRIMARY KEY (nid, cid) in C:\Inetpub\webs\events\includes\database.mysql.inc on line 172.
----------------------------------------------------------
The following queries were executed
signup_status module
Update #3
* Failed: ALTER TABLE {signup_status_node_limits} DROP KEY nid, DROP KEY cid, ADD PRIMARY KEY (nid, cid)
Update #4
* ALTER TABLE {signup_status_codes} ADD show_on_form int NOT NULL default '0'
signup_status_log module
Update #2
* ALTER TABLE {signup_status_log} ADD lid int NOT NULL auto_increment FIRST, ADD PRIMARY KEY (lid)
Comment #3
jrbeemanThis the result of an unfortunate design decision I made early on in development and then fixed afterwards. Essentially, the problem is that you've got a duplicate key in the signup_status_node_limits table. You should be able to fix this by going into the database a delete the rows that have a nid of 0, or where there are duplicates of the nid,cid combination. New users should not ever experience this issue.
Comment #4
jrbeemanComment #5
tmichnik commentedokay, so I tried clean up the duplicate combinations, wasn't really working for me. I kept getting this kind of error for all the nodes that I already have created and for new ones as well:
user warning: Unknown column 'signup_status_cert_nid' in 'field list' query: SELECT signup_status_cert_nid FROM signup WHERE nid = 75 in C:\Inetpub\webs\events\includes\database.mysql.inc on line 172.
so I manually added signup_status_cert_nid field to signup table and that seem to get rid off all the errors and everything seems to work fine.
thank you so much for your help
Comment #6
jrbeemanThat's a weird one... when you installed the Signup Status Certificate module, it should have added that column for you.
Comment #7
tmichnik commentedyeah, i have been getting your development updates from the cvs link above, without getting signup_status.install file every time. so that could have messed me up somewhere along the way. but i only ran into problems just now though.
so basically every time you make a change, i should go and get the entire dev release tarball as opposed to just the signup_status.module?
Comment #8
tmichnik commented