Debian Install error

[Westcoast]

Ok, may anyone could help me here

I have tried the manual install descipted here: http://doc.otrs.org/3.0/de/html/manual- ... -otrs.html
I did also try to create the Database by manual

Step by step:
- in phpmyadmin I created the new DB (otrs)
- with otrs-schema.mysql.sql the struktur was build -> worked perfectly, 72 Tables created
- otrs-initial_insert.mysql.sql is adding Data perfectly
- with otrs-schema-post.mysql.sql everythings craching:sometimes in row 5 and sometimes in row 7, cause table "valid" or "users"is missing after ALTER TABLE.

I have also tried to ALTER TABLE by hand, but even there the table just vanishs.


The Errors looks like that:
Console:

Code: Select all

 USER:/opt/otrs/scripts/database# mysql -u DBUSER -p otrs < otrs-schema-post.mysql.sql
    Enter password:
    ERROR 29 (HY000) at line 5: File './otrs/valid.MYD' not found (Errcode: 2)

The References seem to be there (table is in orderd list), but the table itself seems to be missing at all

If i do the following in phpmyadmin manual: (3. ALTER out of schema-post):

Code: Select all

 ALTER TABLE `users` ADD CONSTRAINT FK_users_create_by_id FOREIGN KEY ( create_by ) REFERENCES `users` ( id ) ;

i get back:

Code: Select all

  Ihr SQL-Befehl wurde erfolgreich ausgeführt. (die Abfrage dauerte 0.0937 sek.)

and the table is vanished completly (and is not in orderd list anymore).

Thanks

[crythias]

Why aren't you using the web installer.pl to do this for you?