what are the Db tables responsible for IMAGES ?

Author Message

John Mina

Monday 05 July 2004 5:01:56 am

Hi All
I wonder
What are the tables in the data base responsible for storing pathes for the images ?
I got a case that a code is working locally, and was working ion the remote server, but now not working remotly i downloaded the online DB and isntalled locally i find that localy the pictures are not shown like as if they were online

What do you think the problem is ?

Knowing that the code when runned for getting the apth for the picture it give "" empty string with no values

Any Clue please
Sincerely
John Mina

Björn Dieding@xrow.de

Monday 05 July 2004 7:19:05 pm

the tables ezimage* are resonsable for images...

the tabels hold the full path to the images...

Did you maybe change your siteaccess name? Did you forgot to transfer your storage dir?

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

John Mina

Tuesday 06 July 2004 4:24:13 am

I transfered the var directory all of it when i felt that iforgot somethign

so i am sure itransfered my storage fodler

Regarding teh site acces si guess i did edit some, but wht exactly should i check there

The code on the server returns NULL to me
:(

i transfered the latest working database from my machine this morning to the server , on my machine it is shown as if everythign si correct but on the server it is all the same
+ i mean add over the pictures that it is not retrieving any intro or article body to the users just the article name

What could that be
i installed the whole ezpublish on the server from scratch :(
Can you pleas ehelp me out with that ?
Sicnerely

Björn Dieding@xrow.de

Tuesday 06 July 2004 6:03:14 am

Check if you renamed the storage dir path when changing the siteaccess...

But I think your problem is somewhere else...

You seem to have somehow broken content objects.

Do the content object show up fine in the admin interface (body attribute and other)?

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 01:10:51
Script start
Timing: Jan 19 2025 01:10:51
Module start 'layout'
Timing: Jan 19 2025 01:10:51
Module start 'content'
Timing: Jan 19 2025 01:10:51
Module end 'content'
Timing: Jan 19 2025 01:10:51
Script end

Main resources:

Total runtime0.6292 sec
Peak memory usage4,096.0000 KB
Database Queries60

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0056 589.2813152.6406
Module start 'layout' 0.00560.0030 741.921939.4766
Module start 'content' 0.00860.6192 781.3984550.4453
Module end 'content' 0.62780.0014 1,331.843812.1250
Script end 0.6292  1,343.9688 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00350.5491160.0002
Check MTime0.00140.2194160.0001
Mysql Total
Database connection0.00080.129810.0008
Mysqli_queries0.574791.3375600.0096
Looping result0.00060.0892580.0000
Template Total0.595794.720.2979
Template load0.00210.334720.0011
Template processing0.593694.339620.2968
Template load and register function0.00020.035610.0002
states
state_id_array0.00190.305610.0019
state_identifier_array0.00150.231920.0007
Override
Cache load0.00180.2843350.0001
Sytem overhead
Fetch class attribute can translate value0.00050.084420.0003
Fetch class attribute name0.00130.214450.0003
XML
Image XML parsing0.00060.102020.0003
class_abstraction
Instantiating content class attribute0.00000.003260.0000
General
dbfile0.00070.1151160.0000
String conversion0.00000.001140.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 21
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs