[wp-testers] Searching a space results in error

[Mr. Dew]

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, wp-testers-request at lists.automattic.com
<wp-testers-request at lists.automattic.com> wrote:
> Send wp-testers mailing list submissions to
>         wp-testers at lists.automattic.com
>
> 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
>         wp-testers-request at lists.automattic.com
>
> You can reach the person managing the list at
>         wp-testers-owner at lists.automattic.com
>
> 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 <Chionsas at ktug.lt>
> Subject: [wp-testers] UTF-8 problem
> To: <wp-testers at lists.automattic.com>
> Message-ID: <000301c7114f$d62cfe70$8286fb50$@lt>
> 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 <peter.westwood at ftwr.co.uk>
> Subject: Re: [wp-testers] UTF-8 problem
> To: wp-testers at lists.automattic.com
> Message-ID: <45698038.8070107 at ftwr.co.uk>
> 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
> wp-testers at lists.automattic.com
> 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.