#7 Can't install bug (not related to 'when' keyword)

[Werner KLINGER]

same/similar issue using the latest (Dec2000) PHP4 / MySQL / Apache trio under Win32 (at home)
But also using the proven hosting free.fr (proxad.fr / online.fr ), account http://mydb.free.fr/test/MOT-2/
Free.fr server settings:
PHP Version 3.0.16
Mysql Version 3.22.30
Apache/1.3.9 (Unix) Debian/GNU mod_perl/1.21_03-dev

When trying to install (regardless of with or without the patch), I get the following message:

==
MOT Setup Results

MOT Home

sql_query: Table 'mydb.table_defs' doesn't exist
query: 'describe table_defs'

Warning: 0 is not a MySQL result index in your script on line 98
processing tables/updates/2.0.b1.mysql ...
sql_query: Table 'mydb.table_defs' doesn't exist
query: 'alter table table_defs add display_order bigint not null'
sql_select_db: Table 'mydb.table_defs' doesn't exist processing tables/updates/2.0.b3.mysql ...
sql_query: Table 'mydb.field_defs' doesn't exist
query: 'alter table field_defs change type type
enum('date','time','datetime','short_string','medium_string','long_string','file','short_int','medium_int','long_int','password','float','boolean','table','database',
'url','email','link')'
sql_select_db: Table 'mydb.field_defs' doesn't exist

Setup done.

Despite the 'Setup done' string, the database is obviously not correctly setup (nothing work afterthat).

One time, I've been further in install (more scripts successful) at home, by deleting the database. However, this didn't fixed all (but I need to try the patch at home), and furthermore, deleting/creating a database is not allowed by any hosting company!

I haven't found any hint in the Readme...

(other question: any other project with similar subject: database w/o html/sql/php ?)