Hi, I'm trying to figure out how to fix a site that broke shortly after updating from Joomla 3.1.5 to 3.2.
After running that update, the site seemed fine until I logged out and tried to login again later. Now when I log in to the admin area, I get this error:
There appears to be a syntax error which is writing "(549),(7)" instead of "(549,7)".
I've searched the site files and I think I may have found the offending bit of code in the file "administrator/components/com_k2/models/users.php" but I'm not smart enough to parse it correctly.
Here's line 420:
Is the syntax on that last part correct, or could it be causing this error? It loses me at "implode" but it looks like the nesting may be off or there may be one too many commas.
I also updated K2 during this same work session, so it's possible it could be K2-related. Apologies in advance if I'm barking up the wrong tree here.
Thanks,
Greg
After running that update, the site seemed fine until I logged out and tried to login again later. Now when I log in to the admin area, I get this error:
An error has occurred.
1136 Column count doesn't match value count at row 1 SQL=INSERT INTO hmwmh_user_usergroup_map (user_id,group_id) VALUES (549),(7)
There appears to be a syntax error which is writing "(549),(7)" instead of "(549,7)".
I've searched the site files and I think I may have found the offending bit of code in the file "administrator/components/com_k2/models/users.php" but I'm not smart enough to parse it correctly.
Here's line 420:
$query = "INSERT INTO #__user_usergroup_map VALUES (".$id.", ".implode("), (".$id.", ", $group).")";Is the syntax on that last part correct, or could it be causing this error? It loses me at "implode" but it looks like the nesting may be off or there may be one too many commas.
I also updated K2 during this same work session, so it's possible it could be K2-related. Apologies in advance if I'm barking up the wrong tree here.
Thanks,
Greg