I have upgraded my site to the current version of SS, and now neither Userforms or Newsletter modules don't work. Both are exhibiting exactly the same behaviour on both my offline (MAMP) site and online site. They work fine with a fresh install, using the same template etc.
On the published site, the page displays, but the fields etc are missing.
In the CMS, clicking on the appropriate page brings up the biggest popup dialogue box I've ever seen. I can't copy all of the content (cos it extends much further than my screen), but it starts:
ERROR [User Error]: Couldn't run query:
SELECT `UserDefinedForm_EmailRecipient`.*, `UserDefinedForm_EmailRecipient`.ID, if(`UserDefinedForm_EmailRecipient`.ClassName,`UserDefinedForm_EmailRecipient`.ClassName,'UserDefinedForm_EmailRecipient') AS RecordClassName
FROM `UserDefinedForm_EmailRecipient`
WHERE ((FormID = '3') AND (`FormID` = '3'))
LIMIT 0,10
Table 'xxx_xxx.UserDefinedForm_EmailRecipient' doesn't exist
IN POST /admin/getitem?ID=3&ajax=1
Line 401 in /Applications/MAMP/htdocs/xxx/sapphire/core/model/MySQLDatabase.php
Source
======
392: }
393:
394: function databaseError($msg, $errorLevel = E_USER_ERROR) {
395: // try to extract and format query
396: if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397: $formatter = new SQLFormatter();
398: $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399: }
400:
* 401: user_error($msg, $errorLevel);
402: }
403: }
404:
405: /**
406: * A result-set from a MySQL database.
407: * @package sapphire
<ul>user_error(Couldn't run query:
SELECT `UserDefinedForm_EmailRecipient`.*, `UserDefinedForm_EmailRecipient`.ID, if(`UserDefinedForm_EmailRecipient`.ClassName,`UserDefinedForm_EmailRecipient`.ClassName,'UserDefinedForm_EmailRecipient') AS RecordClassName
FROM `UserDefinedForm_EmailRecipient`
WHERE ((FormID = '3') AND (`FormID` = '3'))
LIMIT 0,10
Table 'xxx_xxx.UserDefinedForm_EmailRecipient' doesn't exist,256)
line 401 of MySQLDatabase.php
Any help greatly appreciated.
Thanks