Embedding calendar in Zencart

[ljdream]

I love the Calendar.
It works and everything is setup.
My issue is that I've embedded it in my Zencart and I get this error info at the bottom of the calendar (see attachment)

This is the error message:
1146 Table 'epc_calendar.layout_boxes' doesn't exist
in:
[select layout_box_name from layout_boxes where layout_box_location=1 and layout_box_status=1 and layout_template ='theme245' order by layout_box_sort_order]

1146 Table 'epc_calendar.sessions' doesn't exist
in:
[select count(*) as total from sessions where sesskey = 'mcok8v5j1k8imo529i9p2o7tg4']

Secondly, along with my error message, my footer dissappears.
I'm really not sure what to do now. I really want to use this calendar, but this issue is driving me crazy

Thanks

[ve9gra]

When embedding the calendar inside of any type of CMS, you have to make sure that the calendar is using the same database as the CMS.

[ljdream]

are you saying that i have to put the epc_calendar as a table in my zencart database?
When I created the calendar, I thought epc_calendar was in it's own little database. please help me understand.

Thanks for your previous quick response!!!! very impressive alertness.

Originally Posted by ve9gra

When embedding the calendar inside of any type of CMS, you have to make sure that the calendar is using the same database as the CMS.

[Brian]

Yes, it will need to use the same DB connection information. Otherwise, you'll end up closing one connection and opening another which can lead to errors.

[ve9gra]

Think of a database as a folder... the calendar doesn't care about its folder.. as long as its file is there. So you're simply putting the calendar's table inside of whichever database you have available, in this case, your zencart DB.

[ljdream]

OOOOOhhhhh, OK, I'm learning!!! That makes total sense. thanks

Originally Posted by Brian

Yes, it will need to use the same DB connection information. Otherwise, you'll end up closing one connection and opening another which can lead to errors.

[ljdream]

OK, I will try it and see what happens,
I will update to let everyone know. I created it's own little epc database. I didn't know you could put it in and existing database.

So the table would be labeled epc_calendar I guess.

Originally Posted by ve9gra

Think of a database as a folder... the calendar doesn't care about its folder.. as long as its file is there. So you're simply putting the calendar's table inside of whichever database you have available, in this case, your zencart DB.

[ljdream]

UPDATE:

IT WORKED

Thank you so much for your support!!!

[ve9gra]

Originally Posted by ljdream

So the table would be labeled epc_calendar I guess.

Exactly. And great

[ljdream]

OK? Quick question...
Currently when I click on the forward/backward buttons, it "refreshes" the complete page.
Is there a way for the calendar to not do that because on my page I have a live video going on and it refreshes back to the beginning everytime the bottom Calendar buttons are clicked.

I can use an IFrame, but the only problem with using it is that I have the mouseover activated and when they mouseover the weekend dates, the Iframe hides most of popup.

[ve9gra]

Look into the AJAX option, but note that it is a beta feature and not fully supported.

[ljdream]

Thanks so much!!!
The Ajax Option Works PERFECTLY!!!!
What Joy!!!

Originally Posted by ve9gra

Look into the AJAX option, but note that it is a beta feature and not fully supported.