This afternoon, I upgraded my Drupal installation to 4.6 and also upgraded event.module to the new version based on flexinode. Everything went fine during the event.module upgrade process. I did not see any SQL errors, and I can confirm that all the data that was previously stored in the old event.module scheme was transferred successfully to the flexinode tables.
The problem is that when viewing one of the upgraded event nodes, none of the extra fields are visible. I'm stumped. I've tried disabling contrib modules that could be interfering with the new event.module to no avail.
http://choirgeek.com/node/120 is an example of an event node (flexinode-1) that should be showing extra fields.
Can anyone help? Thanks in advance.
Bjorn A
http://choirgeek.com
Comments
similar event.module 4.6.0 issue
i installed the 4.6.0(RC) a few days ago, and have not been able to get an event.module working at all.... when i go to 'create event', the page simply comes up blank. i am going to try the newest cvs of the module, but i suspect something else is wrong. if you learn of any solutions, please post!
regards,
-=pj=-
current install ---> http://toronto.nooneisillegal.org
I haven't tried the new one
I haven't tried the new one yet, but you may want to read this.
http://civicspace.advomatic.com/node/48
-sp
---------
Test site...always start with a test site.
Drupal Best Practices Guide
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
Same problem here
I am experiencing the EXACT same problem. Hopefully it will be fixed soon.
My entire event module is broken now.. :(. So much for upgrading.. Will probably revert back to 4.5 tomorrow.
Made some progress
It looks like I've made some progress. First I noticed that I didn't activate Flexinode permissions for any user, which was part of the issue :).
I then went into the settings for the event flexinode, added a text area, and now it seems to allow me to input what I need for events.
My calendar itself is still broken, and existing events don't have the date/time fields even after running the upgrade script.
Here's is the issue I'm having with the calendar. Any thoughts?
http://2cd.lonseidman.com/?q=event
1. Change the type of all
1. Change the type of all event nodes to flexinode-1 (or whatever number it is - the flexinode-n name, not the name you gave it). You can do it with:
update node set type='flexinode-1' where type='event'2. Go to admin/node/configure/types and edit the event type. Change 'show in event calendar' to either 'all views' or 'only views for this type'.
I have it working now at http://www.worldbeatplanet.com/event
--
Mike Cohen, http://www.mcdevzone.com/
--
Mike Cohen, http://www.mcdevzone.com/
how to enable events
Once everything is installed correctly, you need to do one non-intuitive thing to get the extra fields to show up. Go to admin/node/configure/types and pick the content type you want to show on the calendar. (In the new module, any content can be on the calendar -- in your case, it's flexinode.)
You'll see a set of three radio buttons labeled "Show in event calendar" -- switch it from Never to All views or Only in views for this type and save the changes. When you go back to the item create screen, the start and end dates will now appear and the item will show up on the calendar.
There's also an event_upgrade.php you have to run for existing events, though it sounds like you've already done this.
oops
Yeah, now I see it. Whenever I look at an event, no content shows up and I get a big SQL error in watchdog:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node n LEFT JOIN flexinode_data flexinode_5 ON n.nid = fle query: SELECT flexinode_5.textual_data AS flexinode_5, flexinode_2.textual_data AS flexinode_2, flexinode_3.textual_data AS flexinode_3, flexinode_4.textual_data AS flexinode_4, flexinode_4.numeric_data AS flexinode_4_format, FROM node n LEFT JOIN flexinode_data flexinode_5 ON n.nid = flexinode_5.nid AND flexinode_5.field_id = 5 LEFT JOIN flexinode_data flexinode_2 ON n.nid = flexinode_2.nid AND flexinode_2.field_id = 2 LEFT JOIN flexinode_data flexinode_3 ON n.nid = flexinode_3.nid AND flexinode_3.field_id = 3 LEFT JOIN flexinode_data flexinode_4 ON n.nid = flexinode_4.nid AND flexinode_4.field_id = 4 LEFT JOIN flexinode_data flexinode_1 ON n.nid = flexinode_1.nid AND flexinode_1.field_id = 1 WHERE n.nid = 139 in /home/gdelisle/public_html/includes/database.mysql.inc on line 66.
Something's definitely messed up here, and it looks like a colossal bug in flexinode. I've posted an issue here: http://drupal.org/node/20773
partial fix
I was able to partially fix the problem that was affecting individual node views by:
1. downloading a fresh set of 4.6 flexinode files again from the flexinode project page
2. running this SQL command on my database
update node set type='flexinode-1' where type='event'....where flexinode-1 is the type that was created to replace the event type through the event.module upgrade process. Take care with database prefixes if necessary.UPDATE: #2 above was previously filed in the issue tracker at http://drupal.org/node/20234.
Now two problems still remain:
1. Flexinode fields are rendering, but node body text is not.
2. Since my old event nodes had no ending date/time, the upgraded date and time are all equal to 2/31/1969 - 6:00pm. I may have to run some SQL trickery to set the end time for all existing event nodes to be equal to the start time plus one hour (or something like that).
--
Bjorn | choirgeek.com
Fixing converted events
Flexinode doesn't seem to show body text anywhere. As a work-around I added an info field as a text area and copied the body of all event nodes to that field:
insert into flexinode_data (nid,field_id,textual_data) select nid,2,body from node where type="flexinode-1";to deal with the end time, I set the end time to the start time + 1 hour:
update event set end=start+3600 where end=0;Of course I also had to change the node type from event to flexinode-1 as described above.
--
Mike Cohen, http://www.mcdevzone.com/
--
Mike Cohen, http://www.mcdevzone.com/
Working
I seem to have gotten it working on my system. What I had to do was create a new flexinode type and add new fields from scratch -- it looks like the event upgrader created a flexinode that mimics the old event module fields, but somehow they don't work.
I'm going to update my issue on this topic but leave it there because it's a real problem and someone with brains ought to be looking at it.