From 749680b3b88dc5968c7b372eafc728748a79a0c8 Mon Sep 17 00:00:00 2001 From: thomasb Date: Thu, 3 Apr 2008 10:36:54 +0000 Subject: New test-query that does not violate any foreign key contraints git-svn-id: https://svn.roundcube.net/trunk@1241 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/installer/test.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/roundcubemail/installer/test.php b/roundcubemail/installer/test.php index 04259dd1c..5be343a31 100644 --- a/roundcubemail/installer/test.php +++ b/roundcubemail/installer/test.php @@ -120,12 +120,12 @@ if ($db_working) { // more database tests if ($db_working) { // write test - $db_write = $DB->query("INSERT INTO {$RCI->config['db_table_cache']} (session_id, cache_key, data, user_id) VALUES (?, ?, ?, 0)", '1234567890abcdef', 'test', 'test'); - $insert_id = $DB->insert_id($RCI->config['db_sequence_cache']); - - if ($db_write && $insert_id) { + $insert_id = md5(uniqid()); + $db_write = $DB->query("INSERT INTO {$RCI->config['db_table_session']} (sess_id, created, ip, vars) VALUES (?, ".$DB->now().", '127.0.0.1', 'foo')", $insert_id); + + if ($db_write) { $RCI->pass('DB Write'); - $DB->query("DELETE FROM {$RCI->config['db_table_cache']} WHERE cache_id=?", $insert_id); + $DB->query("DELETE FROM {$RCI->config['db_table_session']} WHERE sess_id=?", $insert_id); } else { $RCI->fail('DB Write', $RCI->get_error()); -- cgit v1.2.3