JAKWEB Live Support Chat, HelpDesk and Cloud Chat

Support Tickets - DB Error and Online button always red

DB Error and Online button always red

Live Chat 29.01.2016 2761 Support Status: Closed Solution: Yes mulhergorila

Hi, I can not keep the green Online button.

And I'm not able to create a new operator. (DB ERROR)

DB ErrorMessage:MySQL Query fail: INSERT INTO co_user SET departments = "1", username = "roberta", name = "Roberta", email = "roberta@mulhergorila.com", responses = "1", tw_days = "", tw_time_from = "0:0:00", tw_time_to = "0:0:00", phonenumber = "", dnotify = "1", files = "1", operatorchat = "1", operatorchatpublic = "1", operatorlist = "1", useronlinelist = "", chat_latency = "3000", sound = "1", ringing = "3", emailnot = "0", language = "", invitationmsg = "", access = "1", permissions = "ochat",password = "82b473f7eb4c1a42ff8f56266f2c530d4fb4689a078b2e0c1d3a69da5dfa1420", time = NOW()MySQL Error:Incorrect integer value: '' for column 'useronlinelist' at row 1Date:Friday, January 29, 2016 at 1:30:07 PM

Replies (3)

  • avatar Jerome

    Thank you very much for your ticket.

    We have found the bug and here is a quick fix, please open operator/template/newuser.php and find:

    <tr>
     <td><?php echo $tl["user"]["u3"];?></td>
     <td><div class="radio"><label><input type="radio" name="ls_access" value="1" checked="checked" /> <?php echo $tl["general"]["g19"];?></label></div>
     <div class="radio"><label><input type="radio" name="ls_access" value="0" /> <?php echo $tl["general"]["g18"];?></label></div></td>
     </tr>

    replace with:

    <tr>
     <td><?php echo $tl["user"]["u43"];?></td>
     <td><div class="radio"><label><input type="radio" name="ls_uolist" value="1" checked="checked" /> <?php echo $tl["general"]["g19"];?></label></div>
     <div class="radio"><label><input type="radio" name="ls_uolist" value="0" /> <?php echo $tl["general"]["g18"];?></label></div></td>
     </tr>
     <tr>
     <td><?php echo $tl["user"]["u3"];?></td>
     <td><div class="radio"><label><input type="radio" name="ls_access" value="1" checked="checked" /> <?php echo $tl["general"]["g19"];?></label></div>
     <div class="radio"><label><input type="radio" name="ls_access" value="0" /> <?php echo $tl["general"]["g18"];?></label></div></td>
     </tr>

    or download the package again from our download area and replace the file mentioned above.

    Thank you again for the report.

    29.01.2016 0
  • avatar mulhergorila

    Thank you again.

    Works fine.

    You can close ticket

    29.01.2016 0
  • avatar Jerome

    Thank you very much for the feedback.

    *** Ticket closed ***

    29.01.2016 0
Popup like demo Start Chat and Please Wait
logo

We program modern and fast web and mobile software, always responsive and mobile first! Not just great software also world class support, rated an average of 4.9 out of 5 stars! When you need support from us you will get it!

Feel free to contact us via our contact form at any time, we usually respond in less then 24 hours or start a chat conversation when we are online.

Services
About Us
Some Extra

JAKWEB © 2023 All rights reserved.