Scheduled Events Add-On

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
https://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."

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

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/index.php?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/

but I'm a firm believer in shot gun tactics ask everyone and you’ll get an answerAnd, "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.

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.

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.

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

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

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

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.

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

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

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.

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.

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