Forums / Developer / Data Base strange behaviour, eZ3.3-3

Data Base strange behaviour, eZ3.3-3

Author Message

John Mina

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

Kåre Køhler Høvik

Tuesday 13 July 2004 12:22:34 am

Have you tried to edit the article class latetly ( Please don't try to change it untill you figure out what's wrong. )?
Which Apache/PHP/MySQL versions are you using ?

--
Kåre Høvik

Kåre Høvik

John Mina

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

John Mina

Tuesday 13 July 2004 6:03:07 am

HI
I got a question regardingthe DB also

it was working on my machine in agood way to search article sofr a certain word
but online it is not now
and when i downloaded the online version it is not workign ehr etoo
what is that ?

John

Kåre Køhler Høvik

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

John Mina

Wednesday 14 July 2004 12:12:11 am

Hi Kåre Høvik

I do really thank you alot for your help
and it is enough for me to knwo the reason ,

I wonder If you can help me overcome the secodn rpoblem which is the searching mechanism
and why doens't it work on the server thoguh it work on my machine
>?

Sincerely
JOhn

Kåre Køhler 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

John Mina

Wednesday 14 July 2004 6:40:37 am

Thanks for the HElp
But Unfortunatly , afetr i did the commands and it counted to 100% , it is not searching now either

and somethig is happening but i forgot to say that : after serachign for words X1 , whenever i search for any other word it gives me the results for the search of X1 till i empty my cahce?
it wasn;'t like this when i was working on my machine
wht do u thing the problem is ?

Regards
John