• Problèmes BDD


    Version :: 4.4

    Screenshot(s) :: Coller l

    Logs :: Copier coller votre historique de logs ici

    Bonjour,

    Quelqu’un pourrait m’aider concernant mes problèmes de base de données dont un identifié qui la non sauvegarde des véhicules dans le garage,

    Voici les logs BDD:

    http://pastebin.com/PJuXdty6

    Voici les Logs Rpt:

    http://pastebin.com/BjiP6Nng

    Merci,

  • J’ai tenté de mettre la BDD fournie par Tonic et j’ai toujours le même problème.

    Impossible de trouver les véhicules qui sont mis au garage.

    extDB2: Version: 66  
    extDB2: https://github.com/Torndeco/extDB2  
    extDB2: Windows Version  
    Message: All development for extDB2 is done on a Linux Dedicated Server  
    Message: If you would like to Donate to extDB2 Development  
    Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2  
    Message: Also leave a message if there is any particular feature you would like to see added.  
    Message: Thanks for all the people that have donated.  
    Message: Torndeco: 20/02/15  
    
    extDB2: Found extdb-conf.ini  
    extDB2: Detected 8 Cores, Setting up 6 Worker Threads  
    
    [18:32:40:217689 +02:00] [Thread 2600] extDB2: Database Type: MySQL  
    [18:32:40:229690 +02:00] [Thread 2600] extDB2: Database Session Pool Started  
    [18:32:40:229690 +02:00] [Thread 2600] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True  
    [18:32:40:240691 +02:00] [Thread 2708] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist	[mysql_stmt_errno]: 1449	[mysql_stmt_sqlstate]: HY000	[statemnt]: CALL resetLifeVehicles  
    [18:32:40:240691 +02:00] [Thread 2708] extDB2: SQL_RAW_V2: Error StatementException: SQL: CALL resetLifeVehicles  
    [18:32:40:251691 +02:00] [Thread 2656] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist	[mysql_stmt_errno]: 1449	[mysql_stmt_sqlstate]: HY000	[statemnt]: CALL deleteOldHouses  
    [18:32:40:251691 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist	[mysql_stmt_errno]: 1449	[mysql_stmt_sqlstate]: HY000	[statemnt]: CALL deleteDeadVehicles  
    [18:32:40:251691 +02:00] [Thread 2656] extDB2: SQL_RAW_V2: Error StatementException: SQL: CALL deleteOldHouses  
    [18:32:40:251691 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: SQL: CALL deleteDeadVehicles  
    [18:32:40:252691 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error	[mysql_stmt_error]: The user specified as a definer ('arma3'@'localhost') does not exist	[mysql_stmt_errno]: 1449	[mysql_stmt_sqlstate]: HY000	[statemnt]: CALL deleteOldGangs  
    [18:32:40:252691 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: SQL: CALL deleteOldGangs  
    [18:32:40:437702 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Table 'tanoalife.ah' doesn't exist	[mysql_stmt_errno]: 1146	[mysql_stmt_sqlstate]: 42S02	[statemnt]: SELECT count(*) FROM ah  
    [18:32:40:437702 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT count(*) FROM ah  
    [18:32:40:438702 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<null>' at line 1	[mysql_stmt_errno]: 1064	[mysql_stmt_sqlstate]: 42000	[statemnt]: SELECT id, type, amount, item, price, seller, sellername, status, time FROM ah LIMIT <null>  
    [18:32:40:438702 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, type, amount, item, price, seller, sellername, status, time FROM ah LIMIT <null>  
    [18:35:33:787617 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'impound' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear, fuel) VALUES ('civ', 'B_Quadbike_01_F', 'Car', '76561197988063814', '1','1','"[[],0]"', '2', '423593', '0', '"[]"','1')  
    [18:35:33:787617 +02:00] [Thread 1936] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, impound, gear, fuel) VALUES ('civ', 'B_Quadbike_01_F', 'Car', '76561197988063814', '1','1','"[[],0]"', '2', '423593', '0', '"[]"','1')  
    [18:35:37:307818 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'impound' in 'field list'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: UPDATE vehicles SET active='0',impound='0', inventory='"[[],0]"', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561197988063814' AND plate='423593'  
    [18:35:37:307818 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE vehicles SET active='0',impound='0', inventory='"[[],0]"', gear='"[[[],[]],[[],[]],[[],[]],[[],[]]]"', fuel='1' WHERE pid='76561197988063814' AND plate='423593'  
    [18:35:40:901024 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error	[mysql_stmt_error]: Unknown column 'impound' in 'where clause'	[mysql_stmt_errno]: 1054	[mysql_stmt_sqlstate]: 42S22	[statemnt]: SELECT id, side, classname, type, pid, alive, active, plate, color, gear, fuel  FROM vehicles WHERE pid='76561197988063814' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'  
    [18:35:40:901024 +02:00] [Thread 2948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT id, side, classname, type, pid, alive, active, plate, color, gear, fuel  FROM vehicles WHERE pid='76561197988063814' AND alive='1' AND active='0' AND impound='0' AND side='civ' AND type='Car'  
    
  • @GiJoe_83

    Il est évident que tu n’as pas la bonne db.

     Unknown column 'impound' in 'field list'  
    
  • Salut,

    Je n’ai pas pu te répondre avant, merci en tout cas

    Mais que dois je faire pour trouver la bonne @harmdhast ?

    Tu me donnes que des débuts de piste lol

  • @GiJoe_83

    Je ne me rapelle pas d’une colonne impound tu as du installer un truc sur ton serveur.

    Réinstalle une autre mission au propre si c’était une mission vide sinon il va falloir créer correctement la colonne dans la table appropriée.

  • The user specified as a definer (‘arma3’@‘localhost’) does not exist

    pense a faire ton user arma 3

Messages 6Vues 869
Se connecter pour répondre