CB Query Dropdown field gives 404 when set up

When trying to save a new CB field using a Query Drop Down (Single Select) I get a 404 not found

86.178.207.176 - - [03/Jul/2015:17:13:41 +0100] "POST /administrator/index.php HTTP/1.1" 404 4211 " www.joctest.org.uk/administrator/index.php?option=com_comprofiler&view=editrow&table=fieldsbrowser&action=editrow&cid=90&fieldsbrowser [orderby]=ordering_asc&cbprevstate=b3B0aW9uPWNvbV9jb21wcm9maWxlciZ2aWV3PXNob3dGaWVsZA%3D%3D" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.130 Safari/537.36"

The SQL query I am trying to use is
SELECT country_name FROM j3t_comprofiler_countries order by country_name

if I remove the order by then it works, although I am sure I have managed to save it with the order by included but not a union statement I added.

This is with CB 2.0.9
CB paid subscriptions 4.0.0
CB qury field 4.0.5

I will provide screen shots in a few minutes.

Enable debug mode and maximum error reporting in Joomla global configuration during all testing so errors can expose. Your query should be as follows.

Query Value Column: country_iso_code3
Label Column: country_name
Group Column: country_region

The above should give you the most ideal/usable country dropdown. Have tested the above as working fine.

Tried the above query and setting and get the same error.

Looking at the error in the browser doing an inspect element the error shows as
jquery-migrate.js:21 JQMIGRATE: Logging is active
www.joctest.org.uk/administrator/index.php Failed to load resource: the server responded with a status of 404 (Category not found)


Having added debug etc (sorry, should have done that first...)

The call stack is


Category not found
Call stack
# Function Location
1 JApplicationCms->execute() JROOT/index.php:40
2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:251
3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:237
4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:332
6 require_once() JROOT/libraries/cms/component/helper.php:352
7 JControllerLegacy->execute() JROOT/components/com_content/content.php:16
8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:730
9 JControllerLegacy->display() JROOT/components/com_content/controller.php:79
10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:693
11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72
12 JError::raiseError() JROOT/libraries/legacy/view/category.php:129
13 JError::raise() JROOT/libraries/legacy/error/error.php:253

I have copied the profile information and database queries into the attached file

Category not found is a Joomla error. It's thrown when you try to navigate to a Joomla content page that doesn't exist or you don't have access to. It has nothing to do with the query directly. I tested the above usage so it does work; whatever issue you're having is not in relation to CB Query Field as you've no error coming from it in your latest reply. The table it's using is provided by CBSubs 4.x and its CBSubs Tax plugin. Ensure both are installed.