All Database Tables Deleted

Next topic

Author	Message
Valerie Lynn	Wednesday 25 August 2004 1:49:15 pm You know it's a BAD day when you are - reinstalling EZPublish using the wizard and you get to the part where you can choose delete all data from your database...and well, you do. The problem is, my "database" was comprised of several different tables, 1 set for one application, another set for a second application and the newly created ez publish tables for - you guesed it - the EZPublish Application - all separated by the first two characters of the table names. Word to the wise - ALL tables were deleted - not just tables associated with EZPublish. Val ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ Is it dinnertime yet?
Bård Farstad	Wednesday 25 August 2004 1:57:18 pm Ouch! We should make eZ publish only delete the tables prefixed with ez. I hope you had backup. --bård Documentation: http://ez.no/doc
Trond Åge Kvalø	Thursday 26 August 2004 6:51:29 am Actually it would be best if eZpublish only deleted the tables it created at setup. What if someone has their own tables that start with ez? Maybe the prefix should be something more distinct? just a few thoughts.... best regards trondåge trondåge
Bruce Alspaugh	Friday 27 August 2004 9:13:55 am I'm suprised that in the install wizard you are not given the option to specify what the table prefix should be. A lot of hosting providers only allow you to have one database so you have to share it with multiple applications. If you can specify your own prefix, EZPublish can more easily play nice nicely with other applications. When it comes time to delete tables, you can tell it to delete only those with a certain prefix.
Trond Åge Kvalø	Tuesday 14 September 2004 6:54:24 am You'd think that one should be able to learn from other peoples mistakes, but naahhh.... Now our tables are gone too :-/ We do of course have backup, but still, it's quite a nuisance to restore everything. So does the eZ crew have an ETA for the excellent feature that Bruce described in the post above? best regards trondåge

eZ debug

Timing:	Jan 18 2025 11:45:26
Script start
Timing:	Jan 18 2025 11:45:26
Module start 'layout'
Timing:	Jan 18 2025 11:45:26
Module start 'content'
Timing:	Jan 18 2025 11:45:27
Module end 'content'
Timing:	Jan 18 2025 11:45:27
Script end

Main resources:

Total runtime	0.8813 sec
Peak memory usage	4,096.0000 KB
Database Queries	71

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	589.1484	152.6406
Module start 'layout'	0.0055	0.0042	741.7891	39.4766
Module start 'content'	0.0097	0.8700	781.2656	982.3516
Module end 'content'	0.8797	0.0015	1,763.6172	12.1484
Script end	0.8812		1,775.7656

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0043	0.4851	17	0.0003
Check MTime	0.0019	0.2187	17	0.0001
Mysql Total
Database connection	0.0009	0.0982	1	0.0009
Mysqli_queries	0.7857	89.1574	71	0.0111
Looping result	0.0008	0.0888	68	0.0000
Template Total	0.8475	96.2	2	0.4237
Template load	0.0028	0.3187	2	0.0014
Template processing	0.8446	95.8454	2	0.4223
Template load and register function	0.0001	0.0159	1	0.0001
states
state_id_array	0.0009	0.1036	1	0.0009
state_identifier_array	0.0010	0.1172	2	0.0005
Override
Cache load	0.0023	0.2635	28	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0913	4	0.0002
Fetch class attribute name	0.0017	0.1875	7	0.0002
XML
Image XML parsing	0.0034	0.3850	4	0.0008
class_abstraction
Instantiating content class attribute	0.0000	0.0020	9	0.0000
General
dbfile	0.0030	0.3370	29	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 16 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs