TOPIC: 0 SQL: 00000, , after installation

Installed MailChimp for Joomla and didn't receive any errors during the installation. However when going to the component to enter the API key the following error is displayed:
An error has occurred.
0 SQL: 00000, ,

I tried searching through the forums but was unable to locate a similar error. Any assistance would be greatly appreciated.

[Edit]
I also wanted to add I have tried uninstalling and reinstalling which does not help.
I'm running on the most recent version of Joomla 3.4.1 using pdomysql

When I turn on debug I'm seeing the following errors:
SQLSTATE[42000]: Syntax error or access violation: 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 'LIMIT 0, 1' at line 3

Hey Eirik,
I have no clue what this could be. This is the first time anyone reports this. What's your mysql and PHP version? What's your joomla version?

Regards,
Daniel

Daniel,
The Joomla Version is 3.4.1
Php version 5.3.24
PDO_MySQL version 5.1.73

If you wish I can forward you a link to a phpinfo file but would rather not post that on a public forum.

Regards,
Eirik

The query it seems to be throwing the error on is the following:
It appears LIMIT is being defined twice

I setup a local test box of a clean install of Joomla, CMC runs if the installation runs on MySQLi but breaks on PDO MySQL

Hey Eirik,
Do you get the error before or after providing the API key?

How have you narrowed down the error? The code that creates the query doesn't have any limit actually.

also mysql 5.1 has reached end of life. Can you update there to 5.5 for example? Maybe this is some error related to the mysql version.

Daniel,
I'll clone the installation to another server tomorrow morning with MySQL 5.5 and see if the issue persists. I'll update you when I have further information.

Daniel,
We setup and tested CMC on MySQL 5.5 as well as 5.6 and the error persists when running the website on MySQL PDO

Hi, did you ever resolve this issue as I'm having the same?

Thanks

Hey Mick,
I have never actually experienced the issue. If you have a test server where this happens and you can give us admin access and ftp access I'll be happy to debug.

REgards,
Daniel

Okay, today I ran into the issue. It turns out it is the mysql pdo driver. When you do
$db->loadObject();

And then later again
$db->loadObject();

for the same query it throws this error. I was able to fix this and the fix will be in the next release.