Clicking "Book Now" opens Create Content Page (listing all node types)
| Project: | Booking Time Slots |
| Version: | 6.x-1.x-dev |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs work |
I love this module, great job!
Something seems to be an issue. In the existing issues others have asked the same question but I can't locate an accurate answer.
Is there a way to load the node type that has been created and selected in the settings page from the book now link.
In one of your responses to the question it seemed the underscore in the name may have created a conflict - I changed that = no change.
In another response you mentioned the booking default slot time i.e. 1hr 30min, you suggested adjusting the "To Date" time where you loaded an image to show http://drupal.org/files/issues/Booking_timeslots%20-%20To%20Date.jpg - I changed this also = no change
I am also, just trying to make this module function more streamlined and easy for the user to operate. Loading the Create Content page listing all the available nodetypes to the user is ok but it would be powerful and very cool to just load the nodetype for the booking of the timeslot.
I appologise for repeating the question, I just couldn't find a fix.
I am very thankful for your support here, the response times are very impressive. I am only marking as critical because I am attempting to launch a newsletter to announce the use of the booking form, can't wait to check the response.
You may want to combine this issue with the others that have asked a similar question.
thanks again.

#1
Load the node where and for what reason?
1. You may look for permission: 'show booking dates'
Users with that permission see nodes on the booked slots, so you can click it and after clicking 'More...' node will be loaded.
2. If you want to make lists of already booked slots of specified type, you can create a View table and it could be available for your users. Then they can list their bookings, edit their own, delete or whatever.
If it's not that you meant, please describe it more clearly.
If you have proper set configuration, it will load Creation of specified type, not Create Content page listing.
Make sure that you have the right configuration on Booking Timeslots Settings Page and you selected the right content type for the right View calendar.
#2
I have gone over the settings page a dozen times and changed the view. Everything works perfectly except -
Any user with permission to see and make a booking, when they click the book now on the month view it takes them to the day view; when they click the book now link it loads the "Create Content Page" displaying a long list of node types.
I have settings page listing the booking node type to the field_datetime
I have the view loading the fields of this datetime as long as it is published node.
the booking timeslot works perfectly everywhere else I can make a booking and it display correctly on calendar, just not loading the booking node for ease.
#3
Can you send me what's the URI link from the Day view to this "Create Content Page"?
#4
http://wellbeing.tv/calendar/2009-07-26
Usually only available to authenticated users but I have only made the booking content type accessible and editable for anonymous users for your test.
Could you send me an export of a standard view for calendar so I can see your configuration perhaps?
I've noticed something odd with the way the calendar looks on the left side it displays the last row of dates in a vertical column see http://wellbeing.tv/calendar
#5
You have link: node/add/0/2009-07-26%2010%3A00%3A00
0 means that your content type has been not detected.
- Can you check if you made update.php after module upgrade? See: http://drupal.org/node/478446#comment-1652678
- Can you re-save your settings again on Form Settings?
- Can you dump for me following settings from your db:
SELECT * FROM variable WHERE name LIKE "booking_timeslot_%"#6
This is the data dump before I totally deleted it and removed the module
#
# Table structure for table `mainHubcontent_type_timebooking`
#
CREATE TABLE `mainHubcontent_type_timebooking` (
`vid` int(10) unsigned NOT NULL default '0',
`nid` int(10) unsigned NOT NULL default '0',
`field_datetime_value` datetime default NULL,
`field_name_booking_value` longtext,
`field_phone_booking_value` varchar(11) default NULL,
`field_datetime_value2` datetime default NULL,
PRIMARY KEY (`vid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Then I re-installed the module and edited the datefield to hold only one type of content field and changed the name. I have uploaded images as screenshots to show each setting for view, timebooking and content type fields viewable at http://www.wellbeing.tv/timebookingpage.html
#7
New dump with renewed settings # phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 31, 2009 at 06:39 PM
# Server version: 5.0.45
# PHP Version: 5.1.6
#
# Database : `wellbeing`
#
# --------------------------------------------------------
#
# Table structure for table `mainHubcontent_type_appointmenttimebooking`
#
CREATE TABLE `mainHubcontent_type_appointmenttimebooking` (
`vid` int(10) unsigned NOT NULL default '0',
`nid` int(10) unsigned NOT NULL default '0',
`field_apptdate_value` datetime default NULL,
PRIMARY KEY (`vid`),
KEY `nid` (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table `mainHubcontent_type_appointmenttimebooking`
#
still directing to create content page
Thanks for your help here.
#8
Can you dump for me following variables from db?
SELECT * FROM variable WHERE name LIKE "booking_timeslot_%"#9
When I open a query window in PHPMyAdmin
and enter your query SELECT * FROM variable WHERE name LIKE "booking_timeslot_%"
I get the following -
Error
SQL-query :
SELECT *
FROM variable
WHERE name
LIKE "booking_timeslot_%"
LIMIT 0 , 30
MySQL said:
#1146 - Table 'wellbeing.variable' doesn't exist
I feel a bit silly here but is there another way for me to extract that information you are after or is there a table missing in my DB?
#10
you have some db prefix that's why so probably it will be mainHubvariable instead of variable
#11
# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 03, 2009 at 10:11 AM
# Server version: 5.0.45
# PHP Version: 5.1.6
#
# Database : `?`
#
# --------------------------------------------------------
#
# Table structure for table `mainHubvariable`
#
CREATE TABLE `mainHubvariable` (
`name` varchar(128) NOT NULL default '',
`value` longtext NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table `mainHubvariable`
#
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_avaliable_slots', 's:1:"1";');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_excluded_dates', 'a:2:{s:14:"field_apptdate";i:0;s:13:"field_timeoff";i:0;}');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_fields', 'a:2:{s:14:"field_apptdate";s:14:"field_apptdate";s:13:"field_timeoff";i:0;}');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_hour_from', 's:1:"9";');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_hour_to', 's:2:"19";');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_length_hours', 's:1:"1";');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_length_minutes', 's:2:"30";');
INSERT INTO `mainHubvariable` VALUES ('booking_timeslot_view_calendar', 's:22:"appointmenttimebooking";');
#12
I still can't see your 'booking_timeslot_forms' variable. It likes it isn't set and that's the problem.
Are you sure sure that you selected field from the settings?
Go to: admin/settings/booking_timeslots/form_settings
And in 'Field Names' section please select at least one field which is responsible for dates (datetime or date field).
#13
I've done everything you have explained, I then deleted the content types and started from scratch. Created a new content type called "sessiontimes" then created a date timefield. Then I opened up settings for bookings_timeslots and set the form and the settings as you have explained.
My only guess is that it is something to do with my view argument. Is there a way I can see yours/an example of the view that works.
I've tried everything but a clean drupal install, which isn't far away I feel.
Anything else you think it can be?
#14
http://xcomkids.xcomplete.com/
Can you send me e-mail through contact?
I'll give you some test accounts to test it.
And if you can send me yours, maybe I'll check what's going on.
#15
Hooray !!!
I fixed it.
I ended up creating an entirely new drupal site and combing through the settings. As it turns out, I think a bookings api module loaded from a previous setup was conflicting.
But I have loaded version 1.1 over dev and everything works as it is supposed to, I am very happy.
Thanks for your dedicated support in seeing me through this.
I will do my best to contribute to some documentation for setup.
again thanks.
Scott
#16
That's great.
If you can, you can create some documentation for proper setup. I'll appropriate that. Mostly I'm focused on functionality and documentation is not my good side (considering that English is not my mother tongue).
I'll add some additional warning, if mandatory settings are empty in database.
To summary
If you see 'listing all node types' after clicked on 'Book Now' and link looks like: node/add/0/... (with 0) that means your content type has been not recognized properly. Basically Calendar View and 'Book Now' need to be somehow connected to specified Content Type. If you don't have it in settings, module can just guess which content type you meant.
It's possible to make some more intelligent detection, if only one content type with datetime was found - that's the one, but user could have some old content type and he didn't create new one for booking purpose, so it's not good idea as well.
So basically it's problem of not configured settings (admin/settings/booking_timeslots/form_settings) or some Drupal conflict if settings are set, but are not in database.
If you need to check what kind of variables you have set, you can execute following query:
SELECT * FROM variable WHERE name LIKE "booking_timeslot_%"#17
Automatically closed -- issue fixed for 2 weeks with no activity.
#18
Im having the same issue with the newest DEV. (Sept 24th). Goes to the create content page instead of directly to my specific content type.
Anyone else?
----------------
Update: On the settings page for this module dev version, I dont see where I choose the appropriate content type for when I hit the "book now" link. So, now i am not surprised it isnt choosing a content type.
I do see where I can tell it which date field to use. But not which content type.
#19
I also had the same problem with the Dev version. I think variable "booking_timeslot_forms" isn't set in the database. It may be set in some setups, but only if the module is updated from an earlier version - then the variable is converted from an old name of the variable.
#20
You did already the update.php when upgraded from the older version?
Can you send me prv dump of your site environment that I can check it why is that?
#21
No, I started with installing the Dev version.
I may be in deep water here, cause I just started out looking at your nice
module. However, I had the same symptom as #18.
A brief look at the code, indicated that calendar-day.tpl.php does a...
variable_get('booking_timeslot_forms', array());
...which is set in the release version in booking_timeslots.admin.inc by...
$form['form_settings']['booking_timeslot_forms']
...but that is missing from the Dev version. This is also reported by
#18 from an UI perspective.
#22