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

Joe Polecheck
Joe Polecheck
Questions on new installation...
Working on getting this set up... https://eastend2024.joepolecheck.com/rumma...
3 Replies
Posted on Wednesday, 17 April 2024
  • Resolved
  • New
    • Joe Polecheck
    Joe Polecheck
    Changes to the Submission form
    Can you make changes to the Submission form? There are a few fields I'd like to ...
    0 Replies
    Posted on Thursday, 18 April 2024
  • New
    • Joe Polecheck
    Joe Polecheck
    Error received? Class "XMLReader" not fo
    Just installed the Pro version of Hotspots, but am getting an error when I try t...
    1 Replies
    Posted on Wednesday, 17 April 2024
  • Resolved
  • New
    • Peter Beusch
    Peter Beusch
    Links aus Veranstaltungsübersicht funktionieren ni
    Nach der Migration von Joomla 3.10 auf Joomla 5.0.3 treten folgende Probleme auf...
    2 Replies
    Posted on Monday, 08 April 2024
    Samturnbull
    Samturnbull
    Custom Hotspot Marker fails to load
    I just updated from Joomla 3 to Joomla 4.3.4 and Hotspots 6.0.12. I decided to e...
    0 Replies
    Posted on Tuesday, 09 April 2024