Đã Đóng

Need custom Drupal 8 Module MySQL error fixed

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.

Kĩ năng: Drupal, HTML, MySQL, PHP

Xem nhiều hơn: custom drupal prices, need custom world press theme, capturing mysql error messages php, php capturing mysql error, mysql error 1054 cre loaded, custom drupal installation, need custom myspace layout ill pay, need custom myspace page, mysql error 2006 hy0000, custom drupal module, creating custom drupal module, custom drupal module development, custom drupal module cost, mysql error 144 fixed, develop custom drupal module, drupal smtp module gmail error, drupal custom content type module, need custom shipping module zen cart, module filter drupal 8

Về Bên Thuê:
( 12 nhận xét ) Victoria, Canada

ID dự án: #17465003

27 freelancer đang chào giá trung bình $151 cho công việc này

ambar

61 Join table can handle by the Mysql database. You getting "SQLSTATE[HY000]: General error: 1116 Too many tables" that means when the user selects the too many options that cross the max limit of joining of a table Thêm

$277 CAD trong 7 ngày
(253 Nhận xét)
9.1
sapotacorp

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,

$148 CAD trong 4 ngày
(992 Nhận xét)
8.7
mhanif

Do you have hosting cpanel access ? I will need phpmyadmin access as well as backend access. I can start working on this now.

$133 CAD trong 1 ngày
(195 Nhận xét)
7.0
sat12

i will fix the mysql issue in your drupal site...when more options selected that time it may showing this error.

$155 CAD trong 3 ngày
(394 Nhận xét)
6.9
Itblast

I am an impressive web developer with 8 years of experience. I am full time available to work upon your job. I can work 40+ hours in a week. I love to watch Hollywood Movies and I speak fluent English. I have excellent Thêm

$155 CAD trong 3 ngày
(48 Nhận xét)
6.2
nivasoftvietnam

STARTING AT $600USD/1MONTH FOR HIRING A SENIOR WEB DEVELOPER 160 WORK HOURS (AT $3.75/1HOUR). I am willing to do a trial for 5-7 work days and then you will choose to use my services or not. I am an IT offshoring/outso Thêm

$155 CAD trong 3 ngày
(44 Nhận xét)
5.4
siteexpert

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

$111 CAD trong 3 ngày
(33 Nhận xét)
5.4
Programmer59

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.

$150 CAD trong 3 ngày
(42 Nhận xét)
5.7
ProfSoftStudio

Greeting Thanks for invitation, I am ready to fix the issues please provide me site details Looking for yours response Thanks with regards

$155 CAD trong 3 ngày
(81 Nhận xét)
5.7
schoudhary1553

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Need custom Drupal 8 Module MySQL error fixed. I've delivered more than 400 + projects in the last 5 years and this mak Thêm

$250 CAD trong 4 ngày
(39 Nhận xét)
5.7
greenforest0204

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

$155 CAD trong 3 ngày
(29 Nhận xét)
5.2
rvtechsolution

Hello I am a front-end/back-end Drupal web designer/developer, with experience of building responsive themes in Bootstrap framework. I am ready to create custom Drupal 8 Module that compares users profile fie Thêm

$138 CAD trong 3 ngày
(43 Nhận xét)
5.3
techplusintl

Hi there, Greetings from TechPlus! I've reviewed requirements & ready to fix issues in drupal 8 quickly & economically as we have 5+ years experience in web development. {You'll need to pay only at completion Thêm

$150 CAD trong 3 ngày
(42 Nhận xét)
5.0
SRPTL

I have more than 10 years of professional development experience in Drupal and I have also developed lots of powerful custom Drupal modules for my clients.I hope i will also be the best candidate for your project as we Thêm

$100 CAD trong 1 ngày
(20 Nhận xét)
4.9
cma93

Hi, I'm an experienced developer. I would like to do it for you. I'm available so contact me anytime to get started........... Thanks.

$50 CAD trong 3 ngày
(15 Nhận xét)
4.6
levananikyan

Hi there. I am sure some part of the module should be rewritten to support update of multiple tables simultaneously. It is not couple minute fix. I will try to review the module and relatively quickly do required modi Thêm

$133 CAD trong 4 ngày
(8 Nhận xét)
4.8
mhowe

Hi there, I would be happy to fix the SQL error on your D8 site. I am a professional programmer/web developer from Ottawa, Canada and have years of experience building and maintaining websites for clients of all siz Thêm

$160 CAD trong 1 ngày
(2 Nhận xét)
3.8
achintyatech

Survin IT Solutions Pvt Ltd, has dedicated and experts team of professional developers and designers. Our motto is happy customers by giving the best quality of work within TAT. Survin is renowned in the market and Thêm

$222 CAD trong 7 ngày
(6 Nhận xét)
3.9
vpsbohra

Hello, I can surely create the custom Drupal 8 Module and fix the MySQL error according to the needs. Please feel free to contact me so that we can discuss the further project in details. ((((I'm an EXPERT DRUPAL Thêm

$155 CAD trong 3 ngày
(7 Nhận xét)
3.6
varyavega

Hello Hiring Manager, I read your job descriptions carefully; I am very interesting in your job. I have developed website & app such as Social networking & lifestyle (Tinder style dating, chatting, sharing), Foo Thêm

$201 CAD trong 3 ngày
(6 Nhận xét)
2.3