No announcement yet.

MySQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Hey its you again!

    Well I did get further.

    My problem is my sql file is 300mb and I dont know how to do the SSH stuff so i was doing it manually but after awhile it got tiresome (im a moron ) Then since I had some tables there, including the users. I tried doing that but to no avail.

    Database error in vBulletin:ImpEx Source 3.0.5:

    Invalid SQL:
    SELECT * FROM phpbb_users
    ORDER BY user_id
    LIMIT 0,500
    mysql error: Unknown column 'user_id' in 'order clause'

    mysql error number: 1054

    Date: Saturday 08th of January 2005 07:07:47 PM
    Username: Unreal Player


    • #17
      You will need to completely restore the phpBB database in order to do the import. Here again are the instructions for restoring a database:

      If you have specific questions about this processs, then please ask.
      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.


      • #18
        Ok, that requires you to upload your sql backup first right? My problem is I tried this before(for a different method though, not that one) and it took like 4 hours. It took up alot of space so after the method did not work i deleted it. So is there an easier/quicker way of doing this?

        And when it says DIRECTORY/TO/BACKUP or whatever, can that be on your local computer? Or does it have to be uploaded onto the site


        • #19
          how do u take the back up it is backup.sql or the full back up come with tar ?

          upload it in your dir.. and contact your company let them to Restore you back up in 2 sec


          • #20
            It's SQL

            with the import file do i need to import all of the tables? I just really want the users and their post counts. And I can copy that from the sql file, the user tables. But it's giving me an error with their ID'S?


            • #21
              then if u dont no how to make it with the SSH try to contact your company let them do it for u ..

              or maybe there is easy way for u ...... open the SQL and start takeing table by table like

              phpBB_user take the allllllllllllll databse in phpBB_user and so on .. maybe this is the easy way for u ..


              • #22
                How can I tell them to do it when the file is on my own computer


                • #23
                  upload it in your ROOT dir and contact them tell them that u need to Restore your databse and tell them u have upload the file in your dir..

                  so they have full access andthey can get it ..


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