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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25855
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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.