(OffTopic) phpAdsNew and eZ - weird behaviour

Previous topic

Setup & design

Next topic

Author	Message
Marin Orlic	Saturday 01 October 2005 1:32:52 am Hi all, This is a bit offtopic, but I hope somebody had some experiences :) Sorry for the OT. I have an installation of PAN in eZ Publish (using eZ publish extension), and it worked just fine, without any problems - eZ extension just calls the delivery code, and everything else is managed by PAN. Yesterday we switched to another DB host, and also to another version of MySQL, from 3.23 to 4.1.9. The database switch had some troubles with national chars, but I've mostly settled that issue. There could be one problem - db data is in cp1250, and the default connection charset set by MySQL server is latin2. Back to the problem - I'm loading banners by keywords, such as 'top-468', 'nl-top', 'bottom-468' and so on. After the DB change, PAN started giving me random banners for two of the keywords (maybe more, but didn't notice). There is no apparent link between the requested keywords (top-468 and nl-top are affected) and those that do work (zd-top-468, forum-top-xx and so on work fine). There were some keywords with national chars, but that worked fine. I even removed the national chars from the keywords, no use. This is really weird, does anybody have any idea what could be the problem? I noticed a warning on PAN site about MySQL and ANSI mode, how can I check if it's in that mode? Thanks!
Marin Orlic	Saturday 01 October 2005 5:19:40 am Just as an information - phpAdsNew 2.0.6 works fine. If anybody has problems, maybe I can help :)

Author

Message

Marin Orlic

Saturday 01 October 2005 1:32:52 am

Hi all,

This is a bit offtopic, but I hope somebody had some experiences :) Sorry for the OT.

I have an installation of PAN in eZ Publish (using eZ publish extension), and it worked just fine, without any problems - eZ extension just calls the delivery code, and everything else is managed by PAN.

Yesterday we switched to another DB host, and also to another version of MySQL, from 3.23 to 4.1.9. The database switch had some troubles with national chars, but I've mostly settled that issue. There could be one problem - db data is in cp1250, and the default connection charset set by MySQL server is latin2.

Back to the problem - I'm loading banners by keywords, such as 'top-468', 'nl-top', 'bottom-468' and so on. After the DB change, PAN started giving me random banners for two of the keywords (maybe more, but didn't notice). There is no apparent link between the requested keywords (top-468 and nl-top are affected) and those that do work (zd-top-468, forum-top-xx and so on work fine). There were some keywords with national chars, but that worked fine. I even removed the national chars from the keywords, no use.

This is really weird, does anybody have any idea what could be the problem? I noticed a warning on PAN site about MySQL and ANSI mode, how can I check if it's in that mode?

Thanks!

Marin Orlic

Saturday 01 October 2005 5:19:40 am

Just as an information - phpAdsNew 2.0.6 works fine.

If anybody has problems, maybe I can help :)

eZ debug

Timing:	Jan 18 2025 11:23:04
Script start
Timing:	Jan 18 2025 11:23:04
Module start 'layout'
Timing:	Jan 18 2025 11:23:04
Module start 'content'
Timing:	Jan 18 2025 11:23:06
Module end 'content'
Timing:	Jan 18 2025 11:23:06
Script end

Main resources:

Total runtime	1.4476 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.0069	589.4297	153.4688
Module start 'layout'	0.0069	0.0034	742.8984	39.4219
Module start 'content'	0.0103	1.4357	782.3203	423.9766
Module end 'content'	1.4460	0.0016	1,206.2969	8.1250
Script end	1.4476		1,214.4219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.2307	16	0.0002
Check MTime	0.0013	0.0906	16	0.0001
Mysql Total
Database connection	0.0009	0.0646	1	0.0009
Mysqli_queries	1.4057	97.1086	52	0.0270
Looping result	0.0005	0.0344	50	0.0000
Template Total	1.4108	97.5	2	0.7054
Template load	0.0019	0.1325	2	0.0010
Template processing	1.4088	97.3226	2	0.7044
Template load and register function	0.0002	0.0146	1	0.0002
states
state_id_array	0.0010	0.0680	1	0.0010
state_identifier_array	0.0021	0.1476	2	0.0011
Override
Cache load	0.0015	0.1062	13	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0010	0.0717	1	0.0010
Fetch class attribute name	0.0013	0.0868	2	0.0006
XML
Image XML parsing	0.0001	0.0079	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	2	0.0000
General
dbfile	0.0006	0.0432	10	0.0001
String conversion	0.0000	0.0008	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/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	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: 6 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs