Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2021-03-11 14:10:47

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 10,520
Website GitHub

Sorry early adopters: column name change

Anyone who’s testing Txp 4.9.0-dev, please note that this commit introduces a column change that requires manual intervention if you’re already running 4.9.0-dev on an existing system and don’t wish to splat and repave from scratch.

There are instructions in the commit message but here they are for prosperity:

  1. After updating the files and logging into your Txp back end, in your database, SELECT * from txp_prefs WHERE name LIKE 'smtp%'
  2. Move all mail_enhanced values from the family column to the collection column.
  3. Delete the family column.

If you’re installing 4.9.0-dev on a clean slate you don’t have to do anything, it’ll just work. But if you’re updating an existing 4.9.0-dev you’ll need to make the above changes in your DB. A symptom of not doing the above is that your Admin>Prefs>Mail ‘enhanced_email’ radio button won’t toggle the prefs beneath it.

Sorry for the hassle.


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

Offline

#2 2021-03-11 18:14:37

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,724
Website GitHub Twitter

Re: Sorry early adopters: column name change

What should one do for an update of the current stable release?


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#3 2021-03-11 18:52:10

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,172
Website

Re: Sorry early adopters: column name change

colak wrote #329220:

What should one do for an update of the current stable release?

If you’re not using a dev version of 4.9.0 more recent than this commit you don’t need to do anything. From that point on a new column was added called “family” at the time, but now “collections”.

When it comes to updating the stable 4.8.4 or 4.8.5 to 4.9.0 at a later date, it will add a new “collections” column as part of the update script. Stef’s already made the change to the update script here.


TXP Builders – finely-crafted code, design and txp

Offline

#4 2021-03-12 06:26:54

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 2,474
Website

Re: Sorry early adopters: column name change

Bloke wrote #329219:

Sorry for the hassle.

Small voice: make a backup of the DB before proceeding.

It seems to have worked correctly, the 15+ years old DB appears still functional after this :-).

(The DB purist will almost certainly scream, throw me in some re-education camp in central texas and then guillotine me… Anyway, in Sequel Ace: after running the query above I added the “mail_enhanced” value to the new column by typing it. after doing this 5 or so times, i switched views (structure) to delete the “family”. done)


Where is that emoji for a solar powered submarine when you need it ?

Offline

#5 2021-03-12 09:16:55

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 10,520
Website GitHub

Re: Sorry early adopters: column name change

phiw13 wrote #329223:

It seems to have worked correctly, the 15+ years old DB appears still functional after this :-).

Yay, good to hear.

I added the “mail_enhanced” value to the new column by typing it. after doing this 5 or so times, i switched views (structure) to delete the “family”. done

I did exactly the same thing! Faster than writing a query.


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

Offline

#6 2021-03-12 10:04:55

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 2,474
Website

Re: Sorry early adopters: column name change

Bloke wrote #329226:

I did exactly the same thing! Faster than writing a query.

Great lazy minds … -)


Where is that emoji for a solar powered submarine when you need it ?

Offline

#7 2021-03-12 11:44:00

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,629
GitHub

Re: Sorry early adopters: column name change

phiw13 wrote #329227:

Great lazy minds … -)

s/lazy/efficient/g

Offline

Board footer

Powered by FluxBB