Jump to content
La fin ?! Elle est là ! ×
×
×
  • Create New...
  • 0

aides creation champs bdd


alexis59103
 Share

Question

  • Answers 4
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

4 answers to this question

Recommended Posts

  • 0

Je c'est pas cest pour le cmcs il me manque le champ prestige  jai une erreur sql

A Database Error Occurred

Error Number: 1054

Unknown column 'p.prestige' in 'field list'

SELECT p.guid, p.name, p.sexe, p.class, p.level, p.alignement, p.honor, p.prestige FROM personnages p LEFT JOIN accounts a ON a.level = 0 WHERE p.account = a.guid ORDER BY p.xp DESC LIMIT 20

Filename: /var/www/vhosts/dofly.free-h.net/httpdocs/libraries/AncestraR.php

Line Number: 719

Link to comment
Share on other sites

  • 0
  • Retraité

Ouvre Navicat puis double clique sur ta connection et ensuite double clique sur ancestra_game. Après ca fait un clic droit sur ancestra_game et sélectionne "Console..." puis copie la ligne suivante et fait enter.

 

ALTER TABLE personnages ADD COLUMN prestige SMALLINT(2) NOT NULL DEFAULT 0;

java style =)

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.