AdventureRooms

Any more ideas for this issue? Our editors cannot log in ??

Indeed the tables listed in the warnings are missing in the database. But if these tables are important, I wonder why the site front-end is still working?

• This reply was modified 7 years, 11 months ago by AdventureRooms.

Thanks! I tried a manual update: I merged an up-to-date wordpress into the existing WP installation. It ended up in the same problem: During login I am forced to do a database update and this causes the same errors (tables missing) and finally all pages are gone.

The version before the auto update must have been 4.5.1.

Hi @kharisblank, I updated to the latest version of Sydney and still the lightbox did not work on video links in the portfolio, while image links in posts are working properly.

As a work-around I did now edit the source file of the portfolio section and added this parameter to the link: data-rel=”lightbox-0″

Althroug it’s not the most elegant solution, for now it works.

• This reply was modified 8 years, 3 months ago by AdventureRooms.

Any ideas?? Anyone?? ??

Hallo,

es gibt wohl auch keine M?glichkeit, z.B. über einen wp_options-Eintrag, den Button-Mod zu unterbinden?

VG

Hi und besten dank! Wir haben den Buttontext nun überschrieben via

function woocommerce_gzd_template_order_button_text( $text ) {
	return __( 'Bestellen und zahlen', 'theme-slug' );
}

Dieser Text erscheint aber nur, wenn JS deaktiviert ist, ansonsten überschreibt ein Script den Text abermals?

• This reply was modified 8 years, 6 months ago by AdventureRooms.

My current idea is to modify the query to something like this:

SELECT  parent_meta__order_total.meta_value as total_refund, parent_meta__order_shipping.meta_value as total_shipping, parent_meta__order_tax.meta_value as total_tax, parent_meta__order_shipping_tax.meta_value as total_shipping_tax, posts.post_date as post_date FROM wp410_posts AS posts INNER JOIN wp410_postmeta AS parent_meta__order_total ON (posts.post_parent = parent_meta__order_total.post_id) AND (parent_meta__order_total.meta_key = '_order_total') INNER JOIN wp410_postmeta AS parent_meta__order_shipping ON (posts.post_parent = parent_meta__order_shipping.post_id) AND (parent_meta__order_shipping.meta_key = '_order_shipping') INNER JOIN wp410_postmeta AS parent_meta__order_tax ON (posts.post_parent = parent_meta__order_tax.post_id) AND (parent_meta__order_tax.meta_key = '_order_tax') INNER JOIN wp410_postmeta AS parent_meta__order_shipping_tax ON (posts.post_parent = parent_meta__order_shipping_tax.post_id) AND (parent_meta__order_shipping_tax.meta_key = '_order_shipping_tax') LEFT JOIN wp410_posts AS parent ON posts.post_parent = parent.ID
			WHERE 	posts.post_type 	IN ( 'shop_order','shop_order_refund' )
			 AND parent.post_status IN ( 'wc-refunded')
			 AND 	meta__completed_date.meta_value >= '2016-07-01'
			 AND 	meta__completed_date.meta_value < '2016-08-01'
			 GROUP BY posts.post_parent

But something is still not working, the charts remain empty :-/

I did some research in the default reporting functions. It’s more tricky than I expected, cause the order date is just saved as the post date and the completed date is a meta in another DB table.

Here is something interesting I found out when duplicating our website for deploying a test environment.

After I connected the test site with PayPal sandbox, IPN did entirely stop to work (same server, same settings). So I started to debug and turned off the automatic redirect after payment and transmission of payment data in the PayPal account. This made IPN to work on my Sandbox.

So it seems to me the payment data transition causes some kind of mismatch between what is transmitted and what is the actual payment data. Maybe this is connected to our deposits plugin.

We still have this issue. I am currently in contact with the support of two of our plugins if the problem can be related to their code.

The next days I will clone our site and do some more testing with PayPal sandbox.

OK bad luck, even now the status change happens but no note is saved.

I think this is going to drive me nuts.

OK thanks! I did now lookup all status changes in the code of my plugins and added notes where they had none.. hope that will give me new information. ??

Hi Mike, even with no time limit for the stock, the issue persists, about 50% of the clients see a cancelled message after successfully completing PayPal.

The hosting told us that since PHP 5.3 (we use 5.4) the PHP time can be set per webspace with .htaccess or php.ini and that other clients successfully work with PayPal IPN on the same environment.

In the meantime I let the thankyou page send me an email with the $_SERVER array each time the error comes up. In the query string and redirect query string I can see st=Completed, is that of importance?

[REDIRECT_QUERY_STRING] => key=wc%5forder%5f56d87ed0d1147&utm_nooverride=1&tx=7XA1218886825791G&st=Completed&amt=140%2e00&cc=EUR&cm=%7b%22order%5fid%22%3a5123%2c%22order%5fkey%22%3a%22wc%5forder%5f56d87ed0d1147%22%7d&item_number=

If it’s not the stock hold time, what can I try next?
What can be the reason for wp_remote_post not to work?

Thanks, I will see if it makes a difference.

For now I can say that the timezone is correct (Berlin) and the server time is precisely in sync with the local ebay time.