Project

General

Profile

Actions

Bug #1335

closed

DB function failed with error number 1064

Added by chuksy over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
High
Assignee:
-
Target version:
Start date:
28 November 2009
Due date:
% Done:

100%

Estimated time:

Description

Hi, I successfully installed b5 and when I try to manager members I get this error: Y

ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY b.id' at line 5 SQL=SELECT b.*, GROUP_CONCAT(g.id SEPARATOR ' ') AS groupids FROM jos_users AS b LEFT JOIN jos_gj_users AS u ON u.id_user = b.id LEFT JOIN jos_gj_groups AS g ON u.id_group = g.id WHERE b.id IN () GROUP BY b.id

Pls what is the solution to this?

Thanks


Files

groupjive.jpg (151 KB) groupjive.jpg chuksy, 28 November 2009 21:39
Actions #1

Updated by beat over 14 years ago

  • Assignee deleted (beat)
Actions #2

Updated by krileon over 14 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Duplicate issue; please see #1322.

Actions

Also available in: Atom PDF