Error Message When Selecting Linked Field

5 posts by 3 authors in: Forums > CMS Builder
Last Post: July 27, 2012   (RSS)

By benedict - July 13, 2012

Hi guys,

I have a site with a state table and a region table and an activity table.

In the activity table, when a user selects a state, it shows all the available regions for that state using this code:

SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>activity_cities`
WHERE state = '<?php echo $ESCAPED_FILTER_VALUE;?>'


This has worked for over a year. Unfortunately, when I select state in that section now, it throws the following error:

Error:
Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107

Notice: Undefined index: selectedValue in /home/jschool/public_html/cmsAdmin/lib/menus/default/actionHandler.php on line 107
<option value=''>&lt;select&gt;</option>
<option value="28" >Sydney</option>
<option value="29" >Sydney Surrounds</option>
<option value="30" >Country NSW</option>
<option value="31" >High Ctry/Snowy Mnts</option>
<option value="32" >Lord Howe Is</option>
<option value="33" >Outback</option>
<option value="34" >North Coast</option>
<option value="35" >South Coast</option>
<option value="36" >The Murray</option>
<option value="37" >Narrabri</option>
<option value="107" >Blue Mountains</option>
<option value="108" >Hunter</option>


Funny thing is, it still works once I get rid of the error, but the client has had enough of the error always popping up. I tried upgrading the CMS to the latest version, but still no luck.

Thanks in advance.

Re: [benedict] Error Message When Selecting Linked Field

By Jason - July 13, 2012

Hi,

That's an interesting problem. If you could send in a [url http://www.interactivetools.com/support] 2nd Level Support[/url] Request, we can take a closer look into this for you.

Thanks,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Error Message When Selecting Linked Field

By benedict - July 16, 2012

Thanks - for anybody else following this post in future, turns out it was a small bug in the program that they are fixing in the next release.

Cheers.

Re: [benedict] Error Message When Selecting Linked Field

By ross - July 27, 2012

Hi Benedict

That's definitely an interesting problem. Could you send through another second level support request so we can take a closer look?

Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/