Re: [phpesp-general] table creation problem

[Gael J. <jo...@cy...>]

Hi all, 

I downloaded the latest version of phpESP and tried to populate the
tables under mysql, but I invariably get these errors when using the
orginal scripts: 

ERROR 1067 (42000): Invalid default value for 'changed'
ERROR 1067 (42000): Invalid default value for 'changed'
ERROR 1067 (42000): Invalid default value for 'changed'
ERROR 1146 (42S02): Table 'phpesp.realm' doesn't exist
ERROR 1146 (42S02): Table 'phpesp.designer' doesn't exist
ERROR 1067 (42000): Invalid default value for 'changed'
ERROR 1067 (42000): Invalid default value for 'submitted'

Do you have an idea of where it could come from ?

Thanks for your help;

Gael.

ps: here is my test.php
PHP Information

    * Version: 5.1.1-1.dotdeb.2
    * OS: Linux
    * SAPI: apache2handler
    * register_globals: Yes
    * magic_quotes_gpc: Yes
    * magic_quotes_runtime: No
    * safe_mode: No
    * open_basedir:

PHP Extensions

    * dBase: Yes
    * GD: Yes -- bundled (2.0.28 compatible)
    * GNU Gettext: Yes
    * LDAP: Yes
    * MySQL: Yes
    * PHP Extension Dir (compiled): /usr/lib/php5/20050922
    * PHP Extension Dir (run time): /usr/lib/php5/20050922

phpESP Settings

    * Expected ESP_BASE: **************/phpESP/
    * Expected base_url: ***************/phpESP/
    * Loading phpESP.ini.php ...
    * ESP_BASE: /**********/phpESP/
    * base_url: http://***********/phpESP/
    * Version: 1.8
    * Debug: No

phpESP Language Settings

    * GNU Gettext: Real
    * default_lang: en_US
    * current lang: fr_FR
    * available langs: da_DK, de_DE, el_GR, en_US, es_ES, fi, fi_FI,
fr_FR, hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
      (da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
    * GNU Gettext test: Passed
    * Catalog Open Test: Yes

PHP Session Test

    * session.save_path: /var/lib/php5
    * Counter: 4