Announcement

Collapse
No announcement yet.

This is terrible... SQL Hell

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

  • This is terrible... SQL Hell

    Im getting this sql error when im upgrading on step 5
    "Database error in vBulletin 3.0.12:

    Invalid SQL:
    UPDATE phrasetype SET title='Plugin System', editrows=3, fieldname='plugins' WHERE phrasetypeid=45;

    MySQL Error : Table 'infitech_vbdbfinal.phrasetype' doesn't exist
    Error Number : 1146"

  • #2
    From what version to what version are you upgrading?
    What is the script that is currently running?
    When did you download your new vBulletin version?
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment


    • #3
      I'm upgrading from 3.0.3 to 3.5.3, but the upgrade seems to have gotten me as far as 3.0.12 and stops at step 5. When i look at some of the responses from similar threads the issue never seems to be resolved. I'm sure it was caused by a hack. I CANNOT remove the hack. What can i edit to fix this?

      Comment


      • #4
        I suggest you create a Support Ticket. Very difficult to see what went wrong without really seeing what is happening.
        Want to take your board beyond the standard vBulletin features?
        Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

        Comment


        • #5
          Same problem,

          UPDATE phrasetype SET title='Plugin System', editrows=3, fieldname='plugins' WHERE phrasetypeid=45;

          Anyone can help?

          Comment


          • #6
            Does it say that other error as well abou the missing table like it does at the first post?

            If so, try to recreate the missing table and give the upgrader another go.

            Comment


            • #7
              This is complete error

              Database error in vBulletin 3.0.15:

              Invalid SQL:
              UPDATE phrasetype SET title='Plugin System', editrows=3, fieldname='plugins' WHERE phrasetypeid=45;

              MySQL Error : Unknown column 'phrasetypeid' in 'where clause'
              Error Number : 1054
              Request Date : Wednesday, March 10th 2010 @ 05:27:49 PM
              Error Date : Wednesday, March 10th 2010 @ 05:27:54 PM

              Comment


              • #8
                From what version to what version are you upgrading btw? And where exactly are you getting this error?

                Comment


                • #9
                  i am upgradin from 3.0.15 .... now get on upgrade_350b1.php?step=5 that problem

                  Comment


                  • #10
                    Check if you have a phrasetypeid field in your phrase table.

                    Comment


                    • #11
                      Nope, should I create one? VARCHAR or MEDIUMBLOB?

                      Do you mea in phrasetype or in phrase table?

                      Tnx

                      Comment


                      • #12
                        Created in phrasetype and works.

                        Will see ... doing update ... thanks for help

                        Comment


                        • #13
                          No problem. Let us know how it will go.

                          Comment

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