|
JesterZ Improv
|
June 12, 2013 at 12:08 am
WordPress database error: [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 ‘WHERE event_id = ‘430” at line 1]
SELECT event_id FROM WHERE event_id = '430'
WordPress database error: [Incorrect table name ”]
INSERT INTO `` (`event_id`,`mailchimp_list_id`) VALUES ('430','54cfbe29db')
what to do, to fix?
|
|
Dean
|
June 12, 2013 at 2:54 am
Hi,
It looks like the tables in the database havent been created for some reason. The first thing I would do is to deactivate and reactivate the Mailchimp addon plugin to see if it creates them.
|
|
JesterZ Improv
|
June 12, 2013 at 10:52 am
we deactivated and reactivated. we also uninstalled and reinstalled. trying both the current as well as the pre-release versions. still the same error results.
|
|
JesterZ Improv
|
June 12, 2013 at 11:05 am
just did the deactivate again, etc. and got:
WordPress database error: [Incorrect table name ”]
INSERT INTO `` (`event_id`,`mailchimp_list_id`) VALUES ('462','54cfbe29db')
let me know what’s next to get this fixed.
thanks!
|
|
Josh
|
June 12, 2013 at 2:26 pm
Hi JesterZ,
I’m seeing the same errors on my newer test installs. The older ones aren’t affected. From what I can tell, the database tables for the MailChimp add-on are not being created correctly. I’ve reported what I’ve found to the dev team and one of the developers is looking into it. He wasn’t able to reproduce the errors that you and I are seeing so I sent him admin credentials to the test site that I have set up so he can investigate why the MailChimp tables are being set up correctly.
|
|
JesterZ Improv
|
June 12, 2013 at 4:38 pm
I’m anxious to hear resolution from the dev team. Thank you for looking into this.
|
|
Josh
|
June 12, 2013 at 5:08 pm
Here’s what we are testing:
In the MailChimp add-on this change was made on lines 103 and 104 of espresso-mailchimp.php from:
define( "EVENTS_MAILCHIMP_ATTENDEE_REL_TABLE", get_option( 'events_mailchimp_attendee_rel_tbl' ) );
define( "EVENTS_MAILCHIMP_EVENT_REL_TABLE", get_option( 'events_mailchimp_event_rel_tbl' ) );
to
define( "EVENTS_MAILCHIMP_ATTENDEE_REL_TABLE", $wpdb->prefix."events_mailchimp_attendee_rel" );
define( "EVENTS_MAILCHIMP_EVENT_REL_TABLE", $wpdb->prefix."events_mailchimp_event_rel" );
If you have a code editor and use FTP you can make this change if you’d like to try it out.
|
|
JesterZ Improv
|
June 12, 2013 at 11:48 pm
I’ll give that a try. thank you.
|
|
JesterZ Improv
|
June 13, 2013 at 10:29 am
looks like it accepted without errors – thank you. I’ll keep you posted on the capture of info as registrants come in.
|
