500 error on packages

[dond]

I get this when I try to go to packages.

Unknown column 'external_ref' in 'where clause' SQL=SELECT p.*,u.name AS editor FROM j17_fabrik_packages AS p LEFT JOIN j17_users AS u ON checked_out = u.id WHERE (p.published IN (0, 1)) AND external_ref <> 1 ORDER BY name asc Unknown column 'external_ref' in 'where clause' SQL=SELECT p.*,u.name AS editor FROM j17_fabrik_packages AS p LEFT JOIN j17_users AS u ON checked_out = u.id WHERE (p.published IN (0, 1)) AND external_ref <> 1 ORDER BY name asc LIMIT 0, 20 Unknown column 'external_ref' in 'where clause' SQL=SELECT p.*,u.name AS editor FROM j17_fabrik_packages AS p LEFT JOIN j17_users AS u ON checked_out = u.id WHERE (p.published IN (0, 1)) AND external_ref <> 1 ORDER BY name asc Unknown column 'external_ref' in 'where clause' SQL=SELECT p.*,u.name AS editor FROM j17_fabrik_packages AS p LEFT JOIN j17_users AS u ON checked_out = u.id WHERE (p.published IN (0, 1)) AND external_ref <> 1 ORDER BY name asc

any suggestions?

 

[rob]

Hi

did you update from a 2.X site to 3.0?
If so you may need to double check that all of the queries in:

administrator/components/com_fabrik/sql/updates/mysql/2.x-3.0.sql have been run, specifically these one:

ALTER TABLE `#__fabrik_packages` CHANGE `state` `published` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `#__fabrik_packages` CHANGE `attribs` `params` TEXT NOT NULL;
ALTER TABLE `#__fabrik_packages` ADD `external_ref` VARCHAR(255) NOT NULL;
ALTER TABLE `#__fabrik_packages` ADD `component_name` VARCHAR(100) NOT NULL;
ALTER TABLE `#__fabrik_packages` ADD `version` VARCHAR(10) NOT NULL;
ALTER TABLE `#__fabrik_packages` DROP `tables`;

Remember to replace '#_' with your Joomla database prefix.

 

[dond]

the culprit was
ALTER TABLE `j17_fabrik_packages` ADD `external_ref` VARCHAR(255) NOT NULL;

now I'm having same issues as troester so i'll close this thread and follow http://fabrikar.com/forums/showthread.php?t=23133