summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2008-04-03 10:36:54 +0000
committerthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2008-04-03 10:36:54 +0000
commit749680b3b88dc5968c7b372eafc728748a79a0c8 (patch)
tree26af5111fa6e66b5a3fc84fdf6f0574988a7e4b3
parent120dee0978a4dc29e8a904bfe4a0e31c3cf192ca (diff)
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
-rw-r--r--roundcubemail/installer/test.php10
1 files 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());