Hello,
I took the plunge and finally had a crack at upgrading a 1.4.15 Evo site to 3.1.17 via the Migration plugin that Marc included in his Evo 1 to Evo 2 thread.
Very nice and less daunting to use a plugin to update.
FYI in case this helps anyone: the custom named manager folder in Evo 1.4.15 caused the migration to fail (couldn't even start).
I had a custom manager folder in my 1.4.15 install which caused the Migration to fail (surely the plugin should be able to handle that, but that's for another post).
Visiting my-site.com/assets/update.php returned a page that said "config file not exists".
Changing the custom manager folder name (also referenced in assets/cache/siteManager.php) back to the default "manager" enabled the update page to show and I could then update from 1.4.15 to 3.1.17.
Everything noted below is working fine in the 1.4.15 site but not in the newly updated 3.1.17 site.
Greatly appreciate any help.
After updating, I receive the following 3 parse errors in the system log. I have access to PHPMyadmin but have limited MySQL knowledge so please go easy on me ๐
1 Error 1: Parser / SQLSTATE[HY000]: General error: 1267 Ille - System Events
RESOLVED (SEE BELOW)
Seems related to evoSearch
The website started out in Modx Evolution 0.9.X and appears to have 2 different collations, no doubt applied in updates over the years.
Does anyone know the code to resolve this / correct the collations for Evo 3 (presumably changing latin1_swedish_ci to utf8_general_ci in PhpMyAdmin?)?
Parser / SQLSTATE[HY000]: General error: 1267 Ille - System Events
Event Id: 0 Source: Parser / SQLSTATE[HY000]: General error: 1267 Ille
ยซ Evolution CMS Parse Error ยป
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (SQL: select * from `modx_site_plugins` where `name` = evoSearch and `description` = 0.1 ?????? ??? ?????????? ? ?????? limit 1)
Error information
File /home/my-site/public_html/core/vendor/illuminate/database/Connection.php
Line 703
Basic info
REQUEST_URI http://my-site.com:443/manager/index.php?id=6&a=112&method=fast&action=install&cid=144&name=evoSearch&dependencies=
Manager action 112 - Execute module
Referer https://my-site.com/manager/index.php?a=112&id=6
User Agent Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0
IP (removed)
Current time 2021-10-26 06:18:12
Benchmarks
MySQL 0.0000 s (0 Requests)
PHP 6.0983 s
Total 6.0983 s
Memory 7.5773773193359 mb
2 Error 2: Parser - $this->db = new mysqli($database_ser - System Events
Issue raised at GitHub - https://github.com/evolution-cms/evolution/issues/2024
Seems related to evoCheck - I couldn't get evoCheck to work in 3.1.17. I tried deleting and reinstalling through Extra without success.
Does EvoCheck work in Evo 3?
Any ideas on how to resolve and get it working?
Parser - $this->db = new mysqli($database_ser - System Events
Event Id: 0 Source: Parser - $this->db = new mysqli($database_ser
ยซ Evolution CMS Parse Error ยป
Error : mysqli::__construct(): (28000/1045): Access denied for user 'my-site'@'localhost' (using password: NO)
Error information
ErrorType[num] WARNING[2]
File /home/my-site/public_html/assets/modules/evocheck/inc/evocheck.class.php
Line 62
Source $this->db = new mysqli($database_server, $database_user, $database_password);
Basic info
REQUEST_URI http://my-site.com:443/manager/index.php?a=112&id=10
Manager action 112 - Execute module
Referer https://my-site.com/manager/index.php?a=106&r=2
User Agent Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0
IP (removed)
Current time 2021-10-27 02:04:09
Benchmarks
MySQL 0.0000 s (0 Requests)
PHP 0.1713 s
Total 0.1713 s
Memory 11.579475402832 mb
3 Error 3: Plugin - Quick Manager+ / PHP Parse Error - System Events
RESOLVED WITH WORKAROUND USING EVO 2.02 ENGLISH LANGUAGE FILE (SEE BELOW)
Issue raised at GitHub - https://github.com/evolution-cms/evolution/issues/2023
QuickManager throws the following error relating to a missing English language file and so does not work in the frontend.
I tried reinstalling QuickManager through the Extras module without any success.
There is no language file located in the path above at:
/home/my-site/public_html/manager/includes/lang/english.inc.php
There is however a language file located at a different address at:
/public_html/manager/includes/lang/country/en_country.inc.php
Any ideas on how to resolve?
Plugin - Quick Manager+ / PHP Parse Error - System Events
Event Id: 0 Source: Plugin - Quick Manager+ / PHP Parse Error
ยซ Evolution CMS Parse Error ยป
Error : include_once(/home/my-site/public_html/manager/includes/lang/english.inc.php): failed to open stream: No such file or directory
Error information
ErrorType[num] WARNING[2]
File /home/my-site/public_html/assets/plugins/qm/qm.inc.php
Line 73
Source include_once MODX_MANAGER_PATH."includes/lang/english.inc.php";
Basic info
REQUEST_URI http://my-site.com:443/
Resource [1] Home
Referer https://my-site.com/manager/
User Agent Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0
IP (removed)
Current time 2021-10-26 22:41:34
Benchmarks
MySQL 0.0000 s (0 Requests)
PHP 0.1802 s
Total 0.1802 s
Memory 3.5851135253906 mb
4 In System Configuration > Interface & Features > Manager language : FR (the first option) is always shown even though EN English is the saved language.
RESOLVED (SEE BELOW) - I did a manual ftp update and this resolved the Configuration / TinyMCE theme saving issue
Shouldn't the saved lanaguage show in that select box?
Do other users experience this too? If so sing out and I will raise it at GitHub because seems like an incorrect behaviour.
5 In Elements > Templates / Template Variables / Chunks / Snippets and Plugins, many items are not listed in the main RHS area.
In the LHS tree on the other hand (via the ElementsInTree plugin), all elements show as expected and can be accessed.
RESOLVED (SEE BELOW) - BarnsleyBloke
See screencap showing the differences.
Have other users experienced this?
Anyone know how to show all elements as expected?
6 Modules > Extras (with heading Package Management 0.1.3) shows the new graphics but a green install button for all items, regardless of whether an element is installed.
Issue raised at GitHub - https://github.com/evolution-cms/evolution/issues/2026
See screencap below (DocInfo, DocLister and evoSearch are installed)
In Evo 1.4.15 Extras elements that are installed show a Blue button for installed items (with either Reset or Update) so it's easy to see what is installed and what needs updating.
I tried reinstalling in 3.1.17, no difference.
Do other users experience this in Evo 3's Extras too?
Am I missing something here?
7 The website Header (Logo / Menu / Hamburger Menu Toggle / Search / Social Icons) in the front end shows as expected on the home page.
It doesn't show at all on about 90% of other pages and haven't experienced this at all / ever in 1.4.15.
RESOLVED (SEE BELOW)
Any ideas on how to resolve in Evo 3?
Chunk code is shown below fyi:
{{promobox}}
<!-- header -->
<header class="C-R" role="banner">
<div class="wrapper clearfix">
<div class="logo"><a href="[~1~]" title="[(site_name)]" class="th"><img src="/equity/images/logo-placeholder.png" alt="[(site_name)] logo" /><span>[(site_name)]</span></a></div>
<div id="navhider" class="burger-box toggler" data-toggle="nav">
<button class="burger squeeze no-fries" type="button" role="button" aria-label="Menu" aria-controls="navigation" title="toggle menu">
<div class="bun"><div class="patty"></div></div>
</button>
</div>
<div class="empty"></div>
</div>
</header>
<!-- end header -->
<!-- nav -->
<nav id="primary" role="navigation">
<div class="wrapper clearfix">
<div class="logo"><a href="[~1~]" title="[(site_name)]" class="th"><img src="/equity/images/logo-placeholder.png" alt="[(site_name)] logo" /><span>[(site_name)]</span></a></div>
{{main-menu}}
{{search-form}}
</div>
</nav>
<!-- nav -->
8 EvoSearch appears to be working fine in Evo 3 but shows a couple of parameters in the front end per below.
I tried reinstalling evoSearch through the Extras module without any success.
Related to this unresolved issue at GitHub - https://github.com/evolution-cms/evolution/issues/1978
RESOLVED WITH WORKAROUND Thanks to @BarnsleyBloke's RemoveChunks plugin https://github.com/BBloke/RemoveChunks
a. The search form shows the parameter [+stat_request+] instead of the expected placeholder text "Search here..."
The form chunk is like this...
<div class="srchbx">
<form action="[~5~]" role="search" method="get">
<input type="submit" name="sub" title="Click to Search" value="" />
<div><input type="text" name="search" title="Enter Search Terms" placeholder="Search here..." value="[+stat_request+]" required /></div>
</form>
</div>
If I delete that [+stat_request+] text I see the placeholder text "Search here..." and then I can enter the search terms and the search works as expected.
Any ideas on how to resolve in 3.1.17?
b. The empty search results page shows the [+pages+] parameter.
In the frontend is the evoSearch snippet call in a chunk called {{search}} with the following content...
<section class="posts" role="complementary">
[!evoSearch?
&display=`5`
&addLikeSearchType=`oneword`
&addLikeSearchLength=`2`
&minlength=`2`
&extract=`0`
&ownerTPL=`@CODE:[+dl.wrap+]`
&tpl=`search-row`
&statTpl=`<p>[+stat_total+] results found for "<span class="evoSearch_highlight">[+stat_request+]</span>"</p>`
&noResult=`<p>There were no results for "<span class="evoSearch_highlight">[+stat_request+]</span>". Please try a different term.</p>`
{{dl-pagination}}
&sortBy=`pagetitle`
&sortDir=`ASC`
&tvPrefix=``
&tvList=`banner`
&filters=`AND(
content:c.template:notin:6,7,8,23,25,26,27,28;
content:c.id:notin:5,6,7,8,88;
)`
!]
</section>
[+pages+]
In Evo 1.4.15 the empty search results page shows nothing where the chunk call is (which is nice) where as in 3.1.17 it shows - [+pages+]
Any ideas on how to resolve in 3.1.17?
Original post edited to include 9 below...
In a new issue also posted also posted here for relevance...
9 I get the following error when trying to log into the FormLister front end login form. I think perhaps the error is because web users and manager users have been merged into the one group in Evo 3 and &userGroups=WebUsers
is likely no longer correct usage.
RESOLVED Thanks to @BarnsleyBloke's incredible and patient help.
Basically Evo 3.1.17 is not ready for front end web user login without hacking files in Evo 3's core folder.
It was challenging to get working. Based on my experience I would advise anyone that has an Evo 1.4.x (or possibly Evo 2.0.x but I have never used it so unsure) website where front end web users login to access secure content NOT to update to Evo 3 until the devs build in native support for web user login. Or unless you are super technical and comfortable running "composer" and hacking the core files.
Parser / SQLSTATE[42S02]: Base table or view not f - System Events
Event Id: 0 Source: Parser / SQLSTATE[42S02]: Base table or view not f
ยซ Evolution CMS Parse Error ยป
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my-table.modx_web_user_attributes' doesn't exist
Basic info
REQUEST_URI http://my-site.com:443/demos/my-account/login
Resource [38] Login
Referer https://my-site.com/demos/my-account/login
In my Formlister login forms I have the following parameters - does anyone know what I need to change these to so that the login form works in Evo 3.1.17
[!FormLister?
&controller=`Login`
&context=`web`
&userGroups=`WebUsers`
etc
Many thanks.
I am looking forward to keep playing with Evo 3. Many thanks in advance for any help.