Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 05-06-2008, 12:00 PM   #1
Registered: Oct 2007
Location: BC, Canada
Distribution: Fedora, Debian
Posts: 210

Rep: Reputation: 41
Suse Wiki swap - Recent pages error 2006 or 1105

hey everyone,
recently swapped from a Windows Server hosted wiki ( eww ) to a SUSE wiki. The port went great until this error: when you go to recent pages:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "wfSpecialRecentchanges". MySQL returned error "1105: Unknown error (localhost)".
The error swaps between a 2006 - host has gone away error as well depending on the wiki's mood I guess.

It seems to me that the wiki is looking in the wrong place.. if I were a betting man I'd say the SQL statement is getting passed the wrong information. I double checked the wikiusers permission, but its all good.

Any ideas?

Last edited by Lantzvillian; 05-06-2008 at 12:12 PM.
Old 05-06-2008, 04:42 PM   #2
Registered: Oct 2007
Location: BC, Canada
Distribution: Fedora, Debian
Posts: 210

Original Poster
Rep: Reputation: 41
Better yet: The SQL statement is:

SELECT * FROM `recentchanges` FORCE INDEX (rc_timestamp)LEFT OUTER JOIN `watchlist` ON wl_user=1 AND wl_title=rc_title AND wl_namespace=rc_namespace WHERE rc_timestamp >= '20080429000000' AND rc_bot = 0 ORDER BY rc_timestamp DESC LIMIT 50

Which works on the old box, but not the new one



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't view wiki pages on any browser except links grooveharder Linux - Software 5 11-12-2006 01:29 PM
The SWAP partition is not being used in Mandriva 2006 Hitboxx Mandriva 4 08-31-2006 06:44 PM
retrieving wiki pages with wget pete-theobald Programming 4 07-20-2005 09:28 AM
Swap Partition Error Installing SUSE 9.3 mtn Linux - Newbie 4 07-15-2005 06:19 PM
Linux Wiki pages! redhatrosh LQ Suggestions & Feedback 12 03-28-2005 06:34 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:15 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration