Unsubscribe Error

Eric535

Member
When a subscriber clicks on my link to unsubscribe and it directs him to the unsubscribe page the page loads up with his email and info. Once he hits the unsubscribe button they get the following error.

Error 500!
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uni_newsletter.mw_cache' doesn't exist
 
UPDATE

Just noticed that when i go into my backend to my lists I get an error as well..

Error 500!


CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uni_newsletter.mw_cache' doesn't exist


I guest this happenened after I updated to version 1.8.9
 
How did you do the update? That table should have been created while you updated the app...
Anyway, you can create it manually using phpmyadmin by selecting your database and running:
Code:
CREATE TABLE IF NOT EXISTS `mw_cache` (
    `id` char(32) NOT NULL,
    `expire` int(11) NULL,
    `value` longblob,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
If you can't do that, open a ticket and we'll find a way.
 
How did you do the update? That table should have been created while you updated the app...
Anyway, you can create it manually using phpmyadmin by selecting your database and running:
Code:
CREATE TABLE IF NOT EXISTS `mw_cache` (
    `id` char(32) NOT NULL,
    `expire` int(11) NULL,
    `value` longblob,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
If you can't do that, open a ticket and we'll find a way.


Thanks. I ran your command through SSH and it worked.

I updated the same way I always do. Downloaded the files and ftp'ed.
 
Back
Top