Re: [APA] log error after install.php procedure

[centaure d. <cen...@ce...>]

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 ?