[Tiki-devel] Some issues upgrading from Tiki 26 to Tiki 27.1

Volker Wysk <post-hhF2Jplw28UoZk/[email protected]> Mon, 25 Nov 2024 20:21:11 +0100
Newsgroups gmane.comp.cms.tiki.devel
Message-ID <[email protected]>
Hi!

I've upgraded from Tiki 26 to Tiki 27.1 and it mostly worked. Some minor
issues:

1. In setup.sh, "f" and then "x" don't work. That's the default. You get
messages about composer missing later. I tried again, and did "c"/"f"/"x"
and it worked. (I should have done "b" instead.)

2. Calling tiki-check.php next doesn't work. I got this:

Fatal error: Uncaught Error: Call to undefined function
smarty_function_ticket() in /var/www/html/tiki/tiki-check.php:2990 Stack
trace: #0 {main} thrown in /var/www/html/tiki/tiki-check.php on line 2990

When calling tiki-check.php after tiki-install.php, it works.

3. In tiki-install.php, I think it was after entering the database
connection information, I got some warning messages. All in one line, I've
pulled them apart. They all start with "Warning
:20231008_fix_primary_key_issues_on_several_tables_tiki,". I've removed this
prefix here, so they better fit in this mail:

Incorrect table definition; there can be only one auto column and it must be
defined as a key on tiki_actionlog_conf table
Can't DROP 'id'; check that column/key exists on tiki_actionlog_conf table
Duplicate key name 'uk_action_obj' on tiki_actionlog_conf table
Can't DROP 'traId'; check that column/key exists on tiki_translated_objects
table
Duplicate column name 'id' on tiki_translated_objects table
Duplicate key name 'uk_type_objId' on tiki_translated_objects table
Incorrect table definition; there can be only one auto column and it must be
defined as a key on tiki_history table
Can't DROP 'user'; check that column/key exists on tiki_history table
Duplicate key name 'uk_version_pageName' on tiki_history table
Incorrect table definition; there can be only one auto column and it must be
defined as a key on tiki_untranslated table
Can't DROP 'id_2'; check that column/key exists on tiki_untranslated table
Duplicate key name 'uk_source_lang' on tiki_untranslated table"

Nevertheless, I got the message that the update of the database has worked,
and 61 SQL queries have been executed.

4. Later I got this: "Oops. You need to make sure client charset and
database encoding are forced to UTF-8. Reset the database connection to
continue.". It isn't clear to me what "Reset the database connection" means.
Add some more info?

5. After that, the installer finished. But now I get an ugly, big blue
bubble with the text "Skip to main content" at the top left of every page. I
need to inspect my module settings to fix this.

6. After this, tiki-check.php can be executed. Under "Benchmark PHP/MySQL",
when clicking "Check", I got this:

Fatal error: Uncaught mysqli_sql_exception: FUNCTION tiki.ENCODE does not
exist in /var/www/html/tiki/tiki-check.php:3949 Stack trace: 
#0 /var/www/html/tiki/tiki-check.php(3949): mysqli_query() 
#1 /var/www/html/tiki/tiki-check.php(3830): BenchmarkPhp::test_mysql() 
#2 /var/www/html/tiki/tiki-check.php(3788): BenchmarkPhp::test_benchmark()
#3 /var/www/html/tiki/tiki-check.php(2955): BenchmarkPhp::run() 
#4 {main} thrown in /var/www/html/tiki/tiki-check.php on line 3949"

Again, it was all in one line.


That's it. 

Cheers,
Volker


_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel