Out of date custom templates error - none found really as the styles were deleted after upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • karlm
    Senior Member
    • Jun 2006
    • 826
    • 5.3.x

    Out of date custom templates error - none found really as the styles were deleted after upgrade

    VB 5.2.2
    PHP 5.4.45
    MySQL 5.5.50
    No Addons - none at all.
    All issues occur in default style since upgrade to VB5
    All issues occur in English/default language since upgrade to VB5




    When I log into ACP, I'm told there are 19 problems with default style templates.

    I deleted all the old skins to ensure maximum compatibility.

    I follow the link from the ACP front page (see pic1) and am presented with an empty frame where I would usually see the alleged 19 errors (in previous versions of VB it worked this way at least).

    Meanwhile this error won't go away and I can't find a way to remove it.
    pic1
    pic2

    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.
  • karlm
    Senior Member
    • Jun 2006
    • 826
    • 5.3.x

    #2
    --gentle bump--
    VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
    No Addons - none at all.

    Comment

    • Mark.B
      vBulletin Support
      • Feb 2004
      • 24286
      • 6.0.X

      #3
      You can run this query to remove the outdated template notices:
      Code:
      UPDATE `template` SET `mergestatus`='none'
      As always, backup your database before running queries on it.
      MARK.B
      vBulletin Support
      ------------
      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

      Comment

      • karlm
        Senior Member
        • Jun 2006
        • 826
        • 5.3.x

        #4
        Thanks, Mark.

        I note you use two different quote things, are they definitely that way or are all of them using the ' or `... I don't even know where ` is on my keyboard anymore this one's just a copy and paste job.

        Where do I run this command, from the ACP or do I log in via putty and run it there?
        VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
        No Addons - none at all.

        Comment

        • karlm
          Senior Member
          • Jun 2006
          • 826
          • 5.3.x

          #5
          Originally posted by Mark.B
          You can run this query to remove the outdated template notices:
          Code:
          UPDATE `template` SET `mergestatus`='none'
          Apparently, I can't...
          Code:
             [TABLE="class: tborder, align: center, border: 0, cellpadding: 4, cellspacing: 0"]
           	 		[TR]
           			[TD="class: alt1, colspan: 2"]An error occurred while attempting to execute your query. The following information was returned.
          			error number: 1146
          			error desc: Table 'mydatabasename-obviouslychanged4security.template' doesn't exist[/TD]
           		[/TR]
           	 [/TABLE]
          VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
          No Addons - none at all.

          Comment

          • Mark.B
            vBulletin Support
            • Feb 2004
            • 24286
            • 6.0.X

            #6
            Do you have a table prefix set? If so you'll need to add that to the query:
            Code:
            UPDATE 'yourprefix_template' SET 'mergestatus'='none'
            MARK.B
            vBulletin Support
            ------------
            My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
            My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

            Comment

            • karlm
              Senior Member
              • Jun 2006
              • 826
              • 5.3.x

              #7
              Thank you - I can't believe I didn't give that a thought

              VB 5.4.1 - PHP 7..2.4 - MySQL 5.5.56
              No Addons - none at all.

              Comment

              • Mark.B
                vBulletin Support
                • Feb 2004
                • 24286
                • 6.0.X

                #8
                Originally posted by karlm
                Thank you - I can't believe I didn't give that a thought
                Don't worry, everyone forgets that, myself included.
                MARK.B
                vBulletin Support
                ------------
                My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                Comment

                Related Topics

                Collapse

                Working...