Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-10-09 12:47:26

TomBus
Member
From: Bavaria
Registered: 2005-07-06
Posts: 85

[de-de] [gelöst] Lauter Fehlermeldungen - error 127

Hallo,

bei Aufruf der Kategorienseite erhalte ich folgende zwei Fehlermeldungen:
Warning: Got error 127 from storage engine select category, count(*) as num from txp_image where 1 group by category in /……./httpdocs/textpattern/lib/txplib_db.php on line 81

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /……/httpdocs/textpattern/lib/txplib_db.php on line 287

Unter Verfassen versuche ich mit “Image Selector” ein Bild einzufügen und erhalte:
Got error 127 from storage engine SELECT * FROM txp_image WHERE category = ““ORDER BY date DESC in /………./httpdocs/textpattern/lib/txplib_db.php on line 81 root is empty.

Die Bild Kategorie ist root nicht vorhanden und in site-design ist ein Bild

und bei dem Aufruf der Bilder erhalte ich:
Warning: Got error 127 from storage engine select *, unix_timestamp(date) as uDate from txp_image where 1 order by id asc limit 150, 15 in /………/httpdocs/textpattern/lib/txplib_db.php on line 81

Das ganze unter 4.0.6

gibt es da Rat oder Lösungen?

Tom

Last edited by TomBus (2008-10-09 13:56:15)

Offline

#2 2008-10-09 13:30:10

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: [de-de] [gelöst] Lauter Fehlermeldungen - error 127

Fire up PHPmyAdmin and try repairing the Textpattern tables.
Which version of MySQL are you using?

Offline

#3 2008-10-09 13:34:45

TomBus
Member
From: Bavaria
Registered: 2005-07-06
Posts: 85

Re: [de-de] [gelöst] Lauter Fehlermeldungen - error 127

Hi ruud,
MySQL-Version: 4.1.11-Debian_4sarge7
Tom

Offline

#4 2008-10-09 13:49:54

TomBus
Member
From: Bavaria
Registered: 2005-07-06
Posts: 85

Re: [de-de] [gelöst] Lauter Fehlermeldungen - error 127

Hi,
I tried to repair the table txp_image and I got

meinedb.txp_image repair info Wrong bytesec: 0- 0- 0 at 11280; Skipped
meinedb.txp_image repair status OK

?

Then I tried to repair again and ….
… everything is ok!

Thank you, for Your tip

Tom

Last edited by TomBus (2008-10-09 13:55:06)

Offline

Board footer

Powered by FluxBB