[ postfixadmin-Bugs-1875897 ] can`t create backup from menu

[SourceForge.net <no...@so...>]

Bugs item #1875897, was opened at 2008-01-20 10:57
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1875897&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Interface (example)
Group: SVN (please specify revision!)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: can`t create backup from menu

Initial Comment:
SVN version 2008-01-19T16:48:15.336774Z
297

in file backup.php 

- $result = db_query ("SHOW CREATE TABLE ".table_by_pos($i)); 
+ $result = db_query ("SHOW CREATE TABLE $tables[$i]");

- $result = db_query ("SELECT * FROM ".table_by_pos($i));
+ $result = db_query ("SELECT * FROM $tables[$i]");

- $tables = array('admin','alias','config','domain','domain_admins','log','mailbox','vacation','vacation_notification');
+ $tables = array('admin','alias','domain','domain_admins','log','mailbox','vacation','vacation_notification');



----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2008-01-21 08:21

Message:
Logged In: NO 

sorry, I run upgrade.php and problem was solved. But when I run the
upgrade.php, I saw this problem: 

ALTER TABLE `vacation` CHANGE `email` `email` VARCHAR( 255 ) /*!40100
CHARACTER SET latin1 COLLATE latin1_swedish_ci */ NOT NULL

DEBUG INFORMATION:
Invalid query: Error on rename of './postfix/#sql-33c0_2b1' to
'./postfix/vacation' (errno: 150)

if I remove table vacation and vacation_notificaion and then I create it
using

CREATE TABLE `vacation` (
  `email` varchar(255) /*!40100 CHARACTER SET latin1 COLLATE
latin1_swedish_ci */ NOT NULL default '',
  `subject` varchar(255) /*!40100 CHARACTER SET latin1 COLLATE
latin1_swedish_ci */ NOT NULL default '',
  `body` text NOT NULL,
  `cache` text NOT NULL,
  `domain` varchar(255) /*!40100 CHARACTER SET latin1 COLLATE
latin1_swedish_ci */ NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`email`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual
Vacation';

everything is done, but I can`t create table vacation_notification using

CREATE TABLE vacation_notification (
	on_vacation varchar(255) NOT NULL,
	notified varchar(255) NOT NULL,
	notified_at timestamp NOT NULL default now(),
	CONSTRAINT vacation_notification_pkey PRIMARY KEY(on_vacation,
notified),
	FOREIGN KEY (on_vacation) REFERENCES vacation(email) ON DELETE CASCADE
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci TYPE=InnoDB
        COMMENT='Postfix Admin - Virtual Vacation Notifications';

I obtain error that table /postfix/vacation_notification.frm can`t be
created errono=150


----------------------------------------------------------------------

Comment By: Christian Boltz (christian_boltz)
Date: 2008-01-20 12:37

Message:
Logged In: YES 
user_id=593261
Originator: NO

Hmm, I can't see what fails here - I just tested and the backup seems to
work.

Can you please add some details? What is the problem you want to solve?

BTW: Your $tables does not include the "config" table. If you have updated
from an earlier version of postfixadmin, please run upgrade.php to create
it (and to update your other tables also).

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1875897&group_id=191583