Hi Torben,
After upgrading to OACS 5.9, E-Commerce package started to return the following error. PSQL version is (9.1.23)
Have you faced the same problem?
Since those are core related issues, I decided to ask first, before going to the source code and start to fix it.
Best wishes,
[02/Nov/2016:14:38:23][22527.b5237b70][-conn:evex:1-] Error: nsdbpg: result status: 7 message: ERROR: invalid input syntax for integer: "[ec_id]"
LINE 4: where package_id = '[ec_id]';
^
[02/Nov/2016:14:38:23][22527.b5237b70][-conn:evex:1-] Error: nsdbpg: result status: 7 message: ERROR: invalid input syntax for integer: "[ec_id]"
LINE 4: where apm_parameter_values.package_id = '[ec_id]'
^
[02/Nov/2016:14:38:23][22527.b5237b70][-conn:evex:1-] Error: Database operation "0or1row" failed (exception ERROR, "ERROR: invalid input syntax for integer: "[ec_id]"
LINE 4: where apm_parameter_values.package_id = '[ec_id]'
^
")
ERROR: invalid input syntax for integer: "[ec_id]"
LINE 4: where apm_parameter_values.package_id = '[ec_id]'
^
SQL:
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '[ec_id]'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'CacheRefresh'
while executing
"ns_pg_bind 0or1row nsdb0 {
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_valu..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
invoked from within
"db_exec 0or1row $db $full_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec 0or1row $db $full_name $sql]
}"
(procedure "::nsf::procs::db_string" line 27)
invoked from within
"db_string select_instance_parameter_value {} -default """
(procedure "::nsf::procs::ad_parameter_cache" line 17)
invoked from within
"ad_parameter_cache $package_id $parameter"
(procedure "::nsf::procs::parameter::get" line 30)
invoked from within
"parameter::get -localize=$localize_p -package_id $package_id -parameter $name -default $default"
(procedure "::nsf::procs::ad_parameter" line 7)
invoked from within
"ad_parameter -package_id {[ec_id]} CacheRefresh 600"
invoked from within
"ns_cache_eval {*}$max_age -- util_memoize $script {*}$script"
(procedure "util_memoize" line 5)
invoked from within
"util_memoize {ad_parameter -package_id [ec_id] CacheRefresh 600} 600"
(procedure "ec_cache_refresh_mem" line 2)
invoked from within
"ec_cache_refresh_mem"
invoked from within
"ns_cache_eval {*}$max_age -- util_memoize $script {*}$script"
(procedure "util_memoize" line 5)
invoked from within
"util_memoize {ec_cache_refresh_mem} 300"
(procedure "ec_cache_refresh" line 2)
invoked from within
"ec_cache_refresh"
(procedure "ec_url" line 2)
invoked from within
"ec_url"
("uplevel" body line 61)
invoked from within
"uplevel {
ad_page_contract {
Entry page to the ecommerce store.
@param usca_p
@param how_many
@param start_row
@author
..."
(procedure "code::tcl::/var/www/evex/packages/ecommerce/www/index" line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
invoked from within
"uplevel {
if { [file exists $__adp_stub.tcl] } {
# ensure that data source preparation procedure exists and is up-to-date
..."
(procedure "adp_prepare" line 2)
invoked from within
"adp_prepare"
invoked from within
"template::adp_parse [file rootname [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 6)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "::nsf::procs::rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file([ad_conn url]) [ad_conn file]
set ..."
called from rp_handler
GET http://192.199.241.135:8000/ecommerce/? referred by 'http://evex.co/xowiki/'; peer 192.199.241.135 user_id 0
X-Forwarded-For: 186.203.216.22
Host: 192.199.241.135:8000
Connection: close
Pragma: no-cache
Cache-Control: no-cache
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
User-Agent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36
Referer: http://evex.co/xowiki/
Accept-Encoding: gzip, deflate, sdch
Accept-Language: en-US,en;q=0.8
Cookie: user_session_id="0"; ad_session_id="40008%252c0%252c0%252c1478097449%2b%257b628%2b1478098649%2bACF045E1367800029715E5BADA2F0F3B31192F4A%257d"