News module: Table 'cms.cmsjts_module_news' doesn't exist

[drlandau]

CMSMS version 1.11.7
News module version 2.10.4

Note, the table prefex is "cmsjts" instead of the default "cms" (I need to run multiple instances of CMSMS on the same MySQL database).

When trying to add a new news article I get the following error:

DEBUG: SQL = INSERT INTO cmsjts_module_news (news_id, news_category_id, news_title, news_data, summary, status, news_date, start_time, end_time, create_date, modified_date,author_id,news_extra) VALUES (19,'','Test','Dette er en lang test blahblah blaaah','Dette er en test','published','2013-07-11 17:22:07','2013-07-11 17:22:07',NULL,'2013-07-11 17:28:01','2013-07-11 17:28:01','1','')
Table 'cms.cmsjts_module_news' doesn't exist

When checking phpMyAdmin I see only these two "News" related tables:

cmsjts_module_news_categories_seq
cmsjts_module_news_seq

I don't see the table "cmsjts_module_news"...

Anyone that knows why I'm missing the table "cmsjts_module_news" (possible others as well) and how to recreate it (them)?

A complete list of the tables from phpMyAdmin:
cmsjts_additional_htmlblob_users
cmsjts_additional_htmlblob_users_seq
cmsjts_additional_users
cmsjts_additional_users_seq
cmsjts_adminlog
cmsjts_admin_bookmarks
cmsjts_admin_bookmarks_seq
cmsjts_admin_recent_pages
cmsjts_admin_recent_pages_seq
cmsjts_content
cmsjts_content_props
cmsjts_content_props_seq
cmsjts_content_seq
cmsjts_crossref
cmsjts_css
cmsjts_css_assoc
cmsjts_css_seq
cmsjts_events
cmsjts_events_seq
cmsjts_event_handlers
cmsjts_event_handler_seq
cmsjts_groups
cmsjts_groups_seq
cmsjts_group_perms
cmsjts_group_perms_seq
cmsjts_htmlblobs
cmsjts_htmlblobs_seq
cmsjts_modules
cmsjts_module_deps
cmsjts_module_news_categories_seq
cmsjts_module_news_seq
cmsjts_module_search_items_seq
cmsjts_module_templates
cmsjts_permissions
cmsjts_permissions_seq
cmsjts_siteprefs
cmsjts_templates
cmsjts_templates_seq
cmsjts_userplugins
cmsjts_userplugins_seq
cmsjts_userprefs
cmsjts_users
cmsjts_users_seq
cmsjts_user_groups
cmsjts_version

Thanks a lot!

[Jos]

Go to admin » Extensions » Modules
then click the "Uninstall" link behind News, then click "install"
Note you will lose any changes you have made so far.

[Dr.CSS]

Try going to system maintenance > database and run repair tables then optimize tables then in next tab run update routes...