• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Similar to previous fix.

Added missing where clause in "bboard_message_set.message_set_content"

query. Thanks to Louis Zirkel for catching this.

Fix for message-edit-3 blowing up. Tested on both PG and Oracle. Thanks

go out to Louis. - Arjun

"In digging into the code I found that there is a call to

bboard_message_clear_categories which in turn calls db_dml to call a

stored proc. This doesn't seem to work, but changing the db_dml call

to db_exec_plsql seems to have resolved the issue." -- Louis Zirkel

fixed MIME type checking for text inside oracle clob

    • -2
    • +2
    ./packages/acs-mail/tcl/acs-mail-procs.tcl

moved the time check inside the if statment for expected_arrival_time

fixed bug when all_items_p is selected, the item_id_list was not set to item_id so only the last item_id would get passed to fulfill-3.tcl. Also added a time check to make sure all parts of the time had two digits. PostgreSQL chokes if it's not formatted exactly (ie. HH:MI:SS). Created a new function called: ec_timeentrywidget_time_check to do the check.

added a proc ec_timeentrywidget_time_check to make sure that the time part of the time stamp has all of the necessary digits for HH:MM:SS. If it doesn't, postgresql complains.

fixed trig_ec_order_state_after_tr

fixed typo

    • -1
    • +1
    ./packages/cms/tcl/pagination-procs-oracle.xql
reimplemented RI triggers for live_revision and latest_revision as user triggers

cleanups, playing with cvs, hi log readers

    • -4
    • +2
    ./packages/postcard/www/add-picture-2.tcl
cleanup

removed trigger delete

fixes

    • -2
    • +2
    ./packages/postcard/www/add-picture-2.tcl
removed deleted file

- converted over to using pg lobs,

- always uses template system for content generation

- added basic double click checks to postcard sending

- added more fine grained security checks based on

a more atomic security/permission model

    • -0
    • +25
    ./contrib/obsolete-packages/postcard/www/add-picture.adp
    • -0
    • +14
    ./contrib/obsolete-packages/postcard/www/index.xql
  1. … 15 more files in changeset.
added basic permissioning and pg lob support

updated with latest file revisions, not sure about url conventions

    • -60
    • +61
    ./contrib/obsolete-packages/postcard/postcard.info
    • -60
    • +61
    ./packages/postcard/postcard.info

changed number to numeric in one of the functions

fixed bug where the order amount would not be subtracted from the gift certificate total

    • -3
    • +10
    ./packages/ecommerce/www/finalize-order.tcl

fixed to_number call that I missed

    • -2
    • +2
    ./packages/ecommerce/tcl/ecommerce-state-changes-procs-postgresql.xql

fixed more things in ACS-subsite and more site node stuff API.

    • -3
    • +13
    ./packages/acs-subsite/tcl/rel-types-procs.tcl
    • -0
    • +8
    ./packages/acs-subsite/tcl/rel-types-procs.xql
    • -2
    • +5
    ./packages/acs-tcl/tcl/site-nodes-procs.tcl

Mounted acs-workflow by default. It is confusing not to do so because

it is listed as a core package that "probably isn't meant to be mounted"

by site map, and yet it is designed to be mounted. I think that all

core packages designed to be mounted should be mounted at install time

but haven't gone through to make sure we're consistent.

acs-workflow has to be part of the core because the CR needs it.

Restored calculation of blob size (CR won't do this for us)

    • -2
    • +1
    ./packages/file-storage/www/file-oracle.xql
    • -4
    • +1
    ./packages/file-storage/www/index-oracle.xql
Added calculation of blob size (CR won't do this for us)

ported date calculations for postgresql

    • -5
    • +21
    ./packages/ecommerce/www/gift-certificate-finalize-order-postgresql.xql

fixed a few more subsite issues, and added a special case to query dispatcher.

    • -2
    • +2
    ./packages/acs-subsite/tcl/attribute-procs.tcl
    • -0
    • +13
    ./packages/acs-subsite/tcl/attribute-procs.xql
    • -30
    • +12
    ./packages/acs-subsite/tcl/rel-types-procs.tcl

set default TemplateRoot=templates/store

more cleanup of cms

    • -62
    • +122
    ./packages/cms/tcl/browser-procs.tcl
    • -85
    • +122
    ./packages/cms/tcl/clipboard-procs.tcl
    • -31
    • +52
    ./packages/cms/tcl/clipboard-ui-procs.tcl
    • -1
    • +14
    ./packages/cms/tcl/content-add-procs.tcl
    • -41
    • +43
    ./packages/cms/tcl/content-method-procs.tcl
    • -22
    • +57
    ./packages/cms/tcl/content-method-procs.xql
    • -80
    • +32
    ./packages/cms/tcl/form-procs-oracle.xql
    • -84
    • +71
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -379
    • +527
    ./packages/cms/tcl/form-procs.tcl
    • -17
    • +6
    ./packages/cms/tcl/item-procs-oracle.xql
    • -19
    • +9
    ./packages/cms/tcl/item-procs-postgresql.xql
    • -232
    • +276
    ./packages/cms/tcl/item-procs.tcl
    • -65
    • +64
    ./packages/cms/tcl/module-procs-oracle.xql
    • -106
    • +83
    ./packages/cms/tcl/module-procs-postgresql.xql
  1. … 12 more files in changeset.

updated the .info file with new acs-geo-tables files

    • -49
    • +65
    ./packages/ecommerce/ecommerce.info