Quotes and apostrophes are now ?s - Joomla! Forum - community, help and support
hi,
i migrated joomla site 1 server another. things went pretty smoothly except 2 things:
can me fix either of these issues? http://www.sitkawild.org
tia
bob
i migrated joomla site 1 server another. things went pretty smoothly except 2 things:
- quotations marks , apostrophes display question marks, and
most content centered when should left justified ( in ie 7 @ least, looks right in firefox - template: darkstar)
can me fix either of these issues? http://www.sitkawild.org
tia
bob
it looks there may have been character encoding difference when transferring.
you may able perform global search , replace on mysql database replace ? marks '
the hard part not changing valid question marks. try changing ?s misses quoted words.
in case, use kind of sql query:
i'm not sure if need escape (add \ ) ' in the sql statement, maybe.
as always, backup db or @ least content table before making changes.
more info on mysql search , replace here:
http://www.google.co.nz/search?hl=en&q=mysql+search+replace&btng=search&meta=
you may able perform global search , replace on mysql database replace ? marks '
the hard part not changing valid question marks. try changing ?s misses quoted words.
in case, use kind of sql query:
code: select all
update jos_content set introtext= replace (introtext, '?s', ''s');
update jos_content set fulltext= replace (fulltext, '?s', ''s');
i'm not sure if need escape (add \ ) ' in the sql statement, maybe.
as always, backup db or @ least content table before making changes.
more info on mysql search , replace here:
http://www.google.co.nz/search?hl=en&q=mysql+search+replace&btng=search&meta=
Comments
Post a Comment