error in database

29.03.2015 12:39
#1
Evtuh
Joomshopping forum user no avatar
Name: Vasilii
15.04.2011
Posts: 3
Quote
error in database

Russian:
Здравствуйте, после переезда на другой хостинг после импорта Базы данных в новую пустую базу. Возникает такая ошибка. После обновления страницы исчезает. Как починить?
English:
Hello, after moving to another hosting after importing a database into a new empty database. This error occurs. After refreshing the page disappears. How to fix it?

Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_countries` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_shipping_method` ADD `name_en-gb` varchar(100) NOT NULL, ADD `description_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_payment_method` ADD `name_en-gb` varchar(100) NOT NULL, ADD `description_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_order_status` ADD `name_en-gb` varchar(100) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_delivery_times` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_unit` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_attr` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_attr_values` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_products_extra_fields` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_products_extra_field_values` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_free_attr` ADD `name_en-gb` varchar(255) NOT NULL
Error install new language:
Duplicate column name 'title_en-gb' SQL=ALTER TABLE `jos_jshopping_config_seo` ADD `title_en-gb` varchar(255) NOT NULL, ADD `keyword_en-gb` text NOT NULL, ADD `description_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'text_en-gb' SQL=ALTER TABLE `jos_jshopping_config_statictext` ADD `text_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_manufacturers` ADD `name_en-gb` varchar(255) NOT NULL, ADD `alias_en-gb` varchar(255) NOT NULL, ADD `short_description_en-gb` text NOT NULL, ADD `description_en-gb` text NOT NULL, ADD `meta_title_en-gb` varchar(255) NOT NULL, ADD `meta_description_en-gb` text NOT NULL, ADD `meta_keyword_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_categories` ADD `name_en-gb` varchar(255) NOT NULL, ADD `alias_en-gb` varchar(255) NOT NULL, ADD `short_description_en-gb` text NOT NULL, ADD `description_en-gb` text NOT NULL, ADD `meta_title_en-gb` varchar(255) NOT NULL, ADD `meta_description_en-gb` text NOT NULL, ADD `meta_keyword_en-gb` text NOT NULL
Error install new language:
Duplicate column name 'name_en-gb' SQL=ALTER TABLE `jos_jshopping_products` ADD `name_en-gb` varchar(255) NOT NULL, ADD `alias_en-gb` varchar(255) NOT NULL, ADD `short_description_en-gb` text NOT NULL, ADD `description_en-gb` text NOT NULL, ADD `meta_title_en-gb` varchar(255) NOT NULL, ADD `meta_description_en-gb` text NOT NULL, ADD `meta_keyword_en-gb` text NOT NULL
error in database


Joomla: 1.5.26
JoomShopping: 2.9.7
PHP: 5.3.27
MySQL: 5.5.40-cll
Website Url: www.rakhat63.ru
 
29.03.2015 21:04
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16504
Quote
Aw: error in database

delete folder
language/en-gb
or
rename to
language/en-GB

 
01.04.2015 12:27
#3
Evtuh
Joomshopping forum user no avatar
Name: Vasilii
15.04.2011
Posts: 3
Quote
Aw: error in database

I deleted the folder from the folder administrator/languagе folder and also from folder language but to no avail.


Joomla: 1.5.26
JoomShopping: 2.9.7
PHP: 5.3.27
MySQL: MySQL: 5.5.40-cll
Website Url: www.rakhat63.ru
 
01.04.2015 13:18
#4
Evtuh
Joomshopping forum user no avatar
Name: Vasilii
15.04.2011
Posts: 3
Quote
Aw: error in database

Decided. Through phpMyadmin manually modified in the database columns where there were errors. prefixes with GB changed to gb. Everything works now.


Joomla: 1.5.26
JoomShopping: 2.9.7
PHP: 5.3.27
MySQL: 5.5.40-cll
Website Url: http://www.rakhat63.ru
 
Copyrights MAXXmarketing GmbH. All Rights Reserved