Announcement

Collapse
No announcement yet.

Problems after importing from phpbb (Impex)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems after importing from phpbb (Impex)

    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
    Last edited by KrisP; Fri 16 Feb '07, 6:49am.

  • #2
    Run this query to add that field to the search table:

    ALTER TABLE mydatabase_search ADD completed SMALLINT UNSIGNED NOT NULL DEFAULT '1'
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


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

      Comment


      • #4
        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.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        Loading...
        Working...
        X