My site admin struggles to load and it seems to be due to the error below following the 3.9 upgrade.
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE meta2.meta_key LIKE 'currency_23'
' at line 6 for query
SELECT count(*) as count
FROM wp_posts as posts
LEFT JOIN wp_postmeta as meta on posts.id = meta.post_id
LEFT JOIN wp_postmeta as meta2 on posts.id = meta2.post_id
WHERE meta.meta_key LIKE 'payout_23'
WHERE meta2.meta_key LIKE 'currency_23'
AND YEAR(posts.post_date_gmt) = YEAR(CURRENT_TIMESTAMP)
ORDER BY date ASC
LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Wplms_Commissions_API->get_instructor_payouts
Can you look into the possible cause and fix please
hi,
I have checked the thing in the file.
and noticed yes you are right there is a bug we will fix it. and give you an update for this plugin.
To fix this at your end please share your valid ftp credentials in private reply ,
This reply has been marked as private.
hi,
I have made changes in the file now check it please.
We have a slightly different error now but might be still related
[12-Mar-2020 20:55:16 UTC] WordPress database error Unknown column 'date' in 'order clause' for query
SELECT count(*) as count
FROM wp_posts as posts
LEFT JOIN wp_postmeta as meta on posts.id = meta.post_id
LEFT JOIN wp_postmeta as meta2 on posts.id = meta2.post_id
WHERE meta.meta_key LIKE 'payout_28'
AND meta2.meta_key LIKE 'currency_28'
AND YEAR(posts.post_date_gmt) = YEAR(CURRENT_TIMESTAMP)
ORDER BY date ASC
LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Wplms_Commissions_API->get_instructor_payouts
[12-Mar-2020 20:56:19 UTC] WordPress database error Unknown column 'date' in 'order clause' for query
SELECT count(*) as count
FROM wp_posts as posts
LEFT JOIN wp_postmeta as meta on posts.id = meta.post_id
LEFT JOIN wp_postmeta as meta2 on posts.id = meta2.post_id
WHERE meta.meta_key LIKE 'payout_28'
AND meta2.meta_key LIKE 'currency_28'
AND YEAR(posts.post_date_gmt) = YEAR(CURRENT_TIMESTAMP)
ORDER BY date ASC
LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Wplms_Commissions_API->get_instructor_payouts
ok we will be checking this on Monday.Please ping back for a reminder.
Can you follow up on this please
Hi we have fixed that too but we could not make that change in your site beccause ftps is not working .
Please share new credentials again to fix that .
I tested the FTP, same details are working. Can you retry please. You may want to type in password if copy isnt working
Made the changes in your file please check now .
Thanks Alex. No more database errors noted.
We are planning to upgrade MariaDB on the server to version 10+
Would that be a problem?
Since you made the change, when we create course, there is no Buy button on product page. Could that be a related issue?
Well we have not checked that yet but if wordpress supports that version then there wont be any problems.
Thanks Alex for all the help
.
