Lukket

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.

Evner: Drupal, HTML, MySQL, PHP

Se mere: 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

Om arbejdsgiveren:
( 12 bedømmelser ) Victoria, Canada

Projekt ID: #17465003

27 freelancere byder i gennemsnit $151 på dette job

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 Flere

$277 CAD in 7 dage
(253 bedømmelser)
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 in 4 dage
(992 bedømmelser)
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 på 1 dag
(195 bedømmelser)
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 in 3 dage
(394 bedømmelser)
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 Flere

$155 CAD in 3 dage
(48 bedømmelser)
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 Flere

$155 CAD in 3 dage
(44 bedømmelser)
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 in 3 dage
(33 bedømmelser)
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 in 3 dage
(42 bedømmelser)
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 in 3 dage
(81 bedømmelser)
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 Flere

$250 CAD in 4 dage
(39 bedømmelser)
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 in 3 dage
(29 bedømmelser)
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 Flere

$138 CAD in 3 dage
(43 bedømmelser)
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 Flere

$150 CAD in 3 dage
(42 bedømmelser)
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 Flere

$100 CAD på 1 dag
(20 bedømmelser)
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 in 3 dage
(15 bedømmelser)
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 Flere

$133 CAD in 4 dage
(8 bedømmelser)
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 Flere

$160 CAD på 1 dag
(2 bedømmelser)
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 Flere

$222 CAD in 7 dage
(6 bedømmelser)
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 Flere

$155 CAD in 3 dage
(7 bedømmelser)
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 Flere

$201 CAD in 3 dage
(6 bedømmelser)
2.3