WordPress database error: [Duplicate key name 'group_idpos']
ALTER TABLE `wp_redirection_items` ADD INDEX `group_idpos` (`group_id`,`position`)

WordPress database error: [Duplicate key name 'group']
ALTER TABLE `wp_redirection_items` ADD INDEX `group` (`group_id`)

WordPress database error: [Duplicate key name 'group']
ALTER TABLE `wp_redirection_logs` ADD INDEX `group` (`group_id`)

WordPress database error: [Duplicate key name 'redirection_id']
ALTER TABLE `wp_redirection_logs` ADD INDEX `redirection_id` (`redirection_id`)

WordPress database error: [Duplicate key name 'created']
ALTER TABLE `wp_redirection_logs` ADD INDEX `created` (`created`)

WordPress database error: [Duplicate key name 'ip']
ALTER TABLE `wp_redirection_logs` ADD INDEX `ip` (`ip`)

WordPress database error: [Duplicate key name 'group_id']
ALTER TABLE `wp_redirection_logs` ADD INDEX `group_id` (`group_id`)

WordPress database error: [Duplicate key name 'module_id']
ALTER TABLE `wp_redirection_logs` ADD INDEX `module_id` (`module_id`)

WordPress database error: [Duplicate key name 'name']
ALTER TABLE `wp_redirection_modules` ADD INDEX `name` (`name`)

WordPress database error: [Duplicate key name 'type']
ALTER TABLE `wp_redirection_modules` ADD INDEX `type` (`type`)

WordPress database error: [Table 'wp_redirection_404' already exists]
CREATE TABLE `wp_redirection_404` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `created` datetime NOT NULL, `url` varchar(255) NOT NULL DEFAULT '', `agent` varchar(255) DEFAULT NULL, `referrer` varchar(255) DEFAULT NULL, `ip` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `created` (`created`), KEY `url` (`url`), KEY `ip` (`ip`,`id`), KEY `referrer` (`referrer`) ) DEFAULT CHARACTER SET utf8;

Auto-suggest Jquery plugin fix | SPACEBUG

Auto-suggest Jquery plugin fix

jquery

Jquery plugin is an upgrade and fix of a good looking Autosuggest Jquery plugin, originally written by Drew Wilson. It has the following improvements:

  1. Works well on IE 7, 8 and chrome as well as FireFox 2
  2. Provides a UI that uses the native textbox – so clicking “back” works more intuitively
  3. provide a single select option – a better fit to most website requirements
  4. provides CSS for small and large search boxes

Simple usage


$("input[type=text]").autoSuggest("http://somesite.com/path_to_script",
 {minChars: 2, matchCase: false});

Advance usage can be found in the original project page – be sure to access it with Chrome or FF3, otherwise that site does not show properly.

Demo

Demo of this plugin can be found here, really hard to miss the search box there.

Download

Source code can be found here:

Auto-suggest CSS

Auto-suggest Javascript