Can't Select Language on Product Virtuemart Import

  • Posts: 15
  • Thank you received: 0
10 years 4 days ago #180383

-- HikaShop version -- : HikaShop Business 2.3.4
-- Joomla version -- : 1.5.26
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Safari 7.1
-- Error-message(debug-mod must be tuned on) -- : No error message on page. I am trying to use the HikaShop Product Import Feature to import Virtuemart version 2.0.22a. It wants me to select the main language you want for your contents (products descriptions, manufacturers...) :

The language selector is empty and I can not find any help on how to correct this.
Any help would be greatly appreciated.

The purpose of this is to be able to move this old 1.5 website to Joomla 3.X.
Thanks....Scott

I am trying to use the HikaShop Product Import Feature to import Virtuemart version 2.0.22a. It wants me to select the main language you want for your contents (products descriptions, manufacturers...) :

The language selector is empty and I can not find any help on how to correct this.
Any help would be greatly appreciated.

The purpose of this is to be able to move this old 1.5 website to Joomla 3.X.
Thanks....Scott



500 - An error has occurred.

JDatabaseMySQL::query: 1146 - Table 'uncldtem_db.jos_languages' doesn't exist SQL=SELECT * FROM jos_languages

Call stack
# Function Location
1 JAdministrator->dispatch() /home/uncldtem/public_html/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/uncldtem/public_html/administrator/includes/application.php:136
3 require_once() /home/uncldtem/public_html/libraries/joomla/application/component/helper.php:162
4 hikashopController->execute() /home/uncldtem/public_html/administrator/components/com_hikashop/hikashop.php:54
5 JController->execute() /home/uncldtem/public_html/administrator/components/com_hikashop/helpers/helper.php:1461
6 hikashopController->show() /home/uncldtem/public_html/libraries/joomla/application/component/controller.php:236
7 hikashopController->display() /home/uncldtem/public_html/administrator/components/com_hikashop/helpers/helper.php:1220
8 JController->display() /home/uncldtem/public_html/administrator/components/com_hikashop/helpers/helper.php:1480
9 ImportViewImport->display() /home/uncldtem/public_html/libraries/joomla/application/component/controller.php:310
10 hikashopView->display() /home/uncldtem/public_html/administrator/components/com_hikashop/views/import/view.html.php:19
11 JView->display() /home/uncldtem/public_html/administrator/components/com_hikashop/helpers/helper.php:1687
12 JView->loadTemplate() /home/uncldtem/public_html/libraries/joomla/application/component/view.php:192
13 include() /home/uncldtem/public_html/libraries/joomla/application/component/view.php:564
14 include() /home/uncldtem/public_html/administrator/components/com_hikashop/views/import/tmpl/show.php:39
15 hikashopTranslationHelper->loadLanguages() /home/uncldtem/public_html/administrator/components/com_hikashop/views/import/tmpl/vm.php:28
16 JDatabaseMySQLi->loadObjectList() /home/uncldtem/public_html/administrator/components/com_hikashop/helpers/translation.php:75
17 JDatabaseMySQLi->query() /home/uncldtem/public_html/libraries/joomla/database/database/mysqli.php:474
18 JError->raiseError() /home/uncldtem/public_html/libraries/joomla/database/database/mysqli.php:247
19 JError->raise() /home/uncldtem/public_html/libraries/joomla/error/error.php:171
20 JException->__construct() /home/uncldtem/public_html/libraries/joomla/error/error.php:136

Attachments:
Last edit: 10 years 4 days ago by soliver.

Please Log in or Create an account to join the conversation.

  • Posts: 15
  • Thank you received: 0
10 years 4 days ago #180384

I solved the problem so if this happens to you, do the following:

Use phpMyAdmin and create the missing table, then put the missing data into the table. Here is the code to do that:

Create the Table Below First by doing a SQL Query. Add this query to create the Table.

CREATE TABLE `jos_languages` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`active` tinyint(1) NOT NULL default '0',
`iso` varchar(20) default NULL,
`code` varchar(20) NOT NULL default '',
`shortcode` varchar(20) default NULL,
`image` varchar(100) default NULL,
`fallback_code` varchar(20) NOT NULL default '',
`params` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

Then do this query to add the language to the table.

INSERT INTO `jos_languages` VALUES (1, 'English (United Kingdom)', 1, 'en_GB.utf8, en_GB.UT', 'en-GB', 'en', '', '', '', 1);

Last edit: 10 years 4 days ago by soliver.

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum