Db problem i faced after upgrad

Next topic

Author	Message
John Mina	Wednesday 29 June 2005 6:38:49 am Dear Developers, I faced some problems afetr upradding or in my way to upgrade, I was running 3.3-3 then i moved 3.3-4 then 3.3-5 actuall ythe db only have minor changes n these 2 upgrades. then i moved to 3.4.0 and i Found that DB is having a problem inone of the tables information where i can't even view via phpmyadmin on the server. Do Any body know how to make sure that file works fine, it is called ezapprove... in the past i haven;t had any important approvement to be done only one editor for the Web site. So do any one have any clue about how to fix that ? NOTE: the OLD DB of version 3.3-5 is having the same peroblem by the same table Many thanks to you for cooperation Best Regards John
John Mina	Sunday 03 July 2005 12:44:39 am a clarification to my problem stated above i get the following error when i try to open either tables ezsearch or ezapprove <i> Can't open file: 'ezsearch_object_word_link.MYD'. (errno: 145) Error SQL-query : SHOW KEYS FROM `ezsearch_object_word_link` MySQL said: #1016 - Can't open file: 'ezsearch_object_word_link.MYD'. (errno: 145) </i>
Daniel Beyer	Sunday 03 July 2005 9:00:29 am Hi John, did you make use of the update-scripts, too. Putting the upgrade-sql-files into you database is not the only thing that has to be done for upgrading the database. Refer to this document to see what has to be done for upgrading eZ publish 3.3.5 to 3.4.0: http://ez.no/ez_publish/download/changelogs/ez_publish_3_4/upgrading Here is an overview in which order you have to upgrade eZ publish: http://ez.no/ez_publish/documentation/general_information/what_is_ez_publish/releases Here you can find all changelogs and hints how to upgrade a specific version: http://ez.no/ez_publish/download/changelogs/ Daniel Beyer _________________________________ YMC AG Kreuzlingen, Switzerland web: www.ymc.ch ____________________________________

Author

Message

Wednesday 29 June 2005 6:38:49 am

Dear Developers,
I faced some problems afetr upradding or in my way to upgrade, I was running 3.3-3 then i moved 3.3-4 then 3.3-5 actuall ythe db only have minor changes n these 2 upgrades. then i moved to 3.4.0 and i Found that DB is having a problem inone of the tables information where i can't even view via phpmyadmin on the server.

Do Any body know how to make sure that file works fine,
it is called ezapprove... in the past i haven;t had any important approvement to be done
only one editor for the Web site. So do any one have any clue about how to fix that ?

NOTE: the OLD DB of version 3.3-5 is having the same peroblem by the same table

Many thanks to you for cooperation
Best Regards
John

John Mina

Sunday 03 July 2005 12:44:39 am

a clarification to my problem stated above i get the following error when i try to open either tables ezsearch or ezapprove
<i>
Can't open file: 'ezsearch_object_word_link.MYD'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `ezsearch_object_word_link`

MySQL said:

#1016 - Can't open file: 'ezsearch_object_word_link.MYD'. (errno: 145)
</i>

Daniel Beyer

Sunday 03 July 2005 9:00:29 am

Hi John,

did you make use of the update-scripts, too. Putting the upgrade-sql-files into you database is not the only thing that has to be done for upgrading the database. Refer to this document to see what has to be done for upgrading eZ publish 3.3.5 to 3.4.0:
http://ez.no/ez_publish/download/changelogs/ez_publish_3_4/upgrading

Here is an overview in which order you have to upgrade eZ publish:
http://ez.no/ez_publish/documentation/general_information/what_is_ez_publish/releases

Here you can find all changelogs and hints how to upgrade a specific version:
http://ez.no/ez_publish/download/changelogs/

Daniel Beyer
_________________________________
YMC AG
Kreuzlingen, Switzerland
web: www.ymc.ch
____________________________________

eZ debug

Timing:	Jan 19 2025 11:36:18
Script start
Timing:	Jan 19 2025 11:36:18
Module start 'layout'
Timing:	Jan 19 2025 11:36:18
Module start 'content'
Timing:	Jan 19 2025 11:36:18
Module end 'content'
Timing:	Jan 19 2025 11:36:18
Script end

Main resources:

Total runtime	0.0219 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	590.4297	152.6250
Module start 'layout'	0.0056	0.0087	743.0547	39.4609
Module start 'content'	0.0144	0.0052	782.5156	89.3203
Module end 'content'	0.0195	0.0023	871.8359	34.3047
Script end	0.0218		906.1406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0029	13.3668	14	0.0002
Check MTime	0.0013	5.7910	14	0.0001
Mysql Total
Database connection	0.0009	3.9886	1	0.0009
Mysqli_queries	0.0041	18.7500	3	0.0014
Looping result	0.0000	0.0687	1	0.0000
Template Total	0.0019	8.8	1	0.0019
Template load	0.0012	5.6339	1	0.0012
Template processing	0.0007	3.1414	1	0.0007
Override
Cache load	0.0008	3.8414	1	0.0008
General
dbfile	0.0003	1.4785	8	0.0000
String conversion	0.0000	0.0556	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