Français Solved Problèmes de champ manquant dans la DB

[TartiFlette]

Bonjour,

A chaque jour sa peine =)

Lorsque des joueurs (nouveaux) viennent sur le serveur, voici les soucis

J'ai l'impression qu'il à du mal à inscrire les joueurs dans la DB

Log DB

[19:16:56 +01:00] [Thread 9336] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[19:16:56 +01:00] [Thread 9336] extDB3: SQL: Initialized: NULL = ""
[19:16:56 +01:00] [Thread 9336] extDB3: Locked
[19:17:39 +01:00] [Thread 9373] extDB3: SQL: Error MariaDBQueryException: Unknown column 'reward_days' in 'field list'
[19:17:39 +01:00] [Thread 9373] extDB3: SQL: Error MariaDBQueryException: Input: SELECT DATEDIFF(current_timestamp(), reward_stamp) as reward_diff, reward_days FROM players WHERE pid='76561197997657578'
[19:19:39 +01:00] [Thread 9371] extDB3: SQL: Error MariaDBQueryException: Unknown column 'reward_days' in 'field list'
[19:19:39 +01:00] [Thread 9371] extDB3: SQL: Error MariaDBQueryException: Input: SELECT DATEDIFF(current_timestamp(), reward_stamp) as reward_diff, reward_days FROM players WHERE pid='76561198033684806'
[19:26:05 +01:00] [Thread 9375] extDB3: SQL: Error MariaDBQueryException: Unknown column 'reward_days' in 'field list'
[19:26:05 +01:00] [Thread 9375] extDB3: SQL: Error MariaDBQueryException: Input: SELECT DATEDIFF(current_timestamp(), reward_stamp) as reward_diff, reward_days FROM players WHERE pid='76561198033684806'
[19:26:48 +01:00] [Thread 9370] extDB3: SQL: Error MariaDBQueryException: Unknown column 'reward_days' in 'field list'
[19:26:48 +01:00] [Thread 9370] extDB3: SQL: Error MariaDBQueryException: Input: SELECT DATEDIFF(current_timestamp(), reward_stamp) as reward_diff, reward_days FROM players WHERE pid='76561198033684806'
[19:27:53 +01:00] [Thread 9375] extDB3: SQL: Error MariaDBQueryException: Unknown column 'reward_days' in 'field list'
[19:27:53 +01:00] [Thread 9375] extDB3: SQL: Error MariaDBQueryException: Input: SELECT DATEDIFF(current_timestamp(), reward_stamp) as reward_diff, reward_days FROM players WHERE pid='76561198033684806'
[19:28:50 +01:00] [Thread 9370] extDB3: SQL: Error MariaDBQueryException: Field 'reward_stamp' doesn't have a default value
[19:28:50 +01:00] [Thread 9370] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198033684806', 'Serizawa TAMAO', '0', '15000', '"[`Serizawa TAMAO`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[19:28:50 +01:00] [Thread 9373] extDB3: SQL: Error MariaDBQueryException: Field 'reward_stamp' doesn't have a default value
[19:28:50 +01:00] [Thread 9373] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('76561198033684806', 'Serizawa TAMAO', '0', '15000', '"[`Serizawa TAMAO`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
[19:28:51 +01:00] [Thread 9375] extDB3: SQL: Error MariaDBQueryException: Field 'reward_stamp' doesn't have a default value

Log serveur

19:31:46 "------------- Client Query Request -------------"
19:31:46 "QUERY: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime, jail_time FROM players WHERE pid='76561197997657578'"
19:31:46 "Time to complete: 0.000999451 (in seconds)"
19:31:46 "Result: []"
19:31:46 "------------------------------------------------"
19:31:46 "------------- Insert Query Request -------------"
19:31:46 "QUERY: SELECT pid, name FROM players WHERE pid='76561197997657578'"
19:31:46 "Time to complete: 0.000999451 (in seconds)"
19:31:46 "Result: []"
19:31:46 "------------------------------------------------"
19:31:46 "------------- Client Query Request -------------"
19:31:46 "QUERY: SELECT pid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime, jail_time FROM players WHERE pid='76561197997657578'"
19:31:46 "Time to complete: 0.000999451 (in seconds)"
19:31:46 "Result: []"
19:31:46 "------------------------------------------------"
19:31:47 "------------- Insert Query Request -------------"
19:31:47 "QUERY: SELECT pid, name FROM players WHERE pid='76561197997657578'"
19:31:47 "Time to complete: 0.000999451 (in seconds)"
19:31:47 "Result: []"

Si vous avez des idées je suis preneur

 

[TartiFlette]

Je rencontre cette erreur sur le serv Oxygen et pas en local

 

[Ziirox]

Salut,

Le problème vient probablement de colonnes manquantes dans la base de données. Il faut ajouter les colonnes reward_days et reward_stamp dans la table concernée. Assure-toi que leurs types de données correspondent aux besoins du script.

Pour reward_stamp, pense à définir une valeur par défaut ou adapte les requêtes SQL pour en fournir une. Cela devrait corriger les erreurs.

Bon courage !

 

[TartiFlette]

Merci de l'aide

Justement, pour reward_stamp de base dans mon serveur local j'ai rien

Première photo serv oxygen et seconde local

La seule différence est dans le local

Ajuster les privilèges qui est coché et qui m'est impossible à cocher sur oxygen

 

[TartiFlette]

Soucis réglé

Merci Maxence