Import stuck on "Insert User Table"

cmccarracmccarra New
edited July 2012 in Vanilla 2.0 - 2.8

I imported from phpbb to version 2.0.17 (I can't remember the exact version) and that worked fine. But in order for a theme to work correctly I had to update to 2.0.18.4, the udate work but when importing data using the this database function it got stuck on insert user table with the following error:

Unknown column '_NewID' in 'field list'|Gdn_Database|Query|insert ignore GDN_User (UserID,Name,Password,Email,CountComments,HourOffset,DateFirstVisit,DateLastActive,DateInserted,_NewID,HashMethod) select i.UserID, i.Name, i.Password, i.Email, i.CountComments, i.HourOffset, i.DateFirstVisit, i.DateLastActive, i.DateInserted, i._NewID, 'Unknown' as HashMethod from GDN_zUser i

I take it it has something to do with info phpbb imported. Any suggestions? Kind of urgent.

Cheers!

Comments

  • I also can't sign in to the site in a new tab now to do anything in the backend

  • cmccarra said:
    But in order for a theme to work correctly I had to update to 2.0.18.4, the udate work but when importing data using the this database function it got stuck on insert user table with the following error:

    I don't understand. The correct order is : Import in Vanilla 2.0.x and then upgrade that same Vanilla to the latest version... OR Import directly in a clean install of Vanilla 2.0.18.4...

    You don't update and then import again.

    There was an error rendering this rich post.

Sign In or Register to comment.