[tpcwebmaster]

Hi Steve,
We’ve been using Connections for a while and it had worked great. Several weeks ago we upgraded the database to MySQL 5.6 and the latest Connections plugin. Since then, our editor users have been unable to use the Manage function to edit existing entries. They receive a Gateway Timeout error, but strangely, they can add new entries without issue. Users with admin permissions are able to use the Manage function.

I tried exporting the entire database and importing into a brand new, clean database on a different server and receive this error when importing the Connections tables:

<h1>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 ‘2014-05-09 19:10:05’, ‘1395663790’, ‘organization’, ‘public’, ‘nameremoved’, ”’ at line 22</h1>

I tried removing that line and not surprisingly the error just moves to another line.

Have you seen anything like this before? Is there anything you can suggest? Thanks for your help!

[Steven Zahm]

@ tpcwebmaster

re: Have you seen anything like this before? Is there anything you can suggest? Thanks for your help!

No, I have seen this before. Have you checked the PHP error log to see if there are any errors reporting that could shed light? If you have, try turning on WP_DEBUG, visit the page and then look at the PHP error log.

re: I tried exporting the entire database and importing into a brand new, clean database on a different server and receive this error when importing the Connections tables:

I doubt importing into a new db will resolve the issue. Can not really help with the import error… but my guess is some type of versioning conflict issue where the exported SQL is not compatible with the settings used to import the SQL file.

Let me know what you find in the PHP error log.

[Author]

Posts