problem trying to update

Everything about the STHS Web Portal - Open Source Version / Tout ce qui touché le STHS WebPortal – Open Source
DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 3:40 pm

Hi! when I'm trying to update my portal here what I get:

Unknown column 'o.PlayerType' in 'where clause'

Here's what I did so far : Dowloaded the last release , backup my old website and sql. Update my connection / setting file with my server info, upload everything on the server. Rather than having an install button or update button I'm getting this error message.


Any help would be greatly appreciated. We had some security issue last year and was hoping to fix that in the off-season.

Thanks,
dom

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Sun Jul 16, 2017 3:54 pm


DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 3:58 pm

yep I did! This is where I downloaded the last update. I have tried to paste the sql command and got this

Erreur
Requête SQL :


ALTER TABLE `playersextensionoffers` ADD COLUMN `PlayerType` varchar(10) NOT NULL DEFAULT 'player' AFTER `Type`
MySQL a répondu: Documentation

#1060 - Nom du champ 'PlayerType' déjà utilisé

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 4:08 pm

something I didn't say is that I trash all my previous website and tried to do a fresh install...

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Sun Jul 16, 2017 4:11 pm

As-tu vidé ta base de données?

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 5:29 pm

Ok premiere erreure que je viens de voir c'est que je loadais dcfhl.net/home. Quand je tape dcfhl.net j'arrive sur la bonne page et je peux faire upgrade de 3.2 a 3.3 et je reçois : Duplicate column name 'CommishIcon'

Si je vide les tables je peux faire Install et reçois cette erreure : Unknown column 'o.PlayerType' in 'where clause'

Si j'efface tout mes tables ça semble fonctionner :/

Je te tiens au courant et merci encore
Last edited by DCFHL Commish on Sun Jul 16, 2017 5:32 pm, edited 1 time in total.

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Sun Jul 16, 2017 5:31 pm

Vide ta base de données (effacer toutes les tables)

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 5:34 pm

oui je vais maintenant essayer de reimporter ma base de donnée dans la nouvelle

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 5:43 pm

ok si je reimporte ma base de donnée je reviens au point de depart. J'essaie d'importer mes table une a une mais je recois toujous le message que la table "players' existe déjà

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Sun Jul 16, 2017 6:06 pm

Dans ton fichier de backup, efface toute les lignes où il y a create table.

Avant garde toi une copie de ton fichier

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Sun Jul 16, 2017 9:04 pm

ok dans le fond je dois ouvrir le fichier .SQL et effacer tout les ligne create table 'players' create table 'prospects' etc?

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Mon Jul 17, 2017 9:57 am

DCFHL Commish wrote:
Sun Jul 16, 2017 9:04 pm
ok dans le fond je dois ouvrir le fichier .SQL et effacer tout les ligne create table 'players' create table 'prospects' etc?
Oui, puisque tu as réinstaller/recréer tes tables, tu ne veux que les données qui sont insérées via les commande INSERT.

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Mon Jul 17, 2017 10:03 am

ok j'essaie ca à l'instant

merci!

DCFHL Commish
New in Town / Le Ptit Nouveau
Posts: 48
Joined: Fri Apr 19, 2013 4:29 pm

Re: problem trying to update

Post by DCFHL Commish » Mon Jul 17, 2017 10:19 am

Ok voici ce que je reçois :

INSERT INTO `goaliestats` (`STAT_ID`, `Name`, `Season_ID`, `ProGP`, `ProMinPlay`, `ProW`, `ProL`, `ProOTL`, `ProShutouts`, `ProGA`, `ProSA`, `ProPim`, `ProA`, `ProPenalityShotsShots`, `ProPenalityShotsGoals`, `ProEmptyNetGoal`, `FarmGP`, `FarmMinPlay`, `FarmW`, `FarmL`, `FarmOTL`, `FarmShutouts`, `FarmGA`, `FarmSA`, `FarmPim`, `FarmA`, `FarmPenalityShotsShots`, `FarmPenalityShotsGoals`, `FarmEmptyNetGoal`, `Active`, `Number`, `ProShootout`, `ProSARebound`, `ProStartGoaler`, `ProBackupGoaler`, `ProStar1`, `ProStar2`, `ProStar3`, `ProStarPower7Days`, `ProStarPower30Days`, `ProStarPowerYear`, `FarmShootout`, `FarmSARebound`, `FarmStartGoaler`, `FarmBackupGoaler`, `FarmStar1`, `FarmStar2`, `FarmStar3`, `FarmStarPower7Days`, `FarmStarPower30Days`, `FarmStarPowerYear`, `Team`, `Retired`) VALUES
(1, 'Peter Delmas', 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1044, 0, 1, 0, 0, 1, 4, 0, 0, 0, 0, 1, 'True', 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 20, 0, 0, 0, 0, 0, 0, 12, 0),
(2, 'Mike[...]
MySQL a répondu: Documentation

Voici un printscreen:
https://www.dropbox.com/s/y569tfv7x0k6f ... 9.png?dl=0

Est-ce que je suis mieux de retourné a la version 3.2?

Merci encore de ton temps

JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

Re: problem trying to update

Post by JimToupet » Mon Jul 17, 2017 10:24 am

Non.

Envoie-moi par courriel ton fichier .sql

Post Reply