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

François Gaillard
François Gaillard
Dowload all Hotspots entries
Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
0 Replies
Posted on Sunday, 06 April 2025
  • #kml
  • #download
Ben Luyten
Ben Luyten
Set number of hotspots / user groups
Hi, I'm working with Hotspots for my new website and I love it! After trying ...
0 Replies
Posted on Monday, 31 March 2025
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...
1 Replies
Posted on Monday, 24 February 2025
  • #Hotspots
  • #hotspots Joomla 5
Aleksej Khoroshevskij
Aleksej Khoroshevskij
Text size in the comment input form
Hello. How can I increase the font size in the comment input field? For examp...
0 Replies
Posted on Wednesday, 26 February 2025
  • #CComment 6
Aleksej Khoroshevskij
Aleksej Khoroshevskij
Problem with enlarged image
Hello. When you click on the image in the comments, it does not appear in the ce...
1 Replies
Posted on Wednesday, 26 February 2025