Error after adding Escal module to the right column

rooster · 04-07-2005, 10:50 PM

Hello,

There is an error message if I place the Calendar module above other modules, on the right column. In my case, I placed the Calendar above the Polls.

No error message if I place the calendar module right at the bottom.

Perhaps there is a bug in the escal module?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Below is the error message. Instead of showing the Polls, the error message appeared.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Polls

MB DB function failed with error number 1146
Table 'escal.mos_poll_menu' doesn't exist SQL=SELECT p.id, p.title FROM mos_poll_menu AS pm, mos_polls AS p WHERE (pm.menuid='45' OR pm.menuid='0') AND p.id=pm.pollid AND p.published=1
SQL = SELECT p.id, p.titleFROM mos_poll_menu AS pm, mos_polls AS pWHERE (pm.menuid='45' OR pm.menuid='0') AND p.id=pm.pollidAND p.published=1

**Brian** · 04-07-2005, 11:45 PM

FWIW, escal.mos_poll_menu isn't part of the calendar script.

Perhaps Chuck will know what this means?

diske52 · 04-08-2005, 12:11 AM

Sorry I could post sooner.

Well could you please state the live address of your site, and the template that your using.

I think I saw that issue with rhuk_planetfall, I do not believe its an issue with the module, it is an issue with how mambo and the calendar component are bringing down information from different tables in the database and obviously mambo is overlapping escal's. Try switching templates. I should make that common thing to try when an error comes up forum

((It looks like Easy Cal is trying to pull down data, but Mambo's connection for the Polls module is causing a problem with the connection.))

Also, are you using two seperate databases, or did you just add a table to your mambo database for easy calendar? Don't forget to add the address of your site.

its 12:10 (midnight) i'll be on for a bit, then on at 8am Friday morning. Hopefully we can get this done.

rooster · 04-08-2005, 11:03 AM

Hi Brian, Polls is a module on Mambo -- which is why the question was posted in "Mambo Integration" section.

Thanks diske52 for your response.

Quote:

Originally Posted by diske52

Well could you please state the live address of your site, and the template that your using.

Sorry, I am only testing this on a local server, so I can't show you via an URL. The template is sort of customised but the layout is similar to rhuk Solar Flare II and WD Motoryzacja. By the way, I am using Mambo 4.5.2.

Quote:

obviously mambo is overlapping escal's

Or the other way? Escal module codes did not end properly and were overlapping into Polls?

Quote:

Also, are you using two seperate databases, or did you just add a table to your mambo database for easy calendar?

No, just 1 database. I just add the escal module to the right column ("right" module position).

Don't worry about this too much. Go spend some time with your girlfriend.

For the moment, I will just place Escal right at the bottom of all modules on the right column.

Thanks again, diske52. I bought Easy PHP Calendar on your recommendation.

diske52 · 04-08-2005, 03:41 PM

Ah yes, MSAS is a nice way to get things going before you go live.

Well, I do hope you tried a different template, I would like to know if the Polls issue is always going to be a problem ontop of the calendar.

Once i get done working on this mambo-phpshop , online store, I'll take a look at it myself. By the way, if any of you are looking to create an online store, and have transaction-free product transfers, I recommend mambo-phpshop, its essentially mambo with the built in phpshop. I like it better than oscommerce.

And as for the work, I enjoy helping people get the calendar going on mambo, its alot of fun to see people making the most out of their site. But really, Brian has done all the work here, I'm just helping squeeze it into Mambo

Chuck

xpozay · 07-10-2005, 08:01 AM

I am in the process of 'organising' - I am not a coder - a new mambo webiste with PHPShop, SMF, Coppermine and hopefully easyphpcalendar and community builder (of course a few hacks along the way).

Did you get easyphpcaledar working with mambo-phpshop? I am using the latest build 4.5.2.3 ecommerce edition. I was meant to try easyphp today however community builder destroyed my phpshop - just finished a reinstall so will try in the morning (I am in singapore).

sounds like you are doing similar things to me - would love to have a conversation it. probably not appropriate for this forum. you can drop an email through this forum. I have enabled emails.

thanks chris

diske52 · 07-12-2005, 08:50 PM

Hey Guy,

I'll delete these messages afterward, its alright, I now know I should have made a Misc Area.

I would have emailed you but

"Sorry! That user has specified that they do not wish to receive emails. If you still wish to send an email to this user, please contact the administrator and they may be able to help."

So I do not believe you have public emails set on. Also there is a problem with the private msg's right now, I cannot send you one. Anyhow, hit me up on diske52@yahoo.com. And check out www.chuckcourtney.com,

talk to ya soon,
Chuck

ve9gra · 07-13-2005, 06:44 AM

PS: There is no problem with the Private Messaging system. It's been disabled in order to be able to keep better track of support requests with the Ticket System instead of receiving PMs.

diske52 · 07-14-2005, 08:13 PM

:Sheesh: Makes me realize how far I can get behind when I'm not around for a few days. Its alright, I was up north having a beer on the beach thinking....

.oO(ve9gra is totally taking care of the forums with brian's assistance)

AhGratzi ve9Gra

-Chuck

ve9gra · 07-14-2005, 09:22 PM

No problem Chuck... I try to give back to someone who gives plenty (Brian). I still can't beleive I came in when EPC (at that time EasilySimpleCalendar) was at version 3!!!! Ah, the good ol' days

diske52 · 07-14-2005, 10:48 PM

Hah well that beats the heck out of me!

You and I should get a game plan together to create a tutorial with images for different aspects of the calendar with mambo.

There is a few different examples of how we can lay it out.

Maybe even different tutorials with graphics showing how to change css styles, widths of in-module calendars along with modifying templates.

By the way, have you posted your own mambo sites as well? I do not recall seeing it on the "Sites Running Mambo..."

-Chuck

ve9gra · 07-15-2005, 07:27 AM

That's because I've never used Mambo

I'm using Postnuke at the moment and originally came from PHP-Nuke, so I'm taking care of that section. Actually, before I started using pre-built CMS's, I had coded my own and integrated it with PHPBB2 to feed the front page. It's just that with having seen EPC through all the changes, I can (most of the time) integrate it in just about any website. Just have to be a bit creative sometimes

To follow on your idea of having tutorials, maybe we should start an EPC-Community website

diske52 · 07-15-2005, 09:37 AM

Quote:

To follow on your idea of having tutorials, maybe we should start an EPC-Community website

Hah well we could get a domain, easily aquired from Brian or I, but what would it compose? Another forum?

I am thinking seperate webpages / full tutorials with images, doing

1. covering basic integration of the calendar for each CMS. each CMS having its own tutorial.

2. advanced placement of the calendar, as in placement of code directly within templates.

3. appending the current mambo template tutorial for creating your own template within dreamweaver and specifically creating a "block" or "module position" for easy php calendar to be placed.

4. wrappers & their attributes, the actualy files themselves and how they can be modified. such as printable.php

5. Maybe even a more detailed tutorial for non-cms users.?

What are the pro's and con's of doing this on a seperate website?

Pro: Site focuses on support
Pro: Information is easier to find instead of searching forums, asking a question the same way someone else did.

Con: Site may feel alienated from main site.
Con:

Maybe we can speak to Brian about a

cms.easyphpcalendar.com or
tutorials.easyphpcalendar.com, or etc.

I would want each tutorial as a seperate forum category, and the replies that come underneath it would surely refine it. At that point the tutorials could be included within the easy phpcal download package, or put on a appropriate link.

<chug chug> ah this coffee is great, but will our efforts taste as good. whats your thoughts?

-Chuck

**Brian** · 07-15-2005, 11:07 AM

I would be happy to give you a sub domain here and would structure the forums differently if needed.

ve9gra · 07-15-2005, 11:41 AM

Great! Seems like this has some possibility of going forward!

For the subdomain, I don't think having a forum would be of any use. The forum here is doing the job just fine. What I'd like the sub to be is a repository of instructions to integrate the calendar into different CMS's. One CMS per section, with different types (with examples) of integration. Like how to have it in a side block, how to use the TOC in the center module, how to use the altLink in a side block to link to a TOC calendar in the center module... Basically with a blurb of what this does (and why you'd want to use this style) with pictures so they see the final product before they start, and then step by step, how to acheive that final product on their own site.

And then we can just refer to the current forum for if they have any questions.

**Brian** · 07-15-2005, 12:05 PM

When you decide on a name (cms sounds good), just open a support ticket with the name, user name and password to use and I'll set it up.

ve9gra · 07-15-2005, 03:08 PM

Done... And Chuck, do you have an email address I could reach you at so we can coordinate this?

diske52 · 07-15-2005, 07:43 PM

Yes Sir Master Sir, I've got about 12 email address's (rolls cube) email me at

diske52 at yahoo dot com

I've started a road map, so lets talk about that. What are your views on what i've posted above. We should lay it out as we see fit, and knock this baby out.

-Chuck