Jump to content
Sign in to follow this  
FastEddy

Event Calender

Recommended Posts

For anyone installing the most current version of this contribution, there are several files that don't have carriage returns in the file. The code/CSS/etc. is all run together. That's what causes the parse error on line 1. Open up the files with FrontPage, Word, or something that will parse the file and then copy it up to your host.

It's that way because they copied the files directly off a UNIX server.

 

It because of the way different operating systems handle text files.

 

On Windowz each line is terminated by a <cr><lf> (carriage return, line feed) combination.

 

On UNIX each line is terminated by a <lf> (line feed) only.

 

If you download files from your server and open them with Notepad they might be all "run togther".

 

However, if you open the same file with Wordpad (NOT WORD!) you don't have that problem. It doesn't seem to care, but Notepad does.

 

I use Crimson Editor (it's free - Google it if interested, it's a nice "tabbed" editor). It doesn't care how the lines end either.

 

I can't help with the contribution, but I thought I'd toss that out...

;)


If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Share this post


Link to post
Share on other sites

That's okay if you can't help with the other. This is good information for someone down the line that installs the contribution.

Thanks, germ.

Share this post


Link to post
Share on other sites
For anyone installing the most current version of this contribution, there are several files that don't have carriage returns in the file. The code/CSS/etc. is all run together. That's what causes the parse error on line 1. Open up the files with FrontPage, Word, or something that will parse the file and then copy it up to your host.

 

I installed this contribution on RC2 and it works fine. I found one minor bug, if anyone has any thoughts. When looking at the dropdown for events, it doesn't include the event if it starts on today's date. I looked at the select, but didn't see the problem offhand.

 

If you want to look at the code see:

 

http://injewelrynow.com/events_calendar.php?view=all_events

 

Or here is the original PHP code:

 

<?php
/*
 $Id: events_calendar v2.00 2003/06/16 18:09:20 ip chilipepper.it Exp $
 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]
 Copyright © 2003 osCommerce
 Released under the GNU General Public License
*/

require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_EVENTS_CALENDAR);

define('SECTION', NAVBAR_TITLE);  

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_EVENTS_CALENDAR, '', 'NONSSL'));

//add breadcrumb for requested 
if(isset($single_event) || $HTTP_GET_VARS['select_event'])
{
   $navbarEventTitle = NAVBAR_EVENT_TITLE_DETAIL;
}
else if($HTTP_GET_VARS['year_view'] == 1)
{
   $navbarEventTitle = NAVBAR_EVENT_TITLE_YEAR;
}
else if($HTTP_GET_VARS['_day'])
{
   $navbarEventTitle = NAVBAR_EVENT_TITLE_DAY;
}
else if($HTTP_GET_VARS['view'] == 'all_events')
{
   $navbarEventTitle = NAVBAR_EVENT_TITLE_ALL;
}
else
{
   $navbarEventTitle = NAVBAR_EVENT_TITLE_MONTH;
}
$breadcrumb->add($navbarEventTitle, $HTTP_SERVER_VARS["REQUEST_URI"], '', 'NONSSL');

$i =1;
$cal = new Calendar;
$cal->setStartDay(FIRST_DAY_OF_WEEK);
$this_month = date('m');
$this_year = date('Y');

if ($HTTP_GET_VARS['_month']) 
{
   $month = $_month;
   $year = $_year;
   $a = $cal->adjustDate($month, $year);
   $month_ = $a[0];
   $year_= $a[1];
}
else
{
   $year = $this_year;
   $month = $this_month;
   $yeventear_= $year;
   $month_= $month;
   $year_= $year;
}
if($HTTP_GET_VARS['_day'])
{
   $ev_query = tep_db_query("select event_id from " . TABLE_EVENTS_CALENDAR 
       . " where DAYOFMONTH(start_date)= '" . $_day . "' and MONTH(start_date) = '" . $_month 
       . "' and YEAR(start_date) = '" . $_year . "' AND language_id = '" . $languages_id . "'");
   if(tep_db_num_rows($ev_query) == 1)
   {
       $ev = tep_db_fetch_array($ev_query);
       $single_event = true;
       $select_event = $ev['event_id'];
   }
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML <?php echo HTML_PARAMS; ?>>
<HEAD>
   <TITLE><?php echo TITLE . ' - ' . NAVBAR_TITLE; ?></TITLE>
   <META http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<META name="KeyWords" content="">
<META name="Description" content="">
   <BASE href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
   <LINK rel="stylesheet" type="text/css" href="stylesheet.css">
   <LINK rel="shortcut icon" href="favicon.ico" >
   <LINK rel="icon" href="favicon.ico" >    
</HEAD>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?> " valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?> " cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </td></tr></table>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
        <!-- Take out the extra header and put in a link to all events -->
         <tr>
            <td align=center><a href="http://www.injewelrynow.com/events_calendar.php?view=all_events"><font size=2 face=verdana>CLICK HERE TO SEE ALL EVENTS</font></td>
               </tr> 
                <!-- LJ add missing row -->
                      <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
                      </tr>
                <!-- add calendar LJ -->
                  <tr><td>
                  <?php require(DIR_WS_BOXES . 'calendar.php'); ?>
                  </td></tr>
               <!-- LJ add a blank line -->
                      <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
                      </tr>
               <tr>
                   <td  class="main" nowrap align=center>
                   <?php
                       echo tep_draw_form('goto_event', FILENAME_EVENTS_CALENDAR, '', 'get');
                       $ev_query = tep_db_query("select *, DAYOFMONTH(start_date) AS day, MONTH(start_date) AS month, YEAR(start_date) AS year"
                           . " from " . TABLE_EVENTS_CALENDAR 
                           . " where start_date >= '" . date('Y-m-d H:i:s') . "' and language_id = '" . $languages_id . "'"
                           . " order by start_date");
                       if(tep_db_num_rows($ev_query) > 0)
                       {
                           $event_array[]  = array('id' => '', 'text' => TEXT_SELECT_EVENT);
                           while ($q_events = tep_db_fetch_array($ev_query))
                           {
                               $year = $q_events['year'];
                               $month = $q_events['month'];
                               $day = $q_events['day'];
                               $event_array[] = array('id' => $q_events['event_id'], 'text' => $cal->monthNames[$month - 1] . ' ' . $day . ' -> ' . $q_events['title']);
                           }
                           echo tep_draw_pull_down_menu('select_event', $event_array, NULL, 'onChange="(this.value != \'\') ? this.form.submit() : \'\' " ;', $required = false);
                       }
                   ?>
                   </form>
                   </td>
               </tr>
           </table>
       </td>
   </tr>
   <tr>
       <td>
<?php
$dateDisplayFormat = "F d, Y";

if(isset($single_event) || $HTTP_GET_VARS['select_event'])
{   //Show Details of a single event.
   $events_query = tep_db_query("select *, DAYOFMONTH(start_date) AS event"
       . " from " . TABLE_EVENTS_CALENDAR 
       . " where event_id = '" . $select_event . "' and language_id = '" . $languages_id . "'");

   while($events = tep_db_fetch_array($events_query))
   {
       list($year, $month, $day) = split ('[/.-]', $events['start_date']);
       $date_start = date($dateDisplayFormat, mktime(0,0,0,$month,$day,$year));
?>
       <?php
       if($events['end_date'])
       {
           list($year_end, $month_end, $day_end) = split ('[/.-]', $events['end_date']);
           $date_end = date($dateDisplayFormat, mktime(0,0,0,$month_end,$day_end,$year_end));
       }
       $event_array = array('id' => $events['event_id'],
                            'title' => $events['title'],
                            'image' => $events['event_image'],
                            'description' => $events['description'],
                            'first_day' => $date_start,
                            'last_day' => $date_end,
                            'OSC_link' => $events['OSC_link'],
                            'link' => $events['link']);
       $clsp = 2;
?>
<!-- LJ add a blank line and move the header down -->
       <?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>


           <table width="100%" cellspacing="0" cellpadding="4" class="event_description">
             <tr><td>
             <?php echo $events['title']?>
             </td></tr>
               <tr>
                   <td class="event_header_dates" nowrap>
                       <?php 
                           if($event_array['last_day'])
                           {
                               echo '<b>' . TEXT_EVENT_START_DATE . '</b>';
                           }
                       ?>
                         <?php echo $event_array['first_day'];?>
                   </td>
<?php
       if($event_array['last_day'])
       {
?>
                   <td class="event_header_dates" nowrap>
                       <b><?php echo TEXT_EVENT_END_DATE;?></b>  <?php echo $event_array['last_day'];?>
                   </td>
<?php
           $clsp++;
       }
?>
                   <td width="100%" class="event" nowrap> </td>
               </tr>
               <tr>
                   <td colspan="<?php echo $clsp;?>" class="event_description">
                      <?php
       if ($event_array['image'])
       {
?>
                       <table border="0" cellspacing="0" cellpadding="0" align="right">
                           <tr>
                               <td class="main">
                                   <?php echo tep_image(DIR_WS_IMAGES .'events_images/' . $event_array['image'], $event_array['title'], '', '', 'align="right" hspace="5" vspace="5"');?>
                               </td>
                           </tr>
                       </table>
<?php
       }
       echo stripslashes($event_array['description']);
?>
                   </td>
<?php
       if($event_array['OSC_link'])
       {
?>
               </tr>
               <tr>
                   <td colspan="<?php echo $clsp;?>"  align="left" class="event_header">
                       <?php echo TEXT_EVENT_OSC_LINK;?>  
                       <a href="<?php echo $event_array['OSC_link'];?>">
                           <?php echo $event_array['OSC_link'];?>
                       </a>
                   </td>
<?php
       }
       if($event_array['link'])
       {
?>
               </tr>
               <tr>
                   <td colspan="<?php echo $clsp;?>" align="left" class="event_header">
                       <?php echo TEXT_EVENT_LINK;?>  
                       <a href="http://<?php echo $event_array['link'];?>" target="_blank">
                           <?php echo $event_array['link'];?>
                       </a>
                   </td>
<?php
       }
?>
               </tr>
           </table>
<?php
   }

   //Show all other events for the same day or during the duration of the selected event.
   $beginDay = $year . '-' . $month . '-' . $day;
   $endDay = $year_end . '-' . $month_end . '-' . $day_end;
   $other_events_query = tep_db_query("select *, DAYOFMONTH(start_date) AS event from ". TABLE_EVENTS_CALENDAR 
       . " where ( (start_date BETWEEN '" . $beginDay . "' and '". $endDay . "')"
       . "			or (end_date BETWEEN '" . $beginDay . "' and '" . $endDay . "')" 
       . "         or ( (start_date <= '" . $beginDay . "' and start_date <= '" . $endDay . "')" 
       . "             and (end_date >= '" . $beginDay . "' and end_date >= '" . $endDay . "') ) )" 
       . " and language_id = '" . $languages_id . "' and event_id != '" . $select_event 
       . "' order by start_date");
   if (tep_db_num_rows($other_events_query) > 0) 
   {
?>
            <h3><?php echo TEXT_OTHER_EVENTS;?></h3>
           <table border="0" width="100%" cellspacing="0" cellpadding="2" class="event_header">

<?php
       while ($other_events = tep_db_fetch_array($other_events_query))
       {
           $event_array = array('id' => $other_events['event_id'],
                                'event' => $other_events['event'],
                                'title' => $other_events['title']);
?>
               <tr>
                   <td align="center" width="24" class="event_header" nowrap>
                       <b><?php echo $i; ?></b>
                   </td>
                   <td width="100%" class="event">
                       <a href="<?php echo FILENAME_EVENTS_CALENDAR;?>?select_event=<?php echo $event_array['id'];?>">
                           <?php echo $event_array['title'];?>
                       </a>
                   </td>
               </tr>
<?php
           $i++;
       }
?>
           </table>
<?php
   }
}
elseif($HTTP_GET_VARS['year_view'] == 1)
{   //Show the full year view.
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="0">
               <tr>
                   <td><?php echo $cal->getYearView($year_); ?></td>
               </tr>
           </table>
<?php
}
elseif($HTTP_GET_VARS['_day'])
{   //Show all Events for the specified date.
   $events_query_raw = "select *, DAYOFMONTH(start_date) AS event from " . TABLE_EVENTS_CALENDAR
   	. " where '" . $_year . "-" . $_month . "-" . $_day . "' BETWEEN start_date and end_date" 
       . " and language_id = '" . $languages_id . "' order by start_date";

   $listingTitle = date($dateDisplayFormat, mktime(0, 0, 0, $_month, $_day, $_year));
   $displayPagingSuffix = $listingTitle;
   require(DIR_WS_MODULES . 'events_calendar_listing.php');
}
else if($HTTP_GET_VARS['view'] == 'all_events')
{   //Show all Events from current date.
   $events_query_raw = "select *, DAYOFMONTH(start_date) AS event from " . TABLE_EVENTS_CALENDAR 
       . " where (start_date >= '" . date('Y-m-d H:i:s') . "' or end_date >= '" . date('Y-m-d H:i:s') . "')"
       . " and language_id = '" . $languages_id . "' order by start_date";

   $listingTitle = 'All Events';
   $displayPagingSuffix = NULL;
   require(DIR_WS_MODULES . 'events_calendar_listing.php');
}
else
{   //Show All Events for the current or specified month/year
   $events_query_raw = "select *, DAYOFMONTH(start_date) AS event from " . TABLE_EVENTS_CALENDAR 
       . " where ((MONTH(start_date) = '" . $month_ . "' and YEAR(start_date) = '" . $year_ . "')"
       . "        or (MONTH(end_date) = '" . $month_ . "' and YEAR(end_date) = '" . $year_ . "'))"
       . " and language_id = '" . $languages_id . "'  order by start_date";

   $months = $cal->monthNames[$month_ - 1];

   $listingTitle = $months . ' ' . $year_;
   $displayPagingSuffix = $listingTitle;
   require(DIR_WS_MODULES . 'events_calendar_listing.php');
}
?>
       </td>
   </tr>
</table>
</td>
<!-- body_text_eof //-->
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</BODY>
</HTML>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

Thanks in advance. :rolleyes:

 

 

Hi Lillian,

Let me preface by saying that I am just passing through quickly at the '50,000' level snooping for a project. I am actually looking to incorporate something similiar to what you have done (nice BTW) as a drop down shipping option.

The option is for the web customer to select a local pick up (no delivery or delivery charge) as indicated by a given event location and subsequent date.

 

Do you offer something similiar with your store?

 

At any rate, I have not looked close at the code and must run, but I would find where it is setting <today> so as not to include past events and subtract 1. from it. Literally.... [some variable]= [some date variable] -1.

 

Crude I know, but I think you can get the idea. I will look again later.

 

Greg

Share this post


Link to post
Share on other sites
Hi Lillian,

Let me preface by saying that I am just passing through quickly at the '50,000' level snooping for a project. I am actually looking to incorporate something similiar to what you have done (nice BTW) as a drop down shipping option.

The option is for the web customer to select a local pick up (no delivery or delivery charge) as indicated by a given event location and subsequent date.

 

Do you offer something similiar with your store?

 

At any rate, I have not looked close at the code and must run, but I would find where it is setting <today> so as not to include past events and subtract 1. from it. Literally.... [some variable]= [some date variable] -1.

 

Crude I know, but I think you can get the idea. I will look again later.

 

Greg

 

 

Hi again Lillian,

In \catalog\events_calendar.php (+/-) line 115 be certain that start_date is represented as 'greater than or equal to' as is in the below code...

 

. " where start_date >= '" . date('Y-m-d H:i:s') . "' and language_id = '" . $languages_id . "'"

 

Hope that helps. Now to my own issues ;)

 

Greg

Share this post


Link to post
Share on other sites

I am curious...

 

1) Is this forum really as dead as it appears? No lurkers even?

 

2) Granted I am not just talking to myself, has anybody addressed the issue of loosing the osCsid while navigating through events?

 

 

Event Cal is a great tool, surprised it is not used more.

Share this post


Link to post
Share on other sites

I have installed the eurolife 2 May 2007 release of the Events Calendar on RC2A.

 

When I try to add the related product link:

 

I select a manufacturer, as soon as i select it, it disappears.

I then select a category, that sticks.

Then a product and it remains in the form but my link does not changes.

 

I need the OSC link to go to the products page rather than the category.


What would you do if you knew you could not fail?

Share this post


Link to post
Share on other sites

Is there anone out there that can help me with this? i need the link to go to the product rather than the category. Thank you

 

I have installed the eurolife 2 May 2007 release of the Events Calendar on RC2A.

 

When I try to add the related product link:

 

I select a manufacturer, as soon as i select it, it disappears.

I then select a category, that sticks.

Then a product and it remains in the form but my link does not changes.

 

I need the OSC link to go to the products page rather than the category.


What would you do if you knew you could not fail?

Share this post


Link to post
Share on other sites

Has anyone got htis thing working for OSC 2.2 RC2 yet? I followed the directions to a TEE and it was a big pile of failure. May be cause I'm using STS? Either way, has anyone created an events calendar that DOES work for OSC? I could really use one!

Share this post


Link to post
Share on other sites

There are some serious issues with the event calendar. There are a lot of variables used which are never initialized. There are also a lot of other variables in particular the post variables which are never properly checked. There are a lot of redundant variables used in two different places for the same thing. There are also variables that are set on one place and reinitialized to another value when a local variable should be declared and used. This application is very unstable and buggy. I causes periodic changes to random months or month that are several years in the past. I have reworked the problem code to put in proper checks. Someone need to look over the app for these issues.

Share this post


Link to post
Share on other sites
There are some serious issues with the event calendar. There are a lot of variables used which are never initialized. There are also a lot of other variables in particular the post variables which are never properly checked. There are a lot of redundant variables used in two different places for the same thing. There are also variables that are set on one place and reinitialized to another value when a local variable should be declared and used. This application is very unstable and buggy. I causes periodic changes to random months or month that are several years in the past. I have reworked the problem code to put in proper checks. Someone need to look over the app for these issues.

 

 

"Someone need to look over the app for these issues."

 

Sounds like you have already. How about sharing it in the contributions area?

 

 

Speaking of which...

 

We do (2) in town, one day events a week (same place), and (1) out of town, four day event a month (different places). The four day event is sporadically scheduled and knocks out one weekly event a month. Warehouse pick-ups are always welcomed but not a preferred or predominant means.

 

I patched the 'drop down' event selector functionality and a store pick-up delivery option into my shipping choices so as to pass the event and date(s) through the entire order process. It is dynamically tied to the Events Calendar so as to eliminate duplication. Manage the calendar, event pick-up dates / locations stay managed as well.

 

It is rough yet and requires a little polishing, but if anybody is interested I will focus on getting at least what I have posted. At least some instructions. I would like to tie it all together better, particularly getting the actual functionality of the drop down selector into the shipping module. It does all work though now.

 

 

Also, if you are noticing that your events are not showing past midnight the day of, remove the time variables from the queries so that it looks something like this ...

. " where start_date >= '" . date('Y-m-d') .

Share this post


Link to post
Share on other sites

hi everyone.. I have a shop www.alcova.biz and I've been using the calendar in the past.

lately my provider has upgraded to mysql 5 and today I just realized that the event manager doesn't insert new events.

 

can someone help me sort this problem out?

Share this post


Link to post
Share on other sites

keeps going to december

Hi all,

when I click on an event and also in the forward an bacward arrows it keeps me to December.

 

Any suggestion?

 

Thanks

Share this post


Link to post
Share on other sites
keeps going to december

Hi all,

when I click on an event and also in the forward an bacward arrows it keeps me to December.

 

Any suggestion?

 

Thanks

 

 

solved,

just added this line in .htaccess

 

php_value register_globals "on"

Share this post


Link to post
Share on other sites
solved,

just added this line in .htaccess

 

php_value register_globals "on"

 

 

That still doesn't solve the problem. If it requires Register Globals to be on, then there are a lot of serious problems which need to be resolved. Most hosts I've dealt with in the past (including my current one) will not allow register globals on, as it presents security risks. Has anybody come up with a real fix for this contribution, or know of any other alternatives???

Share this post


Link to post
Share on other sites
That still doesn't solve the problem. If it requires Register Globals to be on, then there are a lot of serious problems which need to be resolved. Most hosts I've dealt with in the past (including my current one) will not allow register globals on, as it presents security risks. Has anybody come up with a real fix for this contribution, or know of any other alternatives???

 

 

Nevermind ..... I found a better and safer solution .... The Google Calendar contribution - http://addons.oscommerce.com/info/6601

 

very few changes to be made and no security flaws.

Share this post


Link to post
Share on other sites

Nevermind ..... I found a better and safer solution .... The Google Calendar contribution - http://addons.oscommerce.com/info/6601

 

very few changes to be made and no security flaws.

 

 

Hi there,

 

Would you mind sharing the "few" changes you have made to the google calender contribution.

 

Would be verry appreciated.

 

Thanx,

 

bert

Share this post


Link to post
Share on other sites

Hello everybody I'm riding my shop and put the calendar is giving some errors like error to make the calendar work correctly, good

1. Once I click on the error or Calendar Month Event At The Top, it's this error:

 

78835065.th.gif

 

2. When I go to add something to the Calendar has these errors ....

img1

61929918.th.gif

 

2.2 When I go select some Makers he does not select anything, when I select any category it appears the product column as shown in second image

 

Img 2

38473772.th.gif

 

3. When I when I put it INICIO change screen, then it appears the Insert button click on it and this error:

58646669.th.gif

 

Please can anyone help me?

 

I'm new and do not know much PHP

and I apologize for my English because I used the Google translator!

Share this post


Link to post
Share on other sites

Hi Regarding the google calendar add on, does any one use it, did you have to make any changes, link to a site that uses it would be good to see it first, Thanks Phil

Share this post


Link to post
Share on other sites

Hey Ya'll I've been trying to get this contribution up for the last thre days, I keep getting the

 

1146 - Table 'testzhe.TABLE_EVENTS_CALENDAR' doesn't exist

 

error. I'm running oscommerce 2.2RC2a. On the admin side eeverythng works perfectly, but when I look at the webpage the calendar doesn't show up and and the event page pretty much the same error appears

Events Calendar

 

1146 - Table 'testzhe.TABLE_EVENTS_CALENDAR' doesn't exist

 

select *, DAYOFMONTH(start_date) AS day, MONTH(start_date) AS month, YEAR(start_date) AS year from TABLE_EVENTS_CALENDAR where start_date >= '2011-05-04 08:55:38' and language_id = '1' order by start_date

 

[TEP STOP]

. Could someone tell me what I'm doing wrong I installed 2 may 2007 version. I've tried reinstalling the DB table aswell. I'd really appreaciat any insight ya'll can share.

Share this post


Link to post
Share on other sites

Hey Ya'll I've been trying to get this contribution up for the last thre days, I keep getting the

 

1146 - Table 'testzhe.TABLE_EVENTS_CALENDAR' doesn't exist

 

error. I'm running oscommerce 2.2RC2a. On the admin side eeverythng works perfectly, but when I look at the webpage the calendar doesn't show up and and the event page pretty much the same error appears

Events Calendar

 

1146 - Table 'testzhe.TABLE_EVENTS_CALENDAR' doesn't exist

 

select *, DAYOFMONTH(start_date) AS day, MONTH(start_date) AS month, YEAR(start_date) AS year from TABLE_EVENTS_CALENDAR where start_date >= '2011-05-04 08:55:38' and language_id = '1' order by start_date

 

[TEP STOP]

. Could someone tell me what I'm doing wrong I installed 2 may 2007 version. I've tried reinstalling the DB table aswell. I'd really appreaciat any insight ya'll can share.

 

 

NVM I just realized some code was placed in the wrong area.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×