Namo Posted December 5, 2018 Posted December 5, 2018 SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `forums_topics` LEFT JOIN `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums;',forums_topics.tid)) LEFT JOIN `core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE popular_time > 1544045162 AND forums_forums.password IS NULL AND forums_forums.can_view_others=1 AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(2,4,5,6,7,8,9,10,13,15,16,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,36,37,38,39,41,42,43,45,46,47,48) ORDER BY forums_topics.start_date DESC LIMIT 5 IPS\Db\Exception: Table 'gtaforum.forums_topics' doesn't exist (1146) #0 /var/www/vhosts/gtaforum.pl/httpdocs/system/Db/Select.php(378): IPS\_Db->preparedQuery('/*IPS\\forums\\wi...', Array, true) #1 /var/www/vhosts/gtaforum.pl/httpdocs/system/Db/Select.php(580): IPS\Db\_Select->runQuery() #2 /var/www/vhosts/gtaforum.pl/httpdocs/system/Patterns/ActiveRecordIterator.php(62): IPS\Db\_Select->count(false) #3 [internal function]: IPS\Patterns\_ActiveRecordIterator->count() #4 /var/www/vhosts/gtaforum.pl/httpdocs/applications/forums/widgets/hotTopics.php(67): count(Object(IPS\Patterns\ActiveRecordIterator)) #5 /var/www/vhosts/gtaforum.pl/httpdocs/system/Widget/Widget.php(759): IPS\forums\widgets\_hotTopics->render() #6 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/Theme.php(824) : eval()'d code(16599): IPS\_Widget->__toString() #7 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->widgetContainer('sidebar', 'vertical') #8 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/Theme.php(824) : eval()'d code(14160): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #9 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->sidebar('right') #10 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/Theme.php(824) : eval()'d code(6195): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #11 /var/www/vhosts/gtaforum.pl/httpdocs/system/Theme/SandboxedTemplate.php(58): IPS\Theme\class_core_front_global->globalTemplate('GTA Forum - Pol...', '\n<div class='ip...', Array) #12 /var/www/vhosts/gtaforum.pl/httpdocs/system/Dispatcher/Dispatcher.php(166): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #13 /var/www/vhosts/gtaforum.pl/httpdocs/system/Dispatcher/Standard.php(118): IPS\_Dispatcher->finish() #14 /var/www/vhosts/gtaforum.pl/httpdocs/system/Dispatcher/Front.php(574): IPS\Dispatcher\_Standard->finish() #15 /var/www/vhosts/gtaforum.pl/httpdocs/system/Dispatcher/Dispatcher.php(148): IPS\Dispatcher\_Front->finish() #16 /var/www/vhosts/gtaforum.pl/httpdocs/index.php(13): IPS\_Dispatcher->run() #17 {main} I transferred IPS from a dedicated server from PLESK to VPS with PLESK using the Dropbox Backup plugin. Someone will help me?
DawPi Posted December 5, 2018 Posted December 5, 2018 1 hour ago, Namo said: Table 'gtaforum.forums_topics' doesn't exist (1146) You missed that (and probably other) table.
Faqole Posted December 6, 2018 Posted December 6, 2018 Make sure that the database backup contains all the data.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.