Database Problem

Next topic

Author	Message
Christian Santiago	Monday 03 May 2010 2:27:16 pm Hello,ive installed the latest ez publish with ez flow on my site,i went through the steps and everything went ok,untill i got to 71% where i have to put the details for the site,and when i hite next i get this error Warning The database [db328220869] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [db328220869] now i went to phpmyadmin and the database was created in utf-8 thats what it says,so how can i fix this.i have 1and1 hosting and i have no idea how to change thsi database to utf-8 if i have to.thanks in advanced
Jarosław Heba	Monday 03 May 2010 3:18:27 pm Hi, What about collation?
Doug Brethower	Monday 03 May 2010 9:06:28 pm In phpmyadmin or in mysql prompt: ALTER DATABASE `db328220869` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Cheers! Doug Brethower Apple Certified Technical Consultant, Southwest, MO USA http://share.ez.no/directory/companies/lakedata.net

Author

Message

Monday 03 May 2010 2:27:16 pm

Hello,ive installed the latest ez publish with ez flow on my site,i went through the steps and everything went ok,untill i got to 71% where i have to put the details for the site,and when i hite next i get this error

Warning

The database [db328220869] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [db328220869]

now i went to phpmyadmin and the database was created in utf-8 thats what it says,so how can i fix this.i have 1and1 hosting and i have no idea how to change thsi database to utf-8 if i have to.thanks in advanced

Jarosław Heba

Monday 03 May 2010 3:18:27 pm

Hi,

What about collation?

Doug Brethower

Monday 03 May 2010 9:06:28 pm

In phpmyadmin or in mysql prompt:

ALTER DATABASE `db328220869` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Cheers!

Doug Brethower
Apple Certified Technical Consultant, Southwest, MO USA
http://share.ez.no/directory/companies/lakedata.net

eZ debug

Timing:	Jan 29 2025 23:47:05
Script start
Timing:	Jan 29 2025 23:47:05
Module start 'layout'
Timing:	Jan 29 2025 23:47:05
Module start 'content'
Timing:	Jan 29 2025 23:47:06
Module end 'content'
Timing:	Jan 29 2025 23:47:06
Script end

Main resources:

Total runtime	0.9883 sec
Peak memory usage	4,096.0000 KB
Database Queries	59

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.1328	151.2109
Module start 'layout'	0.0045	0.0026	739.3438	36.6484
Module start 'content'	0.0071	0.9805	775.9922	524.6719
Module end 'content'	0.9876	0.0007	1,300.6641	11.8594
Script end	0.9883		1,312.5234

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0029	0.2928	16	0.0002
Check MTime	0.0012	0.1246	16	0.0001
Mysql Total
Database connection	0.0007	0.0746	1	0.0007
Mysqli_queries	0.9472	95.8406	59	0.0161
Looping result	0.0005	0.0491	57	0.0000
Template Total	0.9614	97.3	2	0.4807
Template load	0.0017	0.1718	2	0.0008
Template processing	0.9597	97.1051	2	0.4799
Template load and register function	0.0001	0.0127	1	0.0001
states
state_id_array	0.0007	0.0742	1	0.0007
state_identifier_array	0.0008	0.0805	2	0.0004
Override
Cache load	0.0014	0.1436	17	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0539	3	0.0002
Fetch class attribute name	0.0009	0.0921	6	0.0002
XML
Image XML parsing	0.0038	0.3815	3	0.0013
class_abstraction
Instantiating content class attribute	0.0000	0.0005	6	0.0000
General
dbfile	0.0051	0.5114	28	0.0002
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
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/header.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/header.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs