Database error when edit employee and save

  • P. Swemmelaar
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 9 months ago #156779 by P. Swemmelaar
Database error when edit employee and save was created by P. Swemmelaar
When saving an employee after edit a database error occur.

Kind regards,
Peter
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156790 by omar montes
Replied by omar montes on topic Database error when edit employee and save
Hello Peter, thanks for your post, since we have a similar error, I will reply here, instead of opening a new thread.

In our case, everything was working fine before... however, after updating to version 2.19.4, we get the following error when trying to edit an employee:

     0 Incorrect integer value: '' for column `chc1_a1224z`.`ppp12_app_sch_employee`.`access` at row 1

We have tried optimizing the database, and when that didn't work, we reinstalled the update (2.19.4)... and yet, the problem is persistent.

Any guidance would be greatly appreciated, as we are attempting to integrate OScalendar with Gcalendar, and need to edit employees to accomplish this.

Thanks again and Best Regards from California,

Omar

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156792 by Mr. Dam
Replied by Mr. Dam on topic Database error when edit employee and save
Hi Omar,
Please submit ticket on category: OS Services Booking and provide your site url with super admin account. I will figure the problem for you
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • P. Swemmelaar
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 9 months ago #156795 by P. Swemmelaar
Replied by P. Swemmelaar on topic Database error when edit employee and save
Hi Dan,
This error is introduced with version 2.19.4.
You can easily reproduce it. Edit an employee and save.

Kind regards,
Peter

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156797 by Mr. Dam
Replied by Mr. Dam on topic Database error when edit employee and save
Dear @all, could you please re-download and install OS Services Booking to see whether if the issue is resolved
Thanks
Dam

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156806 by omar montes
Replied by omar montes on topic Database error when edit employee and save
Hi Dam,
thanks for your help.

will do.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156808 by Mr. Dam
Replied by Mr. Dam on topic Database error when edit employee and save
You're welcome
Dam

Please Log in or Create an account to join the conversation.

  • P. Swemmelaar
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 9 months ago #156843 by P. Swemmelaar
Replied by P. Swemmelaar on topic Database error when edit employee and save
Hi Dam,

The fix works, thank you.

Now I get a http500 error when clicking "Manage Orders". I did make another topic for this.

@Omar. Omar, do you get this error also?

Kind regards,
Peter
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #156918 by Mr. Dam
Replied by Mr. Dam on topic Database error when edit employee and save
Seems the issue has just been fixed, right?
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • P. Swemmelaar
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 9 months ago #156925 by P. Swemmelaar
Replied by P. Swemmelaar on topic Database error when edit employee and save
Hi Dam,

Yes, this issue is fixed. See the this topic: joomdonation.com/forum/os-services-booki...e-orders.html#156862

Kind regards,
Peter

Please Log in or Create an account to join the conversation.

Moderators: Mr. Dam