New release of STHS Web Portal - New CKEditor

Everything about the STHS Web Portal - Open Source Version / Tout ce qui touché le STHS WebPortal – Open Source
Post Reply
JimToupet
The Passion One / Le Passionné
Posts: 232
Joined: Wed Jul 02, 2014 10:55 am

New release of STHS Web Portal - New CKEditor

Post by JimToupet » Sat Jun 03, 2017 9:42 am

This release correct the issue that CKEditor is not present in the repository. This relase use the latest version of CKEditor via the editor's CDN (JavaScript version).

Correct bug from teamhistory (importing players and goalers) and playersextensionoffers (accessing goalers) tables.

You can download the full .zip file here (for new installation)

You can download only modified files for the new CKEditor here

For the PlayerType bug when accessing goalies, apply this modifications via your database management software :

Code: Select all

ALTER TABLE `playersextensionoffers` ADD COLUMN `PlayerType` varchar(10) NOT NULL DEFAULT 'player' AFTER `Type`
For the PRIMARY KEY bug when importing players/goalers, apply this modification via your database management software : PLEASE MAKE A BACKUP OF YOUR TEAMHISTORY TABLE BEFORE

Code: Select all

ALTER TABLE `teamhistory` MODIFY `ID` INT NOT NULL;
ALTER TABLE `teamhistory` DROP PRIMARY KEY; 
ALTER TABLE `teamhistory` AUTO_INCREMENT = 1;
ALTER TABLE `teamhistory` ADD `_ID` int NOT NULL AUTO_INCREMENT primary key FIRST;
ALTER TABLE `teamhistory` DROP COLUMN `ID`;
ALTER TABLE `teamhistory` CHANGE COLUMN `_ID` `ID` INT NOT NULL AUTO_INCREMENT;

User avatar
CBSHL
The Accomplished One / L'Accompli
Posts: 59
Joined: Sun Jun 19, 2011 10:44 pm

Re: New release of STHS Web Portal - New CKEditor

Post by CBSHL » Fri Jun 09, 2017 3:25 pm

TESTED AND WORKING!!

IT IS JUST LIKE A WALK IN THE PARK TAKES ABOUT 2 MINUTES.


Tested it all as I had all those bugs, and I feel you worked hard for me as it answered specifically all of our problems. I couldnt thank you enough dear JimToupet. Seriously I have spent countless hours trying to fix this and I am not a programmer of any kind (although I learned html by myself in the early internets) and was kindof running out of imagination on how to find a solution on google or elsewhere lol.

Thank you mate. if there is any way I can reward you let me know this is gold to me and made my week!

EDIT: Dont forget to truncate your tables that have accumulated wrong stats (players and goalies and also playerstats in my case)

Code: Select all

TRUNCATE TABLE `players`
TRUNCATE TABLE `goalies`
TRUNCATE TABLE `playerstats`

Schifty031
The Accomplished One / L'Accompli
Posts: 113
Joined: Wed May 10, 2017 4:20 pm

Re: New release of STHS Web Portal - New CKEditor

Post by Schifty031 » Fri Jun 09, 2017 8:12 pm

Please put a sticky on this

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

Re: New release of STHS Web Portal - New CKEditor

Post by JimToupet » Sat Jun 10, 2017 7:38 am

Truncate those tables will make lost all history unless you upload again all your file for all your seasons.
CBSHL wrote:
Fri Jun 09, 2017 3:25 pm
TESTED AND WORKING!!

IT IS JUST LIKE A WALK IN THE PARK TAKES ABOUT 2 MINUTES.


Tested it all as I had all those bugs, and I feel you worked hard for me as it answered specifically all of our problems. I couldnt thank you enough dear JimToupet. Seriously I have spent countless hours trying to fix this and I am not a programmer of any kind (although I learned html by myself in the early internets) and was kindof running out of imagination on how to find a solution on google or elsewhere lol.

Thank you mate. if there is any way I can reward you let me know this is gold to me and made my week!

EDIT: Dont forget to truncate your tables that have accumulated wrong stats (players and goalies and also playerstats in my case)

Code: Select all

TRUNCATE TABLE `players`
TRUNCATE TABLE `goalies`
TRUNCATE TABLE `playerstats`

User avatar
CBSHL
The Accomplished One / L'Accompli
Posts: 59
Joined: Sun Jun 19, 2011 10:44 pm

Re: New release of STHS Web Portal - New CKEditor

Post by CBSHL » Sat Jun 10, 2017 9:50 am

it is our first season and we had countless bugs so we'll start fresh hehe

User avatar
CBSHL
The Accomplished One / L'Accompli
Posts: 59
Joined: Sun Jun 19, 2011 10:44 pm

Re: New release of STHS Web Portal - New CKEditor

Post by CBSHL » Sun Jun 11, 2017 12:46 pm

Hi Jim, I dont know if it can be related but since I applied those fixes, I cannot update my site anymore. What I mean is that I upload every csv files, and the 2 xml needed after the sim, but it doesnt have any effect on the database as it seems. We dont see the schedule updating or the games played at all. Could it be related?? or it is a bug of its own?

Also to upload league.stc I had to create a blank file with notepad, name it leaguename.stc, upload that and then put the real file on my FTP

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

Re: New release of STHS Web Portal - New CKEditor

Post by JimToupet » Sun Jun 11, 2017 3:21 pm

I can't say that don't have any effect but I'm very doubtful. While those tables are not used in all file's import, I don't think that can be related.

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

Re: New release of STHS Web Portal - New CKEditor

Post by JimToupet » Sun Jun 11, 2017 3:38 pm

I just test it with a fresh install and I can upload and update the portal.

User avatar
CBSHL
The Accomplished One / L'Accompli
Posts: 59
Joined: Sun Jun 19, 2011 10:44 pm

Re: New release of STHS Web Portal - New CKEditor

Post by CBSHL » Sun Jun 11, 2017 6:32 pm

ok thank you i will look elsewhere. great support you rock man

Owen
The Crazy / Le Fou
Posts: 402
Joined: Tue Jan 01, 2013 12:43 pm
Contact:

Re: New release of STHS Web Portal - New CKEditor

Post by Owen » Wed Jun 14, 2017 12:35 pm

That sounds to me like your directories may have changed. Check them out in your database and also double-check your Connections/settings.php file to ensure you're pulling data from the right place.

uubeee
New in Town / Le Ptit Nouveau
Posts: 24
Joined: Tue Feb 24, 2015 12:08 pm

Re: New release of STHS Web Portal - New CKEditor

Post by uubeee » Mon Jun 19, 2017 1:05 am

Do we just replace the files or do we need to run that command on the database. Because I ran that command and got a "playertype already exists" error

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

Re: New release of STHS Web Portal - New CKEditor

Post by JimToupet » Wed Jun 21, 2017 3:04 pm

You run the command only if needed.

The first one is for the playertype error when accessing a player/goalie page

The second one is about probleme importing player's and goalie's file.

Owen
The Crazy / Le Fou
Posts: 402
Joined: Tue Jan 01, 2013 12:43 pm
Contact:

Re: New release of STHS Web Portal - New CKEditor

Post by Owen » Thu Jul 27, 2017 1:14 am

Your CKEditor update works like a champ! How can I code it to load the custom version I've uploaded to my site? I thought it'd be as simple as adding

<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/ckeditor.js"></script>

as a line instead of the ckeditor.com pull, but according to their site, there are a few directors that also need to be added.
Elite Hockey Experience

We're not just any league. We're the competitive league that you've waited years to find!
Now available en Français & auf Deutsch!
www.elitehockeysim.com

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

Re: New release of STHS Web Portal - New CKEditor

Post by JimToupet » Thu Jul 27, 2017 1:49 pm

Make sure to download all files needed and check your path.

According to standard download from CKEditor, your path should look like js/ckeditor/ckeditor.js

Post Reply