wasimshaikh / php-calendar

Automatically exported from code.google.com/p/php-calendar
1 stars 0 forks source link

Install fails with SQL error beta 10 #102

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. unzip
2. upload
3. installer

What is the expected output? What do you see instead?

***
Software Error
Message:

Error creating logins table.
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near '`atime` timestamp NOT 
NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`uid`, `seri' at line 5
SQL query: CREATE TABLE `phpc_logins` (
`uid` int(11) unsigned NOT NULL,
`series` char(43) collate utf8_unicode_ci NOT NULL,
`token` char(43) collate utf8_unicode_ci NOT NULL
`atime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`uid`, `series`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

Backtrace

    /var/www/events.de/install/install.php:582 - soft_error
    /var/www/events.de/install/install.php:630 - db_error
    /var/www/events.de/install/install.php:449 - create_logins_table
    /var/www/events.de/install/install.php:387 - create_tables
    /var/www/events..de/install/install.php:74 - install_base

***

What version of the product are you using? On what operating system?

***
Linux  2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64 GNU/Linux

Apache/2.2.16 (Debian) Server 
***

Please provide any additional information below.

Original issue reported on code.google.com by mo...@atinar.de on 26 Aug 2012 at 7:23

GoogleCodeExporter commented 9 years ago
That is the installer from the development version. I haven't gotten around to 
testing it yet. I just committed a change to fix your issue.

Original comment by sproctor@gmail.com on 26 Aug 2012 at 8:36