Translating text directly in database

[stobi_de]

Hello,

sorry for asking this question again.
I have a problem with the access of the translations within Prestashop 1.7.2.4, so I have to change some texts directly in the database.

Is there a possibily to do that?

I have texts in normal Prestashop and in the ritools-template, which have to be changed.
The support from ritools....hm...

 

Hope to get an answer here

[joseantgv]

41 minutes ago, stobi_de said:

Hello,

sorry for asking this question again.
I have a problem with the access of the translations within Prestashop 1.7.2.4, so I have to change some texts directly in the database.

Is there a possibily to do that?

I have texts in normal Prestashop and in the ritools-template, which have to be changed.
The support from ritools....hm...

 

Hope to get an answer here

 

Translations are not in database but in files. And it depends on which translation do you want to modify, it can be in a folder or in another.

 

Which problem do you have with translations from backoffice?

 

[stobi_de]

My shop is running on a hosteurope server.

When I want to change the translations (backoffice or template, all the same) I get a too-many-redirects error.
it does not depend on the browser or cookies, it depends on hosteurope.
I installed the same version on a 1und1 server without any problems.

But hosteurope says: not our problem.

So I try a work arround.

 

Frank

[selectshop.at]

This is a classical server error, or mal-formed .htaccess. Did you already regenerated the .htaccess ? If yes, than provider should re-configure his server or simply rename the main .htaccess to .htaccess.old and try to use back-office translations.

 

BTW: as answered before here and also in German Forum to your same question for PS 1.7.2.3, - translations are not located in database but in files. I suggest you to follow what Whiley answered to you before:

 

[stobi_de]

I did not see the answer of Whiley, I think, I forgot the notify-button.

The htaccess

I have this file in my prestashop directory.
My first content was

php_value short_open_tag 0
 

and then it was completed with a lot of text by prestashop

 

# ~~start~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again
# .htaccess automaticaly generated by PrestaShop e-commerce open-source solution
# http://www.prestashop.com - http://www.prestashop.com/forums

<IfModule mod_rewrite.c>
<IfModule mod_env.c>
SetEnv HTTP_MOD_REWRITE On
</IfModule>

RewriteEngine on

#Domain: svs-schneider.de
RewriteRule . - [E=REWRITEBASE:/presta/]
RewriteRule ^api$ api/ [L]

RewriteRule ^api/(.*)$ %{ENV:REWRITEBASE}webservice/dispatcher.php?url=$1 [QSA,L]

# Images
RewriteRule ^([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$1$2$3.jpg [L]
RewriteRule ^([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$1$2$3$4.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$1$2$3$4$5.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$1$2$3$4$5$6.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6$7.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7$8.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8$9.jpg [L]
RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9$10.jpg [L]
RewriteRule ^c/([0-9]+)(\-[\.*_a-zA-Z0-9-]*)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2$3.jpg [L]
RewriteRule ^c/([a-zA-Z_-]+)(-[0-9]+)?/.+\.jpg$ %{ENV:REWRITEBASE}img/c/$1$2.jpg [L]
# AlphaImageLoader for IE and fancybox
RewriteRule ^images_ie/?([^/]+)\.(jpe?g|png|gif)$ js/jquery/plugins/fancybox/images/$1.$2 [L]

# Dispatcher
RewriteCond %{REQUEST_FILENAME} -s [OR]
RewriteCond %{REQUEST_FILENAME} -l [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^.*$ - [NC,L]
RewriteRule ^.*$ %{ENV:REWRITEBASE}index.php [NC,L]
</IfModule>

AddType application/vnd.ms-fontobject .eot
AddType font/ttf .ttf
AddType font/otf .otf
AddType application/font-woff .woff
AddType font/woff2 .woff2
<IfModule mod_headers.c>
    <FilesMatch "\.(ttf|ttc|otf|eot|woff|woff2|svg)$">
        Header set Access-Control-Allow-Origin "*"
    </FilesMatch>
</IfModule>

#If rewrite mod isn't enabled
ErrorDocument 404 /presta/index.php?controller=404

# ~~end~~ Do not remove this comment, Prestashop will keep automatically the code outside this comment when .htaccess will be generated again

[selectshop.at]

Besides I'm speaking about rewrite problems of the server and not rewrite rules added by .htaccess for PRESTASHOP, this line is not original Prestashop:

 

php_value short_open_tag 0

 

Comment it (#php_value short_open_tag 0 ). I don't think Prestashop uses short open tags. This is for other CMS Software and the value 0 only says that short open tag is disabled (as for security reasons). If commenting the line translations do not work as well, than revert to your provider. Some .htaccess before or ini-files, or server configuration is causing the problem of wrong re-direction.

 

 BTW: notifications of the forum are disabled for the moment There is a bug on it and Invision team and Presta Team is already working on the debug.

[stobi_de]

The installation of Prestashop told me to put short_open_tag to off..
I tested without this line, but there is no difference.

[selectshop.at]

Never seen this advice...

So we are there where we started some hours ago. It is a server problem. A bad configured firewall, a bad configured server directive, or a simply ini or .htaccess before your Shop .htaccess. So one or two level before your webspace. Your experience is saying the same. On one server no problem, on the other = problem.

[stobi_de]

Yes, I wrote this AGAIN to the hosteurope service.
If this doesn't help, I have to tell my customer: got to 1und1.

Bahhhh I don't like 1und1.

So we have to life at the moment with some strange texts

btw. found some texts in the source code and repalced it.