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
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. # 1
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. # 2
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. # 3
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. # 4
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. # 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
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. # 7
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. # 8
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. # 9
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. # 10
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. # 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

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
  • New
    • 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
  • New
    • Andrew Stocker
    Andrew Stocker
    Trying to resize the image in the comments
    Hey everyone, Basically I am trying to make the images in the comments smalle...
    9 Replies
    Posted on Wednesday, 12 August 2009
    Tibor Jozsef Virag
    Tibor Jozsef Virag
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    2 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    Christer Linde
    Christer Linde
    error message when adding/cofiguring email address
    When configuring the email plugin that send a email message to admin when a new ...
    0 Replies
    Posted on Friday, 09 May 2025