Search ' ', a space, results in error in Page Management
(wp-admin/edit-pages.php). I do not have any pages. I am using the Nov
27 build.
Page Management
WordPress database error: [You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near ') AND (post_type = 'page' AND (post_status =
'publish' OR post_status = 'future' at line 1]
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND () AND (post_type =
'page' AND (post_status = 'publish' OR post_status = 'future' OR
post_status = 'draft' OR post_status = 'private')) ORDER BY menu_order
DESC
No pages yet.
Create New Page »
Likewise, searching a space ' ' in the Manage post or anywhere in the
blog itself results in a MySQL error.
On 11/26/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Send wp-testers mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.automattic.com/mailman/listinfo/wp-testers
or, via email, send a message with subject or body 'help' to
[EMAIL PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of wp-testers digest..."
Today's Topics:
1. UTF-8 problem (Rimas Abromavi?ius)
2. Re: UTF-8 problem (Peter Westwood)
----------------------------------------------------------------------
Message: 1
Date: Sun, 26 Nov 2006 13:41:34 +0200
From: Rimas Abromavi?ius <[EMAIL PROTECTED]>
Subject: [wp-testers] UTF-8 problem
To: <[email protected]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="windows-1257"
Hello,
I'm using WP2.1alpha3 and I'm having problems with some
specific character display (while writing in Lithuanian,
particularly character è [U+010D - latin c with caron]).
The problem lies in WP using latin1 connection for chatting
with DB. I don't notice this problem with WP2.05 somehow
and that is quite strange, because it should exhibit the
exact same behavior, as I don't see any 'set names utf8' there ;)
When I put:
$this->query('SET NAMES UTF8');
in line 57 of wp-includes/wp-db.php, it fixes the problem
because the DB connection then uses UTF-8 not just for storing,
but also for transferring the data. I'm not a MySQL nor PHP
guru, but I suppose this is a bug and should be fixed using
'set names' or some other method.
--
</Chionsas>
------------------------------
Message: 2
Date: Sun, 26 Nov 2006 11:53:28 +0000
From: Peter Westwood <[EMAIL PROTECTED]>
Subject: Re: [wp-testers] UTF-8 problem
To: [email protected]
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=windows-1257
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Rimas Abromavièius wrote:
> Hello,
>
> I'm using WP2.1alpha3 and I'm having problems with some
> specific character display (while writing in Lithuanian,
> particularly character è [U+010D - latin c with caron]).
> The problem lies in WP using latin1 connection for chatting
> with DB. I don't notice this problem with WP2.05 somehow
> and that is quite strange, because it should exhibit the
> exact same behavior, as I don't see any 'set names utf8' there ;)
>
> When I put:
> $this->query('SET NAMES UTF8');
> in line 57 of wp-includes/wp-db.php, it fixes the problem
> because the DB connection then uses UTF-8 not just for storing,
> but also for transferring the data. I'm not a MySQL nor PHP
> guru, but I suppose this is a bug and should be fixed using
> 'set names' or some other method.
>
I think this is more likely a mysql configuration issue.
Are the tables in the database latin1 or utf8?
westi
- --
Peter Westwood
http://blog.ftwr.co.uk
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFaYA4VPRdzag0AcURAhE8AJ9lYDkeDKEpSLrjYad1F4ttNLzSZwCeMMxg
VIerFHbpoh4eYtDBdKOXF5k=
=lDmy
-----END PGP SIGNATURE-----
------------------------------
_______________________________________________
wp-testers mailing list
[email protected]
http://lists.automattic.com/mailman/listinfo/wp-testers
End of wp-testers Digest, Vol 21, Issue 27
******************************************
--
This e-mail is provided "AS IS" with no warranties, and confers no rights.
_______________________________________________
wp-testers mailing list
[email protected]
http://lists.automattic.com/mailman/listinfo/wp-testers
