|
|
<p>
<div style="font-size: 76%; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; line-height: 1.3em;">
<p>If you do not have your JoomlaTags as meta keywords, you can run these SQL queries to do that, then use a 1.6/1.7-compatible tag cloud component that runs on metakeys.</p>
<p>First create a temp table:</p>
<ul>
<li>CREATE TABLE tmpcontent (cid INTEGER(11) UNSIGNED NOT NULL, metakey TEXT NOT NULL);</li>
</ul>
<p>Fill it with the metadata:</p>
<p> </p>
<ul>
<li>INSERT INTO tmpcontent SELECT c.id, GROUP_CONCAT(t.name SEPARATOR ',') FROM jos_content AS c LEFT JOIN jos_tag_term_content AS t2c ON t2c.cid=c.id LEFT JOIN jos_tag_term AS t ON t.id=t2c.tid GROUP BY c.id;</li>
</ul>
<p> </p>
<p>Have a look at the temp table to ensure info is correct:</p>
<p> </p>
<ul>
<li>SELECT * FROM tmpcontent;</li>
</ul>
<p> </p>
<p>Copy the metadata to the content:</p>
<p> </p>
<ul>
<li>UPDATE jos_content AS c, tmpcontent AS t SET c.metakey=t.metakey WHERE c.id=t.cid;</li>
</ul>
<div>Voila!</div>
<div>I recommend SP Upgrade to migrate to 1.6/1.7 (20euros was well worth avoiding the headache).</div>
<p> </p>
<p>THANK YOU TO THORSTEN (tcriess) FOR THIS FIX!!! <span style="color: #454545; line-height: normal; font-family: verdana, helvetica, sans-serif; font-size: 13px;">Check out Scientific Wave Solutions (Thorsten's site) </span><a id="yiv489367480yui_3_2_0_1_13200351898601032" style="color: #234786; text-decoration: underline; outline-width: 0px; outline-style: initial; outline-color: initial; line-height: normal; font-family: verdana, helvetica, sans-serif; font-size: 13px;" rel="nofollow" href="http://www.scientific-wave.com/" target="_blank"><span id="lw_1320066606_2" class="yshortcuts">http://www.scientific-wave.com</span></a><span style="color: #454545; line-height: normal; font-family: verdana, helvetica, sans-serif; font-size: 13px;"> and</span><a style="color: #234786; text-decoration: underline; outline-width: 0px; outline-style: initial; outline-color: initial; font-family: Arial, Helvetica, sans-serif; line-height: normal;" rel="nofollow" href="http://www.jtrackback.info/" target="_blank"><span id="lw_1320066606_3" class="yshortcuts">http://www.jtrackback.info/</span></a><span style="color: #454545; font-family: Arial, Helvetica, sans-serif; line-height: normal;"> where there is a PayPal link to make him a donation  </span></p>
</div>
</p> |
IP Logged
|
