[BETA] MyCalendar3

[alf007]

Looks like the DB isn't updated...
Any error report?
Have you re-checked the changes made to
includes/acp/acp_forums.php
and
adm/style/acp_forums.html?

[duw]

No error report
Manually put in info to DB, but no display on cal. When I change the table name from phpbb3x_mycalendar to phpbb_mycalendar - get an error then.
Checked both other files and look fine.
Just can't get the Yes value to stick in the ACP. Am really at a loss.

[alf007]

Could you PM me your changed files

adm/style/acp_forums.html,
includes/acp/acp_forums.php,
includes/constants.php,
includes/functions.php,
includes/functions_admin.php


Maybe a typo somewhere or a conflict with another MOD...

[Syberian Alexey]

Hello, alf!
There is a problem, if there are too many events per one day, and/or if they have very long names. There is not enough free space in day cells.

Is there any way to solve this problem? Some kind of small scrollbar or, perhaps, a way to change sizes of cell?
Thank you

[alf007]

Hi!
Interesting point, i didn't thought it may happen for my own usage,
but i add this request to the next features list.

[CyprusTM]

hi i tried to install this and i got the following error

Code: Select all

SQL ERROR [ mysqli ]

Table 'violaonl_forum1.phpbb_mycalendar' doesn't exist [1146]

SQL

SELECT c.*, (cal_interval_units = 'DAY' && cal_interval = 1 && '2009-02-01 00:00:00' = INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date) as block_end, t.topic_title , f.forum_name, (t.forum_id IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)) as cal_read FROM phpbb_mycalendar as c, phpbb_topics as t, phpbb_forums as f WHERE c.forum_id = f.forum_id AND c.topic_id = t.topic_id AND t.forum_id IN (1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16) AND f.enable_events > 0 AND '2009-02-01 00:00:00' >= cal_date AND ( cal_repeat = 0 OR ( cal_repeat > 0 AND ( (cal_interval_units = 'DAY' AND ('2009-02-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date)) OR (cal_interval_units = 'WEEK' AND ('2009-02-01 00:00:00' <= INTERVAL ((cal_interval * (cal_repeat - 1)) * 7) DAY + cal_date)) OR (cal_interval_units = 'MONTH' AND ('2009-02-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) MONTH + cal_date)) OR (cal_interval_units = 'YEAR' AND ('2009-02-01 00:00:00' <= INTERVAL (cal_interval * (cal_repeat - 1)) YEAR + cal_date)) ) ) ) AND ( ( cal_interval_units = 'DAY' AND (TO_DAYS('2009-02-01 00:00:00') - TO_DAYS(cal_date)) % cal_interval = 0 ) OR ( cal_interval_units = 'WEEK' AND (TO_DAYS('2009-02-01 00:00:00') - TO_DAYS(cal_date)) % (7 * cal_interval) = 0 ) OR ( cal_interval_units = 'MONTH' AND DAYOFMONTH(cal_date) = DAYOFMONTH('2009-02-01 00:00:00') AND PERIOD_DIFF(DATE_FORMAT('2009-02-01 00:00:00', '%Y%m'), DATE_FORMAT(cal_date, '%Y%m')) % cal_interval = 0 ) OR ( cal_interval_units = 'YEAR' AND DATE_FORMAT(cal_date, '%m%d') = DATE_FORMAT('2009-02-01 00:00:00', '%m%d') AND (YEAR('2009-02-01 00:00:00') - YEAR(cal_date)) % cal_interval = 0 ) ) ORDER BY cal_interval_units ASC, cal_date ASC, cal_repeat DESC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: mini_calendar.php
LINE: 270
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 28
CALL: include('mini_calendar.php')

[alf007]

Have you done the SQL part action

Code: Select all

CREATE TABLE phpbb_mycalendar(...

(from the MyCalendar3_install.xml)

[CyprusTM]

yep, sorry figured it out afterwards.

now however i do not know how to add events. it does not show anywhere on my ACP. il keep looking

thank you for your reply

[alf007]

I've added a summary of normal usage steps, on the first post of this topic

[CyprusTM]

ok followed this step

in ACP/Manage forums/ click on a forum /Edit/General forum settings/Enable Events for Calendar on Yes


however it does not show Enable Events For Calendar = Yes

its not there