vasilissk

Helo Elfin.

Until this point I did numerus tests in paypal plugin and my results upon this point are:

If you change the <- $state-> variable to take the abbreviations instead of numbers, half of the problem will be solved.

The other half is to replace the <- $phone -> variable with the <- $night_phone_a -> variable and the other half problem will also be solved.

There are many parameters in paypal plugin and in yours too.

Just for you to know what I did, I wrote a small script and I inserted in paypal.php:

line <- 320 ->

$p->add_field(‘night_phone_a’, $_POST[‘phone’]);
function add_field($name, $value) {
$_POST[‘$name’] = $value;
}
This script allowed me to create a new copy from variable <- phone -> to <- night_phone_a ->, to convert the phone number.

I tried to do the same with the variable <- state -> but it didn’t work because the variable is the same and I couldn’t create a new $value over the same variable.
As a result the page was in loop because the state was missing.

So far so good.

For more information about paypal variables read:

https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/e_howto_html_Appx_websitestandard_htmlvariables

Thank you.

Hello again.

I read the code in html and the fields are not in the right order. The submition is in random order and at least 38 lines mixed up. Paypal excludes many entries because of incorect order.
Some of whom are not even approved commands form paypal.

Paypal.php and in paypal.class.php are packing the scrip but there are many errors about paypal’s virables.

For example: <- state” value=”11″ ->. The new paypal code does not allow number for the states. It needs to be abreviate.

Another: <- phone” value=”444-123-1234″ > it is today <- night_phone_a ->.

The correct order to submit to paypal in html for example is:

<input type=”hidden” name=”cmd” value=”_xclick”>
<input type=”hidden” name=”business” value=”[email protected]”>
<input type=”hidden” name=”item_name” value=”hat”>
<input type=”hidden” name=”item_number” value=”123″>
<input type=”hidden” name=”amount” value=”15.00″>
<input type=”hidden” name=”first_name” value=”John”>
<input type=”hidden” name=”last_name” value=”Do*”>
<input type=”hidden” name=”email” value=”[email protected]”>
<input type=”hidden” name=”address1″ value=”9 Street”>
<input type=”hidden” name=”address2″ value=”5″>
<input type=”hidden” name=”city” value=”Berwyn”>
<input type=”hidden” name=”state” value=”PA”>
<input type=”hidden” name=”zip” value=”19312″>
<input type=”hidden” name=”night_phone_a” value=”44444444444″>
<input type=”hidden” name=”night_phone_b” value=”555″>
<input type=”hidden” name=”night_phone_c” value=”1234″>

In case one of the lines change order the code will not pass to paypal correctly.

I need some help to find out how remove some unneseseraly enties.

Thank you.

Hello again.

I did debuging in eshop_products.php file and in line , <- 312 ->
there is this entry:

}else{
$available=’n/a’;
}

Repalce it with:

}else{
$stocktable=$wpdb->prefix .”eshop_stock”;
$available=’n/a’;
}

The reason is the value <- $available=’n/a’ -> cannot find Array
therefor when the Value is =”no” then the array loads first
<- $stocktable=$wpdb->prefix .”eshop_stock”; ->
and places in it the record.

Please add this in your next version.

Thank you.

Hello again.

From a closer look it looks that there is not any table with the name <- _eshop_featured -> in the database, because there is no any entry to create <- eshop_featured-> table in <- install.php -> file, in order to create entries “yes” or “” for the <- eshop_produts.php-> file.

There is create table <- _eshop_stock -> in install.php but there isn’t <- _eshop_featured ->.

Hmm…
I am thinking…
I guess I need your help.

Thank you.

The new version 5.2.0 fixed the problem so far!

Thanks Elfin

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.

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.

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>.

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

Well, I uninstalled and reinstalled the plugin and it works now.
But I lost all data items.
I have to re enter averything from the start ?? .
It should be a way to backup a portion of the data base before uninstall.

The Shipping rates takes only numbers. The report was cut and paste from the shipping rates screen page.

The url is:
http: //68. 225. 127. 246 /?page_id=85

Mr. You are very tricky.
I had all my images in as default thumbnails and I have to redo all the thubnails from scratch for each page from the begining.

I did use the “Set thumbnail” to ad a new thumbnail image in the post 100×100.

The image appears in the post, but it doesn’t appear in the “eshop > Products > Listing Images”, and also it doesn’t appear when I use the microcode:
[eshop_show_product id=’99’ class=’hilite’ imgsize=”50″ panels=’yes’ form=’yes’]