PHP and MySQL advise?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • voyger
    Senior Member
    • Jun 2017
    • 381

    PHP and MySQL advise?

    I'm using a PHP 7.1 and MySQL Version 5.6
    I wanted to update to PHP 7.2 or even PHP 7.3

    question
    if I update the PHP do I have to update MySQL as well
    or can I update only the PHP to 7.2 or 7.3 ?
    thanks
    voyger.: In Almighty God I trust, everyone else has to provide evidence."

    vBulletin Version 5.5.5
  • In Omnibus
    Senior Member
    • Apr 2010
    • 2310

    #2
    MySQL 5.6 support ended a year ago. They are recommending everyone upgrade to MySQL 8.

    Comment

    • voyger
      Senior Member
      • Jun 2017
      • 381

      #3
      my host don't have
      MySQL 8.
      I only can change to
      MySQL 5.7
      voyger.: In Almighty God I trust, everyone else has to provide evidence."

      vBulletin Version 5.5.5

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        MySQL 5.7 would give your site a performance boost. MySQL 8.0 would give it more of a performance boost. However, since very little of page generation is constrained by MySQL, you probably wouldn't notice the benefit for either.

        To answer your question, you can upgrade PHP without upgrading MySQL. Many people do which is why we can't take advantage of advancements from MySQL 5.7 and 8.0 in the software.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • voyger
          Senior Member
          • Jun 2017
          • 381

          #5
          thanks wayne for your replay

          try to update PHP 7.3 on my test forum I got this error so for the time been went back to PHP 7.1
          can you help pleas how to solve

          Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23 Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /home/clients/21143e8b83f7568da4039b68d3d6faa4/prova/includes/vb5/template.php(369) : eval()'d code on line 23
          voyger.: In Almighty God I trust, everyone else has to provide evidence."

          vBulletin Version 5.5.5

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73981

            #6
            Seems one of your templates has improper coding. Since the templates are converted to PHP when stored, this can cause an issue. Since it mentions "title", I am going to guess the template is the header. If you've modified the header try it with an unmodified header.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            • voyger
              Senior Member
              • Jun 2017
              • 381

              #7
              never touch that template don't know how the header template got improper code
              try to edit the HTML template is empty need the code to have a custom title direct to my forum title

              can you gives the HTML code and if you can step by step how to edit the template

              thanks again
              Last edited by voyger; Wed 6 Feb '19, 3:41am.
              voyger.: In Almighty God I trust, everyone else has to provide evidence."

              vBulletin Version 5.5.5

              Comment

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73981

                #8
                Your header template is empty? If it is, I am not sure how your site even works. The header template loads all the CSS and initial Javascript as well as including variables needed by the Javascript to work properly on a page.

                Revert the empty template to view the HTML code. It is a bit much to post here.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

                • voyger
                  Senior Member
                  • Jun 2017
                  • 381

                  #9
                  I thinking found the template can you help which line to edit
                  sorry I am not very technical thanks for your patience

                  Click image for larger version

Name:	Capture.PNG
Views:	363
Size:	130.5 KB
ID:	4408097

                  voyger.: In Almighty God I trust, everyone else has to provide evidence."

                  vBulletin Version 5.5.5

                  Comment

                  • Wayne Luke
                    vBulletin Technical Support Lead
                    • Aug 2000
                    • 73981

                    #10
                    What is the code for the title tag? It should look like this in a default template:

                    Code:
                        <title>
                            <vb:if condition="$page['channelid'] != $nodeid AND !empty($conversationStarter) AND isset($conversationStarter['htmltitle']) AND !empty($conversationStarter['htmltitle'])">
                                {vb:raw conversationStarter.htmltitle} - 
                            <vb:elseif condition="isset($page['title'])" />
                                <vb:if condition="!empty($page['titleprefix'])"> {vb:raw page.titleprefix} -  </vb:if>
                                {vb:var page.title} - <vb:comment>We have a page, not a channel. We don't allow html in page titles at the moment.</vb:comment>
                            </vb:if>
                            {vb:var vboptions.bbtitle}
                        </title>
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud demonstration site.
                    vBulletin 5 API

                    Comment

                    • voyger
                      Senior Member
                      • Jun 2017
                      • 381

                      #11
                      this what i got is look similar to me


                      PHP Code:
                      <title>
                        <
                      vb:if condition="$page['channelid'] != $nodeid AND !empty($conversationStarter) AND isset($conversationStarter['htmltitle']) AND !empty($conversationStarter['htmltitle'])">
                         {
                      vb:raw conversationStarter.htmltitle} -
                        <
                      vb:elseif condition="isset($page['title'])" />
                         <
                      vb:if condition="!empty($page['titleprefix'])"> {vb:raw page.titleprefix} -  </vb:if>
                         {
                      vb:var page.title} - <vb:comment>We have a pagenot a channelWe don't allow html in page titles at the moment.</vb:comment>
                        </vb:if>
                        {vb:var vboptions.bbtitle}
                       </title> 
                      voyger.: In Almighty God I trust, everyone else has to provide evidence."

                      vBulletin Version 5.5.5

                      Comment

                      • voyger
                        Senior Member
                        • Jun 2017
                        • 381

                        #12
                        any answer on this pleas would like to update to
                        PHP 7.3
                        need to solve this problem
                        need help how can i solve this error

                        thanks
                        voyger.: In Almighty God I trust, everyone else has to provide evidence."

                        vBulletin Version 5.5.5

                        Comment

                        • Wayne Luke
                          vBulletin Technical Support Lead
                          • Aug 2000
                          • 73981

                          #13
                          I don't see an error in that template code. I also don't get the warning message on my local machine which is using PHP 7.3. However, I don't have any edited templates. What templates have you modified. You're looking for constructs like this:

                          PHP Code:
                          <vb:elseif condition="isset($page['title'])" /> 

                          See how title is within single quotes? That is how it should be. So you would have to look for $page[title] in every template and change them to $page['title']. Though $page could be a different variable.

                          What does a search for [title] return? Styles -> Search in Templates.
                          Translations provided by Google.

                          Wayne Luke
                          The Rabid Badger - a vBulletin Cloud demonstration site.
                          vBulletin 5 API

                          Comment

                          • voyger
                            Senior Member
                            • Jun 2017
                            • 381

                            #14
                            thanks wayne for helping much appreciated I never changed anything on template
                            never the less will have more accurate look on template hope my luck will turn on me and found the error
                            will let you know

                            regard
                            voyger.: In Almighty God I trust, everyone else has to provide evidence."

                            vBulletin Version 5.5.5

                            Comment

                            • voyger
                              Senior Member
                              • Jun 2017
                              • 381

                              #15
                              hi again trouble round the corner !
                              look it all template i don't see any error

                              when i search [title] I don't get any
                              return Styles
                              click on Product Title
                              I get this error
                              Invalid Page URL. If this is an error and the page should exist, please contact the system administrator and tell them how you got this message.




                              Last edited by voyger; Sun 10 Feb '19, 2:46am.
                              voyger.: In Almighty God I trust, everyone else has to provide evidence."

                              vBulletin Version 5.5.5

                              Comment

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