WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm quite happy with the results and i think the template is subtly cleaner and mo' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('having a stable server for the last few days has allowed me to finish the site design work i wanted to do over christmas. i'm quite happy with the results and i think the template is subtly cleaner and more efficient, and the navigation links have been improved considerably, and i've already seen the benefits in site usage. i'm quite happy with the result and now i can concentrate on posting and building up blog and forum traffic in 2007. some of the changes aren't that obvious, but here's a full list of the ones i can remember doing: <h3>new features/general</h3> <ul> <li>i've created a <strong><a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/">new forum</a></strong>. although there haven't been a lot of registrations so far, a lot of interesting and useful information has already been listed. if you haven't checked out the forum yet, then i'd recommend giving it a go</li> <li>made changes to how comments get posted on blog, which has totally eliminated all <strong><a target="_blank" title="no comment spam" href="http://www.connectedinternet.co.uk/2007/01/01/1263/">comment spam without a plugin</a></strong></li> <!--more--> <li><strong>replaced the wordpress search engine with google search</strong>: it seems to be much better at finding results, and it has definitely encouraged more readers to search my site for posts</li> </ul> <h3>navigation improvements</h3> <ul> <li><strong>header navigation:</strong> added a new header with important navigation links, including a vital subscribe link. i've also added a similar set of links at the bottom of the sidebar</li> <li><strong>reduced the number of categories and merged a lot of my utw tags</strong> to make navigation simplier</li> <li><strong>reduced the length of the sidebar by using tabbed navigation</strong>. this has allowed me to group similar types of links to make it easier for users to follow, whilst at the same time making all options available to users and highlighting the ones i think are the most useful</li> <li><strong>added tabbed navigation at the bottom of my posts</strong>. this has gone a long way to reduce the 'noise' that was there previously, making it clearer to users what they can do next. i've also incorporated a search box so that users can search my site for more posts once they've finished reading mine, or the whole internet within my site without having to leave</li> <li><strong>added '<a title="share this plugin" href="http://www.connectedinternet.co.uk/2006/12/17/1193/">share this'</a> to my posts</strong> so that my social bookmarking links are nice and tidy</li> <li><strong>combined my skyscraper ad and <a title="vizu poll" href="http://www.connectedinternet.co.uk/2006/11/29/1119/">vizu poll</a> to save space</strong> in my sidebar</li> <li>added smaller mybloglog images</li> <li>removed snap preview as it was getting annoying</li> <li><strong>tidied up my trackbacks and pingbacks</strong> so that only the title and site name are shown, and no more massive excerpts</li> </ul> <h3>seo/revenue optimisation</h3> <ul> <li><strong>improved my meta tags</strong>: i've done more work on these since making <a title="guide to meta tags" href="http://www.connectedinternet.co.uk/2006/12/22/1223/">this post,</a> so if you want to learn more leave a post in the forum</li> <li><strong>added a new adsense link ad to my tabbed navigation boxes</strong>, and the performance has startled me. in the past i've had no joy with link ads, but my current <strong>link ad is now my second best performing unit</strong></li> <li>added more adsense channels so that i can better track which ads are doing well, as well as adding more adsense <a title="section targetting" href="http://www.connectedinternet.co.uk/2005/12/13/677/">section targeting</a> to my pages</li> <li><strong>i've added my site to dozens of directories.</strong> i didn't believe this was a good use of my time, so i paid $5 for someone to add me to 60 p5 and p6 directories. i've also rejoined <a target="_blank" title="blogtopsites" href="http://www.blogtopsites.com/internet/">blogtopsites</a> and at the time of writing i'm #2, which is nice</li> </ul> <h3>plugins</h3> <ul> <li>even though i've got a shiny new server, i've still made an effort to reduce the number of plugins i'm using, especially the very intensive ones. i've managed to <strong><a target="_blank" title="reducing plugins" href="http://www.connectedinternet.co.uk/2006/12/23/1231/">reduce the number of plugins i use from 35</a></strong> to 28, despite adding a few new ones this week (<a title="all my plugins" href="http://www.connectedinternet.co.uk/about/plugins-i-use/">full list here</a>):</li> </ul> <ol> <li><strong><a title="visit plugin homepage" href="http://blog.taragana.com/index.php/archive/angsumans-translator-plugin-pro-for-wordpress-blogs-released/">angsuman’s translator plugin pro</a> plugin:</strong> despite having <a title="wordpress plugins not to install" href="http://www.connectedinternet.co.uk/2006/12/01/1125/">problems initially with this plugin</a>, i gave angsuman admin access to my site and he very quickly found the problem. his tweaks were so good in fact, that the translated pages actually load faster than the real pages! you can try out the plugin by clicking on any of the flags at the top of the sidebar. the real beauty of this plugin is that the translated pages will appear on non-english search engines, which will increase my site traffic</li> <li><strong><a title="visit plugin homepage" href="http://www.alinks.org/">alinks</a> plugin:</strong> together with my<a title="shoplinc alinks module" href="http://www.connectedinternet.co.uk/2006/12/19/1208/"> chitika shoplinc module</a> i've been able to add shopping links very quickly throughout my site which has added a nice new revenue stream (4th behind adsense, feedburner and text-link-ads). i expect this to grow as i write about newer products in 2007</li> <li><strong><a title="visit plugin homepage" href="http://www.jameskelly.org/wordpress-plugins/custom-login-and-registration-forms-plugin/">themed login and register</a> plugin:</strong> this plugin has allowed me to theme my login pages and to control what pages and content users see when they login/register/logout</li> <li><strong><a title="visit plugin homepage" href="http://inner.geek.nz/wordpress-plugins/smart-unread-comments/">smart unread comments</a> plugin: </strong>i've created a <a title="updates page" href="http://www.connectedinternet.co.uk/manage/">new updates page</a> which is listed in my new header nav, which lists shows the latest posts and other useful info. what it also does thanks to the smart unread comments plugin is show you what comments have been left since your last visit (it uses a cookie). thanks to the themed login plugin this page is now the first page that users will see when they login, which will provide them a quick snapshot of what has happened since they last visited</li> <li><strong><a title="visit plugin homepage" href="http://rawlinson.us/blog/?p=212">feed list</a> plugin:</strong> this plugin has allowed me to add a new section 'forum posts' in the sidebar which shows the last 10 posts from the <a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/">new forum</a>. if you haven't checked out the forum yet, then i'd recommend giving it a go</li> <li><strong><a rel="lightbox" title="visit plugin homepage" href="http://www.thunderguy.com/semicolon/wordpress/less-wordpress-plugin/">less</a> plugin</strong>: ajay will probably say as usual that i can acheive this effect without a plugin. what the less plugin does is force '(more…)' links from the homepage to go to the top of the article, rather than to the part after the '(more…)'. i think this makes articles easier to read, as well as ensuring that readers see my best performing ad unit</li> <li><strong><a title="visit plugin homepage" href="http://unknowngenius.com/blog/wordpress/spam-karma/">spam karma 2</a> plugin:</strong> the best spam handling plugin in my view. although i've eliminated my comment spam problem, it's nice to have sk2 as a backup (and the <a title="math comment spam plugin" href="http://www.connectedinternet.co.uk/2006/12/14/1178/">math comment spam plugin</a> for non-registered users) and it is also catching all my trackback spam</li> <li><strong><a title="visit plugin homepage" href="http://www.jonas.rabbe.com/archives/2005/05/08/super-archives-plugin-for-wordpress/">super archive</a> plugin:</strong> i'm still looking for a nice way of showing my archives, but for now i've used this plugin to display my (buggy) archives. i really want to display my archives like <a title="my archive envy" target="_blank" href="http://jarkolicious.com/archives/">this page</a>, but i can't find the plugin (can anyone help?)</li> </ol>')) as bodyscore, (MATCH (post_title) AGAINST ('new site features')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('having a stable server for the last few days has allowed me to finish the site design work i wanted to do over christmas. i'm quite happy with the results and i think the template is subtly cleaner and more efficient, and the navigation links have been improved considerably, and i've already seen the benefits in site usage. i'm quite happy with the result and now i can concentrate on posting and building up blog and forum traffic in 2007. some of the changes aren't that obvious, but here's a full list of the ones i can remember doing: <h3>new features/general</h3> <ul> <li>i've created a <strong><a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/">new forum</a></strong>. although there haven't been a lot of registrations so far, a lot of interesting and useful information has already been listed. if you haven't checked out the forum yet, then i'd recommend giving it a go</li> <li>made changes to how comments get posted on blog, which has totally eliminated all <strong><a target="_blank" title="no comment spam" href="http://www.connectedinternet.co.uk/2007/01/01/1263/">comment spam without a plugin</a></strong></li> <!--more--> <li><strong>replaced the wordpress search engine with google search</strong>: it seems to be much better at finding results, and it has definitely encouraged more readers to search my site for posts</li> </ul> <h3>navigation improvements</h3> <ul> <li><strong>header navigation:</strong> added a new header with important navigation links, including a vital subscribe link. i've also added a similar set of links at the bottom of the sidebar</li> <li><strong>reduced the number of categories and merged a lot of my utw tags</strong> to make navigation simplier</li> <li><strong>reduced the length of the sidebar by using tabbed navigation</strong>. this has allowed me to group similar types of links to make it easier for users to follow, whilst at the same time making all options available to users and highlighting the ones i think are the most useful</li> <li><strong>added tabbed navigation at the bottom of my posts</strong>. this has gone a long way to reduce the 'noise' that was there previously, making it clearer to users what they can do next. i've also incorporated a search box so that users can search my site for more posts once they've finished reading mine, or the whole internet within my site without having to leave</li> <li><strong>added '<a title="share this plugin" href="http://www.connectedinternet.co.uk/2006/12/17/1193/">share this'</a> to my posts</strong> so that my social bookmarking links are nice and tidy</li> <li><strong>combined my skyscraper ad and <a title="vizu poll" href="http://www.connectedinternet.co.uk/2006/11/29/1119/">vizu poll</a> to save space</strong> in my sidebar</li> <li>added smaller mybloglog images</li> <li>removed snap preview as it was getting annoying</li> <li><strong>tidied up my trackbacks and pingbacks</strong> so that only the title and site name are shown, and no more massive excerpts</li> </ul> <h3>seo/revenue optimisation</h3> <ul> <li><strong>improved my meta tags</strong>: i've done more work on these since making <a title="guide to meta tags" href="http://www.connectedinternet.co.uk/2006/12/22/1223/">this post,</a> so if you want to learn more leave a post in the forum</li> <li><strong>added a new adsense link ad to my tabbed navigation boxes</strong>, and the performance has startled me. in the past i've had no joy with link ads, but my current <strong>link ad is now my second best performing unit</strong></li> <li>added more adsense channels so that i can better track which ads are doing well, as well as adding more adsense <a title="section targetting" href="http://www.connectedinternet.co.uk/2005/12/13/677/">section targeting</a> to my pages</li> <li><strong>i've added my site to dozens of directories.</strong> i didn't believe this was a good use of my time, so i paid $5 for someone to add me to 60 p5 and p6 directories. i've also rejoined <a target="_blank" title="blogtopsites" href="http://www.blogtopsites.com/internet/">blogtopsites</a> and at the time of writing i'm #2, which is nice</li> </ul> <h3>plugins</h3> <ul> <li>even though i've got a shiny new server, i've still made an effort to reduce the number of plugins i'm using, especially the very intensive ones. i've managed to <strong><a target="_blank" title="reducing plugins" href="http://www.connectedinternet.co.uk/2006/12/23/1231/">reduce the number of plugins i use from 35</a></strong> to 28, despite adding a few new ones this week (<a title="all my plugins" href="http://www.connectedinternet.co.uk/about/plugins-i-use/">full list here</a>):</li> </ul> <ol> <li><strong><a title="visit plugin homepage" href="http://blog.taragana.com/index.php/archive/angsumans-translator-plugin-pro-for-wordpress-blogs-released/">angsuman’s translator plugin pro</a> plugin:</strong> despite having <a title="wordpress plugins not to install" href="http://www.connectedinternet.co.uk/2006/12/01/1125/">problems initially with this plugin</a>, i gave angsuman admin access to my site and he very quickly found the problem. his tweaks were so good in fact, that the translated pages actually load faster than the real pages! you can try out the plugin by clicking on any of the flags at the top of the sidebar. the real beauty of this plugin is that the translated pages will appear on non-english search engines, which will increase my site traffic</li> <li><strong><a title="visit plugin homepage" href="http://www.alinks.org/">alinks</a> plugin:</strong> together with my<a title="shoplinc alinks module" href="http://www.connectedinternet.co.uk/2006/12/19/1208/"> chitika shoplinc module</a> i've been able to add shopping links very quickly throughout my site which has added a nice new revenue stream (4th behind adsense, feedburner and text-link-ads). i expect this to grow as i write about newer products in 2007</li> <li><strong><a title="visit plugin homepage" href="http://www.jameskelly.org/wordpress-plugins/custom-login-and-registration-forms-plugin/">themed login and register</a> plugin:</strong> this plugin has allowed me to theme my login pages and to control what pages and content users see when they login/register/logout</li> <li><strong><a title="visit plugin homepage" href="http://inner.geek.nz/wordpress-plugins/smart-unread-comments/">smart unread comments</a> plugin: </strong>i've created a <a title="updates page" href="http://www.connectedinternet.co.uk/manage/">new updates page</a> which is listed in my new header nav, which lists shows the latest posts and other useful info. what it also does thanks to the smart unread comments plugin is show you what comments have been left since your last visit (it uses a cookie). thanks to the themed login plugin this page is now the first page that users will see when they login, which will provide them a quick snapshot of what has happened since they last visited</li> <li><strong><a title="visit plugin homepage" href="http://rawlinson.us/blog/?p=212">feed list</a> plugin:</strong> this plugin has allowed me to add a new section 'forum posts' in the sidebar which shows the last 10 posts from the <a target="_blank" title="connected intenet forum" href="http://www.forum.connectedinternet.co.uk/">new forum</a>. if you haven't checked out the forum yet, then i'd recommend giving it a go</li> <li><strong><a rel="lightbox" title="visit plugin homepage" href="http://www.thunderguy.com/semicolon/wordpress/less-wordpress-plugin/">less</a> plugin</strong>: ajay will probably say as usual that i can acheive this effect without a plugin. what the less plugin does is force '(more…)' links from the homepage to go to the top of the article, rather than to the part after the '(more…)'. i think this makes articles easier to read, as well as ensuring that readers see my best performing ad unit</li> <li><strong><a title="visit plugin homepage" href="http://unknowngenius.com/blog/wordpress/spam-karma/">spam karma 2</a> plugin:</strong> the best spam handling plugin in my view. although i've eliminated my comment spam problem, it's nice to have sk2 as a backup (and the <a title="math comment spam plugin" href="http://www.connectedinternet.co.uk/2006/12/14/1178/">math comment spam plugin</a> for non-registered users) and it is also catching all my trackback spam</li> <li><strong><a title="visit plugin homepage" href="http://www.jonas.rabbe.com/archives/2005/05/08/super-archives-plugin-for-wordpress/">super archive</a> plugin:</strong> i'm still looking for a nice way of showing my archives, but for now i've used this plugin to display my (buggy) archives. i really want to display my archives like <a title="my archive envy" target="_blank" href="http://jarkolicious.com/archives/">this page</a>, but i can't find the plugin (can anyone help?)</li> </ol>')) * 1+ (MATCH (post_title) AGAINST ('new site features')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 1281 ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 1281 ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = 'category') where (post_status IN ( 'publish', 'static' ) and ID != '1281') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7