Change expiration date to all places

This topic contains 7 replies, has 3 voices, and was last updated by  P O 6 years, 2 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • December 19, 2018 at 8:37 am #459276

    P O
    Expired Member
    Post count: 501

    I need to change the expiration date of all places to a new one.

    Select all, new expiration date: 25/01/2019

    How ?

    December 19, 2018 at 10:26 am #459290

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    You can try using the import/export CSV method to do bulk tasks.

    Thanks

    December 20, 2018 at 10:00 am #459420

    P O
    Expired Member
    Post count: 501

    That does not feel safe. CVS will have a different format and for sure will end in a mess.

    Unless you can please share an exact step by step on what to do, what format, how to export in in local, how to import it, avoid duplicates when importing, etc…

    Maybe a MySQL query to change all places at once?

    Thanks.

    December 20, 2018 at 10:07 am #459422

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    Thanks for your reply. I’m referring to the method here https://wpgeodirectory.com/docs/core-export/ . You should always backup everything if you’re updating a massive data.

    Thanks.

    December 20, 2018 at 10:09 am #459423

    P O
    Expired Member
    Post count: 501

    Exactly, 10 alerts telling you everything will be a mess if a comma is wrong feels not safe at all.

    Maybe a MySQL query to change all places at once?

    Thanks.

    December 20, 2018 at 1:03 pm #459443

    Kor
    Moderator
    Post count: 16516

    Hi PO,

    I’ll forward this to a developer for a second opinion.

    Thanks!

    December 20, 2018 at 5:24 pm #459493

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    BACKUP YOUR DATABASE!
    (assuming standard wp_ prefix and for places)

    

    UPDATE wp_geodir_gd_place_detail 
SET expire_date ='2019-01-25' 
WHERE expire_date != 'Never'
    

    Stiofan
    

		
	
    


    

			
				

    

	
    

		December 23, 2018 at 9:22 am

		
		#459777

		
		
		
	
    


    


    

	
    

		
		
    P O
    Expired Member
    
		
		
     Post count: 501
    
	
    

	
    

		
		
    Perfect, much better!
    

    Thank you.
    

		
	
    


    

			
		
	
    • 

	
  • 

		
    Author
    

		
    

			
				Posts
			
		
    

	
    • 





			



	


		Viewing 8 posts - 1 through 8 (of 8 total)
	


	


		
	





		
				

			

				

					
We have moved to a support ticketing system and our forums are now closed.

					Open Support Ticket
				

			

		

		
	
	


			

			


		
	


		

	

	


















	
	
			
			
			
			
                        
            
            
                
                

                    

                        20% Discount Offer
                        
                        
                    

                    

                        Hurry! Get your 20% discount before it expires.
                        Get 20% Discount