All Searches return 0 results

Next topic

Author	Message
nathaniel burbank	Tuesday 20 July 2004 7:16:33 pm I am setting a site (http://politicalretort.org) using eZ Publish 3.4.1, and everything is working great, except for search. Every-time I search for anything, regardless of weather I am in the user or admin interface, I get "no results found" for terms I know exist on my site. Here is what I have done. First I checked to make sure that the appropriate parts of the article class were searchable (they were). Next, using PHPMyAdmin, I took a look at the tables for the "ezsearch_word" in my database. Sure enough, terms from the test article I published were there, so I know stuff is getting indexed properly. Finally, following a suggestion from someone another forum post, I re-uploaded all the files in the "search" folder, inside the kernel. This did no good as well. So, if anyone has and suggestions or can point me to the appropriate forum discussion , I would appreciate it very much. Thanks, Nathaniel
Ole Morten Halvorsen	Tuesday 27 July 2004 4:25:13 am Have you tried to turn on debugging to see if you get any error in there? When searching, eZ publish uses temporary tables so make sure your mysql user has permissions to create temp tables. Ole M. Senior Software Engineer - Vision with Technology http://www.visionwt.com http://www.omh.cc http://www.twitter.com/omh eZ Certified Developer http://ez.no/certification/verify/358441 http://ez.no/certification/verify/272578
nathaniel burbank	Tuesday 03 August 2004 7:54:47 pm Ya, so it turns out that it was an issue of my My_SQL user not having access to temporary tables. I had to ask my web host provider to turn them on, and than search worked! Thanks for the help, Nathaniel -- http://politicalretort.org
John Mina	Monday 16 August 2004 8:11:14 am hi m y problem at : http://ez.no/community/forum/developer/search_problem_in_my_db/#msg65430 a bit similar but not the same as when i set a new ezpublish instalation to use the same DB , it is not having any problems. I wonder what is the problem :( any help please

eZ debug

Timing:	Jan 31 2025 06:21:01
Script start
Timing:	Jan 31 2025 06:21:01
Module start 'layout'
Timing:	Jan 31 2025 06:21:01
Module start 'content'
Timing:	Jan 31 2025 06:21:02
Module end 'content'
Timing:	Jan 31 2025 06:21:02
Script end

Main resources:

Total runtime	1.1396 sec
Peak memory usage	4,096.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	588.2500	151.2266
Module start 'layout'	0.0049	0.0029	739.4766	36.6797
Module start 'content'	0.0078	1.1310	776.1563	939.0781
Module end 'content'	1.1388	0.0008	1,715.2344	12.1484
Script end	1.1395		1,727.3828

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2692	16	0.0002
Check MTime	0.0012	0.1037	16	0.0001
Mysql Total
Database connection	0.0007	0.0589	1	0.0007
Mysqli_queries	1.0911	95.7430	62	0.0176
Looping result	0.0006	0.0493	60	0.0000
Template Total	1.1012	96.6	2	0.5506
Template load	0.0020	0.1728	2	0.0010
Template processing	1.0992	96.4552	2	0.5496
Template load and register function	0.0016	0.1382	1	0.0016
states
state_id_array	0.0016	0.1404	1	0.0016
state_identifier_array	0.0022	0.1966	2	0.0011
Override
Cache load	0.0016	0.1445	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0448	3	0.0002
Fetch class attribute name	0.0020	0.1742	4	0.0005
XML
Image XML parsing	0.0003	0.0301	3	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0010	4	0.0000
General
dbfile	0.0006	0.0560	10	0.0001
String conversion	0.0000	0.0007	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 17 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs