Forums / General / URGENT !!!! removed root folder, how to fix?

URGENT !!!! removed root folder, how to fix?

Author Message

Baur Aibek

Monday 21 June 2004 2:48:46 am

user deleted root folder of a huge site :( the whole site gone to trash.

tried to restore root from trash - no result.

PLEASE help how to repair.

Bård Farstad

Monday 21 June 2004 2:53:52 am

The quickest would be to restore the site from backup.

eZ publish does not support restoring the site structure, only the content. So it will take some time to re-build this manually.

--bård

Documentation: http://ez.no/doc

Baur Aibek

Monday 21 June 2004 2:57:57 am

how to do it?
what is backup? ( we had done only database backup a month ago :(

Baur Aibek

Monday 21 June 2004 3:06:43 am

say at least how to create empty root folder again. we r ready to make structure manually

your advice lookes like a joke (did u really wanted to help?)

Björn Dieding@xrow.de

Monday 21 June 2004 7:03:06 am

To create a new root folder you will have to insert data in the following tables

-ezcontentobject
-ezcontentobject_attribute
-eznode_assignment
-ezcontentobject_tree

make sure it si using the node id 2

you can read the past settings from the the

kernel/sql/mysql/kernel_schema.sql

Doing no daily backups isn't funny either.

-
http://www.xrow.de

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/

Björn Dieding@xrow.de

Monday 21 June 2004 7:05:35 am

just an additional note

if your data is still in the db (trash)

try to set all co to published objects (manually)

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/

Baur Aibek

Monday 21 June 2004 7:57:28 pm

thank people

pls explain "try to set all co to published objects (manually) "

whats "co"m where to set? which table?

please explain

Balazs Halasy

Tuesday 22 June 2004 1:15:05 am

I would suggest that you back up your database (even if it is corrupt) before you do anything else:

mysqldump -u <user> -p <pass> <db_name> > backupfile.sql

When you've backed it up: try to create a new root node by doing as Bjørn says. Finally: you can try to do manual restore from trash, node-by-node. Good luck!

Balazs

Baur Aibek

Tuesday 22 June 2004 2:02:40 am

all is ok
root repaired
we have restored site manually

thanks to all

eZ debug

Timing: Jan 31 2025 06:11:23
Script start
Timing: Jan 31 2025 06:11:23
Module start 'content'
Timing: Jan 31 2025 06:11:23
Module end 'content'
Timing: Jan 31 2025 06:11:23
Script end

Main resources:

Total runtime0.1401 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.0052 588.0547180.8203
Module start 'content' 0.00520.0063 768.8750102.0234
Module end 'content' 0.01150.1285 870.8984529.8750
Script end 0.1400  1,400.7734 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.3284200.0002
Check MTime0.00130.9548200.0001
Mysql Total
Database connection0.00060.456710.0006
Mysqli_queries0.094967.71371410.0007
Looping result0.00100.69431390.0000
Template Total0.128191.410.1281
Template load0.00080.603110.0008
Template processing0.127290.820610.1272
Override
Cache load0.00060.421210.0006
Sytem overhead
Fetch class attribute can translate value0.00060.450310.0006
XML
Image XML parsing0.00030.194010.0003
General
dbfile0.00906.4174200.0004
String conversion0.00000.002930.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.0002 secs