Have you found a solution for this? I am having the same problem?Quote:
Originally Posted by soxophoneplayer
Printable View
Have you found a solution for this? I am having the same problem?Quote:
Originally Posted by soxophoneplayer
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 getQuote:
Originally Posted by dbltoe
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
I did this last timeQuote:
Originally Posted by dbltoe
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/
And, "The Lord helps those who help themselves."Quote:
but I'm a firm believer in shot gun tactics ask everyone and you’ll get an answer
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, replacewithQuote:
// 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');
Then, take the includes/extra_datafiles/extra_pages_filenames.php included in the events mod and replaceQuote:
// 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');
withQuote:
<?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');
?
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.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');
?
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.