40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Tried to update to V2 and ran into some issues

This topic contains 27 replies, has 3 voices, and was last updated by  Kiran 5 years, 1 month ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • February 19, 2019 at 6:03 pm #470079

    Jim Cibelli
    Expired Member
    Post count: 98
    This reply has been marked as private.
    February 20, 2019 at 10:05 am #470181

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    February 20, 2019 at 8:02 pm #470239

    Jim Cibelli
    Expired Member
    Post count: 98

    Do you have an email so we can activate you as an admin to the account

    February 20, 2019 at 9:10 pm #470242

    Jim Cibelli
    Expired Member
    Post count: 98
    This reply has been marked as private.
    February 21, 2019 at 1:21 pm #470333

    Kiran
    Moderator
    Post count: 7069

    Hi Jim,

    Issue has been fixed. Following fields caused issue in conversion.

    

    lat double GENERATED ALWAYS AS (post_latitude) VIRTUAL,
lon double GENERATED ALWAYS AS (post_longitude) VIRTUAL
    

    Please check and let us know.
    

    Kiran
    

		
	
    


    

			
				

    

	
    

		February 21, 2019 at 5:30 pm

		
		#470403

		
		
		
	
    


    


    

	
    

		
		
    Jim Cibelli
    Expired Member
    
		
		
     Post count: 98
    
	
    

	
    

		
		
    Ok how did you fix this did you just delete those tables in the Php my admin and if so where was the data-tables located?
    

		
	
    


    

			
				

    

	
    

		February 22, 2019 at 2:31 am

		
		#470510

		
		
		
	
    


    


    

	
    

		
		
    Kiran
    Moderator
    
		
		
     Post count: 7069
    
	
    

	
    

		
		
    Hello,
    

    The restaurant detail database table was not converted to v2 structure due to error. I have done in manually, and after that it resolved the issue.
    
I have changed data structure of the restaurant detail database table to make it compatible with v2.
    
No table has been deleted. 🙂
    

    Thanks,
    
Kiran
    

		
	
    


    

			
				

    

	
    

		February 22, 2019 at 7:43 pm

		
		#470682

		
		
		
	
    


    


    

	
    

		
		
    Jim Cibelli
    Expired Member
    
		
		
     Post count: 98
    
	
    

	
    

		
		
    Ok but how did you make the data table compatible with V2 and how did you set it up manually.
    

    I’m asking because we are probably going to be going through this process again on our main site and it would be nice to know. 
    

    Thanks,
    

		
	
    


    

			
				

    

	
    

		February 23, 2019 at 12:30 am

		
		#470723

		
		
		
	
    


    


    

	
    

		
		
    Jim Cibelli
    Expired Member
    
		
		
     Post count: 98
    
	
    

	
    

		
		
    I know ideally we would push the site from staging to live but we add listings to the live site on a daily basis meaning we have to figure out a way to copy this process again
    

		
	
    


    

			
				

    

	
    

		February 23, 2019 at 8:21 am

		
		#470752

		
		
		
	
    


    


    

	
    

		
		
    Kiran
    Moderator
    
		
		
     Post count: 7069
    
	
    

	
    

		
		
    Hello Jim,
    

    To convert data from v21 to v2 we are using this class file: https://github.com/AyeCode/geodirectory/blob/master/includes/admin/class-geodir-admin-upgrade.php
    

    To convert listing detail table structure & data it is using this function https://github.com/AyeCode/geodirectory/blob/master/includes/admin/class-geodir-admin-upgrade.php#L693
    

    During v1 to v2 conversion we have changed some columns name to use save database table space & to use it more suitable way. Ex: “post_address” field is changed to “street”, “post_city” changed to “city”, “geodir_contact” changed to “phone”, “geodir_email” changed to “email” etc.. See https://github.com/AyeCode/geodirectory/blob/master/includes/admin/class-geodir-admin-upgrade.php#L721 & https://github.com/AyeCode/geodirectory/blob/master/includes/admin/class-geodir-admin-upgrade.php#L735
    

    Please follow this if you are familiar with WordPress & GeoDirectory coding.
    

    If your staging and live site contains same data then you just have to move two tables from staging site to live site.
    
Export database tables WP_PREFIX_geodir_custom_fields & WP_PREFIX_geodir_gd_restaurant_detail from staging site database and import at your live site database. Drop those two database tables from live site before importing so it can create new structure.
    

    Thanks,
    
Kiran
    

		
	
    


    

			
				

    

	
    

		February 24, 2019 at 7:36 am

		
		#470906

		
		
		
	
    


    


    

	
    

		
		
    Jim Cibelli
    Expired Member
    
		
		
     Post count: 98
    
	
    

	
    

		
		
    Ok so basically we are going to have to manually go in and change the columns name from the old columns name like post_address to street and the data should convert properly and the listings will appear
    

		
	
    


    

			
				

    

	
    

		February 24, 2019 at 8:00 am

		
		#470907

		
		
		
	
    


    


    

	
    

		
		
    Jim Cibelli
    Expired Member
    
		
		
     Post count: 98
    
	
    

	
    

		
		
    Also have all the php webhooks changed from v1 to v2
    

		
	
    


    

			
				

    

	
    

		February 28, 2019 at 10:48 am

		
		#471628

		
		
		
	
    


    


    

	
    

		
		
    Kiran
    Moderator
    
		
		
     Post count: 7069
    
	
    

	
    

		
		
    Hello Jim,
    

    Not all but some hooks changed/added/removed to make compatible with v2. 
    

    Let us know if you want to know about particular hooks.
    

    Kiran
    

		
	
    


    

			
		
	
    • 

	
  • 

		
    Author
    

		
    

			
				Posts
			
		
    

	
    • 





			



	


		Viewing 13 posts - 16 through 28 (of 28 total)
	


	


		

	

	





		
				

			

				

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

					Open Support Ticket