Scheduled Events Add-On

Hi,

Just installed the add-on - seems to work very well - many thanks.

I have a question to take it a step further. I'd like to call the event names and dates into a custom text box on the home page.

I've tried using

<?php include('\includes\templates\orange\templates\tpl_events_home.php');?>

Note I've copied tpl_events_default.php and made tpl_events_home.php in the same directory

I can get text from the file if I add some at the top, (and from a basic php echo 'hello world'), I'm getting nothing from the database. I am not a PHP coder though, just know a few commands.

Does anyone have any ideas. I could be calling the wrong file for starters...

Cheers,
Adam.

When you say text box, are you talking something in one of the sideboxes or a box on the main page?

Hi,

Sorry, should have been clearer. It'll be a section on the main page (define_main_page.php) where I call in the next 2-3 events from the database.

Quote:

---

e.g

SCHEDULED EVENTS

The Peak Open Air Market
2010-09-25

Bradbury School Fair
2010-10-13

More >>>

---

Thanks,
Adam.

Okay, I'll take a look later this evening. Out on laptop now.

Just a quick look and no guarantees till I can look at it better.

You'll need the $result call out of includes/modules/pages/events/header.php

Quote:

---

$result = $db->Execute("SELECT * FROM events WHERE (event_stop >= NOW()-1) ORDER BY event_start");
$eventData = array();
while (!$result->EOF) {
$eventData[] = $result->fields;
$result->MoveNext();
}

---

That will get your data out of the database.

Next, you will need to change

Quote:

---

<?php
// Display the text of each event in a paragraph
foreach($eventData as $eventInfo) {
echo "<h5>" . $eventInfo["event_name"] . "</h5><hr />";
echo "<blockquote>";
if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";
if ($eventInfo['event_start'] != '') echo "<strong>Start Date: </strong>" . zen_date_long($eventInfo["event_start"]) . "<br />";
if ($eventInfo['event_stop'] != '') echo "<strong>Stop Date: </strong>" . zen_date_long($eventInfo["event_stop"]) . "<br />";
//if ($eventInfo['Comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";
if ($eventInfo['event_booth_location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["event_booth_location"] . "<br />";
if ($eventInfo['special_text'] != '') echo "<strong>Special: </strong>" . $eventInfo["special_text"] . "<br />";
if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';
echo "</blockquote><hr />";
}
?>

---

to use for versus foreach and tell it to list however many you want.
Bear in mind that this will bomb if set to 3 and you only have 2 events.
<disclaimer>Not tested and I'm tired from an eleven hour day in the mall.:sleep1:

Many thanks, was out all day yesterday but will give this a try today and let you know how I get on...

Okay, as I suspected my PHP *ahem* skills are not up to the task...

I understand how tpl_events_default works with regard to displaying the data, so assumed I would be able to call this into another page, in my case 'define_main_page.php', and then simply remove the echo statements for the data I don't want to show.

I then planned to play around with the PHP to try and limit the events to the next 2-3 on the list (which you've kindly provided some code for). But I can't get the basic idea to work.

The page call (include) is working. I'm getting the back button displayed, and PHP is working (I've added an 'echo' to the top of tpl_events_default.php to check this)

Note I've also checked it is working okay when displaying on it's own page (i.e. /index.php?main_page=events) and there is no problem, it looks great (I don't even have to play around with the look of it)!! But I'm having no luck with a call to the DB when trying to diplay it on another page.

So, where am I going wrong in my asumption I can display the same data on another page? Is it something to do with paths??? :blush:

Cheers,
Adam.



define_main_page.php

Code:

---

<?php include('\includes\templates\orange\templates\tpl_events_default.php');?>

---

[FONT=Arial Black]NOTE TO ALL USERS:[/FONT]

We are redoing this mod to make it less invasive of the core files and give two options for installation.

Meanwhile... The mod is working with at least 1.3.9f BUT has a small php 5.3 problem that can be fixed by overwriting the phpMyEdit.class.php file in the root directory you are using for your events.

Extract the zip and load the file to the directory you are using for events.

This might be EXACTLY what the doctor ordered.. Got a potential client that we are contemplating how to use Zen Cart as an events manager tool (Collect RSVPS and payments).. This add-on might be JUST the tool we need to complete this.. Can't wait to see the new version!!

Quote:

---

Originally Posted by dbltoe

[FONT=Arial Black]NOTE TO ALL USERS:[/FONT]

We are redoing this mod to make it less invasive of the core files and give two options for installation.

Meanwhile... The mod is working with at least 1.3.9f BUT has a small php 5.3 problem that can be fixed by overwriting the phpMyEdit.class.php file in the root directory you are using for your events.

Extract the zip and load the file to the directory you are using for events.

---

Good add-on!
The installation is complete now and runs well.
Congrats on the link to Google Maps. Very useful for those who create events in a professional manner.
There is a small error message above the table eventz I reach http://locahlost/eshop/eventz and is:

Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\server\www\myserver.dev\public_html\eshop\eventz\phpMyEdit.class.php on line 3100

I do not wish to speak on the function set_magic_quotes_runtime() because I see it just me being the administrator of the shop.

It is now installed on my laptop on the development site where I'm learning about Zen-Cart and where can I test and add add-ons or modules before installing them in the store.
Thanks. I am every day more pleased to have chosen Zen-Cart.

I'm on zc 3.9h I installed this mod back in 3.7 and have updated several times. At zc 3.9d this mod was still working for me. At 3.9h it works on the store front side, but I can no longer access the admin screen of this mod. I hadn't noticed as I only checked it from the store side when I updated....now just discovered the prob as I went to update the coming year's events.

I can access it in my test site but not in live site. I don't have .htaccess file on my test site (windows7 wamp localhost) so I wonder if there is something I should add to my live .htaccess..... or if its more complicated than that (I note comment above that the mod is being re-written.)

I did update the phpMyEdit.class.php from the above zip.

Thanks,
Doug
www.meafordwool.com

I've just read through this thread for the first time and see that you are in the process of updating the mod (as of last October).
There are a couple of comments I had from the old posts, which you may already be addressing, but I'll mention them here just in case they help.

You discussed providing pre-edited language files versus giving instructions for adding defines to them. I think it would be simpler and safer all around to add new files for the mod's defines (in the /extra_definitions/ folder), rather than either of the above. Also, moving all output text to language define files as you mentioned is definitely the way to go.

The fix for db table prefixes:
$result = $db->Execute("SELECT * FROM (DB_PREFIX . 'events') WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
might better be done in the ZC standard way, by defining TABLE_EVENTS in a new (extra_datafiles) file and using that. This would even allow the user to change the table's name if they want to, without getting deep into the PHP code.
$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (EndDate >= NOW()-1) ORDER BY StartDate");

Quote:

---

Originally Posted by soxophoneplayer

I did update the phpMyEdit.class.php from the above zip.

---

I'm curious about this as the file has not changed from the original release to the current version on their website.
What other mods are you using and where did you get your template?

Quote:

---

I'm curious about this as the file has not changed from the original release to the current version on their website.
What other mods are you using and where did you get your template?

---

I just noticed that the file had a more recent date than the 2009 file already existing.

I'm using a load of mods, and the template is my own modified version of Classic. The add ons includle Canada Post, Stock by Attribute, Attributes Grid, Product Short Description, IH2, Zen Lightbox, French Pak, Column Grid, Horizontal Dropdown Menu (that I added link for Eventz), Google Analytics, Comodo Trust, Sales Report, Ceon Manual Card, XML Sitemap, About Us, Encrypted Master Password.

When I updated from zc 1.3.9d I eliminated FEC, and Superorders. I added Edit Orders and Ceon SEO.

I am certain that the front end of Events was working after the update to 1.3.9h, but I honestly don't recall if I checked the admin side - but for sure I haven't added any events since the update.

I don't have Ceon SEO on my test site, and I don't have the .htaccess on it, as in both cases it wouldn't work. Everything else is on the test site which I routinely use to test any site modifications before moving them live.

On the test site, the admin worked today but gave an error message on top of the admin page. When I unziped phpMyEdit.class.php and then that error doesn't show anymore. So I then ftp'd that file to my live site to see if it made a difference, and it doesn't.

When trying to get into the eventz admin I get a 'page does not exist' error and it loads my site map.

There is no error showing in the debug cache.

@glen -- yep already working that way. Oct to April is our big on the road time plus I broke an ankle in three places in Dec. Just out of the cast last week. Most of my time has been spent with a leg up in the air.

@sox make sure you uploaded the folder to your root (step 5 of the Basic/Beginner Installation Instructions in the events_installation_users_guide.txt).

Quote:

---

@sox make sure you uploaded the folder to your root (step 5 of the Basic/Beginner Installation Instructions in the events_installation_users_guide.txt).

---

Yes, Eventz folder is in public_html folder, which is where my admin folder, includes, etc etc. are located.

I haven't seen any motion on this thread in awhile.. I am hoping that is not bad news for me.. lol

I am a new zenner and am real interested in this add on... would solve alot of issues I have... anyway.. I am using 1.3.9h and I see it will work with this version..

I do see a couple people asking if there is any way to show scheduled events to non logged in folks on site.. That is MY thing too..

I am going to allow folks to order w/out registering.. and would like those folks to see the schedule as well as I am allowing COD to any of my Live sales events which I would need to list..

thanks for any help or input

Ken

You can blame the lack of traffic on me. Procrastination, a broken ankle, and hand surgery have really messed with my plans for the past year. Barely had time to keep our customers updated.
I had wanted to migrate all of the mod into the admin and database.
Was part way there, but the release of 1.5.0 [BETA] has convinced me that I need to just fix the current for 1.3.9h and go back to the other idea when 1.5.0 is stable.
The mod has never required that a customer be logged in to see the events.
Give me a couple of days to repackage what we have working on 1.3.9h and I will post the zip here.
THANX for the patience.

NO problem... It may be the examples I have seen posted That made me think it could not be seen except by logged in user as I could not find it and wasn't willing to register just to see it.. LMAO I can be a goof..

and shoot man that was a plenty fast reply for me and I look forward to seeing what you have and thanks again

Ken

Maybe the drug fog is lifting as it was pretty easy to repackage for 1.3.9h. And, it will work with 1.5.0 [BETA] as well.

I still want to get rid of the eventz folder in favor of admin manipulation of the database, but that will have to wait.

The zip is too big to attach so, until it's available in the Free Software Add Ons, you can download the file here.

Just in case I only mentioned it 100 times in the readme.....
BACKUP
BACKUP
BACKUP

Quote:

---

Originally Posted by soxophoneplayer

I'm on zc 3.9h I installed this mod back in 3.7 and have updated several times. At zc 3.9d this mod was still working for me. At 3.9h it works on the store front side, but I can no longer access the admin screen of this mod. I hadn't noticed as I only checked it from the store side when I updated....now just discovered the prob as I went to update the coming year's events.

I can access it in my test site but not in live site. I don't have .htaccess file on my test site (windows7 wamp localhost) so I wonder if there is something I should add to my live .htaccess..... or if its more complicated than that (I note comment above that the mod is being re-written.)

I did update the phpMyEdit.class.php from the above zip.

Thanks,
Doug
www.meafordwool.com

---

Have you found a solution for this? I am having the same problem?

The newest version of the mod is now available in the Free Software Add Ons section.
There was an update to the phpMyEdit (first one in ages) that would effect more than just the class file.
There are major changes in the way the mod accesses the database (for better security) and the table settings have changed so your best option is to upgrade.
Also, the options on the displayed page make it a little more "purdy."

Quote:

---

Originally Posted by dbltoe

The newest version of the mod is now available in the Free Software Add Ons section.
There was an update to the phpMyEdit (first one in ages) that would effect more than just the class file.
There are major changes in the way the mod accesses the database (for better security) and the table settings have changed so your best option is to upgrade.
Also, the options on the displayed page make it a little more "purdy."

---

This is the one I am having problems with. Here is the error I get

MySQL error 1054

Unknown column 'PMEtable0.eventLocation' in 'field list'
phpMyEdit error: invalid SQL query

SELECT `PMEtable0`.`event_id` AS `qf0`,`PMEtable0`.`event_name` AS `qf1`,`PMEtable0`.`eventLocation` 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, 1545.79 miliseconds

Did you replace all files with the newer version per the events_installation_users_guide.txt Upgrade Instructions section?

Boy that was an easy install :clap: (famous last words me thinks) one thing though can change the date format to UK format dd/mm/yyyy somewhere. great mod by the way and as I do a lot of shows round the UK it's a god send well done :bigups:

Take a look at this. http://www.zen-cart.com/wiki/index.php/Date_Format

Quote:

---

Originally Posted by dbltoe

Take a look at this. http://www.zen-cart.com/wiki/index.php/Date_Format

---

I did this last time
https://www.zen-cart.com/tutorials/i...hp?article=401
must have stuffed the date format up at one point :censored: I just asumed that it was this mod that had change the format back :oops:
still a great mod though :thumbsup:

Me again just installed add extra pages to more information side box mod and it's broken the heading to Scheduled Events I now see BOX_INFORMATION_EVENTS I have posted the same problem on the add pages thread but I'm a firm believer in shot gun tactics ask everyone and you’ll get an answer :D here's hoping
Link http://www.rvsolarsystems.co.uk/store/

Quote:

---

but I'm a firm believer in shot gun tactics ask everyone and you’ll get an answer

---

And, "The Lord helps those who help themselves."
It's always a good idea to compare mods and find out what files they have in common before using them. Especially when modifying a live shop.
Some use winmerge, beyondcompare, or (paid) ultracompare to make sure the commonalities are found and dealt with properly.
Using one of those, you'll find that the add pages mod uses a modified includes/languages/custom/english.php as does the events mod. The english.php file holds defines specific to the English language. The variables (in ALL_CAPS format) are set so that they can be called when needed and only need to be defined once. When you see "BOX_INFORMATION_EVENTS" or something similar, it tells you that a define has failed or doesn't exist.
The english.php file provided with the add pages mod is an older version and has an addition to the footer that is (IMHO) stretching the definition of Designed By. It also modifies a core file - includes/filenames.php. This means that an upgrade will wipe out the changes and break the mod.
I would first take the english.php file from the events mod and do the following:
Around line 148, replace

Quote:

---

// information box text in sideboxes/more_information.php - were TUTORIAL_
define('BOX_HEADING_MORE_INFORMATION', 'More Information');
define('BOX_INFORMATION_PAGE_2', 'Page 2');
define('BOX_INFORMATION_PAGE_3', 'Page 3');
define('BOX_INFORMATION_PAGE_4', 'Page 4');

---

with

Quote:

---

// information box text in sideboxes/more_information.php - were TUTORIAL_
define('BOX_HEADING_MORE_INFORMATION', 'More Information');
define('BOX_INFORMATION_PAGE_2', 'Page 2');
define('BOX_INFORMATION_PAGE_3', 'Page 3');
define('BOX_INFORMATION_PAGE_4', 'Page 4');
define('BOX_INFORMATION_PAGE_5', 'Page 5');
define('BOX_INFORMATION_PAGE_6', 'Page 6');
define('BOX_INFORMATION_PAGE_7', 'Page 7');

---

Then, take the includes/extra_datafiles/extra_pages_filenames.php included in the events mod and replace

Quote:

---

<?php
// $Id: extra_pages_filenames.php 2008-12-31 08:07:26Z dbltoe $
// define the extra page filenames
define('FILENAME_DEFINE_EVENTS', 'define_events');
define('FILENAME_EVENTS', 'events');
?

---

with

Quote:

---

<?php
// $Id: extra_pages_filenames.php 2008-12-31 08:07:26Z dbltoe $
// define the extra page filenames
define('FILENAME_DEFINE_EVENTS', 'define_events');
define('FILENAME_EVENTS', 'events');
define('FILENAME_DEFINE_PAGE_5', 'define_page_5');
define('FILENAME_DEFINE_PAGE_6', 'define_page_6');
define('FILENAME_DEFINE_PAGE_7', 'define_page_7');
?

---

Then replace the includes/filenames.php that came with the add pages mod with the original includes/filenames.php that came with your version of Zen Cart.
Doing both these things will allow the mods to work together and not be broken by a future upgrade.

Timed out before I remembered your need for the UK date format.
While doing the changes to the includes/languages/custom/english.php from the events mod suggested in my last post, don't forget to "fix" the date format in lines 23 and 24 to match what you need for the UK.

Quote:

---

Originally Posted by dbltoe

And, "The Lord helps those who help themselves."

---

and fools rush in blah blah :D
sounds like the add pages mod is more trouble than it's worth and as for the zen 4 dummies I agree luckily I have the fix from Clyde from when I was playing with the mod, and besides I've never liked the more info side box. I'd much prefer a way of putting links to pages 1,2,3,4,5,6,7, whatever in the information side box where I feel they belong not in a seperate side box. One thing that drives me bonkers :frusty: is having to roam round a site looking for the information I need, much prefer stuff all in one place. might give the About Us mod a go as you can clone new pages with it or am I asking for problems.

Quote:

---

Originally Posted by dbltoe

Timed out before I remembered your need for the UK date format.
While doing the changes to the includes/languages/custom/english.php from the events mod suggested in my last post, don't forget to "fix" the date format in lines 23 and 24 to match what you need for the UK.

---

sorted that thanks

Quote:

---

Originally Posted by dbltoe

And, "The Lord helps those who help themselves."
It's always a good idea to compare mods and find out what files they have in common before using them. Especially when modifying a live shop.
Some use winmerge, beyondcompare, or (paid) ultracompare to make sure the commonalities are found and dealt with properly.
Using one of those, you'll find that the add pages mod uses a modified includes/languages/custom/english.php as does the events mod. The english.php file holds defines specific to the English language. The variables (in ALL_CAPS format) are set so that they can be called when needed and only need to be defined once. When you see "BOX_INFORMATION_EVENTS" or something similar, it tells you that a define has failed or doesn't exist.
The english.php file provided with the add pages mod is an older version and has an addition to the footer that is (IMHO) stretching the definition of Designed By. It also modifies a core file - includes/filenames.php. This means that an upgrade will wipe out the changes and break the mod.
I would first take the english.php file from the events mod and do the following:
Around line 148, replacewithThen, take the includes/extra_datafiles/extra_pages_filenames.php included in the events mod and replacewithThen replace the includes/filenames.php that came with the add pages mod with the original includes/filenames.php that came with your version of Zen Cart.
Doing both these things will allow the mods to work together and not be broken by a future upgrade.

---

Just tried the alterations on my test wamp site and just got a white screen :frusty: think I'll look into using the FAQ MOD for my extra pages

Quote:

---

Originally Posted by discoverytdi

Just tried the alterations on my test wamp site and just got a white screen :frusty: think I'll look into using the FAQ MOD for my extra pages

---

sorted just uploaded this part
// information box text in sideboxes/more_information.php - were TUTORIAL_
define('BOX_HEADING_MORE_INFORMATION', 'More Information');
define('BOX_INFORMATION_PAGE_2', 'Page 2');
define('BOX_INFORMATION_PAGE_3', 'Page 3');
define('BOX_INFORMATION_PAGE_4', 'Page 4');
define('BOX_INFORMATION_PAGE_5', 'Page 5');
define('BOX_INFORMATION_PAGE_6', 'Page 6');
define('BOX_INFORMATION_PAGE_7', 'Page 7');
and it solved it please tell me that come the upgrade to zencart 1.5 I won't have to do this again, but i'll put it in my events file just in case. NURSE IN NEED A BIGGER BOOK CASE :D

Quote:

---

Then, take the includes/extra_datafiles/extra_pages_filenames.php included in the events mod and replace

Quote:
<?php
// $Id: extra_pages_filenames.php 2008-12-31 08:07:26Z dbltoe $
// define the extra page filenames
define('FILENAME_DEFINE_EVENTS', 'define_events');
define('FILENAME_EVENTS', 'events');
EndQuote

with

Quote:
<?php
// $Id: extra_pages_filenames.php 2008-12-31 08:07:26Z dbltoe $
// define the extra page filenames
define('FILENAME_DEFINE_EVENTS', 'define_events');
define('FILENAME_EVENTS', 'events');
define('FILENAME_DEFINE_PAGE_5', 'define_page_5');
define('FILENAME_DEFINE_PAGE_6', 'define_page_6');
define('FILENAME_DEFINE_PAGE_7', 'define_page_7');
EndQuote

Then replace the includes/filenames.php that came with the add pages mod with the original includes/filenames.php that came with your version of Zen Cart.

Doing both these things will allow the mods to work together and not be broken by a future upgrade.

---

Did you do the other part? If you did not, then the next upgrade will break the cart.

Quote:

---

Originally Posted by dbltoe

Did you do the other part? If you did not, then the next upgrade will break the cart.

---

no cause when I did the other 2 changes they broke the site, . not sure if it's related to the change of host as I've just notice that the rma mods missing from the infomation sidebox the files and everything are there it's just not showing so I'll will try them one by one and see what hapens

Quote:

---

Originally Posted by discoverytdi

no cause when I did the other 2 changes they broke the site, . not sure if it's related to the change of host as I've just notice that the rma mods missing from the infomation sidebox the files and everything are there it's just not showing so I'll will try them one by one and see what hapens

---

and based on your post you didn't fully investigate the error you got and instead just reversed the code.. the way to resolve the error is to checkout the error logs in your cache to see why you got the blank screen..

blank screen = error

But going back to what dbltoe originally posted it sounds like you have several mods modifying the same files and you are not merging all the code in these common files correctly. this is why after installing some mods or making some changes, that some of the code from one or another or your add-ons is being wiped out. If you are not using Winmerge (free) or Beyond Compare (paid) to compare common files when installing mods, you will struggle mightily as you setup your store..

Quote:

---

Originally Posted by DivaVocals

and based on your post you didn't fully investigate the error you got and instead just reversed the code.. the way to resolve the error is to checkout the error logs in your cache to see why you got the blank screen..

blank screen = error

But going back to what dbltoe originally posted it sounds like you have several mods modifying the same files and you are not merging all the code in these common files correctly. this is why after installing some mods or making some changes, that some of the code from one or another or your add-ons is being wiped out. If you are not using Winmerge (free) or Beyond Compare (paid) to compare common files when installing mods, you will struggle mightily as you setup your store..

---

Thanks Diva you are probably right I've not had any problems till now as the mods I have haven't caused problems extra sideboxes IH3 and zen light box etc, will have to read up on winmerge and use it more often in future. the more I use zencart the more I learn still that’s what life’s about making mistakes and learning. Cheers both for all your help. :bigups: On the subject of winmerge is there a simple guide somewhere I could read I get lost with all the jargon sometimes being a thick scouser from Liverpool UK.

Quote:

---

Originally Posted by dbltoe

Did you do the other part? If you did not, then the next upgrade will break the cart.

---

:bigups: cheers done, most have messed up the first time changed both files without a hitch.

Quote:

---

Originally Posted by discoverytdi

Thanks Diva you are probably right I've not had any problems till now as the mods I have haven't caused problems extra sideboxes IH3 and zen light box etc, will have to read up on winmerge and use it more often in future. the more I use zencart the more I learn still that’s what life’s about making mistakes and learning. Cheers both for all your help. :bigups: On the subject of winmerge is there a simple guide somewhere I could read I get lost with all the jargon sometimes being a thick scouser from Liverpool UK.

---

None that I'm aware of.. I'm sure you can Google up something that would be useful.. I downloaded Winmerge and dove in head first.. I didn't find it tough to figure out how to use it.. Did the same when I switched to Beyond Compare (Beyond Compare is not free but it's totally worth the small cost as it's a MUCH better program than Winmerge IMHO..)

Quote:

---

Originally Posted by DivaVocals

None that I'm aware of.. I'm sure you can Google up something that would be useful.. I downloaded Winmerge and dove in head first.. I didn't find it tough to figure out how to use it.. Did the same when I switched to Beyond Compare (Beyond Compare is not free but it's totally worth the small cost as it's a MUCH better program than Winmerge IMHO..)

---

Kind of off topic but for those on a Mac you can use BBEdit to compare and merge files. Not free but works great.

:frusty: now I'm getting a custom 404 page not found page when I click on the link for pages 5,6,7
shouLd I have put the define pages 5'6'7' somewhere else as well

Quote:

---

Originally Posted by discoverytdi

:frusty: now I'm getting a custom 404 page not found page when I click on the link for pages 5,6,7
shouLd I have put the define pages 5'6'7' somewhere else as well

---

http://i896.photobucket.com/albums/a...titled-1-1.jpg
I have 2 define files could that be the problem

Perhaps it's time to discuss things not pertaining to the scheduled events mod elsewhere. I realize I somewhat opened the door, but we're starting to drive a Mack truck throuh it.

Quote:

---

Originally Posted by dbltoe

Perhaps it's time to discuss things not pertaining to the scheduled events mod elsewhere. I realize I somewhat opened the door, but we're starting to drive a Mack truck throuh it.

---

ok sorry will post elsewhere

After this step I get an error of page not found, I have tried using eventz and changing the file name too. I have also downloaded and reloaded the folder several times. Any suggestions?
5. Once the functionality is tested and working, FTP the eventz folder to the root of your site. Once uploaded, you should be able to reach it by entering http://www.yoursite.com/eventz in your browser's address bar.

When you uploaded the entire folder, could you see it in your FTP program?
Can you give me some of the other posting tip answers?

Yes, I can see it in the ftp upload. I'm using zc v1.3.9e, I had recently moved the site from the back end to live, everything else works. I have even re-uploaded all the files with the new version of events and still the same thing. www.totaldogsupplies.com

Haven't tested with e but should work.
It would be nice to know your server type, php version, and the permission your FTP shows on that folder. Did you perhaps add an .htaccess file?

PHP 5.2.12, Events folder is set to 755, server type? I go through fatcow
there is .htaccess file for another add on that is a css flyout header. Here is what it says:
#
# @copyright Copyright 2003-2010 Zen Cart Development Team
# @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
# @version $Id: .htaccess 16111 2010-04-29 22:39:02Z drbyte $
#
# This is used with Apache WebServers
#
# The following blocks direct HTTP requests to all filetypes in this directory recursively, except certain approved exceptions
# It also prevents the ability of any scripts to run. No type of script, be it PHP, PERL or whatever, can normally be executed if ExecCGI is disabled.
# Will also prevent people from seeing what is in the dir. and any sub-directories
#
# For this to work, you must include either 'All' or at least: 'Limit' and 'Indexes' parameters to the AllowOverride configuration in your apache/conf/httpd.conf file.
# Additionally, if you want the added protection offered by the OPTIONS directive below, you'll need to add 'Options' to the AllowOverride list, if 'All' is not specified.
# Example:
#<Directory "/usr/local/apache/htdocs">
# AllowOverride Limit Options Indexes
#</Directory>
###############################
DirectoryIndex index.php

# deny *everything*
<FilesMatch ".*\..*">
Order Allow,Deny
Deny from all
</FilesMatch>

# but now allow just *certain* necessary files:
<FilesMatch "(^$|^favicon.ico$|.*\.(php|js|css|jpg|gif|png)$)">
Order Allow,Deny
Allow from all
</FilesMatch>

IndexIgnore */*


# The following makes adjustments to the SSL protocol for Internet Explorer browsers
<IfModule mod_setenvif.c>
<IfDefine SSL>
SetEnvIf User-Agent ".*MSIE.*" \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
</IfDefine>
</IfModule>

# Fix certain PHP values

#<IfModule mod_php4.c>
# php_value session.use_trans_sid 0
# php_value register_globals 1
#</IfModule>

# to turn off register_globals
# php_value register_globals 0

#turn off X-PHP-Originating-Script header when sending emails from admin
#uncomment to activate:
# php_flag mail.add_x_header Off

RewriteEngine On

# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule .* index.php?%{QUERY_STRING} [L]

Quote:

---

Originally Posted by BethDog

This is the one I am having problems with. Here is the error I get

MySQL error 1054

Unknown column 'PMEtable0.eventLocation' in 'field list'
phpMyEdit error: invalid SQL query

SELECT `PMEtable0`.`event_id` AS `qf0`,`PMEtable0`.`event_name` AS `qf1`,`PMEtable0`.`eventLocation` 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, 1545.79 miliseconds

---

Hi
I have just installed this mod and get exactly the same problem... Not upgrading, this is a first time install.

D/B seems ok and all works from admin. This is from the eventz page

What to check next?

@BethDog - Sorry. I thought I answered from my iPad, but it doesn't show up here. You should not have an .htaccess file in the eventz directory and I'm wondering why your host is behind on their PHP version. Do you have any debug files in your site's root/cache folder? Any error log items in your cpanel?

@Rizla - BethDog's original problem was caused by an older version of the files. Make sure you are using only the latest version. Since you did not answer the posting tips (server type, PHP/MySQL versions, etc) the only thing I can say at this point is that you "appear" to have the right files and it may be that you have a PHP/MySQL problem.

Hi
Info: Linux, PHP: 5.2.17, MySQL: 5.0.92

I D/L the mod on the 17th (UK time) I have D/L it today but apears the same exept for a small change in folder size.
Origisnal: 1.3.9h Size: 308kb
Today: 1.3.9h Size: 312kb

If they ARE different (updated) would I have to merge my english.php again? or which file changed?

Or..... do I have a correct one ;)

Host is updating PHP in a couple of days.

Help!

Checked with Winmerge.... identical, so I seem to have the latest.

Sorry to be a pain... Thinking should I put a support ticket into host?

Rizla

Okay, I've either had a senior moment or files got mixed.
The 1054 may be caused by an incorrect file in the eventz folder.
Check around line 147 of the index.php for

Quote:

---

$opts['fdd']['eventLocation'] = array(
'name' => 'Event Location',
'select' => 'T',
'maxlen' => 75,
'sort' => true
);

---

IF that code is there in your version, change it to

Quote:

---

$opts['fdd']['event_location'] = array(
'name' => 'Event Location',
'select' => 'T',
'maxlen' => 75,
'sort' => true
);

---

In other words replace the capital L with _l

This should NOT cause the directory to not appear.

Arrrrh!! SORTED
God... I must have stared at that for hrs lol

That got rid of the error, Thanks

Almost..... Just entered data, date format still in US (must have missed something. Data is saving to DB but not displaying on site.

Late here now and off for some sleep. So will look closer in the mornins.

Thanks again

Voila! That fixed my problem too! But I do have to type in mysite.com/eventz/index.php in order for it to come up. But I thought I would be kind enough to let people know there is a solution if you get the "Page Not Found" error!

Language defines are only English for now.

BethDog - if you have to type in the index.php, you have a setting out of whack on the server. Check with your host.

ALL - Looks like some bad files got uploaded. I'll know more later tonight.

@dbltoe my whole server is out of wack! I'm going to be looking for a new one.

Okay,
Further investigation shows that I included an old file in the upload to Zen Cart Add Ons. :cry:

Here's a new index.php that will need to replace the index.php in the eventz folder.

Excellent!!! Works as described on the tin.....

Ok dbltoe.... Take a deep breath, a shot of whiskey and tie 'ya hand behinde 'ya back....

One more incey wincey question.... In 'eventz' I have changed the date format to dd-mm-yyyy, but find that this only changes the entry headings.

Si, is the d/b hard coded or could it be altered for UK?

Aint we a pain?

Does not Eventz pose a risk that anyone can enter anything into the zencart scheduler without logging into the service?

If you feel it is a threat, it's your prerogative to change the folder name to anything you wish.

I am having the same problem as some others have had regarding the DB is saving but NOT displaying on the site. I have tried all the updated files in the posts and it is still not working... please help, my url is http://azadapparel.com/index.php?main_page=events

Also, I have added a new page for the Events as well and it seems to be working fine by clicking the information box as well as the nav button on the top of pages. I would like to turn the information box off once this is fixed, thanks!

Got a short break in the action.
Unfortunately we are doing 14-16 hour days in the mall through Christmas Eve. Thus, the sparse presence on my part.
Not sure when I can look but, PM your e-mail along with your geographic location and I will try to set something up with you.

Hi dbltoe,

Thanks for the add-on. This will serve my needs well.

Install went nearly perfect and everything appears to be working so far.

Easy question for you or anyone using handling event registration,
what and where can I find/create a report to export purchases (event reg.) sorted by event, event date, products, and many product options (customer specs)? I would prefer an xls format but not necessary.

FYA, I'm a noob to Zen Cart, php, and CSS.

TIA

Got it working except events do not show on Scheduled events page.
Any suggestions?
Thank you

If everything is functioning with just a blank page (you do have the side columns, etc. showing, right?) and there are no debug files in the /cache folder, the only thing left is that there is no entry in the database.
I noticed today that the instructions do not tell you to upload the eventz folder to the root of your cart. I also did not like the fact that some of the files were overwriting core or custom files from other mods.
SO... I redid the mod to version 1.6.0. It has been submitted to the add-ons section but will take a few days to be approved.
If you need a copy before then, PM me and I'll get one to you.

@matzgmb - To be more informative, there were plans to move all processes of this mod to the admin, but the changes in 1.5.0 put that on hold till registration is better understood and we can verify that PCI and sanitation will not be broken. All are advised to rename the folder for now and, in some cases, an underscore can be added to the beginning of the directory name. As it is now, the database connection passes PCI scan in all the stores we've installed it in. Of course, you could always put it in it's own database.

@gemae - That would be a major change to the concept that events are helpful "Information" for the customer. Of course, the beauty of open source is that you can "adjust as required."

@slingblade01 - There is no database correlation between the event table and purchases. Even an extraction of orders made during event dates could not provide accurate numbers without knowing if all orders were, in fact, because of the event and not just someone arriving after searching Google.

@jazzman2 - If you are having problems with one-day events or events dropping off the list early, you might find this fix will work.

In includes/modules/pages/events/header_php.php find

Quote:

---

$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (event_stop >= NOW()-1) ORDER BY event_start");

---

and replace with

Quote:

---

$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (event_stop >= CURDATE()-1) ORDER BY event_start");

---

Since some ISO's work the date differently, it's a better way of handling the event_stop date anyway.:yes:
If we learn from our mistakes, shouldn't I have multiple doctorates by now?:smartalec:

Hello everyone! I was wondering if there's any way to edit the admin. i love the mod and how it looks but there's stuff i don't really need. i just want it to say

Event Name
Location
Date
Time
Details

Can someone help me? My PHP knowledge is very limited.

Thank you!

Hello Serg, everyone here.:P
Scheduled events is set so that some items will not appear in the listing if nothing is added to that field in the database. For instance, Driving Directions will not appear unless something is entered in the map field in the form.
There is one problem in your case. The lack of a Stop Date (event_stop) will break the operation as the mod needs to know the stop date in order to stop showing the event.
The display file that sets the titles of each item is located in includes/templates/YOUR_CUSTOM/templates/tpl_events_default.php. What you are wanting to change starts around line 14.
As an example, if you wanted to say Location instead of Place, you would change

Quote:

---

if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";

---

to

Quote:

---

if ($eventInfo['event_location'] != '') echo "<strong>Location: </strong>" . $eventInfo["event_location"] . "<br />";

---

Changing

Quote:

---

if ($eventInfo['event_comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";

---

to

Quote:

---

if ($eventInfo['event_comments'] != '') echo "<strong>Details: </strong>" . $eventInfo["Comments"] . "<br />";

---

would fix your need for a Details item.
Of course, you can switch the order of any of those to make them show up in the order you want for your site.

Thank you so much everyone! Haha. I will try that tomorrow, my eyes hurt at the moment. I'll see how it goes!

How do i add the event time? and for the 'Details' why is there a limit on how many characters I can have? There's a lot of details i need to put there. thank you!

Nevermind, i figured out the chararecters, But i can't do the time. is there a way to hide the end date? so it only says Start Date?
thank you!

Any one of the unused items could be used to report a time. You would have to modify the table and tpl file to accept and display a time element or just use one of them as "Hours" and enter something like "Open from 10 AM till 5 PM."

I'm having a hard time figuring out why you would want to NOT let someone know when the event ended, but, like everything else, it can be hidden in the tpl file. You would just comment out the line.

Please understand that this thread is to assist with general operation of the Scheduled Events Mod versus help in rewriting a mod for your personal use. We're getting deeper into the "how do I customize this for me?" which is outside the scope of the thread.

Open Source means you can take it, reverse it, invert it, flatten it, or whatever your wish. But, if you are unable to do so with the information already provided, it might be time to contract someone who is knowledgeable enough to create your new "masterpiece".

Don't want to cut you off at the knees, but I'm afraid the thread will get too far adrift if we continue with customization versus operation.

Best of luck with this and, when you've gotten it to your liking, consider submitting it to Add Ons so that it could be available for anyone else that might need your particular version.:bigups:

Quote:

---

Originally Posted by dbltoe

Any one of the unused items could be used to report a time. You would have to modify the table and tpl file to accept and display a time element or just use one of them as "Hours" and enter something like "Open from 10 AM till 5 PM."

I'm having a hard time figuring out why you would want to NOT let someone know when the event ended, but, like everything else, it can be hidden in the tpl file. You would just comment out the line.

Please understand that this thread is to assist with general operation of the Scheduled Events Mod versus help in rewriting a mod for your personal use. We're getting deeper into the "how do I customize this for me?" which is outside the scope of the thread.

Open Source means you can take it, reverse it, invert it, flatten it, or whatever your wish. But, if you are unable to do so with the information already provided, it might be time to contract someone who is knowledgeable enough to create your new "masterpiece".

Don't want to cut you off at the knees, but I'm afraid the thread will get too far adrift if we continue with customization versus operation.

Best of luck with this and, when you've gotten it to your liking, consider submitting it to Add Ons so that it could be available for anyone else that might need your particular version.:bigups:

---

I'm sorry, I'm just learning this whole zen cart situation and I don't know PHP that well. I would love to customize it and add it for everyone to download. I just don't know how. The add-on is great, don't get me wrong. Once again I'm sorry. For the end date, I am not using the events to let people know about sales and stuff like that, it's
more for in store event, so all I need is the date and time. I will try to figure out how to hide the line. Thank you, and I'm
Sorry.

No need to be sorry about asking questions. You'll get there one day.
You might want to open a thread in the general questions area and fully explain what you are trying to do. You'll probably find someone will have a workable solution.
The more you explain what exactly you want to do, the better your answers will be.

I only just discovered your add-on last week and it is perfect for me.
It is working well. Except if I have a multi day event it removes the event from the list on the last day rather than the day after the last day. How can I fix this?

Robbie,
Check out post 172 in this thread.

171:blush:

Quote:

---

Originally Posted by dbltoe

171:blush:

---

I tried that and it did not work.
I had an event that finished yesterday that disappeared prematurely so I used the CURDATE option. It solved it disappearing yesterday but it didn't disappear today when it should have.
I will try again in case I did something wrong.

No it is still not working.
The page is: http://www.thehorsestall.com.au/stor...in_page=events still with the CURDATE. Where does it pick up the current date? From the PC or somewhere else?

With your server in Sydney, there shouldn't be a problem with your time matching the server.
Must be an error in the code as it doesn't even flip at midnight here.
Can you post your header_php.php here?

Quote:

---

Originally Posted by dbltoe

With your server in Sydney, there shouldn't be a problem with your time matching the server.
Must be an error in the code as it doesn't even flip at midnight here.
Can you post your header_php.php here?

---

Code:

---

<?php
/**
 * @package Header for Scheduled Events 1.6
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: header_php.php 3001 2012-01-18 11:45:06Z dbltoe $
 */

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));

// include template specific file name defines
$define_page = zen_get_file_directory(DIR_WS_LANGUAGES . $_SESSION['language'] . '/html_includes/', FILENAME_DEFINE_EVENTS, 'false');

$result = $db->Execute("SELECT * FROM " . TABLE_EVENTS . " WHERE (event_stop >= CURDATE()-1) ORDER BY event_start");
  $eventData = array();
  while (!$result->EOF) {
    $eventData[] = $result->fields;
    $result->MoveNext();
  }
$breadcrumb->add(NAVBAR_TITLE); 
?>

---

It is the latest one with only the CURDATE change.

Quote:

---

Originally Posted by gemae

I am having the same problem as some others have had regarding the DB is saving but NOT displaying on the site. I have tried all the updated files in the posts and it is still not working... please help, my url is http://azadapparel.com/index.php?main_page=events

---

Check how you are entering your dates: I was having the same problem I was entering 03 09 2012 but I should have been entering the year first- Basically It wouldn't show up because it was saying the event ended already.

Quote:

---

Originally Posted by BethDog

Check how you are entering your dates: I was having the same problem I was entering 03 09 2012 but I should have been entering the year first- Basically It wouldn't show up because it was saying the event ended already.

---

Each time a date is required, the form clearly shows yyyy-mm-dd as the example:mellow:

Quote:

---

Originally Posted by dbltoe

You can add them one of two ways.

Create an extra field in the events table called images or enter the image into one of the other categories. Comments, Special, and Location will all accept 200 or more characters so a link should work in any of those.

If you create an extra field, make sure the type is varchar, the length is 255, and the Allow Null is checked. Then, you'd need to edit the includes/templates/CUSTOM/templates/tpl_events_default.php to add the display of the image field.

Either way, you'll enter html link code for the picture you plan to use. Enclosing them in a div with an id or class will allow you to control the image with the stylesheet.

Remember to use relative links and that the image must be in an accessible directory of your site.

HTH

---

I would like a little more direction with this please I don't know SQL very well, however, I am good at following directions and I can edit the php files pretty well... I have gotten this wonderful addon to work with my site now and would love to be able to put at least one image (preferably multiple images) for the events on the page with the descriptions. I'm probably making this too difficult but please help, thank you!

my site is http://azadapparel.com/index.php?main_page=events

Very useful plugin... Thanks dbltoe...

However... I just downloaded and unzipped it, and after installing, found that the COMMENTS field was not showing on the web page.

So I looked in the SQL and see:

CREATE TABLE `zen_events` (
`event_id` bigint(20) NOT NULL auto_increment,
`event_name` varchar(100) default NULL,
`event_location` varchar(75) default NULL,
`event_start` datetime default NULL,
`event_stop` datetime default NULL,
`event_comment` varchar(255) default NULL,
`event_booth_location` varchar(255) default NULL,
`special_text` varchar(200) default NULL,
`map` varchar(255) default NULL,

Then I look in tpl_events_default.php and see:

if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";
if ($eventInfo['event_start'] != '') echo "<strong>Start Date: </strong>" . zen_date_long($eventInfo["event_start"]) . "<br />";
if ($eventInfo['event_stop'] != '') echo "<strong>Stop Date: </strong>" . zen_date_long($eventInfo["event_stop"]) . "<br />";
if ($eventInfo['event_comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";
if ($eventInfo['event_booth_location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["event_booth_location"] . "<br />";
if ($eventInfo['special_text'] != '') echo "<strong>Special: </strong>" . $eventInfo["special_text"] . "<br />";
if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';
echo "</blockquote><hr />";

So I change to:-

// Display the text of each event in a paragraph
foreach($eventData as $eventInfo) {
echo "<h5>" . $eventInfo["event_name"] . "</h5><hr />";
echo "<blockquote>";
if ($eventInfo['event_location'] != '') echo "<strong>Place: </strong>" . $eventInfo["event_location"] . "<br />";
if ($eventInfo['event_start'] != '') echo "<strong>Start Date: </strong>" . zen_date_long($eventInfo["event_start"]) . "<br />";
if ($eventInfo['event_stop'] != '') echo "<strong>Stop Date: </strong>" . zen_date_long($eventInfo["event_stop"]) . "<br />";
if ($eventInfo['event_comment'] != '') echo "<strong>Comments: </strong>" . $eventInfo["event_comment"] . "<br />";
if ($eventInfo['event_booth_location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["event_booth_location"] . "<br />";
if ($eventInfo['special_text'] != '') echo "<strong>Special: </strong>" . $eventInfo["special_text"] . "<br />";
if ($eventInfo['map'] != '') echo "<strong><a href=" . $eventInfo["map"] . ' target="_blank">Driving Directions</a></strong>';
echo "</blockquote><hr />";
}

... and everything now works...

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

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.

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):

Code:

---

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

---

Any suggestions?

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

Quote:

---

Originally Posted by 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

---

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.:yes:

Quote:

---

Originally Posted by 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.

---

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.,

Quote:

---

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

---

could become

Quote:

---

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.

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.

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!

Quote:

---

Originally Posted by 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 :)

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