by jserbs » Fri May 11, 2012 8:45 pm
I have the same situation with version 2 on this install: Windows Svr 2008; Apache 2.2; Mysql 5.5; PHP 5.3
It appears there are still unfinished code pieces lurking as i have found references in the http logs to images that have changed names, and in the db log there are some errors that seem to be ultimately holding this install up. In addition, I had other errors getting Mysql to work before i got to this point in the install. The lesson here seems to be use *nix or ver 1.8. I decided to try 1.8 and it installed no problem the first time.
There is this SQL error (in mdb2_errors.log):
[Message: MDB2 Error: unknown error] [Information: _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_380ebabfee5445a92f2e28be48bf0544122e71bc5cb USING @0, @1, @2, @3, @4, @5]
[Native code: 1364]
[Native message: Field 'sort' doesn't have a default value]
]
[11/05/2012 - 11:40:21] [Message: MDB2 Error: unknown error] [Information: _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_4625e27c8a2f47c83166ae7820cdc7e3e5fb9a6f159 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11]
[Native code: 1366]
[Native message: Incorrect integer value: 'root' for column 'type' at row 1]
]