Search doesnt work

«

Previous topic

|

Install & configuration

|

Next topic

»

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 19 2025 08:57:48
Script start
Timing:	Jan 19 2025 08:57:48
Module start 'layout'
Timing:	Jan 19 2025 08:57:48
Module start 'content'
Timing:	Jan 19 2025 08:57:48
Module end 'content'
Timing:	Jan 19 2025 08:57:48
Script end

Main resources:

Total runtime	0.0414 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0087	590.2734	152.6250
Module start 'layout'	0.0087	0.0053	742.8984	39.4453
Module start 'content'	0.0139	0.0251	782.3438	89.3359
Module end 'content'	0.0391	0.0023	871.6797	34.3047
Script end	0.0414		905.9844

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	6.7991	14	0.0002
Check MTime	0.0011	2.6474	14	0.0001
Mysql Total
Database connection	0.0016	3.8669	1	0.0016
Mysqli_queries	0.0046	11.0970	3	0.0015
Looping result	0.0000	0.0529	1	0.0000
Template Total	0.0017	4.2	1	0.0017
Template load	0.0009	2.1334	1	0.0009
Template processing	0.0008	2.0350	1	0.0008
Override
Cache load	0.0006	1.4411	1	0.0006
General
dbfile	0.0090	21.7423	8	0.0011
String conversion	0.0000	0.0599	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs