1. De Stijlerij
  2. CMC - Mailchimp for Joomla!
  3. Friday, 28 August 2020
  4.  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?
Responses (6)
Daniel Dimitrov
Support team
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
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
Support team
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
Accepted Answer Pending Moderation
Is there any news on this?

I just installed ccomment and I get "Table '[database name].#__k2_categories' doesn't exist " when I try to add the com_ks component in the settings.

I have a MySQLi database with PHP7.4.
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 4
Daniel Dimitrov
Support team
Accepted Answer Pending Moderation
Diona, why are you posting in a post about CMC?

Create a new ticket item and let us know the version of k2 you use.
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
Accepted Answer Pending Moderation
oh my apologies,I searched for the error and did not realise this was not a board for CComment
  1. more than a month ago
  2. CMC - Mailchimp for Joomla!
  3. # 6
  • Page :
  • 1


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

Last questions

Parsing is stalling
I am having a similar issue to a past user. I am migrating a wordpress site ...
9 Replies
Posted on Wednesday, 14 February 2024
  • New
  • Could not instantiate mail function
    Hallo Daniel, seit heute erhalten wir beim Absenden des Formulars die Meldung...
    1 Replies
    Posted on Friday, 16 February 2024
  • New
  • Problem with jdownloads...no comment function
    Version: Joomla 4 Jdownloads 4.0.39 Stable CComment Pro 6.1.12 I have set ...
    2 Replies
    Posted on Monday, 22 January 2024
    Veranstaltung im Frontend sichtbar obwohl nicht ve
    Hallo, folgendes Problem stellt sich mir: Wenn ich eine Veranstaltung dupl...
    2 Replies
    Posted on Friday, 09 February 2024
    Importing comments?
    Hi, Is it possible to import comments from CCC 6.1.9 (Joomla 3.10.12, PHP 7.4...
    1 Replies
    Posted on Monday, 12 February 2024
  • Resolved