|
From: SourceForge.net <no...@so...> - 2008-03-05 00:25:48
|
Bugs item #1875897, was opened at 2008-01-20 19:57 Message generated for change (Settings changed) made by christian_boltz 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: 8 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) >Summary: "invalid query" in upgrade.php (caused by foreign keys?) 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: Christian Boltz (christian_boltz) Date: 2008-03-05 01:24 Message: Logged In: YES user_id=593261 Originator: NO The comment from "nobody" on 2008-01-21 17:21 shows two problems: 1) the "invalid query" shown by upgrade.php I'll have to check this, probably it is caused by the foreign keys, which make altering tables an interesting challenge ;-) 2) creation of vacation_notification fails This part looks like a duplicate of http://sourceforge.net/tracker/index.php?func=detail&aid=1828857&group_id=191583&atid=937964 ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2008-01-21 17: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 21: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 |
