WordPress database error: [Got error 28 from table handler]
SELECT DISTINCT ID, category_id, cat_name, category_nicename, category_description, category_parent FROM wp_str8_categories, wp_str8_post2cat, wp_str8_posts WHERE category_id = cat_ID AND post_id = ID AND post_id IN (5419)

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_str8_posts LEFT JOIN wp_str8_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (5419) GROUP BY ID

STR8BLOGGIN » Blog Archive » FreeBSD users having trouble with pecl?

FreeBSD users having trouble with pecl?

For a while I’ve had sporadic problems with pecl (PHP’s binary module building tool, part of PEAR) not working properly. Usually the error was:

[root@host ~]# pecl install memcache
	
Fatal error: Call to undefined function preg_match() in /usr/local/share/pear/PEAR/Frontend/CLI.php on line 70

Yet, preg_match() would work from other scripts - it is part of pcre, which was installed.

The problem is this. pcre is included via extensions.ini. That’s why it usually works. However, pecl for some reason deliberately turns off .ini file inclusion (that includes extensions.ini) when it runs the php interpreter. I’m not sure what the objective was here but it’s a problem on FreeBSD’s shared library pcre.so.

The fix: edit the pecl script (usually /usr/local/bin/pecl) and remove the ‘-n’ from the command line arguments.

WordPress database error: [Can't open file: 'wp_str8_comments.MYI'. (errno: 145)]
SELECT * FROM wp_str8_comments WHERE comment_post_ID = '5419' AND comment_approved = '1' ORDER BY comment_date

Leave a Reply