Matvexa

CREATE TABLE IF NOT EXISTS `[b]ЗАМЕНИТЬ НА СВОЙ ПРЕФИКС[/b]_subscriptions_bind` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` int(11) unsigned DEFAULT NULL,
  `user_id` int(11) unsigned DEFAULT NULL,
  `guest_email` varchar(100) DEFAULT NULL,
  `guest_name` varchar(50) DEFAULT NULL,
  `is_confirmed` tinyint(1) unsigned DEFAULT '1',
  `confirm_token` varchar(32) DEFAULT NULL,
  `date_pub` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`subscription_id`) USING BTREE,
  KEY `guest_email` (`guest_email`,`subscription_id`) USING BTREE,
  KEY `confirm_token` (`confirm_token`),
  KEY `subscription_id` (`subscription_id`,`is_confirmed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписки' AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `[b]ЗАМЕНИТЬ НА СВОЙ ПРЕФИКС[/b]_subscriptions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `controller` varchar(32) DEFAULT NULL,
  `subject` varchar(50) DEFAULT NULL,
  `subject_url` varchar(255) DEFAULT NULL,
  `params` text,
  `subscribers_count` int(11) unsigned NOT NULL DEFAULT '0',
  `hash` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash` (`hash`),
  KEY `target_controller` (`controller`,`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Списки подписок' AUTO_INCREMENT=1 ;

шибка в запросе БД:
Table 'u0217028_nah.cms32_subscriptions' doesn't exist
 
SELECT i.*
FROM cms32_subscriptions i
WHERE (i.hash = '65d2fcdf3211bf0af868c11645f8007f')
LIMIT 1
Последние вызовы:
 
cmsModel->getItem() @ /system/controllers/subscriptions/model.php : 38
modelSubscriptions->getSubscriptionItem() @ /system/controllers/subscriptions/frontend.php : 23
subscriptions->renderSubscribeButton()
call_user_func_array() @ /system/core/action.php : 29
cmsAction->__call() @ /system/controllers/subscriptions/hooks/content_toolbar_html.php : 77
onSubscriptionsContentToolbarHtml->renderSubscribeButton() @ /system/controllers/subscriptions/hooks/content_toolbar_html.php : 77
onSubscriptionsContentToolbarHtml->run()
call_user_func_array() @ /system/core/controller.php : 672
cmsController->runExternalHook() @ /system/core/controller.php : 631
cmsController->runHook() @ /system/core/eventsmanager.php : 94
cmsEventsManager::hookAll() @ /system/controllers/content/actions/category_view.php : 220