Problem upgradet vb 4.1.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ala Eddine
    New Member
    • Feb 2011
    • 3

    [Forum] Problem upgradet vb 4.1.2

    problem upgradet vb 4.1.2

    Unexpected Text:

    <?xml version="1.0" encoding="windows-1252"?>
    <?xml version="1.0" encoding="windows-1252"?>
    <errors>
    <error><![CDATA[<p>Database Error</p>

    Invalid SQL:

    SELECT fieldname, varname, text
    FROM phrase
    WHERE languageid IN(-1,0) AND
    fieldname IN ();

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4]]></error>
    <error_html><![CDATA[<p>Database error in vBulletin 4.1.2</p>
    <p>Invalid SQL:

    SELECT fieldname, varname, text
    FROM phrase
    WHERE languageid IN(-1,0) AND
    fieldname IN ();<p>
    <p>
    <strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4<br />
    <strong>Error Number</strong> : 1064<br />
    <strong>Request Date</strong> : Saturday, February 19th 2011 @ 06:51:44 AM<br />
    <strong>Error Date</strong> : Saturday, February 19th 2011 @ 06:51:45 AM<br />
    <strong>Script</strong> : http://www.*****.com/vb/install/upgrade.php<br />
    <strong>Referrer</strong> : http://www.*****.com/vb/install/upgrade.php<br />
    <strong>Classname</strong> : vB_Database<br />
    <strong>MySQL Version</strong> : 5.0.91-community<br />
    </p>]]></error_html>
    </errors>
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Invalid SQL errors are almost always related to modified code. Which version are you upgrading from and did you disable all add-ons prior to upgrading?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Ala Eddine
      New Member
      • Feb 2011
      • 3

      #3
      Originally posted by Steve Machol
      Invalid SQL errors are almost always related to modified code. Which version are you upgrading from and did you disable all add-ons prior to upgrading?
      i use the 4.1.1 to 4.1.2
      and i have disable all add-ons prior to upgrading but the sam errore i khnow that the problem are from langage

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        This may be a server time and/or memory limit. To increase your limits edit your includes/config.php file and add these lines right under the <?php line:

        ini_set('memory_limit', -1);
        ini_set("max_execution_time", "2880");

        Then try again.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • Ala Eddine
          New Member
          • Feb 2011
          • 3

          #5
          Problème Risoved Thanks You

          Comment

          • porschegruven
            Member
            • Feb 2011
            • 44
            • 4.1.x

            #6
            I'm getting this exact same error. My upgrade is failing on step 2 w/ the mysql error at the phrase table. I am attempting to upgrade from 4.1.0 PL2 to 4.1.2

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              Please start your own thread with all the relevant details. Thank you.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

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