Announcement

Collapse
No announcement yet.

database problem when adding newthread

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

  • 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

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

    Comment


    • #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


      • #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


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

          Comment


          • #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


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

              Comment


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

                Comment


                • #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


                  • #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


                    • #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


                      • #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


                        • #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...
                          X