Data Base strange behaviour, eZ3.3-3

Wednesday 07 July 2004 2:19:34 am

Hi all
I have experienced a strange behaviour from my db recently
My DB Specifications:
My DB size is almost 100 MB , as i get from the phpMyAdmin
Containing Articles , and few *.doc Files , till now

Changes I found
All Article Bodies are moved from the body field to another field bellow which is part_2, that one i made for articles that are long so i can have 2 parts for the article

How I noticed that:
The home page just views the name of the articles of the news section, or any other section without showing INTRO , or pictures. though the intro is there in its places

THe pictures are not shown i guess for a different reason which is that the code generating the path of the picture, is nto generating anythign but a NULL.

What I made that i guess made that changes :-
I added a field in the article class "" after adding it and moving it up in the view of the admion tool, all this happend

I ASk if some one have any experience with such a problem and can help me .
I ASK EzPublish if they can guide me how to solve it up.

If any one have any idea how to upgrade my version to a stabel version of 3.4

A lot of thanks to your great job

Sicnerely
JOhn

Tuesday 13 July 2004 1:48:51 am

Hi Kare
well the informaiton of my server are as follows :

Version
 3.3-3 (3.3)
 
SVN revision
 5019
 
PHP
Version
 4.3.6
 
Extensions
 yp, xml, wddx, tokenizer, sysvshm, sysvsem, standard, sockets, shmop, session, pspell, posix, pcre, overload, mbstring, iconv, gmp, gettext, gd, ftp, exif, dio, dbx, dba, curl, ctype, calendar, bz2, bcmath, zlib, openssl, apache2handler, domxml, imap, ldap, mysql, odbc, pgsql, snmp, xmlrpc 
 
Safe mode is off.
Basedir restriction is off.
Global variable registration is on.
File uploading is enabled.
Maximum size of post data (text and files) is 8M.
Script memory limit is 26M.
Maximum execution time is 60 seconds.


PHP Accelerator
There is no known PHP accelerator active.

Yes i tried to edit the Article class , and that mde the problem i guess
I overcomed the problem now by reinstalling the old backup and i re-entered the articles lost.

Now i got 2 questions ?
how to solv ethis problem if there is any other way
NOTe i edited the Class by adding fields not removing any

HOw to get a php accelerator ?

i do appriciate your help as i do really apriciaite the EzPublish system , it is marvelous

Sincerely
JOhn Mina

Tuesday 13 July 2004 6:26:08 am

The corrupted articles is probably because you tried to update the article class. When you have ALOT of obects, this takes to long, and the Apache process times out before it's finnished.

One solution for this is to postpone the class update to the cronjob. This feature is not implemented yet, but will not take alot of time to make. Please contact support : http://ez.no/services/support if you're interested,

--
Kåre Høvik

Kåre Høvik

Wednesday 14 July 2004 1:06:56 am

Try to redindex your search table : http://ez.no/ez_publish/documentation/development/scripting/supplied_scripts/update_search_index

Kåre Høvik