error: sorry we could not find this order

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts

5 October, 2015 at 7:26 pm #12979

Admin & Mod

if you receive this error (sorry we could not find this order) when ordering, the chances are, your mysql version is <5.5.
and the order table has not been created or is missing columns.

please see:
https://wordpress.org/plugins/wppizza/
and
https://wordpress.org/about/requirements/

for requirements.

therefore, first of all, please update your mysql version if this is the case.

once you have done so, the next time an update for wppizza is available, it will automatically create or alter the wppizza orders table as appropriate. (it would do the same of course when installing the plugin for the first time)

as of wppizza version 2.15.0.13+ the following will be available:

if there is no current update available to autocreate/alter the table but you have also carried out some work with the plugin – i.e do not want to re-install – goto :

wppizza->tools and enable/check “update order table”.

save.

this in turn will create the table if it does not exist yet or alter / add any missing columns.

again, before doing so, ensure you are using mysql 5.5+

3 December, 2015 at 3:38 pm #14313

Olly

Admin & Mod

if the above does still not create or alter the table, it is also possible that your database user does not have the credentials to do so.

Ideally you would give your your db user those permissions (though there are security implications associated with this, but also please read here http://codex.wordpress.org/Hardening_WordPress#Database_Security)

However, if this is not possible for some reason, you can also try to create the table manually using the following (via phpmyadmin for example)

replace wp_wppizza_orders below using your wordpress database prefix if you have changed it
so if your db prefix has been changed to abc_ it should be abc_wppizza_orders


/*--------sql create table ----------*/
CREATE TABLE wp_wppizza_orders (
id INT(10) NOT NULL AUTO_INCREMENT,
wp_user_id INT(10) NOT NULL DEFAULT '0',
order_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
order_update TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
customer_details TEXT NULL COLLATE 'utf8mb4_unicode_ci',
order_details MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
order_status ENUM('NEW','ACKNOWLEDGED','ON_HOLD','PROCESSED','DELIVERED','REJECTED','REFUNDED','OTHER') NOT NULL DEFAULT 'NEW' COLLATE 'utf8mb4_unicode_ci',
hash VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
order_ini MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
customer_ini TEXT NULL COLLATE 'utf8mb4_unicode_ci',
payment_status ENUM('INITIALIZED','COMPLETED','PENDING','REFUNDED','AUTHORIZED','FAILED','EXPIRED','INVALID','CANCELLED','OTHER','CAPTURED','COD','NOTAPPLICABLE') NULL DEFAULT 'COD' COLLATE 'utf8mb4_unicode_ci',
transaction_id VARCHAR(48) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
transaction_details TEXT NULL COLLATE 'utf8mb4_unicode_ci',
transaction_errors TEXT NULL COLLATE 'utf8mb4_unicode_ci',
initiator VARCHAR(32) NULL DEFAULT 'COD' COLLATE 'utf8mb4_unicode_ci',
mail_sent ENUM('Y','N','ERROR') NULL DEFAULT 'N' COLLATE 'utf8mb4_unicode_ci',
mail_error TEXT NULL COLLATE 'utf8mb4_unicode_ci',
notes TEXT NULL COLLATE 'utf8mb4_unicode_ci',
user_data TEXT NULL COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (id),
INDEX hash (hash),
INDEX wp_user_id (wp_user_id),
INDEX orderdate_paymentstatus (order_date, payment_status),
INDEX payment_status (payment_status),
INDEX transaction_id (transaction_id),
INDEX ident (hash, payment_status, initiator),
INDEX history (wp_user_id, order_date, payment_status),
INDEX paymentstatus_userid (payment_status, wp_user_id),
INDEX mail_sent (mail_sent)
)
COLLATE='utf8mb4_unicode_ci';

Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘error: sorry we could not find this order’ is closed to new replies.

WPPizza

error: sorry we could not find this order