error wp_eshop_option_names filed

every page in admin, or on the site?

does that table exist in your database?

The error occurs wille I chane the data in every (products) page.
In Dashboaard->pages->page at the bottom of the screen.

The wp_eshop_option_names doesn’t exist in my database.
Is this something new in this release?
In the old release eshop.5.0.4 when I intsalled didn’t have this table.
This is the first time I see it.

Also there are some errors whille I was installing the eshop.5.1.0.

The error on the screen is:

WordPress database error Unknown table ‘wp_eshop_states’ for query DROP TABLE wp_eshop_states made by activate_plugin, do_action, call_user_func_array, eshop_install, include creating table wp_eshop_states creating table wp_eshop_shipping_rates creating table wp_eshop_order_items creating table wp_eshop_orders creating table wp_eshop_stock creating table wp_eshop_downloads creating table wp_eshop_download_orders creating table wp_eshop_countries creating table wp_eshop_base_products creating table wp_eshop_discount_codes creating table wp_eshop_option_sets creating table wp_eshop_option_names WordPress database error BLOB/TEXT column ‘description’ can’t have a default value for query CREATE TABLE wp_eshop_option_names ( optid int(11) NOT NULL auto_increment, name varchar(255) NOT NULL default ”, type tinyint(1) NOT NULL default ‘0’, description TEXT NOT NULL DEFAULT ”, PRIMARY KEY (optid) ) DEFAULT CHARACTER SET utf8 made by activate_plugin, do_action, call_user_func_array, eshop_install, include, dbDelta creating table wp_eshop_emails WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic Paypal email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic Payson email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic Cash email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic ePN email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic webtopay email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic Authorize.net email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Field ’emailContent’ doesn’t have a default value for query INSERT INTO wp_eshop_emails (emailType,emailSubject) VALUES (‘Automatic iDeal Lite email’,’Your order from demo_eshop’) made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Table ‘wp_demo.wp_eshop_option_names’ doesn’t exist for query DESCRIBE wp_eshop_option_names made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Table ‘wp_demo_.wp_eshop_option_names’ doesn’t exist for query ALTER TABLE wp_eshop_option_names CHANGE description description TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error Table ‘wp_demo.wp_eshop_option_names’ doesn’t exist for query DESCRIBE wp_eshop_option_names made by activate_plugin, do_action, call_user_func_array, eshop_install, include WordPress database error BLOB/TEXT column ‘description’ can’t have a default value for query ALTER TABLE wp_eshop_option_names ADD description TEXT NOT NULL default ” made by activate_plugin, do_action, call_user_func_array, eshop_install, include

Hello Elfin.

I think I found the problem in eshop_install.php file.

Line 747 change this :description TEXT NOT NULL DEFAULT ”,
with this line: <backticks> description <backticks> TEXT NOT NULL,
and the problem with the error wp_eshop_option_names will be fixed.

The command <- Text Not Null -> cannot coexist with <- DEFAULT ”->

—————————-
(line 747)

$table = $wpdb->prefix . “eshop_option_names”;
if ($wpdb->get_var(“show tables like ‘$table'”) != $table) {
$sql = “CREATE TABLE “.$table.” (
optid int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default ”,
type tinyint(1) NOT NULL default ‘0’,
<backticks> description <backticks> TEXT NOT NULL,
PRIMARY KEY (optid)
) $charset_collate;”;
error_log(“creating table $table”);
dbDelta($sql);
}

I believe You know what is <backticks>.
This XHTML editor does not allow to print <backticks>.

Should this table start with optid int(11) NOT NULL auto_increment,
or with id int(11) NOT NULL auto_increment like every other table ?

Thank you.

You continually have issues with the install, and it appears to be you alone.

I have amended the description TEXT NOT NULL DEFAULT line for the next release.

Hello.

My guess is because I pay attention to the details.

About the <-TEXT-> I searched the internet and I found it cannot be together with <- DEFAULT -> when is combined with <- NOT NULL ->.

This was the reason the plugin couldn’t create the table to begin with.

All other errors is because there are many <- NOT NULL default ” -> entries with no data in the cells.

Thank you for the responce.

The new version 5.2.0 fixed the problem so far!

Thanks Elfin