Ikool’s Blogbed

How to view more than 7 days’ history data in wordpress.com

While blogging in your wordpress.com account, you may always want to check if your blog’s pageviews is increased or improved, what trend of blog is, where are the visitors coming from, which posts have better pageviews, and even search terms from search engine. I found referrer and search statistics are very useful, they are great hints to improve your blogs pageranks in search engines such as google, yahoo etc. But I was feeling hopeless to see only 7 days history data and then I found it’s a simple job to view more statistic data back to history ;-). This howto is about going beyond the limited history data (by default 7 days) to 9 days (seems it still doesn’t solve my issue though, but what can we do).

If you logged in and visit your wordpress stat page using this link http://<YOUR_USERNAME>.wordpress.com/wp-admin/index.php?page=stats or moving your mouse over your wordpress.com admin “My Account” menu and clicking stat, you will be presented with wodpress.com’s statistics page. There are 7 sections: Pageviews Graphs(daily, weekly and monthly), Referrers, Top Posts & Pages, Search Engine Terms, Clicks, Blog Stat and Incoming Links. We will see how to view more history data for Referrers, Top Posts & Pages, Search Engine Terms, Clicks.

As mentioned above, WordPress.com currently only displays 7 days history data for wordpress bloggers, but this limit can be modified through changing URLs on your browser’s location bar. Note the system currently only allows for a max of 9 days’ result to be returned and default to 7 days, here is how: Continue reading

Advertisements

July 10, 2008 Posted by | How Tos, Technology, Wordpress Tips | , , , | 1 Comment

Fix of unable to update Product details in WP e-commerce

After playing with WP e-commerce for sometime and fixing some issues (see Incorrect URLs for images, css and js files in Products page of WP e-commerce plugin, Fix of Settings menu on WP e-commerce’s Products admin page and Tips on display categories in WP ecommerce), I am able to display products and categories. But I also notice an issue which is users can’t really update product details such as product name, description, product tags, and price and stock control after a product is added.

Let’s take a look at what the issue is. If you check your apache log for your site, then you will notice there is an error message regarding the update SQL query statement used to update the product details as shown below:

[Tue Jun 18 12:11:34 2008] [error] [client IP-ADDRESS] WordPress database error Incorrect integer value: '' for column 'brand' at row 1 for query UPDATE `wp_product_list` SET `name` = '9113 - Retractable ball pen', `description` = 'Plastic retractable ball pen', `additional_description` = '', `price` = '0.70', `pnp` = '', `international_pnp` = '5', `brand` = '', quantity_limited = '0', `quantity` = '0', `special`='0', `special_price`='', `display_frontpage`='0', `notax`='1', `donation`='0', `no_shipping` = '0' WHERE `id`='1' LIMIT 1 made by include, referer: http://blog.sdu2.hyperion.com/wp-admin/admin.php?page=wp-e-commerce/display-items.php

The error specifically points out that database error Incorrect integer value: '' for column 'brand' Continue reading

June 24, 2008 Posted by | How Tos, Wordpress Tips, WP E-Commerce | , , , , | 11 Comments

Tips on display categories in WP ecommerce

There are a few ways to enable WordPress e-commerce plugin to display categories. Some of them are not so obvious to be noticed. Well, you have to bear with that since it’s open source world, what can you expect more. Most of the time we have to dig into the code to figure things out. And I am hoping my finding will help someone else out there. My environment (Windows XP, WordPress 2.5.1 and WP e-commerce 3.6.6) may be different from yours, therefore, the tips here may not apply to yours and you have to use your own judgement, but you may still learn something useful here though. Keep on reading.

Tip #1: Add [showcategories] to your post or page wherever you want it to go, WordPress engine will figure out how to replace this by the corresponding product category list

Tip #2: Calling nzshpcrt_display_categories_groups() function directly. This function is defined in products_page.php. There are a few references to it in this release. Here are:

wp-e-commerce\products_page.php(45): function nzshpcrt_display_categories_groups() {
wp-e-commerce\products_page.php(101): echo nzshpcrt_display_categories_groups();
wp-e-commerce\products_page.php(167): echo nzshpcrt_display_categories_groups();
wp-e-commerce\wp-shopping-cart.php(2015): $output = nzshpcrt_display_categories_groups();

Line numbers may be off a bit, so in this case you will need to just look around. It should not be a big problem

Tip #3: Calling show_cats_brands() directly. Well, this is the core to showing categories. You definitely need to take a look at this function if your changes won’t work. This function is defined in show_cats_brands.php, and here is the signature:

function show_cats_brands($category_group = null , $display_method = null, $order_by = 'name')

June 23, 2008 Posted by | How Tos, Wordpress Tips, WP E-Commerce | , , , , , | 8 Comments

Tips on inserting multiple media files to your post

After uploading multiple images/audios/videos In WordPress 2.5.1 while creating or editing a post/page, users can insert the whole gallery into the post/page. This tips is very useful when you want to upload a few images/audios/videos. Otherwise, you will have to insert each one of the uploaded images one by one by clicking the “Add Image/Video/Audio” button and a few other clicks. Well, here is how you can do that by just one click:

  • Start to write a new post or page, or edit an existing post/page
  • Click any one of “Add Media” buttons (Add an Image, Add Video, Add Audio and Add Media) which is located on the top of post/page editor
  • Upload multiple media files
  • After upload is done, click “Gallery” tab and scroll to the bottom, and press “insert gallery into post”
  • Or you can just close the upload window after completing upload, and add to your post or page

June 22, 2008 Posted by | How Tos, Wordpress Tips | , , , , | Leave a comment

Tips on uploading multiple media files in WordPress

In WordPress 2.5.1, users can upload multiple images/audios/videos. Here is how you can do it:

  • Start to write a new post or page, or edit an existing post/page
  • Click any one of “Add Media” buttons (Add an Image, Add Video, Add Audio and Add Media) which is located on the top of post/page editor
  • Make sure you have chosen “Flash uploader” instead of “Browser upload”.
  • Press “Choose files to upload” button to choose multiple files

June 22, 2008 Posted by | How Tos, Wordpress Tips | , , , | Leave a comment

Fix of Settings menu on WP e-commerce’s Products admin page

WP e-commerce plugin is a wonderful e-commerce plugin which enables WordPress to serve as a shopping site. However, you may notice there is a weird behavior on its Products admin page, the popup menu sitting behind the Product Details label after you press the Settings button as shown in this image

Here is how to fix the behavior:

Continue reading

June 18, 2008 Posted by | How Tos, Wordpress Tips, WP E-Commerce | , , | 3 Comments

Tips on speeding up WordPress Admin’s Dashboard

You may notice that WordPress shows error messages in your WordPress dashboard saying timeout if you host your own WordPress somewhere, that’s because your PHP socket timeout is set too low, mine is 60 secs which is big enough. You may also be aware that you don’t really look at them(Development blog, Incoming Links, Developers news, and WordPress plugins) most of the time. Originally I thought to just remove/comment out some of code related to dashboard but I recall there is a plugin which just does that for you. So I did a search in wordpress.org and found that it’s wordpress-dashboard-editor.

And I installed it and tried it, and it works fine. And I love it, thanks Aaron Harun for the great plugin, here is the description of this plugin:

This plugin allows you to add whatever you want to the WordPress dashboard through PHP and HTML even Sidebar Widgets. You can also wipe the entire dashboard or individually remove some of the more irritating sections like the Dev news, Planet WordPress and the getting started section.

Continue reading

June 15, 2008 Posted by | Wordpress Plugins, Wordpress Tips | , , , , , , , , , , , , | 1 Comment

Incorrect URLs for images, css and js files in Products page of WP e-commerce plugin

After adding a few products with photos to one of the newly defined categories and following the steps as stated in Tips on how to reset default category in WP e-commerce plugin’s admin panel, I am able to see the products listed in the page but none of them with the uploaded photos. This really puzzled me for a while, and I even debugged the code for sometime. However, it turns out e-commerce plugin producing incorrect URLs for images, css and js files included by the plugin, these URLs are in the format of system directory, such as C:\tools\wordpress-2.5.1\wp-content\….. Once the root cause of the issue is found, the fix is a bit easier.

Here I am providing the fixes so that folks who have the similar issues will benefit from it. Continue reading

June 15, 2008 Posted by | Technology, Wordpress Tips, WP E-Commerce | , , , , , , , , , | 23 Comments

Tips on speeding up load time of WP e-commerce plugin in Admin Panel

I have to say WP e-commerce solves a big problem for so many of us who want to set up an online shopping site. It’s so lovely to have it around. But I have to admit that accessing e-commerce menu in administration panel is a headache, especially when web server is on a slow network. Therefore, I try figuring out how to speed it up. Here is what I noticed:

  1. The plugin tries to load feeds from http://www.instinct.co.nz/feed by making the following call (display_log.php):

    You can just comment out this line if you want. This works for me in my development environment.

    Continue reading

June 14, 2008 Posted by | Wordpress Tips, WP E-Commerce | , , , , , , | 1 Comment

Compatibility issue of Thickbox and jQuery in WordPress when both NextGen Gallery and WP e-commerce present

Both jQuery and Thickbox have different versions, and WordPress and its plugins may use different versions of jQuery for different plugins since plugin engineers basically work on their parts without paying much attentions to others’. I checked my installation of WordPress 2.5.1 and it has jQuery 1.2.3 and Thickbox 3.1. However, when you install other plugins which might use a fairly new jQuery such as 1.2.4, what happens in this case is they conflict, some of the features may not work at all, such as Fix of issues with old version of jQuery in WordPress 2.5.1 when using FeedWordPress. In the case of having both NextGen Gallery and WP e-commerc, you may even see what I saw as depicted in this image. The problem gets even worse when the plugins are using Thickbox because different versions of Thickbox will only work perfectly with their corresponding versions of jQuery:

Continue reading

June 14, 2008 Posted by | Wordpress Plugins, Wordpress Tips, WP E-Commerce | , , , , , , , , | 9 Comments