Fujimasa san, sorry for the mistake. here is the correct sql request:I get an error when uploading the "mysql_japanese_install.sql" file in the SQL folder in PhpMyAdmin. Other than that, I can upload the file.
MYSQL message
#住所フォーマット追加 (#Add address format)
INSERT INTO address_format VALUES(21,'$postcode$cr$sate$city$streets$cr$lastname $firstname 様')
#1136-1行目で、列の数が値の数と一致しません。(#1136-In line 1, the number of columns does not match the number of values.)
INSERT INTO address_format VALUES (21, '〒$postcode$cr$state$city$streets$cr$lastname $firstname 様', '$city $country');
But you can't use INSERT two time on same database/table. It is only to add new data. To change existing data the MySQL command 'UPDATE' is used.
When you have an error like that don't upload the whole SQL file again just go to sql tab in phpmyadmin and copy / paste the correct MySQL query there.
I am going to check that but a log file would be very helpful. Just after the error happens look in 'logs' folder (in cart root) where a new file should have been created. Please copy and paste the relevant part of this log file.Next time I upload the contents of ADMIN-JP to the admin folder using FTP software.
When I add a new item I get an error and cannot add it.
I get an error message "If you were entering information, press the BACK button in your browser and re-check the information you If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data."
Bookmarks