Announcement

Collapse
No announcement yet.

english language phrase won't restore

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

  • RealIdea
    replied
    it seems like i will back to my 3.8 and delete all languages except english
    and upgrade again

    Leave a comment:


  • RealIdea
    replied
    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

    Leave a comment:


  • Michael König
    replied
    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;

    Leave a comment:


  • RealIdea
    replied
    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

    Leave a comment:


  • RealIdea
    replied
    Originally posted by Andrew Elkins View Post
    There's no "." in the able name that Steve provided. Please run the above query.
    i can't reach you
    what is the "." mean
    and where is the above queries ?
    i see its all the same queries

    Leave a comment:


  • Andrew Elkins
    replied
    Originally posted by Steve Machol View Post
    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;
    There's no "." in the able name that Steve provided. Please run the above query.

    Leave a comment:


  • RealIdea
    replied
    the same message
    #1146 - Table 'databa_vb.phrase' doesn't exist
    did you mean
    DELETE
    FROM databa_vbphrase AS p1
    USING databa_vbphrase 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;

    MySQL version 5.0.90

    Leave a comment:


  • Steve Machol
    replied
    Then the queries would be:

    For MySQL 4.0.x use this query:

    DELETE
    FROM databa_vbphrase
    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;

    Or for MySQL 4.1.x and higher, use 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;

    Leave a comment:


  • RealIdea
    replied
    $config['Database']['tableprefix'] = 'databa_vb';

    Leave a comment:


  • Steve Machol
    replied
    That is your table prefix? What is the complete line?

    Leave a comment:


  • RealIdea
    replied
    databa_vbaccsess

    Leave a comment:


  • Steve Machol
    replied
    What do you have set for the table prefix in your vB config.php file?

    Leave a comment:


  • RealIdea
    replied
    what ?
    table prefix ?
    what that table ?
    which part ?
    my database name is like this
    mysite_vb

    Leave a comment:


  • Steve Machol
    replied
    You need to edit that query with the appropriate table prefix you are using for your database.

    Leave a comment:


  • RealIdea
    replied
    thank you
    i did that and got this message
    #1146 - Table 'mysite_DB.phrase' doesn't exist

    Leave a comment:

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