Best Of
Vanilla 2023.016 Open Source Release
2023.008 successfully built. Not tested all
1) Go "/utility/update" to update database. Like previous releases "/utility/update" return sometime 'Something wrong...' but update status is ok in config.php. So check update status and date in config.php
2) You have to add "version.json" in root folder
3) If database error during upgrade (MariaDB / Cpanel...) removing ALGORITHM = INPLACE LOCK = NONE in: applications\vanilla\settings\structure.php & library\database\class.databasestructure.php
PLEASE READ previous OSS Custom builds threads for fixing various problems.

Re: New Install and I am getting weird issues
yes, it works.
I just changed the htaccess, and it is amazing
Re: Vanilla 2.5.1 now available - security update
Is it possible to upgrade directly from version 2.5.1 (2018) to the current version (2021.009) ? or will I need to do this in stages?
Due to all sorts of work and family commitments, my forum has been neglected by me but running happily in the background without any apparent issues (another reason why I have left well alone). My account here appears to have been closed so I have re-registered now with the intent of upgrading to make things a lot more secure for one.
I'm very much an amateur so any help or guidance would be very much appreciated.

jsConnect SSO with PHP integration
I'm trying to integrate Vanilla jsConnect SSO with my php site and am confused with the process of integration. I've read the documentation several times but this part is not clear to me. Here's what I have so far:
- jsConnect settings
Authentication url: http://localhost/Website/inc/vanilla-signin.php
Sign in url: http://localhost/Website/login.php?src=vanilla
When I visit the form I get a Sign In
button and clicking on it takes my to my login page as SSO is the default login option set.
Login page
<? $clientID = "xxxxxxx"; $secret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // authenticated user here and logged him on the site $timestamp = time(); $signature = sha1($timestamp.$secret); header('location: inc/vanilla-signin.php?client_id='.$clientID.'&callback=vanillasso×tamp='.$timestamp.'&signature='.$signature); exit(); ?>
Authentication Page
<?php require_once 'functions.jsconnect.php'; require_once '../includes/connect.php'; // 1. Get your client ID and secret here. These must match those in your jsConnect settings. $clientID = "xxxxxxxx"; $secret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"; // 2. Grab the current user from your session management system or database here. if(isset($_SESSION['user'])) $signedIn = true; // 3. Fill in the user information in a way that Vanilla can understand. $user = array(); if ($signedIn) { // CHANGE THESE FOUR LINES. $user['uniqueid'] = $_SESSION['user']['id']; $user['name'] = $_SESSION['user']['name']; $user['email'] = $_SESSION['user']['email']; $user['photourl'] = SITE_URL.'img/users/'.$_SESSION['user']['profile_image']; } $secure = 'sha1'; WriteJsConnect($user, $_GET, $clientID, $secret, $secure); header('location:../forums/'); exit(); ?>
I get redirected back to forums but that Sign In button stays the same. It seems I'm not getting logged in. If I disable the redirect part in vanilla-signin.php
temporarily, I get this echo
(personal details omitted)
vanillasso({"uniqueid":"34","name":"Name","email":"[email protected]","photourl":"http:\/\/localhost\/Website\/img\/users\/photo.jpg","client_id":"xxxxxxxx","signature":"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"})
What is happening here?

Re: Setting up Sublime Text with phpcs
Microsoft VS Code
@donshakespeare May I ask what the advantages for you are, that made you change to VS Code?
Based on its reputation, I tried it, but startup time is (from my feelings) instantanious vs. 4-5 seconds (without any extensions or projects) and HDD space is 35MB vs 250MB. I nevertheless would have considered the change if there were obvious advantages, but I found none.
I have bought Sublime Text and the commercial ftp package SFTP years ago, so the price is at least for me of no importance any more. After using both with their nagging screen for quite a long while, I found that they will be really worth their price as I was using them that often.
Notepad++
Before Sublime, I was using Notepad++ and I still use it a lot as a note taking tool and for it's search(&replace) GUI. I have no grep-tool installed on my Windows machine. Notepad++ is my grep it does a hell of a job there.
phpcbf
There is another tool you have already installed, but without knowing about it: the "PHP Code Beautifier and Fixer". Its in the same path as phpcs. If you run phpcs from command line against "applications\conversations\controllers\api\MessagesApiController.php" you get this result:
FILE: ...ications\conversations\controllers\api\MessagesApiController.php ---------------------------------------------------------------------- FOUND 7 ERRORS AFFECTING 7 LINES ---------------------------------------------------------------------- 37 | ERROR | [ ] Doc comment for parameter | | $conversationMessageModel does not match actual | | variable name $conversationModel 38 | ERROR | [ ] Doc comment for parameter $conversationModel does | | not match actual variable name | | $conversationMessageModel 69 | ERROR | [ ] Doc comment short description must start with a | | capital letter 137 | ERROR | [ ] Doc comment short description must start with a | | capital letter 236 | ERROR | [x] Expected 1 space after FUNCTION keyword; 0 found 256 | ERROR | [ ] Doc comment short description must start with a | | capital letter 371 | ERROR | [x] The closing brace for the class must go on the | | next line after the body ---------------------------------------------------------------------- PHPCBF CAN FIX THE 2 MARKED SNIFF VIOLATIONS AUTOMATICALLY ----------------------------------------------------------------------
See that "PHPCBF CAN FIX THE 2 MARKED SNIFF VIOLATIONS AUTOMATICALLY" at the end? That's true! phpcbf fixes your errors automagically. Look at both errors in Sublime. Open the file and use the power of Sublimes "goto anything": hit ctrl+p and type "messapicon" or "msgapictrl" or any part of the filename you like, you will see how it works and hit the enter key to open the file.
Lines 236 and 371 are important for us, so jump to 236 by hitting ctrl+p and typing ":236" or by using the "goto line" shortcut (which opens goto anything prefilled with a colon) and entering only the line number 236, followed by enter key again. Hover over the red dot at the side and you will see this:
And that for 371:
Go to Windows command line and change to the folder where that file is saved. If you have Sublimes TabsExtra package installed, you can right click on the opened file tab and pick "Copy FilePath > Full Path". That would save yourself some work. To fix this code we have to run phpcbf which is a php file, like that (don't forget to set the coding standard=vanilla!
"c:\Program Files\php\php.exe" %userprofile%\AppData\Roaming\Composer\vendor\squizlabs\php_codesniffer\bin\phpcbf --standard=vanilla MessagesApiController.php
Sublime will notice that the file has changed and reload it, yo that you can immediately see the changes in your new favorite editor.
I do not recommend to use phpcbf on other peoples code. Use it on your own, existing, older files, to make them adhere to Vanillas standards.

Vanilla 2023.014 Open Source Release
2023.014 successfully built. Tested on php 7.4
Copied from Previous Release Notes
1) Go "/utility/update" to update database. Like previous releases "/utility/update" return sometime 'Something wrong...' but update status is ok in config.php. So check update status and date in config.php
2) You have to add "version.json" in root folder
3) If database error during upgrade (MariaDB / Cpanel...) removing ALGORITHM = INPLACE LOCK = NONE in: applications\vanilla\settings\structure.php & library\database\class.databasestructure.php
Please read previous OSS Custom builds threads for fixing various problems.
It's perfectly working on a php 7.4 install.
