Categories
Database Development

row lock cause dead lock in MySQL 5.7

Today my app tell me encount a dead lock, error like this: rror querying database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction 2020-09-25T02:10:41.962926578Z ### The error may exist in class path resource [mybatis/mapper/room/RoomSeatCustomMapper.xml] 2020-09-25T02:10:41.962930571Z ### The error may involve com.sportswin.soa.room.dao.RoomSeatCustomMapper.updateForFreeSeat-Inline 2020-09-25T02:10:41.962934646Z ### The error occurred while setting parameters 2020-09-25T02:10:41.96294191Z ### […]

Categories
Apple User Help

How can I backup, sort, and listen to all of my iPhone Voice Message on my MacBook?

I have many recordings of birds as Voice Memos on my iPhone 6 with iOS 12.4.5 and I am trying to synch to my new MacBook macOS 10.15.6 using iTunes (which is now called Music?) If I connect my iPhone to my new laptop then click the iPhone icon in Music it shows me an […]

Categories
Linux Mastering Development

Implementing Sort URLs Regex Using Unix Commands

I am a newbie to regular expressions as they manifest in things such as sed, awk, sort, grep and other Unix binaries. I know that if I sort a list of URLs in my text editor (BBEdit) using this regular expression: (https?)://([a-z0-9]+[.])*(.+?)[.](.+?)/(.*)$ \3\t\4\t\2\t\5\t\1 It produces the end result I desire. I’d like to sort this […]

Categories
Linux Mastering Development

Implementing Sort URLs Regex Using Unix Commands

I am a newbie to regular expressions as they manifest in things such as sed, awk, sort, grep and other Unix binaries. I know that if I sort a list of URLs in my text editor (BBEdit) using this regular expression: (https?)://([a-z0-9]+[.])*(.+?)[.](.+?)/(.*)$ \3\t\4\t\2\t\5\t\1 It produces the end result I desire. I’d like to sort this […]

Stored procedure returns nullable DateTime instead of a varchar

I have a problem where I have defined a column as a varchar in the stored procedure but yet when I add it to my C# program, EntityFramework uses the original field type of DateTime nullable. I am think the problem could be in the second select statement since I use the same field name […]

Categories
Mastering Development

.NET Core MVC: How in to send an Object In an Object?

Good for all 🙂 I want to easily submit a model for data filtering. For quick sorting, I wrote tags by which the data will be sorted… When I click on the link, the address bar becomes like this -> "&FilterData=Project.Web.Models.FilterData" localhost/User?PageNum=1&SortOrder=NameAsc&FilterData=Project.Web.Models.FilterData <a href="@Url.Action("Index", "User", new FilterRequest(filter, sort, pagination))"> First Name </a> Here is the […]

Categories
Mastering Development

Unsorted Big Data to Train Keras LSTM

I have a dataset I’m working on that is about 2TB in the following form: id | timestamp | cat1 | cat2 | cat3 | … | label | bin1 ——————————————————————- 1 | 04-21-2020 00:12:23 | a | xo | kkl | … | call | 0 1 | 04-21-2020 00:12:31 | b | kk […]

Categories
Mastering Development

Ag Grid server side data source reset request

Using ag-grid server side data source for data fetching. I’m trying to reset filter, sort, pivot and other actions applied to the grid on button click. How to reset params.request in getRows method of the server side data source? I have tried to search through the documentation, but didn’t find any solution regarding this. Is […]

Categories
CMS Magento Mastering Development

How to Get More Image when Click on Load More Button?

im uses Instagram Feed Mageplaza Extension, i do some customization in this extension, i add new button “Load More” from front-end where instagram images are display,also im code a custom jquery to load more images but its not work, Here is Instagram.phtml file code, in this file i add Load More… Button n HTML, and […]

Categories
Mastering Development

I am working on a multi sortable app, with two sortable sections but having difficulties to make some elements sortable

Okay. So this is how it goes.. I have made four sortable columns (with a class name .sort), which has elements that can be sorted (with a class name .sortable) than inside .sortable I have placed elements (with a class name .sort-sortable). So I can drag/drop “.sort-sortable” inside “.sortable” and do the same with “.sortable” […]