Activités de "cicna"

• ABP Framework version: v7.2.2

• UI type: MVC

• DB provider: EF Core

• Tiered (MVC) or Identity Server Separated (Angular): no

• Exception message and stack trace:

• InvalidOperationException: The LINQ expression 'ROW_NUMBER() OVER(PARTITION BY a0.Id ORDER BY a0.Id ASC)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

• Steps to reproduce the issue:"

• 在EfCoreContractRepository.cs中执行这段代码后，报了上面的错误。DB：mysql 5.7.28

• In EfCoreContractRepository. Cs to execute this code, called the above error. DB：mysql 5.7.28

• `var dbContext = await GetDbContextAsync();

        var model = (await GetDbSetAsync()).Where(b => b.Id == id)
            .Select(contract => new ContractWithNavigationProperties
            {
                Contract = contract,
                Customer = dbContext.Customers.FirstOrDefault(c => c.Id == contract.CustomerId),
                Department = dbContext.Departments.FirstOrDefault(c => c.Id == contract.DepartmentId),
    			Orders = dbContext.Orders.Where(c => c.ContractId == contract.Id).ToList(),
    			Agent = dbContext.AgentAccounts.FirstOrDefault(c => c.ContractId == contract.Id)
    		}).FirstOrDefault();`
  

  

• ABP Framework version: v7.2.2
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): no
• Exception message and stack trace:
• [00:06:05 INF] Request starting HTTP/1.1 GET http://203.195.177.144:8080/api/app/orders?filterText=&orderNo=&projectName=&projectPriceMin=&projectPriceMax=&projectRemarks=&executionGenre=&auditStatus=&contractId=&customerId=&myApplyFlow=false&myApprovalFlow=false&sorting=contract.contractNo%20desc&skipCount=0&maxResultCount=10 application/json - [00:06:05 INF] Executing endpoint 'Ywz.Bms.Orders.OrdersAppService.GetListAsync (Ywz.Bms.Application)' [00:06:05 INF] Route matched with {action = "GetList", controller = "Orders", area = "", page = ""}. Executing controller action with signature System.Threading.Tasks.Task1[Volo.Abp.Application.Dtos.PagedResultDto`1[Ywz.Bms.Orders.OrderWithNavigationPropertiesDto]] GetListAsync(Ywz.Bms.Orders.GetOrdersInput) on controller Ywz.Bms.Orders.OrdersAppService (Ywz.Bms.Application).

[00:06:05 ERR] An exception occurred while iterating over the results of a query for context type 'Ywz.Bms.EntityFrameworkCore.BmsDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.IO.IOException: Unable to read data from the transport connection: Connection reset by peer. ---> System.Net.Sockets.SocketException (104): Connection reset by peer --- End of inner exception stack trace --- at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketError error, CancellationToken cancellationToken) at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.Tasks.Sources.IValueTaskSource<System.Int32>.GetResult(Int16 token) at Microsoft.Data.SqlClient.SNI.SNINetworkStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken) at Microsoft.Data.SqlClient.SNI.SslOverTdsStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken) at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](CancellationToken cancellationToken) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource

• Steps to reproduce the issue:"
• DB：mssql2022
• 

• 多个用户不停的点击“合同管理”、“订单管理”菜单，主要速度够快，就会报错。
• Multiple users keep clicking on the "contract management", "order management" menu, the main speed is fast enough, will report an error.
• 请问，这个是什么原因呢？怎么修复呢？
• Excuse me, what is the reason for this? How do you fix it?

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

• ABP Framework version: v7.0.3
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): no
• Exception message and stack trace:
• Steps to reproduce the issue:"

https://community.abp.io/posts/converting-createedit-modal-to-page-4ps5v60m Based on this article, I converted the creation pattern into a page. But the navigation properties don't show up? 1, the use of modal pop-up mode is normal display. 2. When "Create mode to page" is used, it cannot be displayed.

我根据这篇文章（将创建/编辑模式转换为页面）。 但是导航属性显示不出来？ 1、使用模态弹窗方式是正常显示。

2、当使用“创建模式转换为页面”时，显示不出来。

What should I do to display navigation properties normally? 请问需要怎么做，才能正常显示导航属性呢？

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

• ABP Framework version: v7.0.3
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): no
• Exception message and stack trace:
• Steps to reproduce the issue:"

本地调试MVC项目代码特别慢 Debugging MVC project code locally is particularly slow

使用suite新生成的MVC项目 A newly generated MVC project using suite

打开一个页面，需要的时间很长 It takes a long time to open a page

点击打开一个弹窗，每次需要30-60秒 It takes 30-60 seconds to open a pop-up window

我录制了视频，地址 I made a video. The address Debugging MVC project code locally is particularly slow

https://www.bilibili.com/video/BV1Es4y1S7QL/?share_source=copy_web&vd_source=7d5f09ee38e26b20241cf48e752f00b0

请问有解决调试慢的方案吗？ Is there any solution to slow debugging?

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

• ABP Framework version: v7.0.3
• UI type: MVC
• DB provider: EF Core
• Tiered (MVC) or Identity Server Separated (Angular): no
• Exception message and stack trace:
• Steps to reproduce the issue:"

这个*Module.cs文件，我写了自已的代码，有中文注释。 This *Module.cs file, I wrote my own code, with Chinese comments.

当我用suite生成代码时，中文注释变成了乱码，如何解决的呢？ When I use suite to generate code, Chinese comments become garbled. How do I solve this problem?

• ABP Framework version: v6.0.1

• UI type: MVC

• DB provider: EF Core

• Tiered (MVC) or Identity Server Separated (Angular): no

• Exception message and stack trace:

• Steps to reproduce the issue:"

• 1、Add Chat to the Suite's Modules

• 2、Chat is not a feature set in Features（Enable chat）

• 3、File Management, Forms modules installed, no menu appears.

• This is a bug, how do you fix it?