Testing awfull... Serendipity and PostgreSQL 8.3

Tuesday, February 26. 2008

Tuesday, February 26. 2008

Today i noticed that my blog wasnt working as i expected... after some time... someone at #postgresql toldme to watch the typecasting... even i like serendipity... i have to admit it... someone sucks at sql planning... here is the patch for it:

--- functions_entries.orig.inc.php      2008-02-26 02:14:37.000000000 -0430

+++ functions_entries.inc.php   2008-02-26 02:16:32.000000000 -0430

@@ -518,7 +518,7 @@

                         ON  e.authorid = a.authorid

                             {$cond['joins']}

                      WHERE

-                            e.$key LIKE '" . serendipity_db_escape_string($val) . "'

+                            e.$key = '" . serendipity_db_escape_string($val) . "'

                             {$cond['and']}

                      LIMIT  1";

you can download it here

Posted by Santiago Zarate in PHP, Programacion, Tecnico at 01:16

Add comment

Link to this post

| Top Exits (0)

Vote for articles fresher than 90 days!

Current karma: -2, 31 vote(s) 0 hits

Defined tags for this entry: parches, patch, php, postgresql, sy9

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Add Comment

Name:

Email:

Homepage:

In reply to:

Comment:

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.

Standard emoticons like :-) and ;-) are converted to images.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Enter the string from the spam-prevention image above:

Remember Information?
Subscribe to this entry

Home :: Tecnico :: Testing awfull... Serendipity and PostgreSQL 8.3