From 80bd128425b99d91ddca897bc2cd6dcef5268fe4 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 30 Aug 2012 18:47:07 -0700 Subject: more DB cleanup --- mod/profiles.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mod/profiles.php') diff --git a/mod/profiles.php b/mod/profiles.php index 276fcaf64..d864c18d2 100644 --- a/mod/profiles.php +++ b/mod/profiles.php @@ -289,7 +289,7 @@ function profiles_post(&$a) { if($namechanged && $is_default) { - $r = q("UPDATE `contact` SET `name-date` = '%s' WHERE `self` = 1 AND `uid` = %d LIMIT 1", + $r = q("UPDATE `contact` SET `name_date` = '%s' WHERE `self` = 1 AND `uid` = %d LIMIT 1", dbesc(datetime_convert()), intval(local_user()) ); @@ -420,7 +420,7 @@ function profiles_content(&$a) { // move every contact using this profile as their default to the user default - $r = q("UPDATE `contact` SET `profile-id` = (SELECT `profile`.`id` AS `profile-id` FROM `profile` WHERE `profile`.`is_default` = 1 AND `profile`.`uid` = %d LIMIT 1) WHERE `profile-id` = %d AND `uid` = %d ", + $r = q("UPDATE `contact` SET `profile_id` = (SELECT `profile`.`id` AS `profile_id` FROM `profile` WHERE `profile`.`is_default` = 1 AND `profile`.`uid` = %d LIMIT 1) WHERE `profile_id` = %d AND `uid` = %d ", intval(local_user()), intval($a->argv[2]), intval(local_user()) -- cgit v1.2.3