Scheduled Events Add-On

[BillyBoyle]

Can't remember if I ever thanked you for making this Mod/Add-on. Works great with an easy enough set-up.
After playing around with it I have the layout just the way I want, for now anyway...

Thanks again Billy

[pageblair]

Thanks for the add on, I installed to blue cart zen 1.5, It is working well. Question. How can I change some of the DB fields like words start time for instance.

[bubbadan]

Great Mod - not much happening since July I see.

I installed the mod on 1.5 downloaded from the plugin area which states it is for 1.5 - it works fine on pretty much every aspect, however the Google Maps do not work regardless of the URL I use from Google Maps.

It shows as text (As the entire URL) and NOT a clickable link.


the tpl_events_default.php shows that it SHOULD show as a link as the code appears correct (at least to me):

if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';

Any suggestions?

[bubbadan]

IGNORE PREVIOUS LACK OF SLEEP POST!
I was looking at eventz/index.php where you enter and not the actual LISTING link... I have been at this too long

[dbltoe]

IGNORE PREVIOUS LACK OF SLEEP POST!
I was looking at eventz/index.php where you enter and not the actual LISTING link... I have been at this too long

Glad you got it going.

Just a suggestion to help with your entries.

When you click on the link button in Google Maps, also check the box for Short URL. That way the church's URL would be http://goo.gl/maps/hmZNQ. You'll note the absence of special characters. That can make a big difference depending on the encoding of the database. There are no special characters in the Google short URL.

[dbltoe]

Thanks for the add on, I installed to blue cart zen 1.5, It is working well. Question. How can I change some of the DB fields like words start time for instance.

All those are in the includes/templates/CUSTOM/templates/tpl_events_default.php. After each echo in the if statements you'll find the item title in quotes. i.e.,

echo "<strong>Start Date: </strong>"

could become

echo "<strong>Start Time: </strong>"

HOWEVER, you will also need to change the zen_date_long as you would no longer be showing a date.

[dbltoe]

Sorry, I've missed some of the comments in this thread but I have not been receiving notices for some reason. Working on it now.

schoolboy -- thanx for the heads up. I am going with changing the sql setup as I want folks to know it can take more than one comment.

[pukram]

hi there,
i am installing this mod on a xampp local server for testing purposes and i get the exact same error message:
MySQL error 1054

Unknown column 'PMEtable0.event_comment' in 'field list'

---

phpMyEdit error: invalid SQL query

---

SELECT `PMEtable0`.`event_id` AS `qf0`,`PMEtable0`.`event_name` AS `qf1`,`PMEtable0`.`event_location` AS `qf2`,`PMEtable0`.`event_start` AS `qf3`,`PMEtable0`.`event_stop` AS `qf4`,`PMEtable0`.`event_comment` AS `qf5`,`PMEtable0`.`event_booth_location` AS `qf6`,`PMEtable0`.`special_text` AS `qf7`,`PMEtable0`.`map` AS `qf8` FROM `zen_events` AS `PMEtable0` ORDER BY `PMEtable0`.`event_id` LIMIT 0, 1530.182 miliseconds

I am running ZC 1.5.1, installed the very latest update mod (already checked that the index.php is correct)
Xampp 1.8.1
PHP 5.4.7
MySQL 5.5.27

i have installed all from scratch and dont seem to get rid of the error above.
appreciate any suggestions, thanks a lot!

[pukram]

hi there,
i am installing this mod on a xampp local server for testing purposes and i get the exact same error message:
MySQL error 1054

Unknown column 'PMEtable0.event_comment' in 'field list'

---

phpMyEdit error: invalid SQL query

---

SELECT `PMEtable0`.`event_id` AS `qf0`,`PMEtable0`.`event_name` AS `qf1`,`PMEtable0`.`event_location` AS `qf2`,`PMEtable0`.`event_start` AS `qf3`,`PMEtable0`.`event_stop` AS `qf4`,`PMEtable0`.`event_comment` AS `qf5`,`PMEtable0`.`event_booth_location` AS `qf6`,`PMEtable0`.`special_text` AS `qf7`,`PMEtable0`.`map` AS `qf8` FROM `zen_events` AS `PMEtable0` ORDER BY `PMEtable0`.`event_id` LIMIT 0, 1530.182 miliseconds

I am running ZC 1.5.1, installed the very latest update mod (already checked that the index.php is correct)
Xampp 1.8.1
PHP 5.4.7
MySQL 5.5.27

i have installed all from scratch and dont seem to get rid of the error above.
appreciate any suggestions, thanks a lot!

hmmm... got it solved - despite the new index the field "event_comments" was written "event_comment" somehow (figured out when entering data in the DB directly, it had the right spelling |event_comments" but the comment itself would not appear on the scheduled event page of the web site...

well, sorted out by now! thanks for the mod :)

[lunabug]

Does anyone have this working (with actual upcoming events) where i can see what it looks like? Thanks, Leslie