Re: [APA] log error after install.php procedure
Brought to you by:
charchi
|
From: centaure d. <cen...@ce...> - 2003-08-06 17:44:40
|
sorry, i forgot : i'm using the latest version of atomic : 1.0.5 --Original Message Text--- From: centaure domain Date: Mon, 04 Aug 2003 21:49:11 +0200 Hi all, I've tried to install atomic. but i think i've got a problem with install .php : see log file My system : mandrake 9.1 php 4.3.1 Mysql 4.0.1 Trying to connect to database server : OK! Trying to select database : The database photo_db does not exist, trying to create it : OK! Creating tables Creating table apa_config : OK! Creating table apa_users : OK! Creating table apa_albums : Can't create table CREATE TABLE apa_albums( name varchar(255) not null, path varchar(255) not null, nb_photos mediumint unsigned, nb_comments int unsigned not null, nb_views int unsigned not null, time timestamp, check tinyint unsigned DEFAULT '0', ID smallint unsigned not null auto_increment, PRIMARY KEY(ID) )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 'tinyint unsigned DEFAULT '0', ID smallint unsigned not Creating table apa_photos : OK! Creating table apa_comments : OK! Creating table apa_viewsbuffer : OK! Creating table apa_commentsbuffer : OK! Creating table apa_searchindex : OK! Adding administrator root : OK! Creating first album sardaigne : Can't create first album any idea ? |