R2 installation problem on linux 2.4

Mike
Joined: 31 May 2007

R2 installation problem on linux 2.4

Posted:09 Jan 2008 (14:21 UTC)
Hello!

I've an problem with the installation of R2 on

  • linux kernel 2.4
  • SuSE Linux 8.0
  • mysql 4.0.12
  • php 4.4.2

After a clean installation with no errors, I got the following error, when I pushed the last button from the installation screen to /bitweaver/index.php:



  • SQL: SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `messages_system_map` msm ON (mm.`msg_id` = msm.`msg_id` AND msm.`is_read` <> 'y' AND `is_hidden` <> 'y' AND msm.`to_user_id`= '2') WHERE mm.`to_user_id` = 1 AND mm.`group_id` IN (SELECT `group_id` FROM `users_groups_map` WHERE `user_id`= '2') LIMIT 1
  • ERROR CODE: Errno: 1064 Message: 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 'SELECT `group_id` FROM `users_groups_map` WHERE `user_id`= '2')

}}}}}}}}}}}}} -> bit_error_string(Array6)
}}}}}}}}}}}}} LINE: 638, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/BitDbAdodb.php
}}}}}}}}}}}} -> bit_error_handler(mysql, EXECUTE, 1064, You have an error in your SQL syntax. Check the manual that cor..., SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message..., false, Object:adodb_mysql)
}}}}}}}}}}}} LINE: 916, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/util/adodb/adodb.inc.php
}}}}}}}}}}} -> adodb_mysql::_execute(SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message...)
}}}}}}}}}}} LINE: 872, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/util/adodb/adodb.inc.php
}}}}}}}}}} -> adodb_mysql
adodb_mysql
execute(SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message..., Array3)
}}}}}}}}}} LINE: 490, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/util/adodb/drivers/adodb-mysql.inc.php
}}}}}}}}} -> adodb_mysql
adodb_mysql
adodb_mysql::selectlimit(SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message..., 1, -1, Array3)
}}}}}}}}} LINE: 253, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/BitDbAdodb.php
}}}}}}}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
query(SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message..., Array3, 1, null, -1)
}}}}}}}} LINE: 419, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/BitDbAdodb.php
}}}}}}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb::getone(SELECT COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN `message..., Array3)
}}}}}}} LINE: 403, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/messages/Messages.php
}}}}}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb
messages
unreadmessages(2)
}}}}}} LINE: 13, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/messages/bit_setup_inc.php
}}}}} LINE: 1133, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/BitSystem.php
}}}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb
messages
bitsystem::loadpackage(messages, bit_setup_inc.php, true, true)
}}}} LINE: 1200, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/BitSystem.php
}}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb
messages
bitsystem
bitsystem
scanpackages(bit_setup_inc.php, true, active, true, true)
}}} LINE: 126, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/setup_inc.php
}} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb
messages
bitsystem
bitsystem
require_once(/usr/local/apache-1.3.28/PRD/htdocs/bitweaver/kernel/setup_inc.p...)
}} LINE: 8, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/bit_setup_inc.php
} -> adodb_mysql
adodb_mysql
adodb_mysql
bitdbadodb
bitdbadodb
messages
bitsystem
bitsystem
require_once(/usr/local/apache-1.3.28/PRD/htdocs/bitweaver/bit_setup_inc.php)
} LINE: 18, /usr/local/apache-1.3.28/PRD/htdocs/bitweaver/index.php


$_POST:
array (
'tk' => '369c012d962a74f647da',
)

$_COOKIE:
array (
'BWSESSION' => '46760521da87e6d8b988ddc86cd7088d',
'bit-user-bitweaver' => '46760521da87e6d8b988ddc86cd7088d',
'tz_offset' => '3600',
'javascript_enabled' => 'y',
'bit-user-basiswebwiki' => '46760521da87e6d8b988ddc86cd7088d',
'PHPSESSID' => '8ce0e75c068015a3614328417fefb579',
'linkhistory' =>
array (
'/admin/articles/index.php' => '?search=1475&limit=22&category=',
'/admin/articles/view_article.php' => '?pk_article=1475',
'/admin/check/checkresult_list.php' => '?search=&limit=22&pk_applikation_chk=2376&navigation_INPROCESS=1',
'/admin/check/checkresult_detail.php' => '?pk_checkresult=60004498',
'/admin/check/systemcheck.php' => '?navigation_MONITOR=1',
),
)


I called also the sql statement manually on my db and this breaks with the same error as described above.

Please can you help me?

Thank you very much!

Mike
Anonymous

Re: R2 installation problem on linux 2.4

Posted:10 Jan 2008 (13:47 UTC)
You need a newer version of Mysql for the messages package and several other packages. Your version does not support the required subselects.
  Page 1 of 1  1