Unable toconnect to database error on search

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
Mobius
Posts: 39
Joined: Sun 15. Aug 2004, 13:07
Location: Hungary
Contact:

Unable toconnect to database error on search

Post 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?
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Re: Unable toconnect to database error on search

Post 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
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
Mobius
Posts: 39
Joined: Sun 15. Aug 2004, 13:07
Location: Hungary
Contact:

Re: Unable toconnect to database error on search

Post 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
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Re: Unable toconnect to database error on search

Post 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;
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
User avatar
Heiko H.
Posts: 868
Joined: Thu 27. Oct 2005, 11:41
Location: Dresden
Contact:

Re: Unable toconnect to database error on search

Post 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
Not longer here - sorry...

Haubner-IT GbR Dresden
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Re: Unable toconnect to database error on search

Post 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.
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
Mobius
Posts: 39
Joined: Sun 15. Aug 2004, 13:07
Location: Hungary
Contact:

Re: Unable toconnect to database error on search

Post 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
Post Reply