Revision as of 13:59, January 19, 2018 by Jdruker (talk | contribs) (Modifying the section list in the CSV query to exclude hidden options)
Jump to: navigation, search

Option Land Query

{{{prodlong}}} → {{{component}}}

Extension:DynamicPageList (DPL), version 2.01 : Warning: No results.

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT CONCAT(,parameter,) AS `Option`,CONCAT( LEFT( valid, 80), IF( LENGTH( valid ) > 80, "...", "" ) ) AS `Valid Values`,REPLACE(`cargo__PubOption`.`default`,':',':') AS `Default Value`,CONCAT ( LEFT( shortdesc, 130), IF( LENGTH( shortdesc ) > 130, "...", "" )) AS `Description` FROM `cargo__OptionCreate` LEFT OUTER JOIN `cargo__PubOption` ON ((`cargo__OptionCreate`.`_pageName`=`cargo__PubOption`.`_pageName`)) WHERE prodlong="{{{prodlong}}}" AND component="{{{component}}}" AND section="{{{section}}}" AND (`cargo__PubOption`.`hidden`="false" OR `cargo__PubOption`.`hidden`="False" OR `cargo__PubOption`.`hidden`="No" OR (`cargo__PubOption`.`hidden` IS NULL)) AND (`cargo__PubOption`.`shortdesc` IS NOT NULL) ORDER BY CONCAT(,parameter,),CONCAT( LEFT( valid, 80), IF( LENGTH( valid ) > 80, "...", "" ) ),REPLACE(`cargo__PubOption`.`default`,':',':'),CONCAT ( LEFT( shortdesc, 130), IF( LENGTH( shortdesc ) > 130, "...", "" )) LIMIT 5000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'cargo__PubOption.default' in 'field list' (127.0.0.1)

Comments or questions about this documentation? Contact us for support!