Have a custom D8 module that compares users profile field selections with fields in a content type (scholarships) and displays the scholarships that match their profile. Some of the fields are based on taxonomy selections and if the user selects a lot of them I am getting this error
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1116 Too many tables;
Looking for someone experienced with D8 & MySQL to fix this relatively quickly
Update to explain the issue better
User has a profile (profile module) that they select criteria for matching to scholarships. Some of these are list (text) based and some are taxonomy based.
Scholarships are a content type and have the same criteria as possible requirements.
The custom module matches students to scholarships by comparing their selected criteria with scholarships that match this criteria.
When doing the matching, the module only adds 1 join for each field that is text based no matter how many items in that field are selected. The taxonomy fields are adding multiple joins for every item selected in that field. So if 3 items are selected in the "activites" field then 6+ joins are added. This is causing the error to pop up when the joins max out at 61.
I believe the ideal solution would be to have the taxonomy joins act like text joins so they aren't adding multiple joins for each field.
27 freelancere byder i gennemsnit $151 på dette job
Dear statusws! We will provide you dedicated resources on the project. Our Drupal's projects: [login to view URL] Our latest Canada's projects: [login to view URL] Best regards,
I am expert in drupal. I got mainly reviews for drupal work. You may checked my reviews that are come for drupal work. I am expert to make custom module, So i can fix it. Kindly consider my bid. Thanks
Hello Sir! I have read all your description. I am interested in it and we have a team of experienced developers with 6 years of experience and I am waiting for your reply. Regards Jawad Ahmad.
hello i am very interested in your post project. i am sure i can give you good result in time. please call me dmitrii. looking forward your reply. best regards