search

TavstalDev / TShop2

SQL based async item and vehicle shop plugin for Unturned 3
GNU General Public License v3.0
3 stars 0 forks source link

MySQL problem. #13

Closed chewupcheech closed 2 weeks ago

chewupcheech commented 3 weeks ago

I have used both versions of Uconomy, but I constantly encounter the same error. I correctly receive rewards for kills, and my balance increases. But when I try to buy an item from the shop, the money does not charge, and the purchased item appears in the inventory. The console gives an error that you can see on the screen. Please help me solve this problem, because I really liked your plugin and would be happy to use it on my project.

error

TavstalDev commented 3 weeks ago

I have just tested with freshly downloaded tshop, uconomy and their libraries on a test server that I just created and it works.

So the issue is with Uconomy, or with the libraries. Maybe the mysql version is not compatible. Please try only use these libraries (.zip file). If the issue disappears then the problem is with libraries.

chewupcheech commented 3 weeks ago

I did everything according to your instructions, but the error still occurs. As you can see in the screenshots, I did it on a test server, without other plugins. It turns out that the problem is most likely in the version of MySQL. My version is 8.0.37 (I attached a screenshot below). So, which version should i try?

libraries plugins mysqlver logs

chewupcheech commented 3 weeks ago

I tried to test with experience mode and it works fine, but there is one problem: I can sell a vehicle only when all the seats are occupied. When I try to sell any vehicle and there are free seats, I am kicked out of the vehicle and i'm given experience for the sale. Also, for some reason, the vehicle icons are not loading, I did not touch the links. I had a similar problem with the server icons after the last game update, and I had to change the hosting for the images.

https://github.com/user-attachments/assets/e6e298a8-0a45-40fa-9ef3-ce5e7c4aad8c

TavstalDev commented 3 weeks ago

Try use MySql 8.0.39 or 8.0.38.

Could you try selling the vehicle again with the new plugin version that I just uploaded ? But this time try selling it with command too not just by UI buttons.

chewupcheech commented 2 weeks ago

Updated MySQL and same error. Tried fresh version, which you have upload yesterday. You can see the prolem with vehicles on video. Video was captured on clean test server. Selling with the command gives the same result. Later i tried to load GlobalStatistic plugin and found a conflict (you can see console errors in the screens). Due to the conflict, the sale starts to work incorrectly. The item does not disappear from the inventory, but the money for the sale is credited.

https://github.com/user-attachments/assets/f242b910-c001-494e-bd3d-eb5c18bdeb03

logs sellcommanderror sellerror