[blueyed: split this from another thread]
I had the same error and the code in three steps you gave solved it (thank you very much! )
But then I had this other error message (which didn't prevent me from using my blog though) :
Installation des tables b2evolution avec des données d'exemple
Creating default blacklist entries...
Une erreur inattendue est survenue!Si cette erreur persiste, merci de la signaler à l'administrateur.
Retourner à la page d'accueil
Informations additionnelles à propos de cette erreur:MySQL error!
Duplicate entry 'penis-enlargement' for key 2(Errno=1062)
Your query:
INSERT INTO evo_antispam(aspm_string)
VALUES ('penis-enlargement'), ('online-casino'), ('order-viagra'), ('order-phentermine'), ('order-xenical'), ('order-prophecia'), ('sexy-lingerie'), ('-porn-'), ('-adult-'), ('-tits-'), ('buy-phentermine'), ('order-cheap-pills'), ('buy-xenadrine'), ('xxx'), ('paris-hilton'), ('parishilton'), ('camgirls'), ('adult-models')
:D
pyogazel, how about a new thread about it? (I've split it)
It seems like you had an error before and the re-ran the install script. Therefor it now tries to insert the default antispam data a second time.
Try a clean install (if you're installing and not upgrading) by removing the existing tables first.