summaryrefslogtreecommitdiff
path: root/includes/db_schema
diff options
context:
space:
mode:
authorfisharebest <fisharebest@gmail.com>2010-11-07 11:52:20 +0000
committerfisharebest <fisharebest@gmail.com>2010-11-07 11:52:20 +0000
commita6b57e1c9d1af4c8eb01224bc4ac73556c2c0f76 (patch)
tree8ba4d085e7c211f7f6b293f3ca74f5572da613ec /includes/db_schema
parent736267fb3ccdd6017b2b97c23d29790966b686f2 (diff)
downloadwebtrees-a6b57e1c9d1af4c8eb01224bc4ac73556c2c0f76.tar.gz
webtrees-a6b57e1c9d1af4c8eb01224bc4ac73556c2c0f76.tar.bz2
webtrees-a6b57e1c9d1af4c8eb01224bc4ac73556c2c0f76.zip
Unquoted table name in DB SCHEMA update script. Will cause problems for anyone who uses a table prefix that is not alphanumeric...
Diffstat (limited to 'includes/db_schema')
-rw-r--r--includes/db_schema/db_schema_3_4.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/db_schema/db_schema_3_4.php b/includes/db_schema/db_schema_3_4.php
index 01493464a9..845628c24f 100644
--- a/includes/db_schema/db_schema_3_4.php
+++ b/includes/db_schema/db_schema_3_4.php
@@ -44,7 +44,7 @@ define('WT_DB_SCHEMA_3_4', '');
self::exec(
"INSERT IGNORE INTO `##user_gedcom_setting` (user_id, gedcom_id, setting_name, setting_value)".
" SELECT u.user_id, g.gedcom_id, 'RELATIONSHIP_PATH_LENGTH', LEAST(us1.setting_value, gs1.setting_value)".
- " FROM ##user u".
+ " FROM `##user` u".
" CROSS JOIN `##gedcom` g".
" LEFT JOIN `##user_setting` us1 ON (u.user_id =us1.user_id AND us1.setting_name='max_relation_path')".
" LEFT JOIN `##user_setting` us2 ON (u.user_id =us2.user_id AND us2.setting_name='relationship_privacy')".