Active Agenda Community

[robbie-w]

Getting an error when trying to modify a code item (i.e. changing the name of an organisations departments "function")

GET: Array
(
[mdl] => codt
[smd] => cod
[rid] => 4
[grw] => 10
[action] => save
)

backtrace:
(1) function trigger_error, file e:\sites\activeagenda\s2a\lib\includes\general_util.php, line 575
(2) function mdb2errorcheck, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 559
(3) function _saverdc, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 526
(4) function _savecaches, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 983
(5) function _save, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 1111
(6) function saverow, file e:\sites\activeagenda\s2a\lib\classes\grids.php, line 1468
(7) function handleform, file E:\sites\activeagenda\s2a\active_agenda\web\rpc\EditGridRPC.php, line 105

- - - - -

An error of type AA Error (# 256) happened to Janet Hemmant (ID 2, IP 172.16.0.102) at Wed, 5 Mar 2008 14:19:27 +0000.
Module 'codt',Record '4', File e:\sites\activeagenda\s2a\lib\includes\general_util.php, line 575:
_doquery: [Error message: Could not execute statement]
[Last executed query: SELECT `sur`.SurveyID
FROM `sur`

LEFT OUTER JOIN `cod` AS cod1
ON (`sur`.SurveyScaleTitleID = `cod1`.CodeID
AND `cod1`.CodeTypeID = '12')
WHERE `sur`._Deleted = 0
AND `cod1`._Deleted = 0
AND `cod1`.CodeID = '10'
]
[Native code: 1054]
[Native message: Unknown column 'sur.SurveyScaleTitleID' in 'on clause']

[robbie-w]

Above error was using quick edit

This error was using full edit

backtrace:
(1) function join, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 561
(2) function _saverdc, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 526
(3) function _savecaches, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 983
(4) function _save, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 1111
(5) function saverow, file e:\sites\activeagenda\s2a\active_agenda\.generated\cod\cod_EditCodeEdit.gen, line 203
(6) function include, file E:\sites\activeagenda\s2a\active_agenda\web\edit.php, line 86

- - - - -

An error of type AA Error (# 256) happened to Robbie Wallis (ID 1, IP 172.16.142.143) at Wed, 5 Mar 2008 14:55:32 +0000.
Module 'cod',Record '10',ScreenName 'CodeEdit', File e:\sites\activeagenda\s2a\lib\includes\general_util.php, line 575:
_doquery: [Error message: Could not execute statement]
[Last executed query: SELECT RecordID FROM `rdc` WHERE ModuleID = 'surr' AND RecordID IN ()]
[Native code: 1064]
[Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]


GET: Array
(
[mdl] => cod
[rid] => 10
)

backtrace:
(1) function trigger_error, file e:\sites\activeagenda\s2a\lib\includes\general_util.php, line 575
(2) function mdb2errorcheck, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 572
(3) function _saverdc, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 526
(4) function _savecaches, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 983
(5) function _save, file e:\sites\activeagenda\s2a\lib\classes\data_handler.class.php, line 1111
(6) function saverow, file e:\sites\activeagenda\s2a\active_agenda\.generated\cod\cod_EditCodeEdit.gen, line 203
(7) function include, file E:\sites\activeagenda\s2a\active_agenda\web\edit.php, line 86

- - - - -

[mattias]

Hi Robbie,

It looks like your record description cache triggers are out of sync. Try regenerating all your modules, by using the command:

[robbie-w]

thanks will try!

[robbie-w]

That worked

Thanks

Robbie