Namo Posted December 5, 2018 Share 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? Link to comment Share on other sites More sharing options...
DawPi Posted December 5, 2018 Share Posted December 5, 2018 1 hour ago, Namo said: Table 'gtaforum.forums_topics' doesn't exist (1146) You missed that (and probably other) table. Link to comment Share on other sites More sharing options...
Faqole Posted December 6, 2018 Share Posted December 6, 2018 Make sure that the database backup contains all the data. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.