Multi Drop Down List produces errors with EE 1.6 and Multisite Manager (MSM)
Development and Programming
This is the error I have been getting with EE 1.6 and MSM and it appears to be related to the MultiDrop down list extension. When I disabled the extension, all worked okay.
MySQL ERROR:
Error Number: 1064
Description: 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 f.group_id=w.field_group AND f.field_type='multiselect'' at line 1
Query: SELECT f.field_id, f.field_name, f.field_pre_populate, f.field_pre_blog_id, f.field_pre_field_id FROM bcc_weblog_fields AS f, bcc_weblogs AS w WHERE w.weblog_id= AND f.group_id=w.field_group AND f.field_type='multiselect'This has proven to be rather painful since my current project relies on several multi-select fields. Consequently, I have had to downgrade to EE 1.5 to continue development of my project.
Has anyone else experienced this?
DW2
WHy not disable MSM and see what happens?
I was quite a ways into the development when the error showed up. I “was” quite committed to the MSM at that time and felt that disabling the extension was the best option. Unfortunately, one of the major forms in the project contains several multiple select items and to be without the extension was not a good option.