Changeset 6321 for branches

Timestamp:

May 24, 2010, 1:12:23 PM (14 years ago)

Author:

plg

Message:

bug 1682: r6312 was producing a MySQL error (depending on the MySQL server
version) because a count() implies a group by.

This code change was checked against MySQL 5.0.75, MySQL 5.0.51 (where the
error occured) and SQLite 3.6.22.

File:

• branches/2.1/include/functions_user.inc.php (modified) (1 diff)

branches/2.1/include/functions_user.inc.php

@@ -302 +302 @@
     LEFT JOIN '.THEMES_TABLE.' AS t ON t.id = ui.theme
   WHERE ui.user_id = \''.$user_id.'\'
+  GROUP BY ui.user_id
 ;';
   $result = pwg_query($query);
   $user_infos_row = pwg_db_fetch_assoc($result);
-  if (0 == $user_infos_row['counter']) {
+  if (!isset($user_infos_row['counter']) or 0 == $user_infos_row['counter']) {
     create_user_infos($user_id);