Error installing JS Jobs 1.1.5 (Free version)

3 years 1 month ago #4593 by Reid Walley
JS Jobs (free) v 1.1.5 doesn't install...
I downloaded JS Jobs (free) 1.1.5 directly from Joomla Sky. Then attempted to install on Joomla 3.6.2, and got the following error:

Warning

JInstaller: :Install: Error SQL Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE `#__js_job_fieldsordering` ( `id` int(11) NOT NULL AUTO_INCREMENT, `field` varchar(50) NOT NULL, `fieldtitle` varchar(50) DEFAULT NULL, `ordering` int(11) DEFAULT NULL, `section` varchar(20) DEFAULT NULL, `fieldfor` tinyint(2) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `isvisitorpublished` tinyint(1) DEFAULT NULL, `sys` tinyint(1) NOT NULL, `cannotunpublish` tinyint(1) NOT NULL, `required` tinyint(1) NOT NULL DEFAULT '0', `isuserfield` tinyint(1) NOT NULL, `userfieldtype` varchar(250) NOT NULL, `userfieldparams` text NOT NULL, `search_user` tinyint(1) NOT NULL, `search_visitor` tinyint(1) NOT NULL, `cannotsearch` tinyint(1) NOT NULL, `showonlisting` tinyint(1) NOT NULL, `cannotshowonlisting` tinyint(1) NOT NULL, `depandant_field` varchar(250) NOT NULL, `readonly` tinyint(4) NOT NULL, `size` int(11) NOT NULL, `maxlength` int(11) NOT NULL, `cols` int(11) NOT NULL, `rows` int(11) NOT NULL, `j_script` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Extension Install: SQL error processing query: DB function failed with error number 1075
Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=CREATE TABLE `#__js_job_fieldsordering` ( `id` int(11) NOT NULL AUTO_INCREMENT, `field` varchar(50) NOT NULL, `fieldtitle` varchar(50) DEFAULT NULL, `ordering` int(11) DEFAULT NULL, `section` varchar(20) DEFAULT NULL, `fieldfor` tinyint(2) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `isvisitorpublished` tinyint(1) DEFAULT NULL, `sys` tinyint(1) NOT NULL, `cannotunpublish` tinyint(1) NOT NULL, `required` tinyint(1) NOT NULL DEFAULT '0', `isuserfield` tinyint(1) NOT NULL, `userfieldtype` varchar(250) NOT NULL, `userfieldparams` text NOT NULL, `search_user` tinyint(1) NOT NULL, `search_visitor` tinyint(1) NOT NULL, `cannotsearch` tinyint(1) NOT NULL, `showonlisting` tinyint(1) NOT NULL, `cannotshowonlisting` tinyint(1) NOT NULL, `depandant_field` varchar(250) NOT NULL, `readonly` tinyint(4) NOT NULL, `size` int(11) NOT NULL, `maxlength` int(11) NOT NULL, `cols` int(11) NOT NULL, `rows` int(11) NOT NULL, `j_script` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
3 years 1 month ago #4608 by Ahmad
Hi,

Can you re-download latest version from joomsky.com
Problem is fixed.

Download JS Jobs

Please write your valuable review JS Jobs and JS Support Ticket at JED.
Time to create page: 0.194 seconds

Please publish modules in offcanvas position.