Scheduled Events Add-On

[BethDog]

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?

[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."

[BethDog]

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

[dbltoe]

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

[discoverytdi]

Boy that was an easy install (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

[dbltoe]

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

[discoverytdi]

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 I just asumed that it was this mod that had change the format back
still a great mod though

[discoverytdi]

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 here's hoping
Link http://www.rvsolarsystems.co.uk/store/

[dbltoe]

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

// 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

// 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

<?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

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

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