Scheduled Events Add-On

[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

[dbltoe]

$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();

Again, take a look at the red. This is from the includes/modules/pages/events/header_php.php.
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.

[april_may]

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

[dbltoe]

PM is private message.

Try changing

$result = $db->Execute("SELECT * FROM events WHERE (EndDate >= NOW()-1) ORDER BY StartDate");

to

$result = $db->Execute("SELECT * FROM (DB_PREFIX . 'events') WHERE (EndDate >= NOW()-1) ORDER BY StartDate");

[dbltoe]

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.

[dbltoe]

MeltDown,
Sorry I missed your post.
The includes/modules/pages/header_php.php file looks for

WHERE (EndDate >= NOW()-1) ORDER BY StartDate")

This makes sure that no expired events are selected and then sorts them by the start date.

[april_may]

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

[dbltoe]

change header_php.php to

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

Make sure there are no spaces after the ending ?>

[april_may]

Thanks for the code.

Tried it.
I'm still getting the same error message.

back to square one.
any other suggestions?

[dbltoe]

Are you still getting the "******.events" in the error where it talks about database table?