MySQl Error1064
Resolved

Hi guys, Mark here from Image Village.

Been having some issues with the 3.9.1623 to 5.0.32 migration.

Successfully installed J3.4.8 and exported all media files from the correct directories, extracted the SQL database tables and assigned correct prefix for the new MySQL injection, all perfect.

Installed EB3.9.1623 and then installed the latest EB5.0.32 and BOOM! There it is, all working sweet as....then the nut cracked and out popped this little beauty:

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 ') AND `type`='group'' at line 1 SQL=SELECT * FROM `XXXXXX_easyblog_acl_group` WHERE `content_id` IN () AND `type`='group'

Is this an issue with exporting from one unicode to another? I am a bit stumped on this one and wondered if you could help. Unfortunately as i handed my account over to my client (wanted access to resources) i don't have direct access to communications from in here so will have to check back for response or to provide access to DB or J3ADMIN.

If you are happy to e-mail me direct then please do on suppor tAT imagevillage DOT co DOT uk

Appreciate the help and great work on the new EB5 creation, lovely installation interface and looking sweet on J3! :)

Kind regards,

Mark
1 replies
Sue Jones replied on Sunday, February 21 2016, 11:59 PM
Accepted Answer
Scrap that guys i have sussed it out, it seems it was because the user ID belonged to a different set of permissions.

On Assigning the user to SU group the ID assigned from the old DB with those permissions is what was causing the MySQL error.

All solved!


Happy days!:D
Your time
Stack Ideas time
Support is
Offline
It's after office hours

It is currently off working hours and most of us aren't around.

Rest assured that we will get back to your issues as soon as the day starts tomorrow!


Official support hour is:
Monday — Friday. 10:00 am - 7:00 pm
Our timezone:
Kuala Lumpur (GMT +8)