JA Job Board Component 8,554 posts

[brentwilliams2 Friend brentwilliams2Join date: January 2013Posts: 231Downloads:0Uploads:23 Thanks: 4 Thanked: 33 times in 1 posts]

#191487

I just installed 1.0.5 on my test server and got the following error:

500 – JDatabaseMySQL::query: 1054 – Unknown column ‘AutoImport’ in ‘where clause’ SQL=SELECT FeedID FROM mf8437_ja_xml_import_feeds WHERE AutoImport=1

It looks like maybe the installation didn’t add that column? What is the best way to fix this?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#509390

Hello Brentwilliams2,

Please go to your phpmyadmin, and run this query:
ALTER TABLE `#__ja_xml_import_feeds` ADD `AutoImport` tinyint(2) NOT NULL DEFAULT 0;
ALTER TABLE `#__ja_xml_import_feeds` ADD `Language` varchar(50) NOT NULL DEFAULT '*';

Change symbol ‘#’ by your ‘Table Prefix’.

[brentwilliams2 Friend brentwilliams2Join date: January 2013Posts: 231Downloads:0Uploads:23 Thanks: 4 Thanked: 33 times in 1 posts]

#509524

It worked! But there was an extra _ that I had to remove. This worked for me:

ALTER TABLE `#_ja_xml_import_feeds` ADD `AutoImport` tinyint(2) NOT NULL DEFAULT 0;
ALTER TABLE `#_ja_xml_import_feeds` ADD `Language` varchar(50) NOT NULL DEFAULT '*';

Change symbol ‘#’ by your ‘Table Prefix’.

Thank you!!

[Author]

Posts