Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

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

  • Options

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

  • Options

    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.