Recent
Categories
Tags
Users
View Replies (11)

Resolved 0 SQL: 00000, , after installation

  1. Eirik
    Eirik
  3. CMC - Mailchimp for Joomla!
  4. Monday, 11 May 2015
  5.  Subscribe via email
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
Responses (11)
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
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.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 1
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
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
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 2
Mick Elliget
Mick Elliget
Accepted Answer Pending Moderation
Hi, did you ever resolve this issue as I'm having the same?

Thanks
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 3
Eirik
Eirik
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 4
Eirik
Eirik
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 5
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
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.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 6
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
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.
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 7
Eirik
Eirik
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 8
Eirik
Eirik
Accepted Answer Pending Moderation
The query it seems to be throwing the error on is the following:
SELECT *



  FROM m5mx_extensions



  WHERE `type` = 'component' 

  AND `element` = 'com_cmc' 

  LIMIT 0, 1 

  LIMIT 0, 1


It appears LIMIT is being defined twice
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 9
Eirik
Eirik
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 10
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
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
Please if you use our extensions be so kind and review them at JED
Matukio | Hotspots Pro | CComment Pro
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
or Ask a Question

Last questions

Dave
Dave
Is Ccomment still alive?
Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
0 Replies
Posted on Thursday, 14 August 2025
  • New
    • Emanuel Ober
    Emanuel Ober
    Anzeige von mehrtägigen Events auf Buchungsseite
    We have been using Matukio for quite some time now. Unfortunately, we have been ...
    3 Replies
    Posted on Sunday, 03 August 2025
    Zlatko Enev
    Zlatko Enev
    Assistance Needed – Error When Posting Comments
    Hello, I’m experiencing an issue when trying to submit a comment on my site u...
    0 Replies
    Posted on Sunday, 10 August 2025
  • New
    • Pim van Wijngaarden
    Pim van Wijngaarden
    Hotspots Pro 6.0.13 compatability with Joomla 5.3.
    Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
    2 Replies
    Posted on Friday, 04 July 2025
    Laurent Lacoste
    Laurent Lacoste
    some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025