Announcement

Collapse
No announcement yet.

english language phrase won't restore

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

  • #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


    • #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


      • #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


        • #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...
          X