Notice: Undefined index: mysql_collation

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

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;

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.

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.

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.

This thread has been closed due to long inactivity. Posting to it is not possible.
View code on GitHub