Recent
Categories
Tags
Users
View Replies (3)

Resolved 42S02 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_cmc_lists' doesn't exist

  1. Issue
  1. De Stijlerij
    De Stijlerij
  3. CMC - Mailchimp for Joomla!
  4. Friday, 28 August 2020
  5.  Subscribe via email
I know it is a free product and i also checked all the other issues that are in this forum. I even tried to solve it myself.

Error: 42S02 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ellavoge_joomla.xym5j_cmc_lists' doesn't exist

Here is my problem: i get an error that there is no table for cmc available. So i looked and it was true, so i re-installed the product. Still no tables. So i installed it on another website and on that one it was OK.
So now i have copied the tables form the working site to the not working site (with the right prefix). Still not working.

Without the tables there is no way that the register button is going to work.
I see you have this DB issues on more of your extensions. Is there a common way to fix it? or can you help me?
  1. 42s02
  2. table
  3. not found
Responses (3)
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
Is the other site where cmc is running also running on mysql 5.7?
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
De Stijlerij
De Stijlerij
Accepted Answer Pending Moderation
No the other site is running on PHP 7.3.21 and MySQL 5.6.48
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 2
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
My guess is that it is some kind of incompatibility with mysql 5.7 - there was something there about the default DATE handling and maybe that's why creating the tables fails.

Will need to investigate.
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. # 3
  • 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

Walter Fleritsch
Walter Fleritsch
Auch Gäste sollen Kommentare LESEN ab nicht schrei
Wo kann man einstellen, dass auch Gäste (Öffentliche) alle vorhandenen Kommentar...
4 Replies
Posted on Tuesday, 23 February 2021
  • Resolved
  • New
    • Walter Fleritsch
    Walter Fleritsch
    Ccomment verschickt zweite Kommentarnachricht, wen
    Als Moderator erhalte ich eine Benachrichtigung, wenn ein neuer Kommentar geschr...
    2 Replies
    Posted on Sunday, 21 February 2021
  • New
    • #benachrichtigung
    Emanuel Ober
    Emanuel Ober
    Not all additional dates of event shown in Calenda
    We have an event with 3 parts. On the event detail page it looks like this atm (...
    5 Replies
    Posted on Friday, 19 February 2021
  • New
    • Walter Fleritsch
    Walter Fleritsch
    Exaktes Datum statt "XX Stunden her"
    Was muss ich wo ändern (overriden?), um bei den Kommentaren das exakte Datum (TT...
    2 Replies
    Posted on Saturday, 20 February 2021
  • Resolved
  • New
    • Emanuel Ober
    Emanuel Ober
    Tags not shown on event detail page!
    even though the setting for showing tags on the event detail page is set to true...
    4 Replies
    Posted on Friday, 19 February 2021
  • Resolved
  • New