Friday, May 24th 2013, 11:24am UTC+2

You are not logged in.

  • Login
  • Register

Languages

  • 1
  • 2

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

1

Monday, January 11th 2010, 10:25am

Languages

Hi there,



Listen, isn't there a script for easier adding languages?

I have to do some real tweaking in the database when it comes to adding languages.



Maybe you can come up with a mysql file or lamguage.php file for adding all the entries in one time? You know exactly where they are.



Kind regards,



Mike
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

2

Monday, January 11th 2010, 10:55am

Hava you already categories and products or only the default system
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

3

Monday, January 11th 2010, 10:59am

I already have categoriess and products but just for demo purpose. They can be deleted with no problem
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

4

Monday, January 11th 2010, 1:46pm

ok, here are the queries, based on language id 1 which will be copied to language id 3

(This term was hidden for guests. To be able to read it you should register!)

If you have other language_ids, change
(This term was hidden for guests. To be able to read it you should register!)
to the target id and
(This term was hidden for guests. To be able to read it you should register!)
for the origin one

P.S.: This queries are based on H.H.G. multistore EE, for other Versions let the non existing Tables away.
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

franky_n

Professional

Date of registration: Mar 26th 2009

Posts: 615

Thanks: 29

5

Monday, January 11th 2010, 1:55pm

Dear tomale,

VERY IMPORTANT: This is not tested! First try it on an test shop!

Insert a new language in admin menu.

Copy the language files in

(This term was hidden for guests. To be able to read it you should register!)

into a new folder

(This term was hidden for guests. To be able to read it you should register!)


After that extract the attached zip file and open the sql file to edit.
Search and replace $language_id_no with the ID of your new language.
After that save this and import it into your Database (with phpmyadmin or something else).

Otherwise the only chance to insert a language is on first install...

Greetings

Franky
franky_n has attached the following file:
  • new_language.zip (8.43 kB - 21 times downloaded - Last download: Dec 7th 2012, 11:25pm)
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

6

Monday, January 11th 2010, 2:00pm

Ik was sneller (I was faster) :P
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

franky_n

Professional

Date of registration: Mar 26th 2009

Posts: 615

Thanks: 29

7

Monday, January 11th 2010, 2:02pm

Hi Hasan!

Grrrrrr! (The same in english) :D

Viele Grüße

Franky
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

8

Monday, January 11th 2010, 2:30pm

  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

9

Monday, January 11th 2010, 2:32pm

INSERT INTO hhg_shipping_status (shipping_status_id, shipping_status_group, language_id, owner_id, store_id, shipping_status_name, shipping_status_image, shipping_status_system_default) VALUES (9, 1, 4, 1, 1, '3-4 days', 'status_green.gif', 2);



heb al...moest 9 zijn keys lopen op van 1 tot en met 8...volgende is dus..9



Ga alle tabellen even per stuk met de hand doen...
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

10

Monday, January 11th 2010, 2:34pm

H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

11

Monday, January 11th 2010, 2:46pm

Here is the message i get in my email:



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 'AND store_id=1 LIMIT 1' at line 1
QUERY:
SELECT * FROM products_calculation WHERE products_id= AND store_id=1
BACKTRACE:


hhg_db_query_limit(SELECT * FROM products_calculation WHERE products_id= AND store_id=1, 1) % line 177, file: class.xtcPrice.php




xtcPrice.xtcGetPrice(null, true, 1, 0, 0.0000, , , 1) % line 665, file: class.product.php




product.getBoxWhatsNew() % line 32, file: whats_new.php




require(/xxx/xxx/xxx/xxx/xxx/public_html/store_files/1/templates/hhg_ms_r2/source/boxes/whats_new.php) % line 29, file: boxes.php





require(/xxx/xxx/xxx/xxx/xxx/public_html/store_files/1/templates/hhg_ms_r2/source/boxes.php) % line 30, file: index.php





don't know what this has got to do wuth the language part...
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

12

Monday, January 11th 2010, 2:49pm

nothing, has been fixed here: mySQL Syntax Problem
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

13

Monday, January 11th 2010, 2:54pm

Okay,

After fixing the above, it seems to have worked with the database adding language....i'll be goiing through everything, if i find something i will report it here,



Thank you guys!
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

14

Monday, January 11th 2010, 2:56pm

no problem =)
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

15

Monday, January 11th 2010, 3:07pm


(This term was hidden for guests. To be able to read it you should register!)




This error i get when i try to add or edit a category or content item in the admin part when the admin langusge is set on dutch. When the admin is set on german it is ok??
  • Go to the top of the page

franky_n

Professional

Date of registration: Mar 26th 2009

Posts: 615

Thanks: 29

16

Monday, January 11th 2010, 3:09pm

Hi ,

ok this is the corrected zip without the shipping_status_id.

Greetings

Franky
franky_n has attached the following file:
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

17

Monday, January 11th 2010, 3:09pm

Set the file permissions to writable to get the entries for the error
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

tomale

Trainee

Date of registration: Nov 25th 2009

Posts: 67

18

Monday, January 11th 2010, 3:17pm

The data for the dutch language file does not get stored in the database. Trying to name he dutch categories, but they don't get saved to the database.
  • Go to the top of the page

HHGAG

Sage

Date of registration: Jun 14th 2008

Posts: 15,318

Thanks: 37

Occupation: CEO

19

Monday, January 11th 2010, 3:20pm

They won't be saved, if the data is for an update. New one should be work. You haven't used the sql Queries from me, there are all entries, to copy for the new language, so it would work. :whistling:
H.H.G. A.Ş.
Hasan H. Gürsoy (CEO)
--------------------------------------------------------------------------------------------------------------------
Shopsoftware - Shopsystem - Webshop - Onlineshop - Sanal mağaza - Sanal market - eTicaret
  • Go to the top of the page

franky_n

Professional

Date of registration: Mar 26th 2009

Posts: 615

Thanks: 29

20

Monday, January 11th 2010, 3:20pm

Hi tomale,

it works only with new made categories, because already made categories are saved with only 2 languages (en,de).

Greetings

Franky
  • Go to the top of the page
  • 1
  • 2

Similar threads

Tagging