db error?

[pclausen94]

When clicking "run recipe", I get the following error: Task Failed: Can't create table vorpcore_f5e949.whitelist (errno: 150 "Foreign key constraint is incorrectly formed") Options: { "action": "query_database", "file": "./temp/vorp_txAdminRecipe/MariaDB.sql" } Debug/Status: ["5.2.0","Windows 10","loading task query_database"]

[domx4q]

I also have a Database error (on creation), but mine is a bit different.:

[txAdmin:Deployer] Task Failed: BLOB/TEXT column 'items' can't have a default value
Options:
{
  "action": "query_database",
  "file": "./temp/vorp_txAdminRecipe/MariaDB.sql"
}
Debug/Status: ["5.2.0","Linux 4.15.0","loading task query_database"]

[AndrewR3K]

I also have a Database error (on creation), but mine is a bit different.:

[txAdmin:Deployer] Task Failed: BLOB/TEXT column 'items' can't have a default value
Options:
{
  "action": "query_database",
  "file": "./temp/vorp_txAdminRecipe/MariaDB.sql"
}
Debug/Status: ["5.2.0","Linux 4.15.0","loading task query_database"]

please ensure you have maria db installed.

[AndrewR3K]

When clicking "run recipe", I get the following error: Task Failed: Can't create table vorpcore_f5e949.whitelist (errno: 150 "Foreign key constraint is incorrectly formed") Options: { "action": "query_database", "file": "./temp/vorp_txAdminRecipe/MariaDB.sql" } Debug/Status: ["5.2.0","Windows 10","loading task query_database"]

I will look into this today.

[domx4q]

I also have a Database error (on creation), but mine is a bit different.:

[txAdmin:Deployer] Task Failed: BLOB/TEXT column 'items' can't have a default value
Options:
{
  "action": "query_database",
  "file": "./temp/vorp_txAdminRecipe/MariaDB.sql"
}
Debug/Status: ["5.2.0","Linux 4.15.0","loading task query_database"]

please ensure you have maria db installed.

I have MariaDB installed. On the first time I hadn't, but then I watched the linked YouTube Video and did it, to avoid conflicts with existing Files I completeley reinstalled it, but than the error occured multiple times. I had some problems with making MariaDB accesible over the Internet, because I run the FXServer on a V-Server and not local. But now The DB works (also tested with DataGrip).

Does the DB Version might be the Issue? I installed the latest Stable (10.11.2)

I can also ensure, that the DB connection is working, beacuse when I pass wrong credentials, It says wrong credentials.

[zWyzzzzz]

any news?

[AndrewR3K]

I tested this today with latest mariadb and it installed perfectly fine.

are you using latest mariadb install? (Not mysql)

[zWyzzzzz]

yes the last one

[jeann2013]

The solution is change this vorpv2.users for users in the file txAdminRecipe\txData\Vorpcore_FB481B.base\temp\vorp_txAdminRecipe\MariaDB.sql

[AndrewR3K]

Good catch! I totally missed that. I’ll update soon

[lebss44]

we cant start server , there is probleme in CORE ( me and 2 other membres)

[AndrewR3K]

we cant start server , there is probleme in CORE ( me and 2 other membres)

This is the wrong place to post this issue. Please post in vorp core repo, or you can join our discord more faster support.

[lebss44]

i post a message any personne answer me , me and 2 other peaple

[AndrewR3K]

i post a message any personne answer me , me and 2 other peaple

Please read my prior message.