Jump to content

Error SELECT forums_topics.*

Featured Replies

Posted
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?

1 hour ago, Namo said:

Table 'gtaforum.forums_topics' doesn't exist (1146)

You missed that (and probably other) table. 

Make sure that the database backup contains all the data.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.