[SOLVED] How to massively change item state in mysql db

gcprnet
Topic Author
Offline
Elite Member

9 years 4 months ago - 9 years 4 months ago #55455 by gcprnet

[SOLVED] How to massively change item state in mysql db was created by gcprnet

On our site there are about 1500 articles that have the state "archived" that now need to be published. Since changing the state in backend (20 at a time takes about 20 seconds). I figured that I could change this in the MySQL database much easier:

Code:

UPDATE `prefix_content` SET `state` = '1' WHERE `state` = '2';

Can this be done like this, or is there anything els I need to be aware of?
Best Regards

Last edit: 9 years 4 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

9 years 4 months ago #55477 by ggppdk

Replied by ggppdk on topic change item state in mysql db

Hello

you can do it ,

just after doing it,
- logout from backend,
- relogin and go to FLEXIcontent dashboard (backend home page) and click to update temporary data if you are asked

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.