Language problem when i add to product

[Guest vrakas]

My turn now to get an answer, if its possible

On a product when i add to language and in my case its Greek, later when i try to edit or delete it nothing happens.

Brooky posted an sql query here a few days ago about this but it seems that it doesnt always work since on one site it is working and on the other not.

Any ideas about this and how to overcome this problem? :w00t:

[Guest hennaboy]

I am not 100% certain on this one but you can set the auto increment on phpmyadmin for the table.

If you have phpmyadmin installed login to your database and then choose the inv_lang table. check the box next to the ID field and then go across and click on the pencil looking icon (change). On the next page that loads if you scroll across to the extra field you should be able to choose auto increment from there. Save and see if that makes any difference.

[Guest vrakas]

Thanks hennaboy, i will give it a try.

Tryed it and this what i got from the sql

SQL query:

ALTER TABLE `CubeCart_inv_lang` CHANGE `id` `id` INT( 11 ) NOT NULL DEFAULT '0' AUTO_INCREMENT

The documents work but need to test the products also but i have to run off to work

I will be back to let you know.

Final verdic.

Yes the above query DOES work and i can now edit and or delete from the Language.

Thanks again hennaboy :)

[Guest]

hello vrakas

i am trying the same thing

but i get this error

#1067 - Invalid default value for 'id'

i try changing the default value to 1

but i keep getting the same error

by the way where can i find greek language pack for 3.04

[Guest estelle]

Romos - you cant specify DEFAULT VALUE and AUTO_INCREMENT for the same column.

Greekuser - Try this:

ALTER TABLE `CubeCart_inv_lang` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT