Page 1 of 1

[solved]Mini cal block for IM Portal Debug Mode

PostPosted: Sun Mar 02, 2008 3:30 pm
Author: Coroner
Your phpBB Version: 2.0.23
phpBB Type: phpBB / IMPortal
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: http://cscoroner.com/phpbb2/index.php

PHP Version:
MySQL Version: 4.1.20-max-log


What was done before the problem appeared?
Installed IM Portal, AdvBBCodeIMPortal and then Mini cal block for IM Portal


What was done to try to solve the problem?
Checked the data base to make sure it exists, insured all files are located in the correct areas. Checked all mod codes for Calite and Mini Cal.



De.scription and Message

First and foremost, thank you folks for such a great mod. Installs easy and works great.

How ever I have hit a wall with this ad on and am in need of assistance. If you go to my board you can see that I have the Mini Cal planted in the forums main index temporarily so you can verify that it and Calite are working just fine. But for some reason and I'm sure it's something simple that I'm just over looking I am getting the follow error.

Please keep in mine that calite and mini cal are working and there is a data base table phpbb_calendar.

Here the error:

Could not get data for events

DEBUG MODE

SQL Error : 1146 Table 'XXXXXX_forums.calendar' doesn't exist

SELECT c.id, c.stamp, c.eventspan, c.subject, MONTH(c.stamp) as cal_month, DAYOFWEEK(DATE_SUB(c.stamp, INTERVAL 0 DAY)) as cal_weekday, DAYOFMONTH(c.stamp) as cal_monthday, YEAR(c.stamp) as cal_year, HOUR(c.stamp) as cal_hour, MINUTE(c.stamp) as cal_min, SECOND(c.stamp) as cal_sec, MONTH(c.eventspan) as cal_month_end, DAYOFWEEK(DATE_SUB(c.eventspan, INTERVAL 0 DAY)) as cal_weekday_end, DAYOFMONTH(c.eventspan) as cal_monthday_end, YEAR(c.eventspan) as cal_year_end FROM calendar as c WHERE ((c.stamp >= CURDATE()) OR (CURDATE() <= c.eventspan)) AND (c.stamp <= DATE_ADD(CURDATE(), INTERVAL 7 DAY)) ORDER BY c.stamp ASC LIMIT 0,2

Line : 170
File : mini_cal_SNAILLITE.php

Can you please tell me just what I've done wrong so I can activate the block and remove the original.

Thank you for all your efforts and support.

OOPS! I forgot that you need to log in to see the calendar.

ID=Test
Password=654321

Please help with this......

Re: Mini cal block for IM Portal Debug Mode

PostPosted: Wed Mar 05, 2008 9:44 pm
Author: Coroner
OK. The calendar shows up and functions to guests? Anyone who logs in IE: Admin, mod, members etc; loses the whole right side to the debug message?

Can someone please give me some direction with this.......

Re: Mini cal block for IM Portal Debug Mode

PostPosted: Thu Mar 06, 2008 12:27 am
Author: Helter
the minical block by itself is not a mod. It only displays the calendar mod. Have you installed these?
http://www.integramod.com/forum/viewtop ... ght=#31745

Re: Mini cal block for IM Portal Debug Mode

PostPosted: Thu Mar 06, 2008 2:20 am
Author: Coroner
Thanks for the reply and yes. I have had calite for a long time.

Problem is solved for the most part but it wasn't line 170. There's a line in the mini_cal_SNAILLITE.php above that:

" . CAL_TABLE . " as c and I changed it to:
" . php_calendar . " as c and it hooked.

The only position where it won't appear is footer?

Now I'd like to plant it on the forums page next to the who is online colum. Any ideas?

Thanks again for you help and support

Re: Mini cal block for IM Portal Debug Mode

PostPosted: Thu Mar 06, 2008 8:34 am
Author: Helter
its been awhile since i messed around with theses mods, but if I think you need to install 2.0.3.zip to get the block and calendar to play nice together

Re: Mini cal block for IM Portal Debug Mode

PostPosted: Thu Mar 06, 2008 8:24 pm
Author: Coroner
Haven't tested it yet but sounds like a good idea. I don't think postions would affect it no?

Anyhow,
Thanks for the advise.