another ps... I just re-installed the patch.. just in case. I still get the same error message. Do I have to uninstall the patch before re-installing? or does it just overwrite the previous patch?
april_may
another ps... I just re-installed the patch.. just in case. I still get the same error message. Do I have to uninstall the patch before re-installing? or does it just overwrite the previous patch?
april_may
Again, take a look at the red. This is from the includes/modules/pages/events/header_php.php.$result = $db->Execute("SELECT * FROM (DB_PREFIX . 'events') WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
$eventData = array();
while (!$result->EOF) {
$eventData[] = $result->fields;
$result->MoveNext();
It's where the system looks for the table, adds the prefix for the look, and selects events that have not expired.
You should not be seeing a . in the error. If your prefix is fribble, you would see fribble_events versus fribble.events.
I'd have a better idea if you PM the entire error to me.
You can also use phpMyAdmin to check if the database table events has the proper prefix.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
OK, now I am entirely lost. I am new to Zen and to php. This has been a crash course for me. I don't know the lingo here, so please bear with me.
First... what do you mean by " if you "PM" the entire error to me." what is PM? how/what? ... and fribble...was that just a made up name for an example.
Is this what you are talking about?...see red ..here is what is on the includes/modules/pages/events/header_php.php file:
<?php
// $Id: header_php.php 2008-12-31 08:07:26Z 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 events WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
$eventData = array();
while (!$result->EOF) {
$eventData[] = $result->fields;
$result->MoveNext(); }
$breadcrumb->add(NAVBAR_TITLE);
?>
Am I supposed to change something on this page?????
PM is private message.
Try changingto$result = $db->Execute("SELECT * FROM events WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
$result = $db->Execute("SELECT * FROM (DB_PREFIX . 'events') WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Sorry, I've been away from the computer.
When I mentioned to PM me the error, that was only because you were concerned about revealing part of your path.
It's best to keep the rest of the conversation in the forum so that others can learn from what we are doing to fix your situation.
It appears that your major problems are in the tpl and header. And, I'm not sure which is the problem. One time, it looks as if you have hard-coded information versus letting the variables work for you. The other looks like a problem getting the correct prefix working.
Let's try putting a copy of your header_php.php and the tpl_scheduled_events.php here in the forum.
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
MeltDown,
Sorry I missed your post.
The includes/modules/pages/header_php.php file looks forThis makes sure that no expired events are selected and then sorts them by the start date.WHERE (EndDate >= NOW()-1) ORDER BY StartDate")
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Hi- Ok
Recap so we can keep everyone up to date in the forum...
I tried the code you provided in last post and still did not work
I sent you the PM - with my codes...
from phpMyAdmin (first time I've been into the phpMyAdmin file... not familiar with that program yet, but studied it today to familiarize myself with it.) The events table is there. I gave you the prefix for it.
Today, I downloaded the module again, just in case there was something wrong with the files.
I reloaded everything except the english.php and the information
since I only copied and pasted the few lines into the my already customized files.
Still not working. Thought of something- I am on GoDaddy with a Lunix-php server... would that make a difference?
My header_php.php and the tpl_scheduled_events.php are "straight out of the box" I did not alter them.(now or before)
####################
(red text is the original code since I reloaded the file)
header_php.php is:
<?php
// $Id: header_php.php 2008-12-31 08:07:26Z 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 events WHERE (EndDate >= NOW()-1) ORDER BY StartDate"); $eventData = array();
while (!$result->EOF) {
$eventData[] = $result->fields;
$result->MoveNext();
}
$breadcrumb->add(NAVBAR_TITLE);
?>
####################_
tpl_scheduled_events.php is:
<?php
// $Id: tpl_events_default.php 2008-12-31 08:07:26Z dbltoe $
?>
<div class="centerColumn" id="events">
<h1 id="eventsDefaultHeading"><?php echo HEADING_TITLE; ?></h1><hr />
<?php
// Display the text of each event in a paragraph
foreach($eventData as $eventInfo) {
echo "<h5>" . $eventInfo["Event"] . "</h5><hr />";
echo "<blockquote>";
if ($eventInfo['Place'] != '') echo "<strong>Place: </strong>" . $eventInfo["Place"] . "<br />";
if ($eventInfo['StartDate'] != '') echo "<strong>Start Date: </strong>" . zen_date_short($eventInfo["StartDate"]) . "<br />";
if ($eventInfo['EndDate'] != '') echo "<strong>Stop Date: </strong>" . zen_date_short($eventInfo["EndDate"]) . "<br />";
if ($eventInfo['Comments'] != '') echo "<strong>Comments: </strong>" . $eventInfo["Comments"] . "<br />";
if ($eventInfo['Special'] != '') echo "<strong>Special: </strong>" . $eventInfo["Special"] . "<br />";
if ($eventInfo['Location'] != '') echo "<strong>Booth Location: </strong>" . $eventInfo["Location"] . "<br />";
if ($eventInfo['Map_Txt'] != '') echo "<strong><a href=" . $eventInfo["Map_Txt"] . ' target="_blank">Driving Directions</a></strong>';
echo "</blockquote><hr />";
}
?>
<div class="buttonRow back"><?php echo zen_back_link() . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>'; ?></div>
</div>
######################################################################___
OK- where do we go from here?
april_may
change header_php.php toMake sure there are no spaces after the ending ?>PHP Code:
<?php
// $Id: header_php.php 2008-12-31 08:07:26Z 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 (DB_PREFIX . 'events') WHERE (EndDate >= NOW()-1) ORDER BY StartDate");
$eventData = array();
while (!$result->EOF) {
$eventData[] = $result->fields;
$result->MoveNext();
}
$breadcrumb->add(NAVBAR_TITLE);
?>
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Thanks for the code.
Tried it.
I'm still getting the same error message.
back to square one.
any other suggestions?
Are you still getting the "******.events" in the error where it talks about database table?
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
Bookmarks