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" /> ?
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
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