RSS

LuxCal Forum

The place for questions, suggestions and news about the LuxCal Event Calendar

User:   Password:   Remember Me?   
LuxCal Forum / General / Problems / MySQL Error
Posted:  17 Jul 2014 21:01
Moin Roel,

i have a small problem with the MySQL database. I can not see my calendar.
It appears an error, look in your MySQL database.

MySQL.log
Script name: /luxcal/index.php
MySQL error: Unknown column 'c.chbox' in 'field list'
Query string: SELECT
        e.s_date AS sda,
        e.e_date AS eda,
        DATE_FORMAT(e.s_time,'%H:%i') AS sti,
        DATE_FORMAT(e.e_time,'%H:%i') AS eti,
        e.r_type AS r_t,
        e.r_interval AS r_i,
        e.r_period AS r_p,
        e.r_month AS r_m,
        e.r_until AS r_u,
        e.notify AS rem,
        e.not_mail AS rml,
        e.a_datetime AS adt,
        e.m_datetime AS mdt,
        e.event_id AS eid,
        e.event_type AS typ,
        e.title AS tit,
        e.category_id AS cid,
        e.venue AS ven,
        e.description AS des,
        e.xfield1 AS xf1,
        e.xfield2 AS xf2,
        e.user_id AS uid,
        e.editor AS edr,
        e.approved AS apd,
        e.private AS pri,
        e.checked AS chd,
        e.x_dates AS xda,
        c.name AS cnm,
        c.approve AS app,
        c.sequence AS seq,
        c.rpeat AS rpt,
        c.color AS cco,
        c.background AS cbg,
        c.chbox AS cbx,
        c.chlabel AS clb,
        c.chmark AS cmk,
        u.user_name AS una,
        u.color AS uco
    FROM [db]events AS e
    INNER JOIN [db]categories AS c ON c.category_id = e.category_id
    INNER JOIN [db]users AS u ON u.user_id = e.user_id
    WHERE e.status >= 0 AND c.public = 1
        AND c.rpeat = 0
        AND e.r_type = 0
        AND ((e.s_date <= '2014-07-27') AND (IF(e.e_date != '9999-00-00', e.e_date, e.s_date) >= '2014-07-14') )
    ORDER BY
        e.s_date


luxcal.log
2014-07-17T13:34:01+02:00
Script name: /luxcal/index.php
invalid GET variable (index.php: logout=y)


Can you help me?

With best regards
eX