Need to create a lot of groups!
By Dave Parker on Monday, 19 January 2015
Posted in Tips & Tricks (Not Supported)
Replies 4
Likes 0
Views 841
Votes 0
Hi guys.
I have the need to create a lot of groups (for regional areas of the UK). I've started putting them in 1-by-1 but it's going to take days! Not to mention when I am creating them (even from the back-end), a status update is posted on the front end!
So, is there a way I can do this? Even by running a SQL script with the correct information in phpMyAdmin? It would cut down on hours of admin work.
Cheers
Dave
Also...
When trying to create a new group in the backend - I get this error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=UPDATE cxvoz_social_clusters SET `type` = '1' WHERE `id` IN ()
Dave
Dave Parker
·
Monday, 19 January 2015 00:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

Unfortunately right now it's not possible to "mass create groups" at this point of time
Mark
·
Monday, 19 January 2015 01:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark.
**** it!! Okay, a lot of typing to be done then!
Still perplexed over the SQL error though. It creates the group, but some of the fields are missed out, so I have to go back in and edit it after.
Dave
Dave Parker
·
Monday, 19 January 2015 01:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Dave,

Did you still facing this error when creating a group?

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL=UPDATE cxvoz_social_clusters SET `type` = '1' WHERE `id` IN ()

If you still facing this, you might want to provide your backend and FTP access so we can check it.
Nik Faris
·
Monday, 19 January 2015 10:32
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post