Author Archive

Mysql Duplicate Entry

Posted on date Nov-24-2014 · by author  · comments Leave a Comment 

I developed AWS S3 CDN plugin which help users move their image, js, css, pdf… document to AWS S3, a friend request me install it on their site and do a little extra work, when I try to analyze their codes and settings in Mysql database, I found some issues:

mysql -uroot -p’*******’ –default-character-set=utf8 wp_prettys < /home/wp_prettys.sql

and the result is:

ERROR 1062 (23000) at line 527019: Duplicate entry ‘9733467’ for key 1
ERROR 1062 (23000) at line 734137: Duplicate entry ‘9841760’ for key 1
ERROR 1062 (23000) at line 760026: Duplicate entry ‘9871034’ for key 1
ERROR 1062 (23000) at line 967140: Duplicate entry ‘9912852’ for key 1

The database should have no these duplicate records and the database need some repair works, ofcourse we can still import the database from the sql like this;

mysql -uroot -p’*******’ –force –default-character-set=utf8 wp_prettys < /home/wp_prettys.sql

And then we can start works.

Tags :  

Young foreign women and men in the hospital

Posted on date Sep-28-2014 · by author  · comments Leave a Comment 

Just have a super busy week — my family have an operation in hospital, and I had to say the operation shake me, I just have a time to take a deep breath now.

When I in the hospital, I meet a couple of foreign women and men, the Man looks a little off-kilter, and the women have a scarf wrap the face, I say hello and help my family, for a little while, I heard the man said to me, hey, you translate for me, I find he stood beside the doctor and the doctor giving me a look, I go over and I found the doctor say the man need registration first and then she can put the ticket ID into the computer for next steps, and then the doctor give me a paper, I told the man and take him to the registration office, when waiting in the line of registration, I told the sad man, you can install a dictionary on your phone and shown your means in the dictionary, the man take out the phone and told me, I installed, but the cell phone has no electricity, I found his face is ashy, I do not know how to say, I think smile is the Esperanto in the world, then I think I have a way and I told him out of the hospital and at the right hand he can purchase a mobile phone charger. 🙂 When it is our turn in the line of registration, the official said this is just a prescription, she don’t know what need to do and use this can not finish a registration, I go back to the operation room with the man, then the doctor told me she has give a card to the man and use this card can finish the registration…, we come back to the registration office and my start to worry about my family because there have a long line and my family needing me, I came up to the front of the team and told the official, I had card now, this is a foreign friend, can we get this done first please? The kind woman look at me and say wait a moment, and another strong man put his brawny arms on my chest, 2 minutes later, I repeat my request again, the the kind woman said no hurry I am doing it for you, and then I get the registration form, we go back to the operating room and I start console and stroke my family, one hour later, I leave away the operating room with my family, I found the young man is still in the beside of the doctor, I feel a little strange and I said, Hi, are there any more thing I can help you? I found the smile like a flower blooming in his face at the time, he said no, thank you very much, I am very happy and I said loudly, hey, you are bro, and hold my family go out the room, when I come back I have a little regret that I should give some money to the man because I remember it seems I heard he mentioned he have no money, I have a super hard difficult period that I can only use $0.15 per day to struggling to survive and fortunately I survived, I know what will happen when you have no money in this age, I am sorry I was nervous and I was shocked by the operation, that’s the first time I witness the cruel operation, I hope the young woman have money and they are more luck now, we living in such an age, if a man have a temporary disaster, maybe he will lost all life and family, this is not right, we are human beings and we are in 21st century, we still can not build a social network that help people pull through from the disaster and let all people to live with dignity, as human beings, we be made as the same body but big guys told us we have so many differences and we have to waste so huge money because the big guys told us we are threat for each other, the cost can can build all nursing homes or hospital in the world, I am not your threat and you are not my threat, we are just passing traveller in this age and the world, we have the ability to build a more balanced world but we waste our resource for defense against each other…, our world have sick too and I hope we can cure it and make a better world — we have different views but we still can help each other, no matter rich or poor, we still can live with dignity, people have the same right for work hard to make his dream come true.

Undegined function mysql_pconnect error in my crawler

Posted on date Sep-21-2014 · by author  · comments Leave a Comment 

Help a good guy customized a crawler, it works good on my server, but after send the source code to him, he said the script can not work at all, it is strange, I asked access of his server and did a test, it really can not work!

I checked his error logs, in httpd logs, I found “call to undegined function mysql_pconnect”…, hmmmm…, he did not install php-mysql at all, yum install php-mysql, service httpd restart, all things works great. 🙂

So if you get the error of “mysql_pconnect”, you don’t hurry to test/debug your codes, try to check logs and it will guide to find the error, by the way, my friend is really a good guy, never do evil things, I respect him. 🙂

Tags :   ,

Search engine, Mysql, Ibdata1

Posted on date Sep-10-2014 · by author  · comments Leave a Comment 

Some months before I customized a search engine on my server and it works well, the problem is it “eat” each “G” on my VPS, last month I find a cheap server and move it to the new server, and then delete the database and busy for other things, today I decide to customize a new multi-user rss reader on my server because Google Reader was gone and new reader is too~~ooo slow and it can not get my fav rss, I am a heavy-customer of feeds, I need some keywords can be find out easier and can help me analyze the hidden rule in these amazing article so I can study more quickly, but when I installed my system on the VPS, I found the mysql is strange, I try to df -lh and du -a /var | sort -n -r | head -n 10, then I found a big guy — “Ibdata1” used my 80G, I vi /etc/my.cnf, added a line
innodb_file_per_table, then use mysqldump to dump all InnoDB tables, service mysqld stop, rm ib_logfile0, rm ib_logfile1, rm ib_logfile1, service mysqld start, reinstall my rss system, all things works well, and I can read my feeds quicker & easier now. 🙂 This is problem is because I use the InnoDB storage engine for my Search engine because its design follows the ACID model, with transactions featuring commit, rollback, crash-recovery,Row-level locking, but MyISAM do not support these features, but the trouble is the InnoDB design can not reclaim the space, I do not want to limit its size, so the only way is use innodb_file_per_table option and watching it per month and do some manually work to clean the Ibdata1 again, I think I need find a easier way to do this, it full of risk and it is waste my time, I always lost my sleeps and I want health, machine work for me, not I work for machine….

My WordPress Plugin: WP-Ecommerce Postcode Shipping

Posted on date Jan-26-2014 · by author  · comments 6 Comments 

By: epSos .de

Support Forum — WP-Ecommerce Support

My WordPress Plugin: WP-Ecommerce Postcode Shipping

Download link is here.

=== WP E-commerce Postcode Shipping Module ===
Contributors: zhuyi
Author URI:
Donate link:

Tags:wp e-commerce, shipping, postcode shipping, zipcode shipping, e-commerce, ecommerce, checkout, cart, shopping cart, calculator, postage, postcode, zipcode, region, rates, wordpress ecommerce, store, shipping rates
Requires at least: 2.0
Tested up to: 3.8
Stable tag: 1.0.0
License: GPLv2 or later
License URI:

WP E-commerce Postcode Shipping Module is a plugin which allows to calculate the shipping cost by postcode/zipcode.

== Description ==
Plugin Name: WP E-commerce Postcode Shipping Module<br>
Plugin Support URI:

This plugin provides postcode/zipcode shipping module for the WP E-Commerce system.

You can easily add postcode shipping in wp e-commerce shipping tab, on front end, when user go to checkout page, users can specify shipping location in “Calculate Shipping Price” box to calculate their shipping costs.

<h4>How To Use:</h4>
WP E-commerce Postcode Shipping Module is a simple & quick & light wp e-commerce postcode/zipcode solution, you can setting your postcode and shipping price at admin panel -> settings -> store ->shipping, you will find “postcode rate” in Shipping Modules, just setting your post code and shipping price and click update button, everyting is okay.

On front end, user will be asked to enter their postcode/zipcode in “Calculate Shipping Price” box to calculate their shipping costs, if you has set up this postcode and shipping price, our plugin will calculate the “Total Shipping” and add it to the “Total Price”, if there are a postcode which postcode entered by the customer that is not supported by your setting on the back end, the user will get the notification “Sorry, online ordering is unavailable to this destination and/or weight. Please double check your destination details”.

== Installation ==

1:Upload the WP E-commerce Postcode Shipping Module plugin to your wordpress
2:Activate it
3: setting your postcode and shipping price at admin panel -> settings -> store ->shipping, you will find “postcode rate” in Shipping Modules, just setting your post code and shipping price and click update button
That’s all

== Frequently Asked Questions ==
FAQs can be found here:

== Screenshots ==

1. Backend Postcode Shipping Setting
2. Front End Postcode Shipping Calculator
3. If you did not add this postcode at back end, users will get error notification
== Changelog ==

= Version 1.0.0 =
WP E-commerce Postcode Shipping Module Published

== Upgrade Notice ==
= Version 1.0.0 =
WP E-commerce Postcode Shipping Module Published

My Bbpress Plugin – Bbpress Notification

Posted on date Jan-21-2014 · by author  · comments 6 Comments 

Support Forum — BbPress Notification Plugin Support

I have a bbpress forum which have many users, I answer question of my users, a problem is in some days when I check my forum, there are no user questions and in some other days if I do not check my forum,  I found users have question and not solved in some days, this is a trouble for me and my users.

Finally I decide to develope a bbpress plugin to solve the communication problem, when user have new topic or when user replied a topic, as a webmaster, I will receive mail notification, I can get topic title, content, URL,  Autohor, and reply content, reply URL, reply author links and I will get a link to submit my reply via a URL so if I am busy and have no time in PC, I can reply that link via in my mobile mail link directly, so  my bbpress plugin — bbpress noficication born.

This is download link:

Any question is welceom, also you can submit your feature request in comment, thanks, have fun. 🙂


Best Regards,



How to avoid wordpress plugin functions break your theme after upgrade?

Posted on date Feb-21-2013 · by author  · comments 2 Comments 

Hi Friends,

A friend told me that he upgrade his plugin and then…, his wordpress theme shown something like this:

Fatal error: Call to undefined function functionname() in /home/somefolder/public_html/ wp-content/themes/mytheme/single.php on line 15

his site messed up and he do not know how this happened. I do a check for him and I found he hired a guy call a plugin’s function in his theme, and he have a good habit that always upgrade his plugin and theme to the newest version, but this time his plugin have a big change and the naked call function is not existed in the lasted plugin, so….

Dears, if you hope call a function form a plugin, please remember use this kind of method:

< ?php
if ( function_exists( 'yourfunctionname' ) ) {

So if this function do not existed, your theme will works normaly yet, is this helpful? Happy day.

Best Regards,

Contact Me

Posted on date Jan-05-2013 · by author  · comments 2 Comments 

  1. (required)
  2. (valid email required)
  3. (required)

cforms contact form by delicious:days

Tooltips Pro

Posted on date Jan-05-2013 · by author  · comments Leave a Comment 

According to users opinion, I had developed a wordpress tooltips pro version, this version added all new features which users wanting, please check this wordpress tooltips pro feature list:

  • Quick load speed:everything is CSS, no image are used.
  • Easy to use: Dim-witted system, all things just need 5 seconds, you don’t need to edit older posts because tooltips works automatically, just input the content in tooltip management page one time and it will works on all articles automatically, this is really cool if you have an older blog with lots of articles.
  • Show any content in tooltip box: video, audio/song, image/photo, advertising, links/text, show tooltips for nextgen gallery,Show tooltips on image,Show tooltips on button…
  • Any post types and pages supported.
  • Multi language/UTF8 supported: supports any alphabets/language.
  • 7 preset stylesheet and beautiful color schemes: White, Blue, Light, Dark, Red, Cream, Green.
  • Customize tooltip box: You can customization whole stylesheet in customization panel or css file easily, you can set any color, opacity, width, show method, hidden method… for tooltip box.
  • Multi trigger method: You can select show/hidden your tooltips when: Mouse Over, Double Click, Click, Mouse Leave, Mouse Enter, Mouse Out, Mouse Move, Mouse Up, Mouse Down.
  • Multi positioning options: bottomRight, bottomLeft, topRight, topLeft, topMiddle, bottomMiddle, rightMiddle, leftMiddle
    Automatic positioning: tooltip position is calculated automatically.
    Unlimited number of tooltips.
  • Multi browsers supported: Internet Explorer 7+, Firefox 3+, Google Chrome 4+, Opera 9+, Safari 4+.
  • Easy to install: this is a Dim-witted system,no complex settings on back end,you do not need add any php code in your wp, you do not need to remember or insert any short code in posts, you do not need to change any css code, what you need to do is just active it and it will works well automatically, if you hope more customization features please just click your mouse and everything will be okay.
  • Detailed documentation.
  • Assign tooltip to keywords: tooltip will be displayed for these keywords.
  • User-friendly: pretty dotted keywords will catch your readers eye and keep the style of your site and not harass your readers.
  • Mobile devices supported: our tooltip works well on Android, iOS,Tablet and other mobile devices.
  • Easy to use: you don’t need to edit older posts because tooltips works automatically, just input the content in tooltip management page one time and it will works on all articles automatically, this is really cool if you have an older blog with lots of articles.
  • You can find a demo at this page: Tooltips Demo

    More amazing features are being developed and you can upgrade unlimited.

How to add the image INTO the tooltip?

Posted on date Jun-21-2012 · by author  · comments 2 Comments 

Doug ask me a question:

Hi Khan and Tomas,

Did you figure out a way to add the image INTO the tooltip? That’s what I’m trying to do as well.



actually it is very easy, just like this screenshot:

in yourdomain/wp-admin/admin.php?page=tooltipsfunctions.php, add your “keyword” and add your image like this: <img src=’’>

everything will be okay, check and move mouse to the tooltips “Fixed the bug”, you will find a image tooltip shown, have a happy day. 🙂


Best Regards,