error executing query

  • RGehrig

    RGehrig - 2012-07-29

    Running Apache 2.2.4 and PHP 5.1.5 and WebCalendar 1.2.5
    Successfully installed and it tested the MySQL database connection as OK.
    Tried to login as administrator and I get the following error.
    The SQL statement was displayed by echoing $sql in dbi4php.php at line 378.

    Here is the display
    SELECT cal_value FROM webcal_config
           WHERE cal_setting = 'WEBCAL_PROGRAM_VERSION'SELECT COUNT( cal_value ) FROM webcal_configSELECT cal_login, cal_passwd FROM webcal_user WHERE cal_login = 'admin'SELECT cal_value FROM webcal_config
          WHERE cal_setting = 'PUBLIC_ACCESS'SELECT cal_firstname, cal_lastname, cal_is_admin, cal_email, cal_passwd, cal_enabled FROM webcal_user WHERE cal_login = 'admin'SELECT cal_setting, cal_value
        FROM webcal_configSELECT cal_setting, cal_value
        FROM webcal_user_pref WHERE cal_login = 'admin'SELECT cal_view_id, cal_name, cal_view_type,
        cal_is_global, cal_owner FROM webcal_view WHERE cal_owner = 'admin'  OR cal_is_global = 'Y' ORDER BY cal_nameSELECT * FROM webcal_asst
        WHERE cal_assistant = 'admin'SELECT cal_permissions FROM webcal_access_function
          WHERE cal_login = 'admin'SELECT cal_permissions FROM webcal_access_function
          WHERE cal_login = '__default__'<h2>Error</h2>
    <!-begin_error (dbierror)->
    Error executing query.

    Not sure what is going on. This was an upgrade from 1.2.4 that was working OK.

  • RGehrig

    RGehrig - 2012-07-31

    More information.

    Got to the same point with Apache 2.4.2 and PHP 5.4.3

    The MySQL back end is 5.0.33.

  • RGehrig

    RGehrig - 2012-08-04

    I found the problem, turned on MySQL trace in php.ini and found I had a problem in my MySQL setup.
    Had a wrong tmp directory. Fixed that and it now works.
    Will fix timezone issue I see here as well.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks