Error create a new Module and DoctType - Doesn't create a path from my module/doctype

Frappe Framework
1

I’m finally get my frappe works… but I try to create a new module, and new DocType, and doesn 't work…

I have a app named: myerp … and I have a Dir with myerp as name…

When I create a new Module, I put that:

Module name: General
App name: myerp

I believe frappe need to create a sub-dir named “general”… and frappe doesn’t create a sub-dir.

So I thought, maybe I need a DocType sync with these module, so frappe will create a dir with json files… I create a New DocType… and nothing…

When I try to type: New TestDoc show these error:

Traceback (most recent call last):
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/app.py", line 61, in application
    response = frappe.handler.handle()
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/handler.py", line 21, in handle
    data = execute_cmd(cmd)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/handler.py", line 56, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/__init__.py", line 1007, in call
    return fn(*args, **newargs)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/utils/help.py", line 30, in get_help
    return HelpDatabase().search(text)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/utils/help.py", line 108, in search
    select title, intro, path from help where match(content) against (%s) limit 10''', ('%'+words+'%', words))
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/apps/frappe/frappe/database.py", line 199, in sql
    self._cursor.execute(query, values)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 516, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 727, in _read_query_result
    result.read()
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 1066, in read
    first_packet = self.connection._read_packet()
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/connections.py", line 683, in _read_packet
    packet.check_error()
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/Users/fellipeh/Developer/frappe/fellipeh-bench/env/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
ProgrammingError: (1146, u"Table 'e6e070c26a6b7344.help' doesn't exist")

So… frappe was not create a new Python Directory as my module, and not create python directory as my DocType…

Database table (my doctype) was create correctly…

Any thoughts?

2

Perhaps check if the help table exists, run this as root (assuming there is a /root/.my.cnf with the MariaDB root password in it):

mysql e6e070c26a6b7344 -e "SHOW tables;" | grep help

If it doesn’t:

bench --site sitename.example.org setup-help
3

Thanks… help table was not created… now create right on database…

But… I do not have any Dir withmy module and/or DocType… So… my new doctype just exist on “database” not on my dir…

Any thoughts for the reason frappe doesn’t create a sub-dir (python directory) ?

Permission is ok… I have all rights to myerp (python app) directory…

4

Is developer_mode = 1? What guide are you following?

5

Yes, here is my site json:

 "db_name": "e6e070c26a6b7344", 
 "db_password": "XXXXXXXXX", 
 "limits": {
  "space_usage": {
   "backup_size": 1.0, 
   "database_size": 4.72, 
   "files_size": 0.0, 
   "total": 5.72
  }
 },
 "developer_mode": 1
}

I just go to Developer, click on it… click on ModuleDef, and create a new ModuleDef as I mentioned above…

6

Found my problem! :slight_smile:

When I was creating my DocType, I set True on Custom? field… so, frappe not create a sub-dir… just set to False (Uncheck) and save again, and Works!

Thanks Again @clarkej! for your help!

1 Like