Forums / Install & configuration / Search doesnt work

Search doesnt work

Author Message

frank weissman

Saturday 12 March 2005 6:15:07 am

I installed EZ-publish 3.50 and have just one (slightly problematic) problem. The search engine doesn't work. Maybe it is a .ini. problem. But I can't find a reason. It seems to work fine, but returns allways " not found" on the request.

I work with: Linux server,
Apache/1.3.33 (Unix) mod_perl/1.29 PHP/4.3.10
PHP 4.3.10

Extensies:
xml, tokenizer, standard, session, posix, pcre, overload, mysql, imap, gettext, gd, ftp, curl, ctype, bz2, zlib, openssl, apache

Soort:
mysql
Server:
sql02.backbone.tiscomhosting.nl (this is an extrernal database)
Socket pad:
Niet in gebruik.
Databasenaam:
onderwijsad_org

Can someone please help ?

TXS

Ɓukasz Serwatka

Saturday 12 March 2005 6:17:20 am

Hi Frank,

Check if your DB user has right permissions to creating temporary tables.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

frank weissman

Monday 14 March 2005 2:47:07 am

TXS You helped me a bit in the wright direction. It is indeed a database connection problem.

Below I show you the debug output.

Query error: Access denied for user: 'nvexamens-nl@%'

It seems like a "bug" is one off the scripts. But I can't find the wright script yet. The user name should be "nvexamens-nl" without the @%.

Wich script generates the username (or is it in the ezsearch.php script wich contains an error?)

frank weissman

Monday 14 March 2005 4:54:52 am

Well I solved the problem, it was indeed a rights issue in the database. Did not have rights to create tempory tables.

TXS for the given help