My store plugin is not working

[YukikazeMua]

I integrated the store plugin into the Domination, but after I mounted the task to the server, the server couldn't use the store plugin, and when I downloaded the task file, it caused me to fail to download and get kicked off the server

[Ppgtjmad]

Hello @YukikazeMua,

I don't quite understand your issue, could you please explain more in details and provide a log file.

Thank you.

[YukikazeMua]

hi @Ppgtjmad After adding your store mod to the dominate quest, I cannot use your store plugin on my server . But I can use it on my local server

After entering the server, there is no HUD in the lower right corner, and the store can open normally, but it prompts me to refresh the data, and I cannot add money, which is always 0.

[Ppgtjmad]

What saving method are you using? Profile namespace or extDB?

Please provide me with a log file so I can have a closer look, it could be anything...

[YukikazeMua]

Ok, I've fixed the server kicking issue, but I still can't use the store plugin because it shows me money is always 0 and there's no HUD in the bottom right corner

[YukikazeMua]

I failed to obtain data using both Profile namespace and extDB. This is because my extDB log error occurred

[Ppgtjmad]

2023/02/13, 18:55:24 "extDB3: Error Failed to Connect to Database: [0,""Error Invalid Format""]"

Your extDB is not configured correctly thus not saving nor pulling data to/from your database.

I suggest you have a look at this page ->https://github.com/Ppgtjmad/SimpleShops/wiki/database

Report back with any concerns.

[YukikazeMua]

/ SAVING / savingMethod = "extDB"; extDBDatabase = "HG"; extDBProtocol = "SQL_CUSTOM"; extDBCustomFile = "custom.ini";

[YukikazeMua]

These are my Settings, and I'm using the same Settings to put your work on the server and access the database normally.but, I have multiple databases in my extdb3-conf.ini.

[Ppgtjmad]

A few things you can try:

1. Make sure you load the extDB3 that's in SimpleShops extDB3 folder
2. Open @extDB3/extdb3-conf.ini file and check your database connection informations under [HG]

[Ppgtjmad]

Or if you already have an extDB3 setup, just merge corresponding files.

[YukikazeMua]

[Domination] IP = 127.0.0.1 Port = 3306 Username = dominationdb Password = c2FGnDRRC84w8zWE Database = domination

[HG] IP = 127.0.01 Port = 3306 Username = changeme Password = changeme Database = HG

[Ppgtjmad]

I guess the username and password are the same as your [Domination] one:

[HG] IP = 127.0.01 Port = 3306 Username = dominationdb Password = c2FGnDRRC84w8zWE Database = HG

Just make sure dominationdb user has full rights on the HG database.

[YukikazeMua]

The Settings are correct, I used your mission and can access it correctly

[Ppgtjmad]

Does domination come with extDB too or not?

[YukikazeMua]

yes

[Ppgtjmad]

Just load one extDB with a single extdb3-conf.ini file with both your databases domination and HG.

Make sure you have created the HG database with the HG_SimpleShops.sql file.

Then use the same credentials for both databases in extdb3-conf.ini, same username and password for both.

SimpleShops works fine on its own and when it's implemented in many missions as per users feedback, there's likely an issue with your current extDB setup.

[YukikazeMua]

Please wait for me

[YukikazeMua]

I cleared the database after using this setting, and then Domination loaded the database, but HG did not

[Ppgtjmad]

What does the RPT say this time? Does dominationdb have full access/rights to the HG database?

[Ppgtjmad]

Alright, can you use the extDB debug version instead to see where the exact issue is?

extDB3/Optional/Debug Files but keep your extdb3-conf.ini

With the debug DLLs you'll get more infos in your extDB log files.

[Ppgtjmad]

Ok so the best thing for you to do is to open your domination database and import the HG_SimpleShops.sql file with this part REMOVED:

CREATE DATABASE IF NOT EXISTS `HG` DEFAULT CHARACTER SET utf8mb4; -- ! IMPORTANT ! --
USE `HG`; -- ! IMPORTANT ! --

Then also remove the [HG] database in extdb3-conf.ini and set extDBDatabase to "Domination" in HG_Config.h like so:

extDBDatabase = "Domination";

[YukikazeMua]

Need me to give you pbo and ini?

[Ppgtjmad]

Send what you got, also a screenshot of your database setup without any sensitive infos.

[Ppgtjmad]

You didn't do as requested, you should only have one database in the ini config file [Domination] that's it.

[22:30:55:619520 +08:00] [Thread 322692] extDB3: Input from Server: 9:ADD_DATABASE:Domination [22:31:05:614942 +08:00] [Thread 322692] extDB3: Error Invalid Format: 9:ADD_DATABASE:domination

[YukikazeMua]

Do I need to put these two together

[Ppgtjmad]

Please send me your PBO

[YukikazeMua]

Could you tell me your email address or yours discord

[Ppgtjmad]

https://discordapp.com/users/302906948028727297

[YukikazeMua]

Could you tell me your username

[Ppgtjmad]

HoverGuy#1271