FUDforum - خوراک RDF
http://fudforum.org/forum/index.php
Sql error 1064, ASC LIMIT 0,15
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=41071&th=10280#msg_41071
I install FudForum and Egroupware on my server. When i start fudforum via egroupware, i have the following error.
Database error: Invalid SQL: SELECT SQL_CALC_FOUND_ROWS egw_addressbook.*,account_lid,account_type,egw_accounts.account_id FROM egw_addressbook RIGHT JOIN egw_accounts ON egw_accounts.account_id=egw_addressbook.account_id WHERE contact_private=0 AND egw_addressbook.contact_owner=0 ORDER BY ASC
mysql Error: 1064 (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 'ASC LIMIT 0,15' at line 1)
Martin]]>martinb2008-05-15T20:58:18-00:00Re: Sql error 1064, ASC LIMIT 0,15
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=41074&th=10280#msg_41074
I find a correction for the fudforum bug in egroupware 1.4
In file class.so_sql.inc.php :
I replace the following line (675):
if ($order_by && stripos($order_by,'ORDER BY')===false && stripos($order_by,'GROUP BY')===false)
{
$order_by = 'ORDER BY '.$order_by;
}
by:
$strOrder = strlen($order_by);
if ($order_by && stripos($order_by,'ORDER BY')===false && stripos($order_by,'GROUP BY')===false)
{
$order_by = 'ORDER BY '.$order_by;
}
if ($strOrder == 4)
{
$order_by = '';
}
After the change, i can access in fudforum in egroupware 1.4