Recent
Categories
Tags
Users
Badges
View Replies (3)

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

  1. Issue
0
Votes
Undo
  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
0
Responses (3)
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
0
Votes
Undo
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. 3 weeks ago
  2. CMC - Mailchimp for Joomla!
  3. # 1
De Stijlerij
De Stijlerij
Hotspots supporter
Accepted Answer Pending Moderation
0
Votes
Undo
No the other site is running on PHP 7.3.21 and MySQL 5.6.48
  1. 3 weeks ago
  2. CMC - Mailchimp for Joomla!
  3. # 2
Daniel Dimitrov
Daniel Dimitrov
Support team
Sherlock Holmes The Voice
Accepted Answer Pending Moderation
0
Votes
Undo
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. 3 weeks 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

Jip Jonker
Jip Jonker
Rights to delete comments in the backend?
Hi! Is it only possible for Super Admins to delete comments from the backend of ...
0 Replies
Posted on Wednesday, 23 September 2020
  • New
    • #Rights
    • #CComment 6
    Steve Wekarchuk
    Steve Wekarchuk
    Description not appearing on webpage and in an ema
    Good Day, For some events that my client creates, the description will app...
    2 Replies
    Posted on Monday, 21 September 2020
  • New
    • Jackson Wraight
    Jackson Wraight
    How to create New Database for Matukio 7?
    I've installed the new version of matukio event (7.0.0) and during my installati...
    0 Replies
    Posted on Tuesday, 22 September 2020
  • New
    • #install failure
    Jacob
    Jacob
    CMC Mailchimp unable to subscribe user: ajax error
    Facing an issue with CMC that when someone tried to signup for newsletter on the...
    0 Replies
    Posted on Tuesday, 22 September 2020
  • New
    • Oliver Kage
    Oliver Kage
    Need map shown in module
    I need the map shown in a module because i've a template builder. A menu item i...
    0 Replies
    Posted on Tuesday, 22 September 2020
  • New
    • #module