Oracle issue ? Cute live Support cannot start because of a null column.

Last post 06-09-2011, 11:12 AM by Ele. 2 replies.
Sort Posts: Previous Next
  •  06-06-2011, 3:11 AM 67821

    Oracle issue ? Cute live Support cannot start because of a null column.

    Hye,
     
    We are testing Cute live Support on Oracle Database.
     
    When the column "COMMENTBY" for table "CUTECHAT4_SUPPORTFEEDBACK" is null, Cute Live Support cannot start.
     
    This message appears :
    "Failed to connect to chat Service :
       ... The remote server returned an error: (500) Internal Server Error
    ..."
     
    When we add some text in the "COMMENTBY" column, Cute Live Support starts.
     
    This null column occurs when a client sends a feedback message when the support is offline.
    Have we done something wrong when we set up the database or is this a true issue ?
     
    If it is a true issue and without new version, we have to look for another chat tool.
     
     
  •  06-08-2011, 8:35 PM 67867 in reply to 67821

    Re: Oracle issue ? Cute live Support cannot start because of a null column.

    Hi Ele,
     
    Try to set a default value for the column 'COMMENTBY' of table 'CUTECHAT4_SUPPORTFEEDBACK', for example : 'Guest' 
     
    Hope it helps.
     
    Regards,
    Jeff 
     
     
  •  06-09-2011, 11:12 AM 67879 in reply to 67867

    Re: Oracle issue ? Cute live Support cannot start because of a null column.

    Hi Jeff,
     
    Thank you for your response.
     
    Sure we can set a default value, but we would like to have some code that can handle this null column.
     
    We detected this problem quite easily :) but we have absolutely no garanty that this problem will not occur with another database table.
     
    Is it planned to have a new version of Cute Live Support ?
     
    Regards,
    Ele.
     
View as RSS news feed in XML