Forums / Install & configuration / ezimagefile table is empty vs images already stored

ezimagefile table is empty vs images already stored

Author Message

Patricio Villacorta

Thursday 15 January 2004 9:58:13 am

i make a clean upgrade from ez 3.2-3 to 3.3-1. But now i can't load images. If a upload new image, this work fine. But none of images content on storage prior to upgrade are visible.
Looking sql updates scripts, note new table ezimagefile, this is empty, and when upload a new image, data is stored in this table.
How can build info associate to my images already stored?

Thanks in advance...

James Packham

Friday 16 January 2004 8:24:12 am

Assuming all your images are still in var/yoursite/storage you could just restore the old ezimage table from your backup (You made one before the upgrade right?). As long as you edit the sql so that only the data gets put in for that table (not the table structure itself) you should be fine.

Regards,

~James~

Patricio Villacorta

Friday 16 January 2004 10:56:53 am

my ezimage table is sane. when sql update was applied, this create i new table ezimagefile. Now only i can see in my site images posted after update, because ezimagefile have info about them. But older images only in ezimage table are not visible. I think while not have data about mi older images (ezimage table) into new ezimagefile table, i will can't access it. Maybe need build a sql script for fix this issue?

Willie Seabrook

Friday 16 January 2004 12:08:28 pm

I have the same problem

Harry Oosterveen

Tuesday 27 January 2004 8:11:42 am

Apparently, version 3.3 has a new way to store image files, and this is not backward compatible. Is there an update script available for this?

The sql files only create the new 'ezimagefile' table, but do not convert the content of the old 'ezimage' table.

Patricio Villacorta

Tuesday 27 January 2004 12:47:37 pm

I posted this issue in bug section... look for the reply... works for me.

http://ez.no/community/bug_reports/ezimagefile_table_is_empty_vs_current_ezimage_table_upgrade

eZ debug

Timing: Jan 18 2025 18:26:34
Script start
Timing: Jan 18 2025 18:26:34
Module start 'content'
Timing: Jan 18 2025 18:26:34
Module end 'content'
Timing: Jan 18 2025 18:26:34
Script end

Main resources:

Total runtime0.1862 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0080 589.0938180.8047
Module start 'content' 0.00800.0052 769.898497.9766
Module end 'content' 0.01320.1729 867.8750526.3750
Script end 0.1861  1,394.2500 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00331.7719200.0002
Check MTime0.00140.7321200.0001
Mysql Total
Database connection0.00180.952210.0018
Mysqli_queries0.138474.30051410.0010
Looping result0.00150.78831390.0000
Template Total0.172692.710.1726
Template load0.00070.402710.0007
Template processing0.171892.277010.1718
Override
Cache load0.00050.268510.0005
Sytem overhead
Fetch class attribute can translate value0.00090.460310.0009
XML
Image XML parsing0.00020.122510.0002
General
dbfile0.00311.6663200.0002
String conversion0.00000.003830.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs