Hi eGroupWare users,
I am getting the “invalid SQL” error detailed below, and I have no
idea how to repair it.
I searched both the email archives and the knowledge base, but the
error message is so unspecific that it’s hard for me to tell if this
has come up before.
The error first occurred shortly after moving my eGroupWare
installation to a different computer which involved a eGW update from
1.2.005 to 1.2.105 (using the tarball in each case). It happens
whenever I click the Manual or Wiki icon. Manual did not work from the
start, but I think Wiki only stopped working after I upgraded the SQL
using the function in /setup because InfoLog complained about obsolete
SQL tables.
For moving the data, I used eGW’s backup/restore functionality, which
initially seemed to work well.
Please tell me: How do I get the Wiki working again? When I run the
installation check in /setup, it reports that everything is OK.
Calendar is working fine.
eGroupWare 1.2.105
PHP 4.3.9 (I know that version 5 is recommended, but I am not allowed
to install it)
MySQL 4.1.20
OS: 64 bit Red Hat Enterprise Linux ES release 4 (Nahant Update 4)
(Linux kernel 2.6.9-42)
CPU: dual Opteron
/-----
Database error: Invalid SQL: SELECT *,CASE WHEN wiki_body IS NULL THEN 3
ELSE (CASE wiki_lang WHEN ‘en’ THEN 0 WHEN ‘’ THEN 1 ELSE 2 END) END AS
lang_priority FROM egw_wiki_pages WHERE wiki_name=‘eGroupWare’ AND
wiki_lang IN (‘en’,’’) AND ( wiki_id=0 AND wiki_readable IN (0,1,2,))
AND wiki_supercede=wiki_time ORDER BY lang_priority
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 ‘)) AND wiki_supercede=wiki_time ORDER BY
lang_priority’ at line 1)
File: /var/www/html/egroupware/wiki/inc/class.sowiki.inc.php
Line: 229
Function: egw_db::select / sowikipage::read / uiwiki::view / execmethod()
Session halted.
-----
Many thanks to all the Free Software volunteers!
Christian
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys – and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
