Site copied -> search does not find any hits

Next topic

Author	Message
Marco Zinn	Saturday 28 August 2004 9:39:12 am Hi, i have a strange issue here, maybe someone can give me a hint: I copied an existing 3.4.1 installation to some other server (including the DB). I changed the owner of the files, did the Virtualhost setup etc. This seemed to work fine. Now, i enabled the setup wizard, because i wanted to clean the data and set up a new site. I choose the same DB, let ez delete all data in there, installed a new site (2 new siteaccess names) and finished. Now, everything works fine, but the search engine always returns "0 hits". The indexing seems to work fine, the ezsearch table's contents looks fine. I'm almost sure, that the installation is okay. Any hints? I'm using Apache 2 and MySQL 4.0 now, vs. Apache 1.3, MySQL 3.xx on the old server. Does the search so some "special" SQL maybe? Any hints are appreciated. Marco http://www.hyperroad-design.com
Marco Zinn	Saturday 28 August 2004 9:52:23 am So, just type the question and the solution will appear ;) I checked the SQL permissions, and that's it: The user, that i use the acces the DB, was created by Confixx (3). It does NOT have the privilege "CREATE TEMPORARY TABLES". After i granted this, the search works. It seems, as this privilege is new to MySQL 4, at least it does not appear in phpMyAdmin for my MySQL 3 server. See also then last posts at http://ez.no/community/forum/general/searching Marco http://www.hyperroad-design.com

Author

Message

Saturday 28 August 2004 9:39:12 am

Hi, i have a strange issue here, maybe someone can give me a hint:
I copied an existing 3.4.1 installation to some other server (including the DB). I changed the owner of the files, did the Virtualhost setup etc. This seemed to work fine.
Now, i enabled the setup wizard, because i wanted to clean the data and set up a new site. I choose the same DB, let ez delete all data in there, installed a new site (2 new siteaccess names) and finished.
Now, everything works fine, but the search engine always returns "0 hits". The indexing seems to work fine, the ezsearch table's contents looks fine.
I'm almost sure, that the installation is okay.
Any hints?
I'm using Apache 2 and MySQL 4.0 now, vs. Apache 1.3, MySQL 3.xx on the old server.
Does the search so some "special" SQL maybe?
Any hints are appreciated.

Marco
http://www.hyperroad-design.com

Marco Zinn

Saturday 28 August 2004 9:52:23 am

So, just type the question and the solution will appear ;)

I checked the SQL permissions, and that's it:
The user, that i use the acces the DB, was created by Confixx (3). It does NOT have the privilege "CREATE TEMPORARY TABLES".
After i granted this, the search works.
It seems, as this privilege is new to MySQL 4, at least it does not appear in phpMyAdmin for my MySQL 3 server.
See also then last posts at http://ez.no/community/forum/general/searching

Marco
http://www.hyperroad-design.com

eZ debug

Timing:	Jan 19 2025 14:00:29
Script start
Timing:	Jan 19 2025 14:00:29
Module start 'layout'
Timing:	Jan 19 2025 14:00:29
Module start 'content'
Timing:	Jan 19 2025 14:00:30
Module end 'content'
Timing:	Jan 19 2025 14:00:30
Script end

Main resources:

Total runtime	0.7454 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.3906	152.6406
Module start 'layout'	0.0057	0.0029	742.0313	39.4766
Module start 'content'	0.0086	0.7356	781.5078	490.9531
Module end 'content'	0.7442	0.0012	1,272.4609	8.1250
Script end	0.7454		1,280.5859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.4021	16	0.0002
Check MTime	0.0013	0.1697	16	0.0001
Mysql Total
Database connection	0.0008	0.1021	1	0.0008
Mysqli_queries	0.7019	94.1585	52	0.0135
Looping result	0.0004	0.0589	50	0.0000
Template Total	0.7114	95.4	2	0.3557
Template load	0.0022	0.3007	2	0.0011
Template processing	0.7091	95.1263	2	0.3546
Template load and register function	0.0001	0.0121	1	0.0001
states
state_id_array	0.0009	0.1141	1	0.0009
state_identifier_array	0.0006	0.0852	2	0.0003
Override
Cache load	0.0019	0.2502	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0839	1	0.0006
Fetch class attribute name	0.0009	0.1257	3	0.0003
XML
Image XML parsing	0.0004	0.0582	1	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0011	4	0.0000
General
dbfile	0.0016	0.2174	16	0.0001
String conversion	0.0000	0.0009	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
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs