1064 sql error on install

[cweger]

I get this error on insatall:

SQL Error DB function failed with error number 1064
You have an error in your SQL syntax near 'character set cp1250 default NULL, `scorm_package` int(11) default '0', ' at line 4 SQL=CREATE TABLE IF NOT EXISTS `jos_lms_n_scorm` ( `id` int(10) unsigned NOT NULL auto_increment, `course_id` int(10) unsigned default '0', `scorm_name` varchar(255) character set cp1250 default NULL, `scorm_package` int(11) default '0', `summary` text, `version` varchar(9) default NULL, `maxgrade` double NOT NULL default '0', `grademethod` tinyint(2) NOT NULL default '0', `maxattempt` bigint(10) NOT NULL default '1', `updatefreq` tinyint(1) unsigned NOT NULL default '0', `md5hash` varchar(32) default NULL, `launch` bigint(10) unsigned NOT NULL default '0', `skipview` tinyint(1) unsigned NOT NULL default '1', `hidebrowse` tinyint(1) NOT NULL default '0', `hidetoc` tinyint(1) NOT NULL default '0', `hidenav` tinyint(1) NOT NULL default '0', `auto` tinyint(1) unsigned NOT NULL default '0', `popup` tinyint(1) unsigned NOT NULL default '0', `params` text, `width` bigint(10) unsigned NOT NULL default '100', `height` bigint(10) unsigned NOT NULL default '600', `timemodified` bigint(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `lms_n_scorm_course` (`course_id`) ) COMMENT='each record is one SCORM instance and its configuration';


please help.

[den]

Please replace joomlalms.xml file in the com_joomla_lms.zip with attached one.

[pclair]

I am running into a similar issue with mysql throwing a 1064 error.

Since I'm not finding where this XML file should exist, which specific folder should this exist in to replace?

Thank you

[Su_]

As far as we know this problem doesn't occur in latest versions of JoomlaLMS. You don't need to replace any files - please provide the full error message text.

[pclair]

Below is the actual error message....

this error message comes up after a user has completed a test and tries to go back to the LMS which prevents them from doing any other additional testing....

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND published = 1' at line 4 SQL=SELECT params FROM jos_lms_tests WHERE id = AND published = 1
Fatal error: Call to a member function get() on a non-object in /hermes/bosweb/web081/b813/sl.xxx/public_html/sites/xxx/components/com_lms/lms.php on line 1406

[Su_]

Looks like you use Joomlearn LMS, not JoomlaLMS (we are JoomlaLMS support). Please contact their support regarding your issue (joomlashowroom.com) (or I would recommend trying JoomlaLMS :))