TOPIC: [SOLVED] - Unable to Save Locations

[SOLVED] - Unable to Save Locations 11 years 9 months ago #20039

Spitfire
Topic Author
Offline
Fresh Boarder
Posts: 1
Thank you received: 0

I have migrated my website from J1.5 to J2.5. After migrating, I found that I could not save any new 'locations', or edit old ones from the J1.5 site.

I was able to solve this problem myself, but thought that it might be helpful to others if I posted here in case they had the same problem.

Please note that I am not sure whether I made a SQL mistake that caused the error in the first place, or if I did not follow installation instructions properly, or if there is an installation bug when J2.5 is installed over old J1.5 database tables.

The problem lay in that J2.5 version of DTRegister uses four new fields in the __dtregister_locations table that did not exist in the older J1.5 version:

lng          varchar(100)     Yes        NULL
lat          varchar(100)     Yes        NULL
user_id      int(7)           No         0
public       int(2)           No         0

I just added these fields manually in phpMyAdmin. Thereafter, DTRegister worked and I could save and edit 'locations' again.

I hope this helps someone else if they are in same situation.

Regards,
Peter

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

[SOLVED] - Unable to Save Locations 11 years 6 months ago #20501

kellerc Offline Fresh Boarder Posts: 4 Thank you received: 0	Thanks Peter! Worked like a charm! Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

[SOLVED] - Unable to Save Locations 11 years 6 months ago #20504

understandtheregister Offline Senior Boarder Posts: 40 Thank you received: 0	Appreciate the suggestion.....I'll go check but we already were running on Joomla 2.5 and things used to work fine Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

[SOLVED] - Unable to Save Locations 11 years 6 months ago #20505

understandtheregister Offline Senior Boarder Posts: 40 Thank you received: 0	I figured it out the SQL field settings and thank you! I have to say this must be related to a DTRegister upgrade, not just Joomla b/c we haven't changed our Joomla version at all. Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

[SOLVED] - Unable to Save Locations 11 years 6 months ago #20509

dthadmin Offline Administrator Posts: 5470 Thank you received: 3	This was updated in our latest release which is now available on our website. Best Regards, Rich Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

Page:
1

DT Register

General Discussion - Joomla 1.7 / 2.5

[SOLVED] - Unable to Save Locations

Time to create page: 0.490 seconds