Facing issues while importing

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
manigopal
Registered User
Posts: 24
Joined: Sun Aug 12, 2018 6:40 am

Facing issues while importing

Post by manigopal » Wed Jun 12, 2019 2:08 am

I faced this problem after importing the DB, recently i had to setup the fresh one so i used the already taken backup of files & db after importing db this following error shows,


General Error
SQL ERROR [ mysqli ]

Can't find FULLTEXT index matching the column list [1191]

SQL

SELECT f.forum_id, f.forum_name, t.*, MATCH (t.topic_title) AGAINST ('some topic') AS score, fp.post_text AS first_post_text, lp.post_text AS last_post_text, fpu.user_avatar AS fp_avatar, fpu.user_avatar_type AS fp_avatar_type, fpu.user_avatar_width AS fp_avatar_width, fpu.user_avatar_height AS fp_avatar_height, lpu.user_avatar AS lp_avatar, lpu.user_avatar_type AS lp_avatar_type, lpu.user_avatar_width AS lp_avatar_width, lpu.user_avatar_height AS lp_avatar_height FROM (phpbb_topics t) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_posts fp ON (fp.post_id = t.topic_first_post_id) LEFT JOIN phpbb_users fpu ON (fpu.user_id = t.topic_poster) LEFT JOIN phpbb_posts lp ON (lp.post_id = t.topic_last_post_id) LEFT JOIN phpbb_users lpu ON (lpu.user_id = t.topic_last_poster_id) WHERE MATCH (t.topic_title) AGAINST ('some topic') >= 0.1 AND t.topic_status <> 2 AND t.topic_visibility = 1 AND t.topic_time > (UNIX_TIMESTAMP() - 315360000) AND t.topic_id <> 8 AND f.similar_topics_ignore = 0 LIMIT 5

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 994
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/vse/similartopics/core/similar_topics.php
LINE: 210
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/vse/similartopics/event/listener.php
LINE: 63
CALL: vse\similartopics\core\similar_topics->display_similar_topics()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: vse\similartopics\event\listener->display_similar_topics()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/viewtopic.php
LINE: 2370
CALL: phpbb\event\dispatcher->trigger_event()
Last edited by manigopal on Wed Jun 12, 2019 2:35 am, edited 1 time in total.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66331
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: gggfffffffffffffff

Post by Lumpy Burgertushie » Wed Jun 12, 2019 2:16 am

how dare you say that! I mean, really.
however, now that you bring it up, I do agree up to a point.
but, the reality is that pancakes don't have hair.

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

manigopal
Registered User
Posts: 24
Joined: Sun Aug 12, 2018 6:40 am

Re: Facing issues while importing

Post by manigopal » Wed Jun 12, 2019 2:37 am

@Lumpy Burgertushie

any solution for this issue ?

User avatar
Lumpy Burgertushie
Registered User
Posts: 66331
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Facing issues while importing

Post by Lumpy Burgertushie » Wed Jun 12, 2019 4:01 am

now my post looks really crazy since you edited yours with the actual problem you are having.

sorry, I don't have a clue about that error. something wrong with your database backup file.

are you sure it is complete with all the structure and data from the old database?


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

manigopal
Registered User
Posts: 24
Joined: Sun Aug 12, 2018 6:40 am

Re: Facing issues while importing

Post by manigopal » Wed Jun 12, 2019 4:14 am

yes, ofcourse i have exported entire database.

User avatar
John connor
Registered User
Posts: 2116
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Name: Aaron
Contact:

Re: Facing issues while importing

Post by John connor » Wed Jun 12, 2019 4:25 am

I don't know anything about databases, but when I created one of my boards on my computer and then uploaded it for live I had a database issue when I imported it into phpmyadmin. I don't remember the error, but all I know is that I had to open my database in Notepad++ and change all instances of ENGINE= to ENGINE=MyISAM The engine was something else and wouldn't work. So with that, perhaps you too have an engine issue. I'm not sure.

Have you asked your host?

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21148
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: Facing issues while importing

Post by Mick » Wed Jun 12, 2019 8:42 am

You could try the relevant section of Knowledge Base - Transferring Your Board to a New Host or Domain and try using phpMyAdmin for the backup using the parameters suggested. Then try importing that.
"The more connected we get the more alone we become" - Kyle Broflovski

Post Reply

Return to “[3.2.x] Support Forum”