Announcement

Collapse
No announcement yet.

wowbb 1.65 import issue

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

  • wowbb 1.65 import issue

    I was doing my import from wowbb 1.65 tonight and all went well till i got down to import users, then this error came:

    There seems to have been a slight problem with the Appliance Blog Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Now i can not login to my admin control panel.

    Can you please help me resolve this?

    Thankyou,

    Jake
    Applianceblog.com forums

    Appliance Repair School 1987-1988
    Star Appliance Tech. 2 yrs. 1988-1990
    Wards Appliance Tech. 11 yrs. 1990-2001
    Sears Appliance Tech. 4 yrs. 2001-Oct. 2005
    Jake's Appliance Repair Nov. 2005-present


  • #2
    If you see this error next time, view the sourcecode of the page and copy the exact mysql error message which should be in comments.

    What error do you get when trying to log in?
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      Here is the email error i got:

      Database error in vBulletin 3.0.7:

      Invalid SQL:
      SELECT * FROM vb3_cpsession
      WHERE userid =
      AND hash = 'a0dbc0f68e0a937d76d4f7fa2b9eb590'
      AND dateline > 1122263318
      mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hash = 'a0dbc0f68e0a937d76d4f7fa2b9eb590'
      AND dateline >

      mysql error number: 1064

      Date: Monday 25th of July 2005 12:48:38 AM
      Script: http://www.applianceblog.com/mainforums/impex/index.php
      Referer: http://www.applianceblog.com/mainforums/impex/index.php
      IP Address: 24.22.51.44

      Here is the login error i now get:

      You have entered an invalid username or password. Please press the back button, enter the correct details and try again. Don't forget that the password is case sensitive. Forgotten your password?

      Jake
      Applianceblog.com forums

      Appliance Repair School 1987-1988
      Star Appliance Tech. 2 yrs. 1988-1990
      Wards Appliance Tech. 11 yrs. 1990-2001
      Sears Appliance Tech. 4 yrs. 2001-Oct. 2005
      Jake's Appliance Repair Nov. 2005-present

      Comment


      • #4
        Did you re-import? is this a second import? Did you try clearing the imported data?

        Comment


        • #5
          I Just purchased vBulletin 3 last week, its a first time clean import.

          After i got that error, i can't login now to clear the import data.

          I think i know what i did wrong, as i was seaching in this forum to see if anyone else had the same error, I associated my wowbb userID with my current vb3 admin userID.
          I read i could do that after i finished importing, in the admin control panel.

          Do i have to re-install vb3 and start all over with everything? Hopefully not, Please say no!

          Jake
          Applianceblog.com forums

          Appliance Repair School 1987-1988
          Star Appliance Tech. 2 yrs. 1988-1990
          Wards Appliance Tech. 11 yrs. 1990-2001
          Sears Appliance Tech. 4 yrs. 2001-Oct. 2005
          Jake's Appliance Repair Nov. 2005-present

          Comment


          • #6
            Probally, it would be the easiest way to fix things in the long run I'd think...

            the other method you could do is upload tools.php to the admincp folder and use it to restore an imported accouint that you have access to admin status, or you can register a new account and do the same.

            Comment


            • #7
              Thanks to you and Martin,

              Making a new username and the tools.php solved the problem, i was able to finish my import properly, all seems to be working well now.

              Thanks Again for your help!

              John
              Applianceblog.com forums

              Appliance Repair School 1987-1988
              Star Appliance Tech. 2 yrs. 1988-1990
              Wards Appliance Tech. 11 yrs. 1990-2001
              Sears Appliance Tech. 4 yrs. 2001-Oct. 2005
              Jake's Appliance Repair Nov. 2005-present

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X