Home › Forums › Legacy Support › Support queries › Setup issues › Multisite recommendations and considerations and known problems
- This topic has 95 replies, 3 voices, and was last updated 4 years, 4 months ago by ateya3d.
-
AuthorPosts
-
June 17, 2020 at 11:34 am #268847Anshuman SahuKeymasterOkay this is fixed at your website now ,please check and confirm . The issue was appearing because there were users deleted in your setup resulting in uneven count of usermeta umeta_id field . We have fixed that now please check it now .June 17, 2020 at 11:49 am #268857ateya3dSpectatorThanks Alex after we will finish this in the test website how will apply it to our main website ? is you must do the same modification in our database again ?June 18, 2020 at 1:36 pm #269149Anshuman SahuKeymasteryes you have to run the sync on the main website again to avoid any conflicts in migrating the database but first check this on test site check if students are showing their course status is correct or not before pushing to live .June 24, 2020 at 7:30 pm #270454ateya3dSpectatorHi Alex today for more than 45 day no any final solution , i don't know why ?? i re install a fresh copy mirror from my website again and copy your plugin after all your modification and now no any response just say Sync Now Starting ... please be more honestly with me can i get a permanent and final solution or no ??June 24, 2020 at 7:39 pm #270456ateya3dSpectator
[24-Jun-2020 19:19:22 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_product_id'), WP_Hook->apply_filters, vibe_course_max_students_check, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students, QM_DB->query [24-Jun-2020 19:19:22 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_button_extra'), WP_Hook->apply_filters, custom_vibe_course_button_students_extra, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students, QM_DB->query
June 24, 2020 at 7:49 pm #270457ateya3dSpectator[24-Jun-2020 19:44:33 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_product_id'), WP_Hook->apply_filters, vibe_course_max_students_check, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students [24-Jun-2020 19:44:33 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_button_extra'), WP_Hook->apply_filters, custom_vibe_course_button_students_extra, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students [24-Jun-2020 19:44:36 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_product_id'), WP_Hook->apply_filters, vibe_course_max_students_check, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students [24-Jun-2020 19:44:36 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_button_extra'), WP_Hook->apply_filters, custom_vibe_course_button_students_extra, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students
June 25, 2020 at 5:21 am #270488Anshuman SahuKeymasterPlease try replacing the " bp-course-template.php " file in your wp-content/plugins/vibe-course-module/includes folder with bp-course-template.php file given in this zipped file : https://wplms.io/support/wp-content/uploads/2020/06/bp-course-template.php_.zipJune 27, 2020 at 11:47 am #271151ateya3dSpectatornot solve the problem and not starting again alex can i get a final solution or NO ????????????June 27, 2020 at 1:30 pm #271190Anshuman SahuKeymasterWell this is brand new issue which you are getting here now with the plugin .Its a different bug . Please share your site url and admin credentials again along with cpanel creds to check the issue . Please also share on which page you are getting this error.June 29, 2020 at 8:20 am #271485ateya3dSpectatorThis reply has been marked as private.June 30, 2020 at 2:08 pm #271890Anshuman SahuKeymasterI asked for credentials again because it was not working yesterday . You did not share exactly where this error is appearing ? [24-Jun-2020 19:44:33 UTC] خطأ 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 'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta....' at line 1 في قاعدة بيانات ووردبريس للاستعلام select count(user_id) as number from wp_usermeta where meta_key = 'course_status34339'LEFT JOIN wp_blog_usermeta_map ON wp_blog_usermeta_map.meta_id = wp_usermeta.umeta_id WHERE wp_blog_usermeta_map.blog_id = 1 AND القادم من require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wplms/notitle.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, WPLMS_Page_Builder->show_builder_layout, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->new_column, do_shortcode, preg_replace_callback, do_shortcode_tag, WPLMS_Page_Builder->vibe_post_grid, thumbnail_generator, the_course_button, apply_filters('wplms_course_button_extra'), WP_Hook->apply_filters, custom_vibe_course_button_students_extra, bp_course_count_students_pursuing, BP_Course_Template->count_pursuing_students on the website ? Can you please tell exactly where this error is appearing on the website and is there something wrong on the front end due to this ?June 30, 2020 at 2:24 pm #271895ateya3dSpectatori have send to you the new credentials again and i copy to you the error and you can run with your self the Sync will see it's will not work and if you check the error log will see the errorsJuly 1, 2020 at 3:31 pm #272151Anshuman SahuKeymasterWell that sync is not working because there is no user data left to match . can you create a new copy of your main site to test as on your main site all data is mappe I checked the table in which usermeta is mapped . If you see the blog_usermeta_map table you will find the values there .July 1, 2020 at 4:04 pm #272162ateya3dSpectatorbut really this is a new copy of my main websiteJuly 2, 2020 at 5:20 am #272261Anshuman SahuKeymasterThis reply has been marked as private. -
AuthorPosts
- The topic ‘Multisite recommendations and considerations and known problems’ is closed to new replies.