bsuite Bug Fixes (release b2v6)
Contents:
Update: bugfix release b2v7 available.
It’s been a while since I released a new version of bsuite, my multi-purpose WordPress plugin. I’d been hoping to finish up a series of new features, but those have been delayed and this is mostly just a collection of bugfixes. This update is recommended for all bsuite users.
bsuite Features
- Tracks page loads (hits)
- Tracks search terms used by visitors ariving at your site via search engines
- Reports top-performing stories via a function that can be included in the sidebar
- Reports recent comments via a function that can be included in the sidebar
- Reports top search terms via a function that can be included in the sidebar
- Outputs a pulse graph of activity on your site or specific stories
- Highlights search words used by visitors ariving at your site via search engines
- Lists related posts at the bottom of the current post’s content
- Suggests posts that closely match the search criteria for visitors who arrive via search engines
- Integrates bsuite_speedcache
- Does some stuff with tags
Fixed/Changed/Added
- The bsuite report consolidates the two uselessly differentiated top stories lists and adds a top movers list.
- The report also includes a hugely updated Quick Stats section listing today’s current tally and a prediction of the day’s total along with other goodies.
- The table definitions have been updated and optimized for better performance. Zach contributed some optimizations to the
bstat_hitit()function and underlying MySQL queries, and you’ll also find a number of small code optimizations scattered throughout.
- This version finally creates and configures it’s tables automatically upon activation. You no longer need to visit the plugin’s option screen for this to happen.
- A fix to address a MySQL error for users running MySQL 5 has been long overdue. It’s in here.
- Numbers in the reports are now formatted with commas or whatever local format you’ve set MySQL for, using MySQL’s
FORMAT()function.
- As requested, I’ve added a function —
bstat_hits()— return just the hit count for a story or for the whole blog.
- As requested, you can now manually clear the bsuite_speedcache.
- As prompted, prodded, and cajoled, I’ve finally made a change to report hits to the front page (and other pages without post IDs).
- I did a bunch of thinking about tags a while ago, and bsuite now keeps an index of tags in a separate table. I’ve got plans to use this for later features, but for now it’s just a curiosity that shouldn’t cause any problems.
- You can now switch between <tags> or [tags] for compatibility with other plugins (such as noted here) and with WP2’s WYSIWYG editor.
- The code now properly calls
get_settings(’siteurl’)instead ofget_settings(’home’)to build the URL for the spacer.gif that builds the pulse graph, fixing the problem where the graph wouldn’t display for some users.
- Not changed, but at least answered: Eddie commented to explain that ‘–disable-bcmath’ can cause the undefined function errors some people were getting. A later release may incorporate Pramudita’s fix.
- Also not in this version are the user-contributed tag features I’d gotten so excited about. These just aren’t ready for primetime, but people who want to hack about in alpha-ville will find all the supporting code in there.
- This list is probably incomplete and in some other way inaccurate. It’s not intentional, I’m just sloppy. Please leave comments with bug reports or corrections, I’ll do what I can to fix them.
- Finally, I’m now hosting the download on a new server, so it won’t be subject to .Mac’s bandwidth consumption limits.
Installation
Update: bugfix release b2v7 available.
- Download and unzip bsuite.zip
- Place bsuite.php in you wp-content/plugins directory
- Place spacer.gif in your wp-content directory
- Log in to your WordPress admin panel and activate the plugin, then visit the new bsuite submenu of the options tab. This will allow bsuite to create its database tables.
Stats collection will start automatically; you can see the results in the new bsuite Reports submenu of your Dashboard
- Once installed, be sure to enable the options and consider customizing the look by adding the bsuite CSS to your theme’s CSS (sample CSS here).
In order to view the stats reports reports on your public pages, you’ll need to add the display functions to your pages.
Upgrading
Upgrades from earlier versions of bsuite are easy, just replace the old bsuite.php file with the new one.
If you’re upgrading from bstat (which is so old I was tempted to remove this part of the docs), be sure to delete or deactivate the old plugin before activating the new one. Don’t forget to visit the bsuite submenu of the options tab so you can setup all the new features.
Commands
The bstat submenu of the options has a few command buttons:
- Clear bsuite_speedcache
The cache improves performance, but can sometimes get stale before its time. This command clears it.
- Rebuild bsuite tag index
bsuite maintains its tag index with every story edit. Use this command to bring old-content into the index or if you’ve edited the content in way WP doesn’t know about.
Options
The bstat submenu of the options tab has a few configurable settings:
- Minimum userlevel to view bsuite reports
The options are restricted to users at userlevel 8 or above, but you can choose who can view the reports.
- Output default CSS
Some of the bsuite functions require CSS styles not found in the average style sheet. This will output default styles.
- Default pulse graph style
This sets how values are interpolated in drawing the pulse graph. Experiment with the options to see how they work.
- Suggest related entries in post
This will insert a block of links at the tail of each (tagged) post’s content with links to related posts at your site.
- Tag input format
Name your style: square brackets or angle brackets / <tags> or [tags].
- Highlight search words and offer search help
The first part of this should be obvious, but the real trick here is using those search words to offer other related content from your site to visitors. It works (and looks) a lot like the option above, but the suggestions only appear when search words are detected.
- Filter incoming search terms using comment moderation and blacklist words.
Referrer spam is as much of a problem as trackback spam. There are a few tricks in bstat to prevent the problem, but here’s one you can configure. Selecting this option tells bstat to not display search terms that contain words in your moderation list or blacklist.
- Ignore hits from registered users at or above userlevel
No author wants to skew their stats just by poking around their own site.
- Ignore hits from these IP numbers.
Sites with low traffic may find that activity by authors severely skews the stats tracking. Enter an IP address here to ignore it.
Tag Support
Until WordPress adopts a standardized way to manage tags, we’ll have to deal with things like this.
bsuite recognizes tags in three forms:
- Any link with a rel=“tag” attribute
- Any number of single tags like this: <tag>tag name</tag>
- A block of comma-delimited tags like this: <tags>WordPress, WordPress Plugin</tags>
This appears to make it compatible with a number of existing tag management strategies now in use — including those used by Ecto and SimpleTags.
Tags in <tag> and <tags> tags are mapped to Technorati, but a future version will include an option to set other tag resolvers.
Using bsuite Functions
Though many bsuite features require no coding or modifications to theme files, there are a number of public functions available to display lists of top stories, recently commented stories, recent comments, recent incoming search terms, etc. Most of these functions take similar arguments and output their results in similar ways.
Today’s Stats
- bstat_todaypop
displays top stories for today only.
- bstat_todayrefs
displays top incoming search terms for today only.
The functions bstat_todaypop and bstat_todayrefs each take the same arguments.
Usage:
bstat_todaypop({count}, “{before}”, “{after}”);
count is the total number of results to output
before is a string to output before each result
after is a string to output after each result
Example:
<h2>Today's Most Popular</h2> <ul><?php bstat_todaypop(15, “<li>”, “</li>\n”); ?></ul>
Recent Stats
- bstat_recentpop
displays top stories for the past x days. This function reveals more useful data on sites with low traffic, but is somewhat slower than bstat_todaypop.
- bstat_recentrefs
displays top incoming search terms for the past x days. This function reveals more useful data on sites with low traffic, but is somewhat slower than bstat_todayrefs.
The functions bstat_recentpop and bstat_recentrefs each take the same arguments.
Usage:
bstat_recentrefs({count}, “{days}”, “{before}”, “{after}”);
count is the total number of results to output
days is the number of days back to look
before is a string to output before each result
after is a string to output after each result
Example:
<h2>Incoming Search Terms This Week</h2> <ul><?php bstat_recentrefs(15, 7, “<li>”, “</li>\n”); ?></ul>
Recent Discussion
- bstat_discussionbypost
displays recently commented posts. Each post will appear only once.
- bstat_discussionbycomment
displays recent comments (and commenter). Better on sites with lots of community interaction.
The functions bstat_discussionbypost and bstat_discussionbycomment each take the same arguments.
Usage:
bstat_discussionbypost({count}, “{before}”, “{after}”);
count is the total number of results to output
before is a string to output before each result
after is a string to output after each result
Example:
<h2>Incoming Search Terms This Week</h2> <ul><?php bstat_discussionbypost(15, “<li>”, “</li>\n”); ?></ul>
Special Functions
- bstat_hits
displays the current and average daily page loads.
Usage:
bstat_hits([{template}, [{post_id}, [{today_only}]]]);
template will be filled in with the appropriate values for %%hits%% and/or %%avg%%. If left blank, the default template is %%hits%% hits, about %%avg%% daily
post_id over-rides the detected post ID. Common values for this may include “0” to show stats for index pages, or “-1” to show stats for the entire blog (note that %%avg%% reports inaccurately with a “-1” value here)
today_only returns the count for today (note that %%avg%% doesn’t make much sense here)
Example:
<?php bstat_hits('%%hits%% hits, about %%avg%% daily') ?>
prints something like “791 hits, about 10 daily”
<?php bstat_hits('%%hits%% page loads today', -1, 1) ?>
prints something like “5,950 page loads today”
- bstat_pulse
displays the “pulse” graph of hits over time.
Usage:
bstat_pulse([{post_id}, [{max_width}, [{display_text}, [{display_credit}, [{graph_accurate}]]]]]);
post_id is the post_id for the story, usually provided by a WP variable
max_width is the maximum width the graph maw run
display_text (acceptable values: 0 or 1), switch to display stats for total views and average views per day
display_credit (acceptable values: 0 or 1), switch to display “powered by bstat” credit
graph_accurate (acceptable values: 0 or 1), make smooth, accurate graphs or fuzzy (but not inaccurate) graphs
Example:
<h3>Story pulse</h3><?php bstat_pulse($id, 525, 1, 1, 1); ?>
- bstat_hitit
The hamster on a wheel that makes it all work. It records hits for each page load, and hits for each incoming search term.
This function is no longer necessary, as it is executed automatically via a plugin hook that runs every time the footer is called. Still, it’s around if you have content that you want to track outside that scope.
Example:
<?php // this is how it used to work, but it's automated now...
global $id;
if (!is_single() && !is_page()) $id = 0;
bstat_hitit($id, “read”);
?>
note: (be careful of any “curly quotes” that might have been accidentally/automagically inserted in code samples)
Known Bugs
None yet, but I’m sure I’m forgetting something. Report what you find in the comments below.
77 Comments
Comments RSS TrackBack Identifier URI
Sorry, the comment form is closed at this time.
Hi Casey
Tried installing bsuite on WP 2.02 (Apache2 + PHP5) but got a blank page after activating the plugin. I got this error in the server logs:
PHP Parse error: parse error, unexpected $end in E:\\Apache2\\htdocs\\blogs\\grapevine\\wp-content\\plugins\\bsuite\\bsuite.php on line 2279
Any ideas? Cheers!
[...] I was thrilled when Casey over at MaisonBisson posted about the release of Bsuite b2v6. After much prodding by me, Casey has separated tags from posts into their own tables. He and I sat down one evening and fleshed out the overall goal for the tagging structure…we butted heads on a few things but the end result is pretty snazzy. I’ve beta tested the tagging features and I’m fond of them…w00t! Because of all the optimizations, I quickly installed the update on the blogs I host: [...]
Dave: I’m stumped. It’s working elsewhere, and 2279 is the EOF.
I don’t know of any people running this version in Windows, but I hope it’s not anything as annoying as a incompatible line ending or something like that.
I hate to turn the problem around, but if you learn anything, please tell me, I’d love to include any fixes in the baseline.
My Wordpress site name contains a ‘ character (The ‘Mute) which appears to cause a problem in the script.
I’ve fixed it by changing the line:
$blog_name = get_bloginfo(’name’);
to
$blog_name = htmlentities(get_bloginfo(’name’), ENT_QUOTES));
I’m sure someone out there will suggest a better way of solving this problem but it seems to work for me
Cheers - Robert.
one too many close brackets - sorry!
I can not use it on my current theme( Andreas 08 3 column B, http://www.italiasw.com/wordpress-themes/ ).
But it can work on another theme( blog.txt, http://www.plaintxt.org/themes/blogtxt/ ).
Could you help me?
Can’t get it to work with connections reloaded theme. Upload the files and I then get a load of error messages in my plugins and options parts of wp admin control panel.
Anyone had success implementing this plugin with that theme??
Stuart, can you post the error messages?
beatlesan: make sure the theme is calling the get_footer() and wp_footer() functions. Bsuite attaches to the wp_footer hook to get its stats.
Thanks a lot! It works^^
I get these errors after activation:
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp_bstat_hits ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits_reads mediumint(9) unsigned NOT NULL default ‘0′, hits_ads1 mediumint(9) unsigned NOT NULL default ‘0′, hits_ads2 mediumint(9) unsigned NOT NULL default ‘0′, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp_bstat_refs ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits mediumint(9) unsigned NOT NULL default ‘0′, issearchengine tinyint(1) NOT NULL default ‘0′, ref text NOT NULL, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date,ref(3)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 7]
CREATE TABLE wp_bsuite_speedcache ( cache_date datetime NOT NULL default ‘0000-00-00 00:00:00′, cache_bank enum(’user’,'bsuggestive’,'refsforpost’) NOT NULL default ‘user’, cache_item bigint(20) NOT NULL default ‘0′, cache_content text NOT NULL, PRIMARY KEY (cache_bank,cache_item) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 9]
CREATE TABLE wp_bsuite_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, post_id bigint(20) unsigned NOT NULL default ‘0′, comment_id bigint(20) unsigned, tag varchar(250) NOT NULL, tag_raw varchar(250) NOT NULL, PRIMARY KEY (tag_id), UNIQUE KEY post_tag (post_id,comment_id,tag_raw) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
I fixed the above errors by deleting the “DEFAULT CHARSET=utf8″ as this is the default.
Now I’m getting these on the Reports page:
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 '(NOW()))), 0) AS note FROM wp_bstat_hits WHERE bstat_date = NOW]
SELECT FORMAT(SUM(hits_reads) * (86400 / TIME_TO_SEC(TIME(NOW()))), 0) AS note FROM wp_bstat_hits WHERE bstat_date = NOW()
and then:
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 '(NOW())))), a.bstat_id = b.bstat_id WHERE a.post_id = b.po]
UPDATE movers a, wp_bstat_hits b SET a.today = (b.hits_reads * (86400/TIME_TO_SEC(TIME(NOW())))), a.bstat_id = b.bstat_id WHERE a.post_id = b.post_id AND b.bstat_date = CURDATE();
Is it me or what?
The 2 errors above were fixed by changing
(86400/TIME_TO_SEC(TIME(NOW())))
to
(86400/TIME_TO_SEC(NOW()))
[...] Not too long ago I wrote a brief comparison of Sitemeter, Google Analytics, and bsuite. I call the comparison “brief” because it was, well, brief. Not many details, not much information, and my basic conclusion was that Google Analytics provided the best info but that bsuite was handy because the one page summary was a good way to get a quick feel for blog traffic. I also mentioned a bug in bsuite. I was pleased to see a comment (I get very few comments, so any comments please me!) on that post from the bsuite author pointing out a new bsuite release! It took all of about 30 seconds to download bsuite.zip and install it on dreamhost, and indeed the SQL bug I previously mentioned was fixed! [...]
Consider mirroring your file on ShareBigFile.com or rapidshare if you really must
. mac hosting doesn’t seem to be working out too well
[tags]free file hosting, mirror, mirroring, kittens[/tags]
I get funky mySql errors even after changing the char set from UTF-8 to ASCII:
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp2_bstat_hits ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits_reads mediumint(9) unsigned NOT NULL default ‘0′, hits_ads1 mediumint(9) unsigned NOT NULL default ‘0′, hits_ads2 mediumint(9) unsigned NOT NULL default ‘0′, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp2_bstat_refs ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits mediumint(9) unsigned NOT NULL default ‘0′, issearchengine tinyint(1) NOT NULL default ‘0′, ref text NOT NULL, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date,ref(3)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 7]
CREATE TABLE wp2_bsuite_speedcache ( cache_date datetime NOT NULL default ‘0000-00-00 00:00:00′, cache_bank enum(’user’,'bsuggestive’,'refsforpost’) NOT NULL default ‘user’, cache_item bigint(20) NOT NULL default ‘0′, cache_content text NOT NULL, PRIMARY KEY (cache_bank,cache_item) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 9]
CREATE TABLE wp2_bsuite_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, post_id bigint(20) unsigned NOT NULL default ‘0′, comment_id bigint(20) unsigned, tag varchar(250) NOT NULL, tag_raw varchar(250) NOT NULL, PRIMARY KEY (tag_id), UNIQUE KEY post_tag (post_id,comment_id,tag_raw) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
The bsuite plugin is now initialized. The bsuite tables have been created. If you choose to deactivate the plugin you must delete the bsuite tables manually.
————-
————-
————-
when using UTF-8:
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp2_bstat_hits ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits_reads mediumint(9) unsigned NOT NULL default ‘0′, hits_ads1 mediumint(9) unsigned NOT NULL default ‘0′, hits_ads2 mediumint(9) unsigned NOT NULL default ‘0′, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 10]
CREATE TABLE wp2_bstat_refs ( bstat_id bigint(20) unsigned NOT NULL auto_increment, bstat_date date NOT NULL default ‘0000-00-00′, post_id mediumint(9) unsigned NOT NULL default ‘0′, hits mediumint(9) unsigned NOT NULL default ‘0′, issearchengine tinyint(1) NOT NULL default ‘0′, ref text NOT NULL, PRIMARY KEY (bstat_id), KEY combined (post_id,bstat_date,ref(3)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 7]
CREATE TABLE wp2_bsuite_speedcache ( cache_date datetime NOT NULL default ‘0000-00-00 00:00:00′, cache_bank enum(’user’,'bsuggestive’,'refsforpost’) NOT NULL default ‘user’, cache_item bigint(20) NOT NULL default ‘0′, cache_content text NOT NULL, PRIMARY KEY (cache_bank,cache_item) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
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 'DEFAULT CHARSET=utf8' at line 9]
CREATE TABLE wp2_bsuite_tags ( tag_id bigint(20) unsigned NOT NULL auto_increment, post_id bigint(20) unsigned NOT NULL default ‘0′, comment_id bigint(20) unsigned, tag varchar(250) NOT NULL, tag_raw varchar(250) NOT NULL, PRIMARY KEY (tag_id), UNIQUE KEY post_tag (post_id,comment_id,tag_raw) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
The bsuite plugin is now initialized. The bsuite tables have been created. If you choose to deactivate the plugin you must delete the bsuite tables manually.
——-
both from bSuite options page
[tags]syntax error, resistance is painful, ouch, oops, doh[/tags]
I removed every
DEFAULT CHARSET=utf8
and was able to avoid all of the install errors. I’ve learned more about sql tables than I ever wanted to know (GoDaddy linux shared hosting is lame)
The only error left is in the Dashboard view:
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 '(NOW()))), 0) AS note FROM wp2_bstat_hits WHERE bstat_date = NO]
SELECT FORMAT(SUM(hits_reads) * (86400/TIME_TO_SEC(TIME(NOW()))), 0) AS note FROM wp2_bstat_hits WHERE bstat_date = NOW()
after the blog receives at least one hit the rest of the statistics show, including the graph, but the above error is always preset
http://img139.imageshack.us/img139/233/godaddysharedhostingisaripoffyb8.png
[...] On top of that my feed was broken when I updated my Performancing Metrics plug-in and thanks to the Armenian Eagle’s help in locating the problem it was just easier to remove the plug-in since I use both bsuite and Google Analytics anyway. [...]
For anyone having trouble with unexpected EOF at line whatever (the last line), you run PHP like and do, and therefore need to go through the bsuite.php file and change everything that is just “
Sorry, this filtered out the whole point of my comment:
For anyone having trouble with unexpected EOF at line whatever (the last line), you run PHP like and do, and therefore need to go through the bsuite.php file and change everything that is just “>?” to “>?php” and “>?=” to “>?php echo “, otherwise you’ll never get it to work.
Now to solve my apparent DB problems…
Haha, sorry again… any of those > should be <. I’m really good at typing
Is there a timezone setting be built in bsuite? How to change it?
bfans: the timezone is based on the system/mysql time. I will, eventually, add an option to use the WP timezone setting.
I was having the same problems as gasp and james above…. and I took Jams suggestions and fixed those. I still have one more error:
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
CREATE FULLTEXT INDEX bsuggestive ON wp_posts (post_content,post_title);
After googling, I found that it is because my tables are of the type InnoDB where as FULLTEXT INDEX gets created on MyISAM. Any work around on that ?
Using release B2V6 the following errors appear. Removed UTF8 - made no difference. Any help would be much appreciated, as I am not a programmer. (P.S. I do not leave my email since this has led to problems in the past. Thanks!)
UNDER “TOP STORIES” in Dashboard:
TOP STORIES:
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 's pages' ELSE LEFT(b.post_title, 60) END AS title,
SUM(a.hits_reads) AS sor' at line 4]
SELECT a.post_id AS post_id, CASE WHEN b.post_title IS NULL THEN ‘Alice’s
Home’ ELSE LEFT(b.post_title, 60) END AS title, SUM(a.hits_reads) AS
sort_order, CONCAT(’Tot: ‘, FORMAT(SUM(a.hits_reads),
0), ‘, Avg: ‘, FORMAT((SUM(a.hits_reads)) / ((TO_DAYS(NOW())
- TO_DAYS(MIN(a.bstat_date))) + 1), 0), ‘, Max: ‘,
FORMAT(MAX(a.hits_reads), 0), ”) AS note FROM wp_bstat_hits a LEFT JOIN
wp_posts b ON (a.post_id = b.ID) WHERE bstat_date > ‘2006-08-03′ GROUP BY
a.post_id ORDER BY sort_order DESC LIMIT 5
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 's pages' ELSE LEFT(b.post_title, 60) END AS title, CONCAT('Avg' at line 4]
SELECT a.post_id AS post_id, CASE WHEN b.post_title IS NULL THEN ‘Alice’s
Home’ ELSE LEFT(b.post_title, 60) END AS title, CONCAT(’Avg: ‘,FORMAT(a.average, 0), ‘, Today: ‘,
FORMAT(a.today, 0), ‘, Change: ‘, FORMAT(today - average, 0))
AS note, (today - average) AS sort_order FROM movers a LEFT JOIN wp_posts b
ON (a.post_id = b.ID) ORDER BY sort_order DESC LIMIT 5
TOP REFERRERS:
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 's pages') ELSE CONCAT('', FORMAT(SUM(a.hits), 0), ' hits to
', LEFT(b.po' at line 6]
SELECT a.ref AS url, LEFT(a.ref, 60) AS title, SUM(a.hits) AS sort_order,
CASE WHEN b.post_title IS NULL THEN CONCAT(”, FORMAT(SUM(a.hits), 0),
‘ hits to Alice’s Home’) ELSE CONCAT(”, FORMAT(SUM(a.hits), 0), ‘
hits to ‘, LEFT(b.post_title, 70)) END AS note, ‘Go To…’ AS tooltip FROM
Is it possible to get bsuite_speedcache without the whole suite?
That would be very useful for me…
Thank you for this great idea.
At my wodpress 2.0.4 is is not working. I get the message:
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 '(NOW()))), 0) AS note FROM wp_bstat_hits WHERE bstat_date = NOW]
SELECT FORMAT(SUM(hits_reads) * (86400/TIME_TO_SEC(TIME(NOW()))), 0) AS note FROM wp_bstat_hits WHERE bstat_date = NOW()
In my administration panel.
Any ideas?
[tags]error[/tags]
[...] bsuite Bug Fixes (release b2v6) « MaisonBisson.com (tags: wp:plugin statistics) [...]
I have noticed that when I select the option to Highlight search words and offer search help, the first couple of lines of the target post are cut off once you link through from the search engine. As an example, you can search for swiss mini gun on Google, follow the link to Safety Rule 4001 and note that the first sentence of the post is cut off.
The full post is here: http://sr4001.com/2006/08/16/swiss-mini-gun-finger/
The Google search is: http://www.google.com/search?sourceid=navclient-ff&ie=UTF-8&rls=GGGL,GGGL:2006-29,GGGL:en&q=swiss+mini+gun
Currently, Safety Rule 4001 is the third result listed.
[tags]display, error[/tags]
[...] I was surprised to see Matt Mullenweg’s quick response to my support inquiry. As it turned out, there was problem with the Akismet systems, and things should be back on track soon. I was relieved, and also impressed with the quality of the support. I’ve seen many companies and people struggle with customer support (and I struggle with how to support bsuite users), but Matt’s 82 word response was about perfect. It’s (b), I’m very sorry. [...]
I think I’ve figured out that blogs that have an apostrophe in their names (Craig’s Crafts) will get an SQL syntax error like Alice’s above. I get the same type of error, but not on another blog with no apostrophe in its name.
Anyone knowhow to fix this? It’s in the lines after:
WHEN b.post_title IS NULL
THEN ‘$blog_name’
ELSE LEFT(b.post_title, 60)
I figured out a change that seems to fix the SQL error for blogs that have an apostrophe in their names, just change
$blog_name = get_bloginfo(’name’);
to
$blog_name = str_replace(”‘”,”`”,get_bloginfo(’name’));
This changes the apostrophe to a `, but you could remove it or use another character instead.
I got a slight problem.
Installed, fired up and inserted a tagname aaand…
My post included the word : tagname.
Hmmm..
So my question is: where do you put in the tags?
Hi el_inocente.
I just installed bsuite as well (on http://www.lookzine.com) and was having trouble working out what to do with the tag thing too.
This is how it is done, when you write a post (or edit one), in the normal “post” box after you have written what you want (you blog post text), then you type:
tagone, tag two, tag three
Then click publish and you will see the tags come up on your blog.
Note here, I said save above not “save and continue editing”, I found that the “tags” commands get stuffed up if you do anything but publish - and if you edit a post later you need to put the tags above mentioned back in.
Hope that helps.
I have just updated my first post here:
http://www.lookzine.com/portagemma-website-design-and-cms-solutions.html
Thankfully it is a new website and so I do not have that many to update.
[tags]technorati, wordpress, rss, bsuite[/tags]
james, thank you for the hint with
[/code](86400/TIME_TO_SEC(NOW()))[/code]
saved me having to learn something new
When I go to Options -> bsuite page, I get an error at the top that says:
————————
WordPress database error: [Table 'wp_bstat_speedcache' already exists]
CREATE TABLE `wp_bstat_speedcache` ( `cache_id` bigint(20) unsigned NOT NULL auto_increment, `cache_date` datetime NOT NULL default ‘0000-00-00 00:00:00′, `cache_bank` enum(’user’,'bsuggestive’) NOT NULL default ‘user’, `cache_item` bigint(20) NOT NULL default ‘0′, `cache_content` text NOT NULL, PRIMARY KEY (`cache_id`), UNIQUE KEY `cache_uniq` (`cache_bank`,`cache_item`), KEY `cache_name` (`cache_item`) ) TYPE=MyISAM
——————————
When I check the box “Suggest related entries in post (enables tag support):” I get another DB error once or twice at the top of each article under the header:
——————————
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 'WHERE cache_item = '4' AND cache_bank = 'bsuggestive' AND cache_date >= '200' at line 2]
SELECT * FROM WHERE cache_item = ‘4′ AND cache_bank = ‘bsuggestive’ AND cache_date >= ‘2006-09-18 00:34:37′ LIMIT 1 ;
——————————
NOTE: I’m using MySQL V5.0.? which probably has some made some quirky changes somewhere.
@Davids: It looks like the dbDelta function isn’t changing the table structure the way it needs to. Can you manually delete that table and try again?
Casey, I deleted the table and the error in the Options -> bsuite page went away — once. I clicked the “Suggest related entries in post” checkbox, and it returned with the same errors as before in both places.
How long after installation should the first stats show up? I installed a couple hours ago and there is still no data, though I know there have been visits during that period, and not just from me.
If it isn’t recording visits, any ideas where to look for reasons it isn’t counting?
I posted a comment previously, still in moderation, mentioning that I installed bsuite and an hour or more later the reports are still empty, though everything looks like I got it installed properly. Two days later, they’re still empty, so clearly something isn’t working. Where might I look to figure out why data isn’t getting recorded.
Any help would be greatly appreciated.
[...] CNB issues: bsuite sql error — solved with http://maisonbisson.com/blog/post/11390/ [...]
@James: make sure your theme is calling the wp_footer() function, or try manually calling the bsuite_hitit() function.
Please tell me what you find.
Well, that didn’t work. Feel free to delet my last, useless comment. Maybe I need to change the code so it doesn’t get cleaned up by wordpress’s comment system. I’ll try that now.
I’m don’t really know PHP, but I do find the following in index.php:
?php get_footer(); ? (but with left and right angle brackets around it)
which perhaps isn’t what I need.
I am using a theme with some fancy features, from crave4more.com, so maybe something about that interferes.
By manually calling the bsuite_hitit() function, do you mean I should put something like the following in my index.php?
?php bsuite_hitit(); ?
but again with left and right angle brackets around them.
@James:
Forgive me sloppiness above. What I really should have asked is something like….
Check if your code is calling the wp_footer hook. It should look something like this:
<?php do_action(’wp_footer’); ?>
If it doesn’t do that, then none of the plugins that hook to that will ever execute.
As an alternative, you can also call the bstat_hitit() function manually using the documentation in the post above.
Using your examples of bstat_todaypop &
bstat_todayrefs gives me:
Parse error: syntax error, unexpected ‘>’ in /home/.abstractkiln/ivar/ivarzantinge.com/wp-content/themes/default/sidebar.php on line 42
Code:
Recent Popular Posts
â€, “nâ€); ?>
Recent Popular Searches
â€, “nâ€); ?>–>
Any solutions for the problem mentioned above? Thanks
[...] Thanks to bsuite I get a glimpse of searches that brought people to this site. I hope the person who searched for (MySpace OR Facebook) AND Libraries found what he or she was looking for. [...]
Hello,
I have the same problem as James Riemermann - the stats still blank after a day of installation. As your reply to him :Check if your code is calling the wp_footer hook. It should look something like this:
Where to add the ? Sorry, I don’t know any programming at all.
Thanks.
Hello,
I have the same problem as James Riemermann - the stats still blank after a day of installation. As your reply to him :Check if your code is calling the wp_footer hook. It should look something like this:
?php do_action(’wp_footer’); ? between the (sorry, I can type the full syntax here, it’s not showing well after I submitted the comment)
Where to add the ?php do_action(’wp_footer’); ? between the ? Sorry, I don’t know any programming at all.
Thanks.
Hi again,
I think I’ve found the answer, after consulting with a friend who also uses this plugin. I added the wp_footer syntax on “footer.php” just before “” and the stats show.
Tried bstat_recentpop and bstat_todaypop function and it worked like charm. But when adding bstat_recentrefs function, the incoming search term keyphrase seems broken. For example: the keyphrase is “how to sell ebook in ebay” (shown on bsuite report), but displayed as “how to sell ebook in”
How to correct that kind of problem? Wish you can help me, Casey. Thanks a lot!
After installing this plugin, technorati stopped indexing my post. After removing the plugin and database files, my post was indexed. Is this a known bug, coincidence, or could I have set something up wrong?
Hi - thanks for bsuite! Everything started working fine for me after I added Robert’s July 25th, 2006 suggestion re apostrophe’s.
Thought I would pass along a hint too, just in case anyone finds it useful. I wanted to have the stats appear on a single page only, rather than in a sidebar. To to this I just inserted
the code below into my theme’s index.php right before the line Today’s Most Popular”; bstat_todaypop(15, ” “, ” |”); echo “”;
echo “Last 30 days’ Most Popular”; bstat_recentrefs(15, 30,” “,” |”); echo “”;
echo “Last 30 days’ Search Terms”; bstat_recentrefs(15, 30,” “,” |”); echo “”;
echo “Pulse for post 86″; bstat_pulse(86, 200, 1, 0, 0); echo “”;
}
?>
This puts the stats I want on a single post page which I can easily access when I wish. Hope this is useful for someone.
My incoming search terms on the bsuite dashboard are linked to the wrong post, and 90% of my apparent traffic is reported as being direct home page hits, not traffic coming in via links or search. I’m using the Connections Reloaded theme. How can I diagnose this one?
WordPress database error: [Access denied for user 'yscr_bbSxLF'@'localhost' to database 'BlogStuff']
CREATE FULLTEXT INDEX bsuggestive ON wp_posts (post_content,post_title);
It’s too bad to, I’ve been running an earlier version on another blog for many months.
It might just be WP2.02, I had the same problem earlier today trying to install another stats-related plugin on this same new blog. I’ve been running the previous version of that one for months too.
Only then did I realize that I was running an old version of WP so I just updated to 2.05… go the same error message though.
@BillyG: the database user that WP connects with doesn’t have permission to create indexes. You can either elevate that user’s privileges or manually create the index using a db user that does have privs.
has the bstat_refsforpost() function got discontinued [ without notice??!! ]
i see the following in my b2v6 code (line 593):
//
// Display all search terms for a particular story
//
function bstat_refsforpost($post_id, $before, $after, $return = 0) {
}
// end function bstat_refsforpost
this function was the main reason why i am using bsite. i feel many others will be needing this function aswell. why is it being discontinued?
i have copied the function from the older version though. if any one needs the old code:
//
// Display all search terms for a particular story
//
function bstat_refsforpost($post_id, $before, $after, $return = 0) {
global $wpdb, $bsuite_tables, $tableposts;
$request = “SELECT ‘$post_id’ AS post_id, a.ref AS title, SUM(a.hits) AS sort_order, CONCAT(’ (’, SUM(a.hits), ‘)’) AS note
FROM $bsuite_tables[bstat_refs] a, $tableposts b
WHERE a.post_id = b.ID
AND issearchengine = 1
AND a.post_id = $post_id
GROUP BY a.ref
ORDER BY sort_order DESC
LIMIT 150
“;
if($return){
return(bstat_reporter($request, $before, $after, 1));
}else{
echo(bstat_reporter($request, $before, $after, 1));
}
}
// end function bstat_refsforpost
[tags]bsuite[/tags]
The bsuite graph covers up the basic WordPress stats just above the WordPress logo and part of the WP logo itself at the borrom of the Dashboard| bsuite page when viewed at 800 x 600. Unchecking both accurate and fuzzy does NOT seem to turn off the graph. I can live without that part - what it covers up is more useful to me. How do I disable the graph completely?
casey, your .imac bandwidth is full so I can’t download the bsuite. Thanks!
Hey - trying to download the suite and the link is dead. Anyplace else to get it?
Thanks,
Mark
[...] I currently use bsuite and Casey mentioned that a new and improved version is in the works. But what I really want is a way to track and correlate geographic data to post hits/views. I’d love the ability to cultivate a demographic profile based on usage data that I know exists somewhere out there. However as I am not a DB or PHP geek yet, I can’t code this myself. [...]
Hello.. After activating the plugin I do not see any new options tab ? Ther is only Akismet Configuration. Am I doing something wrong ?
pls discard my first comment (the option tab duh!)
I got the plugin to work and I think it’s simply brilliant. Thanks a lot !
Hi, Casey, I’m running WP 2.1.1 and SimpleTags along with bsuite … but I’m not getting the bsuggestive related posts offering. Is there still a conflicted between SimpleTags and bSuite?
Is there a pop call I can explicitly reference in my page file?
Regards,
Rich
BlogRodent
[tags]Tags SimpleTags bSuite Wordpress[/tags]
@Rich:
The “related posts” feature has to be turned on in Options > bsuite. It _should_ work with simpletags-style tags, though you may not want to run both at once.
[...] example, bsuite plugin can be used to track the blog post performance, inserts the search terms used by visitors [...]
I’ve implemented bsuite release b2v6 in wordpress v2.1.1.
It’s great! But, I am unable to see bsuggestive links of related posts. Is there any special configuration, other than the bsuggestive check box in option page of wordpress admin?
@newcomer:
In the released version that only works if you’ve tagged your posts.
Hi casey,
yes, i did read the instruction, and has each my post appended with technorati tags link rel=”tag”.
there are at least 2 posts with similar topic and exactly same rel=”tag” keyword. But, none of these 2 posts has “related posts” link.
please help.
Good day Casey,
I’m still not getting the related post links in my blog, that running wordpress 2.1.2. can you please help me to rectify?
Many thanks.
Hello. Can someone please help to get bsuggestive to work on my wordpress 2.1.2 version? I have embedded some technorati tags in bottom of each posts, for example something. In addition, I’ve enable the bsuggestive option in Wordpres option page as per instruction.
However, I am frustrated as the related post links are not seen. I am not sure I’ve did it wrongly, as I don’t see my post appears in technorati.com when I follow the tag i added for the post.
Many thanks,
walker
Hi ..
I downloaded the zip file yesterday and installed it to my blog which is WP ver 1.5.2 (I tried offline first via apache server installed in my laptop). Looked like the script failed to generate (create..) tables .. or something like that, while when I tried with WP 2.1.2 it worked like a charm..
Cheers, keep it up
I am having the same error as Dave (post number one) where I get a blank/white screen after activation of the bsuite plugin.
Had to remove bsuite from the plugin folder in order to get back into any WP screens.
I have WP version 2.1.2 with one other plugin running ok.
[tags]install bsuite blank[/tags]
Dude,
I have a couple fixes for your bsuite plugin, but I can’t find either a page for it, or your contact info. Get back to me so I can ship the plugin via e-mail.
[...] in late January when I ported my blog over to WordPress and began using my friend Casey’s bsuite plug-in, I ran into an issue involving excerpted entries on the index page and the inability to display [...]
[...] usage is unchanged from the last version. Among the things at the top of the list for bs3: [...]
[...] courtesy of bsuite (a neat wordpress plugin written by Casey, a friend and a colleague of [...]
[...] Visit [...]