Mysql 4.0.27 is not supporting the fieldtype "BOOLEAN"
so i changed
public/install/installation/templates/sql/mysql_schema.phpI replaced BOOLEAN with TINYINT(1) like described here:
http://forums.opengoo.org/index.php?topic=526.0BOOLEAN is an alias to TINYINT(1), so it couldn't be the problem.
But Mysql 4.0.27 seems to have a problem in the SQL-Query.
I found out. SQL except this query:
SELECT *
FROM `opengoo_application_logs`
WHERE `is_private` <= '1'
AND `is_silent` <= '1'
AND `id`
IN (
NULL
)
ORDER BY `created_on`
DESC LIMIT 0, 15
>> Result is: empty Result
And SQL has no error on:
SELECT `object_id`
FROM `opengoo_workspace_objects`
WHERE `object_manager` = 'ApplicationLogs'
AND `workspace_id`
IN ('1')
>> Result is: empty Result
But it gives me an error on:
SELECT *
FROM `opengoo_application_logs`
WHERE `is_private` <= '1'
AND `is_silent` <= '1'
AND `id`
IN (
SELECT `object_id`
FROM `opengoo_workspace_objects`
WHERE `object_manager` = 'ApplicationLogs'
AND `workspace_id`
IN ('1')
)
ORDER BY `created_on`
DESC LIMIT 0, 15
I would like to correct the sql query but i couldn't find out what the problem on the last query is.
I am not sure about "empty Result". Maybe it has to have a result. Maybe NULL is not the same
like "empty Result".
Cause if i test this query, I get an error:
SELECT *
FROM `opengoo_application_logs`
WHERE `is_private` <= '1'
AND `is_silent` <= '1'
AND `id`
IN (
)
ORDER BY `created_on`
DESC LIMIT 0, 15
The table
opengoo_workspace_objects is empty. So it can not
return any results.
Thank you
Jan
PS: I was on hoster strato before. Believe me it was horror too.
But at the moment i have 1&1 on my toplist. I have allot of domains there.
To switch is too much work. Never change a running system.
Since a year he promise to change to mysql 5.0 in the next month.