english language phrase won't restore

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RealIdea
    New Member
    • Dec 2010
    • 16
    • 4.1.x

    #16
    i tried this query
    DELETE
    FROM databa_vbphrase AS p1
    USING phrase AS p1
    LEFT JOIN phrase AS p2 ON ( p1.varname = p2.varname
    AND p2.languageid = -1 )
    WHERE p1.languageid =0
    AND p2.languageid IS NOT NULL;

    and still get this error
    #1146 - Table 'databa_vb.phrase' doesn't exist

    Comment

    • Michael König
      Senior Member
      • May 2001
      • 461
      • 3.6.x

      #17
      Try:

      DELETE FROM p1
      USING databa_vbphrase AS p1
      LEFT JOIN databa_vbphrase AS p2 ON (p1.varname = p2.varname AND p2.languageid = -1)
      WHERE p1.languageid = 0
      AND p2.languageid IS NOT NULL;

      Comment

      • RealIdea
        New Member
        • Dec 2010
        • 16
        • 4.1.x

        #18
        ok thanks done
        4 row(s) deleted. ( Query took 0.0810 sec )
        but really the problem still
        and the arabic phrase in everywhere in the english language

        Comment

        • RealIdea
          New Member
          • Dec 2010
          • 16
          • 4.1.x

          #19
          it seems like i will back to my 3.8 and delete all languages except english
          and upgrade again

          Comment

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