Not being able to update correctly from 3.X to 4.X
-
Posts
-
-
Hi!
I’ve updated a website with learnpress installed. After the upgrade we see the message database needs to be updated, if we check we see all the steps in green, but even thought we try to it says invalid steps. We’ve already tried to deactivate all the other plugins and try again, but it’s not working.
Therefore we tried to do the update databased that it’s marked in case there’re problems updating, but after that all the woocommerce orders are overwritten and the postmeta data in the database deleted… So we had to restore it. We’ve tried in our production and staging server and both times with the same result. -
Hi Ester Serra,
With your problem, we need to access your admin page to check, can you provide me your website URL and your admin account? We will check the problem for you.
Note:
- When submitting your information, please use “access information”, see instruction here https://thimpress.com/knowledge-base/send-sites-access-information/
- And please back up your website before we do anything on your website.
Yours Sincerely,
Julia
———-
ThimPress Support Team
-
-
-
-
-
Hi!
It’s been more than a week and we don’t have the issue solved. We need to do a big WordPress update and until we don’t have it solved on staging we cannot do it on production.
We’ve seen that the database message has dissapear but now it’s not possible to access to the courses as well as we cannot create new orders -
-
Hi,
Yes it’s true you’ve fixed the error message but it’s still not working. As I mentioned before:
– Users with a course bought cannot access to the course. I’ve checked directly with production and it’s not working properly
– Not able to create orders directly from learnpress
And I also attach the next error: https://prnt.sc/oporSAZSvsXlhttps://prnt.sc/qDM98KShPwdm
https://prnt.sc/YyEt3ol4JYRT
https://prnt.sc/C3NZH3SWK7U2We understand that there’s a big update form v3.X to v4.X but this is really a mess. We’ll appreciate the plugin to work properly
-
I’ve forgot to upload the log errors:
27-Sep-2023 12:38:52 UTC] WordPress database error Unknown column ‘ui.graduation’ in ‘where clause’ for query SELECT DISTINCT (item_id) AS item_id FROM wp_learnpress_user_items AS ui
INNER JOIN wp_posts AS p ON p.ID = ui.item_id
WHERE 1=1 AND p.post_status = ‘publish’ AND ui.item_type = ‘lp_course’ AND ui.graduation = ‘in-progress’ AND ui.user_id = 3LIMIT 0, 12
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, WP_REST_Server->respond_to_request, LP_REST_Profile_Controller->course_tab, LP_Profile->query_courses, LP_User_Item_Course::get_user_courses, LP_User_Items_DB->get_user_courses, LP_Database->execute
[27-Sep-2023 12:38:52 UTC] WordPress database error Unknown column ‘ui.graduation’ in ‘where clause’ for query SELECT COUNT(ui.item_id) FROM (SELECT DISTINCT (item_id) AS item_id FROM wp_learnpress_user_items AS ui
INNER JOIN wp_posts AS p ON p.ID = ui.item_id
WHERE 1=1 AND p.post_status = ‘publish’ AND ui.item_type = ‘lp_course’ AND ui.graduation = ‘in-progress’ AND ui.user_id = 3) AS ui 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, WP_REST_Server->respond_to_request, LP_REST_Profile_Controller->course_tab, LP_Profile->query_courses, LP_User_Item_Course::get_user_courses, LP_User_Items_DB->get_user_courses, LP_Database->execute
[27-Sep-2023 12:38:52 UTC] get_user_courses: Unknown column ‘ui.graduation’ in ‘where clause’
[27-Sep-2023 12:38:52 UTC] PHP Fatal error: Uncaught TypeError: LP_Database::get_values_by_key(): Argument #1 ($arr_object) must be of type array, null given, called in /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-content/plugins/learnpress/inc/user/class-lp-profile.php on line 821 and defined in /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-content/plugins/learnpress/inc/databases/class-lp-db.php:782
Stack trace:
#0 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-content/plugins/learnpress/inc/user/class-lp-profile.php(821): LP_Database::get_values_by_key(NULL, ‘item_id’)
#1 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-content/plugins/learnpress/inc/rest-api/v1/frontend/class-lp-rest-profile-controller.php(382): LP_Profile->query_courses(‘purchased’, Array)
#2 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/rest-api/class-wp-rest-server.php(1188): LP_REST_Profile_Controller->course_tab(Object(WP_REST_Request))
#3 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/rest-api/class-wp-rest-server.php(1035): WP_REST_Server->respond_to_request(Object(WP_REST_Request), ‘/lp/v1/profile/…’, Array, NULL)
#4 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/rest-api/class-wp-rest-server.php(447): WP_REST_Server->dispatch(Object(WP_REST_Request))
#5 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/rest-api.php(418): WP_REST_Server->serve_request(‘/lp/v1/profile/…’)
#6 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/class-wp-hook.php(310): rest_api_loaded(Object(WP))
#7 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array)
#8 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/plugin.php(565): WP_Hook->do_action(Array)
#9 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/class-wp.php(398): do_action_ref_array(‘parse_request’, Array)
#10 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/class-wp.php(779): WP->parse_request(”)
#11 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-includes/functions.php(1335): WP->main(”)
#12 /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-blog-header.php(16): wp()
#13 /home/customer/www/emserra.com/public_html/desarrollo/meses/index.php(17): require(‘/home/customer/…’)
#14 {main}
thrown in /home/customer/www/emserra.com/public_html/desarrollo/meses/wp-content/plugins/learnpress/inc/databases/class-lp-db.php on line 782 -
-
-
Hi!
There are still some points:
1. When the user clicks on the course, is there any way that it’s redirected directly into the course intead of redirect the user to the course information page?
2. When we enter into a course we see the next: https://prnt.sc/JPCGqyhm3bLz
3. We need to do all you’ve done in production, how do you want to do that. We didn’t provide you the production accesses because we cannot have our customers without accessing to the courses for 2 weeks but the staging has not the customer data updated. Do you want to tell us what do we have to modify? Or do we have to open a new ticket for the production site? In this case we need to know the exact day when it will be performed. -
-
Hi,
The third point is not related to our theme, it’s related to the changes you’ve done to solve the issue. Could you please tell us what have you done in the website? Otherwise you’ll have to do again it on production, I’ll open a new ticket with exact the same issues with the production URL. But in this case we’ll not be able to wait 2 weeks to have the issue solved.
-
-
Hi,
What do you mean exactly? I’m sorry but we’re talking during 3 days and it seems we don’t understand each other.
Please read carefully all the thread. As you know, you’ve solved in our staging server (test server) some errors we had during the update, from one side the database message and for the other side the users permission problems. Now we need this errors to be solved on production, because we’re going to update there everything and these errors will happen again. Unfortunatelly in this case it’s on production and that means that legally we cannot wait 2 weeks to have the issue solved. This 2 weeks is the time it took to get the issue solved on staging.
For this reason I’m asking to know what your developers did in order to do it by ourselves or to have a guarantee to have this issue solved on a certain date on our production site.
Apart from that, there’s also an issue is not solved and it’s regarding point 2, we’ve changed the theme and the problem is still there, the sidebar for the courses is not loadin: https://prnt.sc/THKE62-yAvpV
-
-
-
-
I’m sorry but it’s still not working: https://prnt.sc/tYuLLJADjb2d
-
-
-
-
-
-
You must be logged in to reply to this topic. You can click here