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

Notices


Reply
  Search this Thread
Old 05-06-2008, 12:00 PM   #1
Lantzvillian
Member
 
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:

Code:
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
Lantzvillian
Member
 
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
 
  


Reply

Tags
wiki


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

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

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