aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorZach Prezkuta <fermion@gmx.com>2013-05-12 09:40:54 -0600
committerZach Prezkuta <fermion@gmx.com>2013-05-12 09:40:54 -0600
commit24d088d43be7cc03a0975360d7542b578c48369f (patch)
tree9b07c3b53abfec221edabdbde9d88a6c8536300d
parent8a1c8c4a03899c844885da58f9184fc10e7d6b07 (diff)
downloadvolse-hubzilla-24d088d43be7cc03a0975360d7542b578c48369f.tar.gz
volse-hubzilla-24d088d43be7cc03a0975360d7542b578c48369f.tar.bz2
volse-hubzilla-24d088d43be7cc03a0975360d7542b578c48369f.zip
mysql 5.1 chokes on 'select * from group' since group is a keyword
-rw-r--r--include/identity.php4
-rw-r--r--mod/import.php4
-rw-r--r--mod/lockview.php4
3 files changed, 6 insertions, 6 deletions
diff --git a/include/identity.php b/include/identity.php
index c8910c018..4bbc8970b 100644
--- a/include/identity.php
+++ b/include/identity.php
@@ -293,7 +293,7 @@ function identity_basic_export($channel_id) {
$ret['hubloc'] = $r;
}
- $r = q("select * from group where uid = %d ",
+ $r = q("select * from `group` where uid = %d ",
intval($channel_id)
);
@@ -372,4 +372,4 @@ function identity_basic_import($arr, $seize_primary = false) {
return $ret;
-} \ No newline at end of file
+}
diff --git a/mod/import.php b/mod/import.php
index 4602c8aa8..9443f5c60 100644
--- a/mod/import.php
+++ b/mod/import.php
@@ -279,7 +279,7 @@ function import_post(&$a) {
. implode("', '", array_values($group))
. "')" );
}
- $r = q("select * from group where uid = %d",
+ $r = q("select * from `group` where uid = %d",
intval($channel['channel_id'])
);
if($r) {
@@ -341,4 +341,4 @@ function import_content(&$a) {
return $o;
-} \ No newline at end of file
+}
diff --git a/mod/lockview.php b/mod/lockview.php
index 01a6997ee..7dda85623 100644
--- a/mod/lockview.php
+++ b/mod/lockview.php
@@ -49,7 +49,7 @@ function lockview_content(&$a) {
stringify_array_elms($deny_users,true);
if(count($allowed_groups)) {
- $r = q("SELECT name FROM group WHERE hash IN ( " . implode(', ', $allowed_groups) . " )");
+ $r = q("SELECT name FROM `group` WHERE hash IN ( " . implode(', ', $allowed_groups) . " )");
if($r)
foreach($r as $rr)
$l[] = '<b>' . $rr['name'] . '</b>';
@@ -61,7 +61,7 @@ function lockview_content(&$a) {
$l[] = $rr['xchan_name'];
}
if(count($deny_groups)) {
- $r = q("SELECT name FROM group WHERE hash IN ( " . implode(', ', $deny_groups) . " )");
+ $r = q("SELECT name FROM `group` WHERE hash IN ( " . implode(', ', $deny_groups) . " )");
if($r)
foreach($r as $rr)
$l[] = '<b><strike>' . $rr['name'] . '</strike></b>';