Create DB table

[msanchez]

i've downloaded the contribution events_calendar (http://www.oscommerce.com/community/contributions,1061) and installed/modified all files. However, i'm stuck on how to create DB table for "events_calendar". Could anyone help out in a step by step process of creating a DB?

 

thanks

[msanchez]

here's our store link to see the error i'm getting with events_calendar

would appreciate any help, thanks!

 

http://healthylifespan.com/catalog/

[TomThumb]

Use phpMyAdmin. There is usually a link from the webhosts control panel.

 

Some versions have a query window, on some you have to click on the SQL tab, either way you should get a window with

 

Run SQL query/queries on database <yourdatebase name>

 

Paste

DROP TABLE IF EXISTS events_calendar;
CREATE TABLE events_calendar (
event_id int(3) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
start_date date NOT NULL default '0000-00-00',
end_date varchar(20) default NULL,
title varchar(255) default NULL,
event_image varchar(64) default NULL,
link varchar(255) default NULL,
OSC_link varchar(255) default NULL,
description text,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (event_id,language_id)
) TYPE=MyISAM;

 

into that window and click on GO.

 

Thats it.

[msanchez]

Thanks TomThumb!

I got the calendar to show but now the buttons are not working.

I'm getting this error now:

 

Fatal error: Call to a member function on a non-object in /home/hsphere/local/home/healthy/healthylifespan.com/catalog/events_calendar.php on line 13

 

Don't understand? help.