Table '****.help' doesn't exist

On a fresh frappe install (sudo python install.py --production) entering random keyword like something into search bar causes an exception:

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 62, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 22, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 53, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 939, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py", line 30, in get_help
    return HelpDatabase().search(text)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/help.py", line 104, in search
    select title, intro, path from help where match(content) against (%s) limit 10''', ('%'+words+'%', words))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 166, in sql
    self._cursor.execute(query, values)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 165, in execute
    result = self._query(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 860, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1061, in _read_query_result
    result.read()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1349, in read
    first_packet = self.connection._read_packet()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1018, in _read_packet
    packet.check_error()
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
    err.raise_mysql_exception(self._data)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
    raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table '1bd3e0294da19198.help' doesn't exist")

OS: Debian GNU/Linux 8.10 (jessie)
ERPNext: v10.0.6 (master)
Frappe Framework: v10.0.7 (master)

+----------------------------------------+
| Tables_in_1bd3e0294da19198             |
+----------------------------------------+
| __Auth                                 |
| __UserSettings                         |
| __global_search                        |
| tabAbout Us Team Member                |
| tabAcademic Term                       |
| tabAcademic Year                       |
| tabAccount                             |
| tabActivity Cost                       |
| tabActivity Log                        |
| tabActivity Type                       |
| tabAddress                             |
| tabAddress Template                    |
| tabAgriculture Analysis Criteria       |
| tabAgriculture Task                    |
| tabAntibiotic                          |
| tabAppointment Type                    |
| tabAppraisal                           |
| tabAppraisal Goal                      |
| tabAppraisal Template                  |
| tabAppraisal Template Goal             |
| tabAssessment Criteria                 |
| tabAssessment Criteria Group           |
| tabAssessment Group                    |
| tabAssessment Plan                     |
| tabAssessment Plan Criteria            |
| tabAssessment Result                   |
| tabAssessment Result Detail            |
| tabAsset                               |
| tabAsset Category                      |
| tabAsset Category Account              |
| tabAsset Maintenance                   |
| tabAsset Maintenance Log               |
| tabAsset Maintenance Task              |
| tabAsset Maintenance Team              |
| tabAsset Movement                      |
| tabAsset Repair                        |
| tabAttendance                          |
| tabAuthorization Rule                  |
| tabAuto Email Report                   |
| tabBOM                                 |
| tabBOM Explosion Item                  |
| tabBOM Item                            |
| tabBOM Operation                       |
| tabBOM Scrap Item                      |
| tabBOM Website Item                    |
| tabBOM Website Operation               |
| tabBank Guarantee                      |
| tabBank Reconciliation Detail          |
| tabBatch                               |
| tabBin                                 |
| tabBlock Module                        |
| tabBlog Category                       |
| tabBlog Post                           |
| tabBlogger                             |
| tabBranch                              |
| tabBrand                               |
| tabBudget                              |
| tabBudget Account                      |
| tabC-Form                              |
| tabC-Form Invoice Detail               |
| tabCalendar View                       |
| tabCampaign                            |
| tabChapter                             |
| tabChapter Member                      |
| tabCheque Print Template               |
| tabCodification Table                  |
| tabCommunication                       |
| tabCompany                             |
| tabCompany History                     |
| tabComplaint                           |
| tabConsultation                        |
| tabContact                             |
| tabCost Center                         |
| tabCountry                             |
| tabCourse                              |
| tabCourse Assessment Criteria          |
| tabCourse Schedule                     |
| tabCrop                                |
| tabCrop Cycle                          |
| tabCurrency                            |
| tabCurrency Exchange                   |
| tabCustom DocPerm                      |
| tabCustom Field                        |
| tabCustom Role                         |
| tabCustom Script                       |
| tabCustomer                            |
| tabCustomer Group                      |
| tabCustomize Form Field                |
| tabCustoms Tariff Number               |
| tabDaily Work Summary                  |
| tabDaily Work Summary Settings Company |
| tabData Import                         |
| tabData Migration Connector            |
| tabData Migration Mapping              |
| tabData Migration Mapping Detail       |
| tabData Migration Plan                 |
| tabData Migration Plan Mapping         |
| tabData Migration Run                  |
| tabDefaultValue                        |
| tabDeleted Document                    |
| tabDelivery Note                       |
| tabDelivery Note Item                  |
| tabDelivery Stop                       |
| tabDelivery Trip                       |
| tabDepartment                          |
| tabDependent Task                      |
| tabDepreciation Schedule               |
| tabDesignation                         |
| tabDesktop Icon                        |
| tabDetected Disease                    |
| tabDiagnosis                           |
| tabDisease                             |
| tabDocField                            |
| tabDocPerm                             |
| tabDocShare                            |
| tabDocType                             |
| tabDomain                              |
| tabDonor                               |
| tabDonor Type                          |
| tabDosage Form                         |
| tabDosage Strength                     |
| tabDriver                              |
| tabDriving License Category            |
| tabDrug Prescription                   |
| tabDynamic Link                        |
| tabEmail Account                       |
| tabEmail Alert                         |
| tabEmail Alert Recipient               |
| tabEmail Digest                        |
| tabEmail Domain                        |
| tabEmail Flag Queue                    |
| tabEmail Group                         |
| tabEmail Group Member                  |
| tabEmail Queue                         |
| tabEmail Queue Recipient               |
| tabEmail Rule                          |
| tabEmail Unsubscribe                   |
| tabEmployee                            |
| tabEmployee Advance                    |
| tabEmployee Education                  |
| tabEmployee External Work History      |
| tabEmployee Internal Work History      |
| tabEmployee Leave Approver             |
| tabEmployee Loan                       |
| tabEmployee Loan Application           |
| tabEmployment Type                     |
| tabError Log                           |
| tabError Snapshot                      |
| tabEvent                               |
| tabExpense Claim                       |
| tabExpense Claim Account               |
| tabExpense Claim Advance               |
| tabExpense Claim Detail                |
| tabExpense Claim Type                  |
| tabFee Category                        |
| tabFee Component                       |
| tabFee Schedule                        |
| tabFee Schedule Program                |
| tabFee Schedule Student Group          |
| tabFee Structure                       |
| tabFee Validity                        |
| tabFeedback Request                    |
| tabFeedback Trigger                    |
| tabFees                                |
| tabFertilizer                          |
| tabFertilizer Content                  |
| tabFile                                |
| tabFiscal Year                         |
| tabFiscal Year Company                 |
| tabFooter Item                         |
| tabGL Entry                            |
| tabGST HSN Code                        |
| tabGSuite Templates                    |
| tabGender                              |
| tabGrading Scale                       |
| tabGrading Scale Interval              |
| tabGrant Application                   |
| tabGuardian                            |
| tabGuardian Interest                   |
| tabGuardian Student                    |
| tabHas Domain                          |
| tabHas Role                            |
| tabHelp Article                        |
| tabHelp Category                       |
| tabHoliday                             |
| tabHoliday List                        |
| tabHomepage Featured Product           |
| tabHub Category                        |
| tabIndustry Type                       |
| tabInstallation Note                   |
| tabInstallation Note Item              |
| tabInstructor                          |
| tabInstructor Log                      |
| tabIntegration Request                 |
| tabInterest                            |
| tabIssue                               |
| tabIssue Type                          |
| tabItem                                |
| tabItem Attribute                      |
| tabItem Attribute Value                |
| tabItem Customer Detail                |
| tabItem Group                          |
| tabItem Price                          |
| tabItem Quality Inspection Parameter   |
| tabItem Reorder                        |
| tabItem Supplier                       |
| tabItem Tax                            |
| tabItem Variant                        |
| tabItem Variant Attribute              |
| tabItem Website Specification          |
| tabJob Applicant                       |
| tabJob Opening                         |
| tabJournal Entry                       |
| tabJournal Entry Account               |
| tabKanban Board                        |
| tabKanban Board Column                 |
| tabLab Prescription                    |
| tabLab Test                            |
| tabLab Test Groups                     |
| tabLab Test Sample                     |
| tabLab Test Template                   |
| tabLab Test UOM                        |
| tabLand Unit                           |
| tabLanded Cost Item                    |
| tabLanded Cost Purchase Receipt        |
| tabLanded Cost Taxes and Charges       |
| tabLanded Cost Voucher                 |
| tabLanguage                            |
| tabLead                                |
| tabLead Source                         |
| tabLeave Allocation                    |
| tabLeave Application                   |
| tabLeave Block List                    |
| tabLeave Block List Allow              |
| tabLeave Block List Date               |
| tabLeave Type                          |
| tabLetter Head                         |
| tabLinked Land Unit                    |
| tabLinked Plant Analysis               |
| tabLinked Soil Analysis                |
| tabLinked Soil Texture                 |
| tabLoan Type                           |
| tabMaintenance Schedule                |
| tabMaintenance Schedule Detail         |
| tabMaintenance Schedule Item           |
| tabMaintenance Team Member             |
| tabMaintenance Visit                   |
| tabMaintenance Visit Purpose           |
| tabManufacturer                        |
| tabMaterial Request                    |
| tabMaterial Request Item               |
| tabMedical Code                        |
| tabMedical Code Standard               |
| tabMedical Department                  |
| tabMember                              |
| tabMembership                          |
| tabMembership Type                     |
| tabMode of Payment                     |
| tabMode of Payment Account             |
| tabModule Def                          |
| tabMonthly Distribution                |
| tabMonthly Distribution Percentage     |
| tabNewsletter                          |
| tabNewsletter Email Group              |
| tabNormal Test Items                   |
| tabNormal Test Template                |
| tabNote                                |
| tabNote Seen By                        |
| tabOAuth Authorization Code            |
| tabOAuth Bearer Token                  |
| tabOAuth Client                        |
| tabOffer Letter                        |
| tabOffer Letter Term                   |
| tabOffer Term                          |
| tabOpening Invoice Creation Tool Item  |
| tabOperation                           |
| tabOpportunity                         |
| tabOpportunity Item                    |
| tabOpportunity Type                    |
| tabPOS Customer Group                  |
| tabPOS Item Group                      |
| tabPOS Profile                         |
| tabPOS Profile User                    |
| tabPacked Item                         |
| tabPacking Slip                        |
| tabPacking Slip Item                   |
| tabPage                                |
| tabParty Account                       |
| tabParty Type                          |
| tabPatch Log                           |
| tabPatient                             |
| tabPatient Appointment                 |
| tabPatient Medical Record              |
| tabPatient Relation                    |
| tabPayment Entry                       |
| tabPayment Entry Deduction             |
| tabPayment Entry Reference             |
| tabPayment Gateway                     |
| tabPayment Gateway Account             |
| tabPayment Reconciliation Invoice      |
| tabPayment Reconciliation Payment      |
| tabPayment Request                     |
| tabPayment Schedule                    |
| tabPayment Term                        |
| tabPayment Terms Template              |
| tabPayment Terms Template Detail       |
| tabPayroll Employee Detail             |
| tabPayroll Entry                       |
| tabPeriod Closing Voucher              |
| tabPhysician                           |
| tabPhysician Schedule                  |
| tabPhysician Schedule Time Slot        |
| tabPlant Analysis                      |
| tabPlant Analysis Criteria             |
| tabPortal Menu Item                    |
| tabPrescription Dosage                 |
| tabPrescription Duration               |
| tabPrice List                          |
| tabPrice List Country                  |
| tabPricing Rule                        |
| tabPrint Format                        |
| tabPrint Heading                       |
| tabPrint Style                         |
| tabProduct Bundle                      |
| tabProduct Bundle Item                 |
| tabProduction Order                    |
| tabProduction Order Item               |
| tabProduction Order Operation          |
| tabProduction Plan Item                |
| tabProduction Plan Material Request    |
| tabProduction Plan Sales Order         |
| tabProgram                             |
| tabProgram Course                      |
| tabProgram Enrollment                  |
| tabProgram Enrollment Course           |
| tabProgram Enrollment Fee              |
| tabProgram Enrollment Tool Student     |
| tabProgram Fee                         |
| tabProject                             |
| tabProject Task                        |
| tabProject Type                        |
| tabProject User                        |
| tabProperty Setter                     |
| tabPurchase Invoice                    |
| tabPurchase Invoice Advance            |
| tabPurchase Invoice Item               |
| tabPurchase Order                      |
| tabPurchase Order Item                 |
| tabPurchase Order Item Supplied        |
| tabPurchase Receipt                    |
| tabPurchase Receipt Item               |
| tabPurchase Receipt Item Supplied      |
| tabPurchase Taxes and Charges          |
| tabPurchase Taxes and Charges Template |
| tabQuality Inspection                  |
| tabQuality Inspection Reading          |
| tabQuotation                           |
| tabQuotation Item                      |
| tabQuotation Lost Reason               |
| tabRepayment Schedule                  |
| tabReport                              |
| tabRequest for Quotation               |
| tabRequest for Quotation Item          |
| tabRequest for Quotation Supplier      |
| tabRestaurant                          |
| tabRestaurant Menu                     |
| tabRestaurant Menu Item                |
| tabRestaurant Order Entry Item         |
| tabRestaurant Reservation              |
| tabRestaurant Table                    |
| tabRole                                |
| tabRole Profile                        |
| tabRoom                                |
| tabSMS Log                             |
| tabSMS Parameter                       |
| tabSalary Component                    |
| tabSalary Component Account            |
| tabSalary Detail                       |
| tabSalary Slip                         |
| tabSalary Slip Loan                    |
| tabSalary Slip Timesheet               |
| tabSalary Structure                    |
| tabSalary Structure Employee           |
| tabSales Invoice                       |
| tabSales Invoice Advance               |
| tabSales Invoice Item                  |
| tabSales Invoice Payment               |
| tabSales Invoice Timesheet             |
| tabSales Order                         |
| tabSales Order Item                    |
| tabSales Partner                       |
| tabSales Person                        |
| tabSales Taxes and Charges             |
| tabSales Taxes and Charges Template    |
| tabSales Team                          |
| tabSalutation                          |
| tabSample Collection                   |
| tabSchool House                        |
| tabSensitivity                         |
| tabSensitivity Test Items              |
| tabSerial No                           |
| tabSeries                              |
| tabSessions                            |
| tabSetup Progress Action               |
| tabShipping Rule                       |
| tabShipping Rule Condition             |
| tabShipping Rule Country               |
| tabSingles                             |
| tabSoil Analysis                       |
| tabSoil Analysis Criteria              |
| tabSoil Texture                        |
| tabSoil Texture Criteria               |
| tabSpecial Test Items                  |
| tabSpecial Test Template               |
| tabStandard Reply                      |
| tabStock Entry                         |
| tabStock Entry Detail                  |
| tabStock Ledger Entry                  |
| tabStock Reconciliation                |
| tabStock Reconciliation Item           |
| tabStudent                             |
| tabStudent Admission                   |
| tabStudent Admission Program           |
| tabStudent Applicant                   |
| tabStudent Attendance                  |
| tabStudent Batch Name                  |
| tabStudent Category                    |
| tabStudent Group                       |
| tabStudent Group Creation Tool Course  |
| tabStudent Group Instructor            |
| tabStudent Group Student               |
| tabStudent Guardian                    |
| tabStudent Language                    |
| tabStudent Leave Application           |
| tabStudent Log                         |
| tabStudent Sibling                     |
| tabStudent Siblings                    |
| tabSubscription                        |
| tabSupplier                            |
| tabSupplier Quotation                  |
| tabSupplier Quotation Item             |
| tabSupplier Scorecard                  |
| tabSupplier Scorecard Criteria         |
| tabSupplier Scorecard Period           |
| tabSupplier Scorecard Scoring Criteria |
| tabSupplier Scorecard Scoring Standing |
| tabSupplier Scorecard Scoring Variable |
| tabSupplier Scorecard Standing         |
| tabSupplier Scorecard Variable         |
| tabSupplier Type                       |
| tabTag                                 |
| tabTag Category                        |
| tabTag Doc Category                    |
| tabTarget Detail                       |
| tabTask                                |
| tabTask Depends On                     |
| tabTax Rule                            |
| tabTerms and Conditions                |
| tabTerritory                           |
| tabTimesheet                           |
| tabTimesheet Detail                    |
| tabToDo                                |
| tabTop Bar Item                        |
| tabTraining Event                      |
| tabTraining Event Employee             |
| tabTraining Feedback                   |
| tabTraining Program                    |
| tabTraining Result                     |
| tabTraining Result Employee            |
| tabTranslation                         |
| tabUOM                                 |
| tabUOM Conversion Detail               |
| tabUnhandled Email                     |
| tabUser                                |
| tabUser Email                          |
| tabUser Permission                     |
| tabVariant Field                       |
| tabVehicle                             |
| tabVehicle Log                         |
| tabVehicle Service                     |
| tabVersion                             |
| tabVital Signs                         |
| tabVolunteer                           |
| tabVolunteer Skill                     |
| tabVolunteer Type                      |
| tabWarehouse                           |
| tabWarranty Claim                      |
| tabWater Analysis                      |
| tabWater Analysis Criteria             |
| tabWeather                             |
| tabWeather Parameter                   |
| tabWeb Form                            |
| tabWeb Form Field                      |
| tabWeb Page                            |
| tabWebhook                             |
| tabWebhook Data                        |
| tabWebhook Header                      |
| tabWebsite Item Group                  |
| tabWebsite Sidebar                     |
| tabWebsite Sidebar Item                |
| tabWebsite Slideshow                   |
| tabWebsite Slideshow Item              |
| tabWebsite Theme                       |
| tabWorkflow                            |
| tabWorkflow Action                     |
| tabWorkflow Document State             |
| tabWorkflow State                      |
| tabWorkflow Transition                 |
| tabWorkstation                         |
| tabWorkstation Working Hour            |
+----------------------------------------+

try a bench update

1 Like

Try

bench migrate

Refer to [solved] I got error message alot Table ‘efc88b4f1234143c.help’ doesn’t exist

Alternatively, try

bench setup-help
1 Like

bench setup-help solved the issue.

FYI

bench update causes an error, see LINK.

2 Likes

Hello aleksas,

Do you run setup-help on the frappe folder or there is a site reference?

Thanks

Sorry for not updating on the issue. Haven’t encountered it in a while - at least did two-three fresh installs since last encounter. I consider issue to be resolved.

I had the same issue every time I reinstalled ERPNext yesterday, using the easy install script with the --production flag. I had to run bench --site {SITE} setup-help to fix it.

I wouldn’t mark this issue as resolved yet.

Sure, if issue persists then it should still be kept open. It may be that I’m so used to this issue I don’t even notice it anymore :smiley: .