Problems after importing from phpbb (Impex)

[KrisP]

I have some problems after importing my phpbb database using Impex.

The search function doesn't work, I get:



Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT * FROM mydatabase_search AS search
WHERE searchhash = '7657a4768afda5297ced44ddf95d50fc'
AND userid = 1
AND completed = 1;
MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054


Both emptying and rebuilding the search index dosent help.

Another problem - my avatars dosent get imported from images/avatars

[Steve Machol]

Run this query to add that field to the search table:

ALTER TABLE mydatabase_search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1'

[KrisP]

It says "You are not authorized to execute SQL queries" (This is the admin user created with the installation of vBulletin).

[Steve Machol]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = 'x';

...with x being your userid number.