Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2017-09-19 06:35:34

Xavez2
Member
Registered: 2017-09-19
Posts: 16

Update to 4.6.2 complete, "No articles recorded" in backend

Hi!

I’m currently seeing this in the backend of my website:

The same is true for Articles, Images, Files and Links. Categories, Sections, Pages, Forms and Styles do work.

On the front-end, everything seems to be working fine too. There are also no warnings or anything else in the diagnostics panel.

Any ideas? :O

Last edited by Xavez2 (2017-09-19 06:38:23)

Offline

#2 2017-09-19 07:37:09

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,796
Website GitHub

Re: Update to 4.6.2 complete, "No articles recorded" in backend

Hi. That is very strange. I’ve seen articles that show up on the admin side that don’t appear on the public site, but not the other way around. That’s usually caused by a database collation issue, or a NULL / 000-00-00 00:00:00 date issue.

One thing that might give us a clue is if you temporarily put your site in Debugging mode from Admin->Preferences and visit your Articles, Image, Files or Links panels. After backing up your database, you could also try looking in the textpattern table from phpMyAdmin (or equivalent) and checking that your articles generally look okay – no weird characters that might be breaking things, the collation is set the same for all columns, maybe even see if it offers you the option to ‘repair’.

Beyond that right now, I don’t know sorry. Please post the output of your low diagnostics and that might also shed a little light on the subject.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

#3 2017-09-19 08:15:04

Xavez2
Member
Registered: 2017-09-19
Posts: 16

Re: Update to 4.6.2 complete, "No articles recorded" in backend

I think this gives us a hint, unfortunately I don’t know how to solve it:

User_Error "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='"
in /home/path/to/textpattern/lib/txplib_db.php at line 409.
adminErrorHandler()
textpattern/lib/txplib_db.php:409 trigger_error()
textpattern/lib/txplib_db.php:1187 safe_query()
textpattern/include/txp_list.php:216 getThing()
textpattern/include/txp_list.php:60 list_list()
textpattern/index.php:211 include()

FYI, all tables are encoded this way:

Last edited by Xavez2 (2017-09-19 08:20:03)

Offline

#4 2017-09-19 08:35:22

phiw13
Plugin Author
From: South-Western Japan
Registered: 2004-02-27
Posts: 3,395
Website

Re: Update to 4.6.2 complete, "No articles recorded" in backend

(Wild guess)
Do you have line in your config.php that says:

$txpcfg['dbcharset'] = 'utf8mb4';

(it says @‘utf8’, try changing it)


Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg

Offline

#5 2017-09-19 08:38:48

Xavez2
Member
Registered: 2017-09-19
Posts: 16

Re: Update to 4.6.2 complete, "No articles recorded" in backend

Tried that, but it gives the same result.

What’s confusing me is that there is no problem on the front-end of my website, it’s only the back-end that’s not working correctly.

Offline

#6 2017-09-19 08:42:38

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,796
Website GitHub

Re: Update to 4.6.2 complete, "No articles recorded" in backend

Alright, that helps a lot. To fix the mix of collations, Robert has some advice on how to approach it for the Plugins panel, which is the usual place where this occurs.

Using that SQL as a template and looking at the columns in your textpatten, txp_file, txp_image and txp_link tables, you should be able to alter the commands for each table to CHANGE COLUMN for the columns that are not the same as the others. There’s likely only a handful in each table that differ so just alter those to match the remaining column collations and everything should come back to normal.

As long as you ensure the only part that changes in each column is the collation — i.e. the column types (MEDIUMTEXT, VARCHAR, INT, etc) and all other parts of the column definition remain the same — it should have no ill effects on anything. One way to ensure that is to first DESCRIBE textpattern or SHOW CREATE TABLE textpattern which will give you a rundown of the current table properties on a column-by-column basis.

I really wish I knew how this happened during upgrade so we could fix it, but it happens so sporadically that I’ve never been able to pinpoint the cause.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

#7 2017-09-19 18:04:09

Xavez2
Member
Registered: 2017-09-19
Posts: 16

Re: Update to 4.6.2 complete, "No articles recorded" in backend

Excellent, that brought everything back!

I wish I could help you more with the debugging process, but I already jumped through a bunch of hoops to get here, the upgrade to 4.6.2 wasn’t the smoothest in TXP history, that’s for sure :-).

Offline

#8 2017-09-19 18:21:57

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,796
Website GitHub

Re: Update to 4.6.2 complete, "No articles recorded" in backend

Xavez2 wrote #307096:

Excellent, that brought everything back!

Yay!.

the upgrade to 4.6.2 wasn’t the smoothest in TXP history, that’s for sure :-)

Yeah, sorry about that. For some it’s plain sailing, for others (like myself and you it seems) it’s a hassle. I expected it because I’m running an officially unsupported environment (Percona) but others I’m not sure why it happens. Partly, it was just a massive upgrade. Thousands and thousands of changes, which probably didn’t help as we couldn’t possibly test every environment. Would still love to find out why, and all I can do is apologise.

If it’s any consolation, 4.7.0 is a lot smaller in scope, but still pretty amazing so far.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

Board footer

Powered by FluxBB