mattpayne11
Member
So, I've been pretty lazy to update my site and that's my fault; however, when I updated my site from J! 1.5 to 3.31, I noticed a problem with the way in which data is stored for the Link element in phpmyadmin.
Formerly, links had the following syntax:
Link title|-|URL
For example:
Forecast|-|http://forecast.weather.gov//MapClick.php?site=DEN&textField1=39.18721&textField2=-106.4756
Now, the syntax is like this:
{"label":"link title","link":"URL"}
For example:
{"label":"Forecast","link":"http://forecast.weather.gov//MapClick.php?site=DEN&textField1=39.18721&textField2=-106.4756"}
So, as you can see, it would seem that the only way to transition my table from J1.5 to J3.3 would be to do a few sql queries to fix the issue; however, I'm finding that the "Replace" function sql query can only help me with the first part of the string and not the last part (adding the "} to the end of the string). Any help is appreciated in solving this issue.
Formerly, links had the following syntax:
Link title|-|URL
For example:
Forecast|-|http://forecast.weather.gov//MapClick.php?site=DEN&textField1=39.18721&textField2=-106.4756
Now, the syntax is like this:
{"label":"link title","link":"URL"}
For example:
{"label":"Forecast","link":"http://forecast.weather.gov//MapClick.php?site=DEN&textField1=39.18721&textField2=-106.4756"}
So, as you can see, it would seem that the only way to transition my table from J1.5 to J3.3 would be to do a few sql queries to fix the issue; however, I'm finding that the "Replace" function sql query can only help me with the first part of the string and not the last part (adding the "} to the end of the string). Any help is appreciated in solving this issue.