database problem when adding newthread

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • QtrCafe
    Member
    • Feb 2005
    • 71

    database problem when adding newthread

    Hello

    I get this when adding a new thread. I just moved the forum to a new server.
    can someone help me please?

    Code:
     
    Invalid SQL:
    INSERT INTO thread
     (postusername, postuserid, title, iconid, visible, forumid, dateline, open, attach, lastpost, lastposter, replycount, hiddencount)
    VALUES
     ('عمر الأنصاري', 25, 'تجربه', 0, 1, 29, 1150503378, 1, 0, 1150503378, 'عمر الأنصاري', 0, 0);
    MySQL Error  : Duplicate entry '0' for key 1
    Error Number : 1062
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #2
    How did you actually MOVE from account A to B?

    Comment

    • QtrCafe
      Member
      • Feb 2005
      • 71

      #3
      well, I took a backup then just had a new installation in the new server and just asked my server provider to have the backup inserted to the new database did i just mess everything up?

      Comment

      • Floris
        Senior Member
        • Dec 2001
        • 37767

        #4
        That's where it went wrong.. doing an install and then import the .sql dump.

        You should have backed up the .sql database and the forum files. Moved the files and .sql to the new account. Then ask your host to create a new database and restore the .sql database. Then don't run upgrade.php or install.php but instead update config.php to point to the new database.

        Comment

        • QtrCafe
          Member
          • Feb 2005
          • 71

          #5
          oh .. ok .. well, I don't have any of the old files now. is there a way to fix this now???

          Comment

          • Floris
            Senior Member
            • Dec 2001
            • 37767

            #6
            By the way, was your old version for example 3.5.3 and did you install fresh 3.5.4? Or the same version?

            Comment

            • QtrCafe
              Member
              • Feb 2005
              • 71

              #7
              it was a 3.5.3 and i did a fresh install of 3.5.4

              Comment

              • Floris
                Senior Member
                • Dec 2001
                • 37767

                #8
                make a backup of what you have now before you do anything. As you have no backup what so ever apparantly.

                Comment

                • Floris
                  Senior Member
                  • Dec 2001
                  • 37767

                  #9
                  Ok, you can try 2 things.

                  1) run upgrade.php from 3.5.4

                  or

                  2) replace the files 3.54 with the 3.5.3 files and see if the problem disappeared.

                  Comment

                  • QtrCafe
                    Member
                    • Feb 2005
                    • 71

                    #10
                    tried to upgrade and i got this SQL error

                    Code:
                     
                    Database error in vBulletin 3.5.4:
                    Invalid SQL:
                    INSERT INTO adminhelp
                     (script, action, optionname, displayorder, volatile, product)
                    VALUES
                     ('accessmask', '', '', 1, 1, 'vbulletin'),
                     ('accessmask', 'edit', '', 1, 1, 'vbulletin'),
                     ('accessmask', 'modify', '', 1, 1, 'vbulletin'),
                     ('accessmask', 'quickedit', '', 1, 1, 'vbulletin'),
                     ('accessmask', 'resetall', '', 1, 1, 'vbulletin');
                    MySQL Error  : Duplicate entry '0' for key 1
                    Error Number : 1062
                    I will try to use 3.5.3 files and I'll let you know

                    Comment

                    • QtrCafe
                      Member
                      • Feb 2005
                      • 71

                      #11
                      just uploaded the 3.5.3 files and still facing the same problem ... do i have to run any upgrade files or anything??

                      Comment

                      • Floris
                        Senior Member
                        • Dec 2001
                        • 37767

                        #12
                        Did you revert to the backup before replacing the files?
                        Running upgrade .. errors .. and then trying to use 353 files on half upgraded board will only error more.

                        Comment

                        • QtrCafe
                          Member
                          • Feb 2005
                          • 71

                          #13
                          lol ok I think I should just open a ticket. Will you guys help me out if i do???

                          Comment

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