Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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:
- After updating the files and logging into your Txp back end, in your database,
SELECT * from txp_prefs WHERE name LIKE 'smtp%' - Move all
mail_enhancedvalues from thefamilycolumn to thecollectioncolumn. - Delete the
familycolumn.
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
Online
Re: Sorry early adopters: column name change
What should one do for an update of the current stable release?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
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
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 ?
Sand space – admin theme for Textpattern
Offline
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
Online
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 ?
Sand space – admin theme for Textpattern
Offline
Re: Sorry early adopters: column name change
Offline