Page 1 of 1

Unable toconnect to database error on search

Posted: Mon 26. May 2008, 20:57
by Mobius
If I put a search form to my page, i have "Unable toconnect to database" error message.
All other functions works fine.
It is an 1.3.5 upgaded to 1.3.9.

Any Idea?

Re: Unable toconnect to database error on search

Posted: Mon 26. May 2008, 21:19
by flip-flop
Hmm, I think it is a corrupted file.

Upload a second time
- /inc_act/
- /inc_front/
- /inc_lib/
- /inc_tmpl/

and the files
- /index.php
- /phpwcms.php
- /login.php

Re: Unable toconnect to database error on search

Posted: Mon 26. May 2008, 21:36
by Mobius
flip-flop wrote:Hmm, I think it is a corrupted file.

Upload a second time
- /inc_act/
- /inc_front/
- /inc_lib/
- /inc_tmpl/

and the files
- /index.php
- /phpwcms.php
- /login.php
I made the update today to 1.3.9, all files was overwritten.
Before that i have 1.3.5 and the same error message...

here is the search page: http://www.meganeklub.hu/index.php?kereses-1

Re: Unable toconnect to database error on search

Posted: Tue 27. May 2008, 06:22
by flip-flop
I haven´t any idea why your search isn´t running well. The error message isnt´produced by the cms.

Why you are running a non existing site charset like
<meta http-equiv="content-type" content="text/html; charset=utf8_general_ci" /> ? :shock:
Please make a correction of this fatal mistake and validate your site. Important :!:

HTML: http://validator.w3.org/
CSS: http://jigsaw.w3.org/css-validator/


What is you db charset/collation?

A second hint, please switch in your config:
$phpwcms['db_pers'] = 0;

The right db version is registered?
E.g.
$phpwcms['db_version'] = 50045;
or e.g.
$phpwcms['db_version'] = 40122;

Re: Unable toconnect to database error on search

Posted: Tue 27. May 2008, 09:43
by Heiko H.
flip-flop wrote:I haven´t any idea why your search isn´t running well. The error message isnt´produced by the cms.
I have seen the errormessage

Image

But, sorry, i have no more ideas then flip-flop. Try his hints first.

Heiko

Re: Unable toconnect to database error on search

Posted: Tue 27. May 2008, 09:46
by flip-flop
You are right, the error message is generated by provider. I can´t find this message in phpWcms.
I think the site charset (and db charset/collation) are the sources of error.

Re: Unable toconnect to database error on search

Posted: Thu 29. May 2008, 07:22
by Mobius
The charset is changed to iso-8859-1, but the search is still bad.
In phpmyadmin the sql has the following setting:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation:utf8_general_ci