user686 Od Neznámy Člen od dec -0001 user686 30 jún 2014 11:43 I need help. Installation was succesfull but there is an error: Notice: Undefined index: mysql_collation in ~/includes/library/lib_language.inc.php (Line 35) In this line in the document, i have: // Set mysql charset and collation if (!database::set_encoding(self::$selected['mysql_collation'])) { database::set_character(self::$selected['charset']); } Anyone know the answer to correct this error? Thanks
litecart Main Crew Od Sweden Člen od feb 2013 litecart 30 jún 2014 13:35 Are you using the latest development release? Run this query in phpmyadmin: ALTER TABLE lc_languages ADD mysql_collation VARCHAR(32) NOT NULL AFTER charset;
user603 LiteCart Fan Od Czech Republic Člen od jún 2014 user603 1 sep 2014 17:50 Same issue here, I am running litecart via Softaculous. Adding the field via provided SQL helped. The locale and collation can (and should) be set via admin, section Languages.
litecart Main Crew Od Sweden Člen od feb 2013 litecart 1 sep 2014 22:19 Which version does this concern? The latest stand alone installer has the following correct query: CREATE TABLE lc_languages ( id int(11) NOT NULL AUTO_INCREMENT, status tinyint(1) NOT NULL, code varchar(2) NOT NULL, name varchar(32) NOT NULL, locale varchar(32) NOT NULL, charset varchar(16) NOT NULL, [color=#00c] mysql_collation varchar(32) NOT NULL,[/color] raw_date varchar(32) NOT NULL, raw_time varchar(32) NOT NULL, raw_datetime varchar(32) NOT NULL, format_date varchar(32) NOT NULL, format_time varchar(32) NOT NULL, format_datetime varchar(32) NOT NULL, decimal_point varchar(1) NOT NULL, thousands_sep varchar(1) NOT NULL, currency_code varchar(3) NOT NULL, priority tinyint(2) NOT NULL, date_updated datetime NOT NULL, date_created datetime NOT NULL, UNIQUE KEY id (id), KEY status (status) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci; I will pass this question to the Softaculous crew for you.
litecart Main Crew Od Sweden Člen od feb 2013 litecart 2 sep 2014 11:10 Did this occur after an upgrade or after a new install? Softaculous could not verify the issue. Neither could I. All installation and upgrade patches seems fine in our stable versions.