Re: Install Help!!!!!

[email protected] (mikespub) Thu, 03 Jul 2003 16:11:50 GMT
Newsgroups gmane.comp.cms.xaraya.knowledge-base
Organization not much
Message-ID <[email protected]>
In article <bdv8e6$im0$1-111RdWWlOxkOkXtL6OYfHgC/[email protected]>, [email protected] (Kevin) wrote:
>...
>error description is: 'You have an error in
>your SQL syntax near 'INNER JOIN xar_security_acl acl
>ON p.xar_pid = acl.xar_perm' at line 9'.
>
>If I run install with Create Database. It creates some tables and then
>gives the above error.
>
>Settings for PHP, mySQL are correct been using these for ages.
>
>Any help please?
>
>Thanks
>
>Kevin

Could be some INNER JOIN issue in certain versions of MySQL
- you're not the first to have mentioned this, although I didn't find
any bug reports on this at http://bugs.xaraya.com/

Since SELECT ... FROM ... INNER JOIN ... ON ... is functionally
equivalent to  SELECT ... FROM ..., ... WHERE ... in MySQL, I've
switched to the other syntax in bitkeeper. If that still doesn't work
out for you, please file a bug report...

Mike.