Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Mediawiki

Database error

 

 

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded


mediawiki-l at clubjuggle

Feb 16, 2006, 4:30 AM

Post #1 of 4 (702 views)
Permalink
Database error

I am getting the following MySQL error when creating a new page on my wiki:

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 "SearchMySQL4::update". MySQL returned error "1016:
Can't open file: 'wt_searchindex.MYI' (errno: 145) (localhost)".

If it helps, the wiki in question is http://wikitography.org.

Thanks,
~Terry
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


T.Vasiliadis at schlemmerblock

Feb 17, 2006, 5:21 AM

Post #2 of 4 (678 views)
Permalink
Re: Database error [In reply to]

It is possible, that wiki has now right to write it files???


-----Ursprüngliche Nachricht-----
Von: mediawiki-l-bounces [at] Wikimedia [mailto:mediawiki-l-bounces [at] Wikimedia] Im Auftrag von Terry Auspitz
Gesendet: Donnerstag, 16. Februar 2006 13:46
An: MediaWiki announcements and site admin list
Betreff: [Mediawiki-l] Database error

I am getting the following MySQL error when creating a new page on my wiki:

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 "SearchMySQL4::update". MySQL returned error "1016:
Can't open file: 'wt_searchindex.MYI' (errno: 145) (localhost)".

If it helps, the wiki in question is http://wikitography.org.

Thanks,
~Terry
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


robchur at gmail

Feb 17, 2006, 6:50 AM

Post #3 of 4 (662 views)
Permalink
Re: Database error [In reply to]

Do a REPAIR TABLE on the searchindex table.


Rob Church

On 17/02/06, Vasiliadis, Thomas <T.Vasiliadis [at] schlemmerblock> wrote:
> It is possible, that wiki has now right to write it files???
>
>
> -----Ursprüngliche Nachricht-----
> Von: mediawiki-l-bounces [at] Wikimedia [mailto:mediawiki-l-bounces [at] Wikimedia] Im Auftrag von Terry Auspitz
> Gesendet: Donnerstag, 16. Februar 2006 13:46
> An: MediaWiki announcements and site admin list
> Betreff: [Mediawiki-l] Database error
>
> I am getting the following MySQL error when creating a new page on my wiki:
>
> 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 "SearchMySQL4::update". MySQL returned error "1016:
> Can't open file: 'wt_searchindex.MYI' (errno: 145) (localhost)".
>
> If it helps, the wiki in question is http://wikitography.org.
>
> Thanks,
> ~Terry
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] Wikimedia
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l [at] Wikimedia
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] Wikimedia
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


tstarling at wikimedia

Aug 27, 2008, 9:03 PM

Post #4 of 4 (474 views)
Permalink
Re: Database error [In reply to]

Fred Bauder wrote:
> I'm getting the following error from time to time after upgrading to 1.13:
>
> Database error
>
> 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 "MediaWikiBagOStuff::_doinsert". MySQL returned
> error "1213: Deadlock found when trying to get lock; try restarting
> transaction
>
> Any ideas?

It's a bug, a lot of people have been having that. We need a backtrace, so
we can fix it for 1.13.1. Try to grab me on IRC and I'll walk you through it.

-- Tim Starling


_______________________________________________
MediaWiki-l mailing list
MediaWiki-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Wikipedia mediawiki RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.