Kegbot / kegbot-server

Kegbot Server, the internet beer kegerator monitoring system.
https://docs.kegbot.org/projects/kegbot-server/
MIT License
192 stars 103 forks source link

"Brewer matching query does not exist" for new install #86

Closed mik3y closed 11 years ago

mik3y commented 11 years ago

Unknown brewer appears to be getting a incomplete/incorrect primary id key. Reproduced on sqlite.

Type: Traceback (most recent call last):
  File "/Users/mike/.venv/kb-test/bin/kegbot-admin.py", line 7, in <module>
    execfile(__file__)
  File "/Users/mike/gitbox/kegbot/pykeg/bin/kegbot-admin.py", line 30, in <module>
    management.execute_from_command_line()
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
    utility.execute()
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/core/management/commands/kb_setup.py", line 54, in handle
    self.InitialSetup()
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/core/management/commands/kb_setup.py", line 72, in InitialSetup
    self._RunCommand(kb_set_defaults.Command(), args=['--force'])
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/core/management/commands/kb_setup.py", line 62, in _RunCommand
    cmd.run_from_argv([sys.argv[0], cmdname] + args)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/core/management/commands/kb_set_defaults.py", line 41, in handle
    defaults.set_defaults(options['force'])
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/core/defaults.py", line 56, in set_defaults
    print "Type:", unk_type
  File "/Users/mike/gitbox/kegbot/pykeg/src/pykeg/beerdb/models.py", line 126, in __str__
    return "%s by %s" % (self.name, self.brewer)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/db/models/fields/related.py", line 350, in __get__
    rel_obj = qs.get(**params)
  File "/Users/mike/.venv/kb-test/lib/python2.7/site-packages/django/db/models/query.py", line 366, in get
    % self.model._meta.object_name)
pykeg.beerdb.models.DoesNotExist: Brewer matching query does not exist.
digitalthinker commented 11 years ago

This one is biting me in the butt. How do I fix it?

mik3y commented 11 years ago

digitalthinker: Please provide more details:

digitalthinker commented 11 years ago

Kegbot v0.9.7 – I’ve tried the pip install numerous times.

I’ve tried mysql and sqllite – latest trial gave me the finger saying MySQLDB not found.

I’ve reinstalled Ubuntu and I’m getting ready to perform a new install for the 4th time.

Is the pip install different than the git install?

From: mike w [mailto:notifications@github.com] Sent: Saturday, February 02, 2013 2:25 PM To: Kegbot/kegbot Cc: digitalthinker Subject: Re: [kegbot] "Brewer matching query does not exist" for new install (#86)

digitalthinker: Please provide more details:

— Reply to this email directly or view it on GitHub https://github.com/Kegbot/kegbot/issues/86#issuecomment-13035746 .

Image removed by sender.

Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 9.0.0.2308, Virus/Spyware Database: 6.21020)

http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51

mik3y commented 11 years ago

You almost certainly do not need to re-install Ubuntu, so that should save you some time.

Can you please send the output of the following command: pip freeze

Is the pip install different than the git install?

Yes, the git install contains unreleased sources. You are right to use pip.

mik3y commented 11 years ago

Also, please paste the full output of the error you're getting.

digitalthinker commented 11 years ago

Fresh install

  1.  Installed sqlite
  2.  Installed kegbot server package. Was prompted for mysql root password.
  3.  Installed virtualenv
  4.  Installed Kegbot Server
  5.  Setup Kegbot with command (kb) $setup-kegbot.py. documentation missing (kb) Error: Could not locate Python Imaging Library….
  6.  Installed pip install pillow - (kb) $ pip install pillow
  7.  Retried kegbot server setup Error: Memcache client library not installed. Answered No to enable memcached caching layer. All other values default except America/New_York
  8.  Run Kegbot Server = success
  9.  Kegbot setup Woot! – don’t know how to set DEBUG = FALSE

Would like to avoid the Brewer Matching Query does not exist error. I’ll let you know if it finds me.

From: mike w [mailto:notifications@github.com] Sent: Saturday, February 02, 2013 2:39 PM To: Kegbot/kegbot Cc: digitalthinker Subject: Re: [kegbot] "Brewer matching query does not exist" for new install (#86)

You almost certainly do not need to re-install Ubuntu, so that should save you some time.

Can you please send the output of the following command: pip freeze

Is the pip install different than the git install?

Yes, the git install contains unreleased sources. You are right to use pip.

— Reply to this email directly or view it on GitHub https://github.com/Kegbot/kegbot/issues/86#issuecomment-13035984 .

Image removed by sender.

Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 9.0.0.2308, Virus/Spyware Database: 6.21020)

http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51

digitalthinker commented 11 years ago

DoesNotExist at /kegadmin/taps/

Brewer matching query does not exist.

Request Method: GET Request URL: http://localhost:8000/kegadmin/taps/ Django Version: 1.4.3 Exception Type: DoesNotExist Exception Value:

Brewer matching query does not exist.

Exception Location: /home/tony/kb/local/lib/python2.7/site-packages/django/db/models/query.py in get, line 366 Python Executable: /home/tony/kb/bin/python Python Version: 2.7.3 Python Path:

['/home/tony/kb/bin', '/home/tony/kb/local/lib/python2.7/site-packages/distribute-0.6.24-py2.7.egg', '/home/tony/kb/local/lib/python2.7/site-packages/pip-1.1-py2.7.egg', '/home/tony/kb/lib/python2.7', '/home/tony/kb/lib/python2.7/plat-linux2', '/home/tony/kb/lib/python2.7/lib-tk', '/home/tony/kb/lib/python2.7/lib-old', '/home/tony/kb/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', '/home/tony/kb/local/lib/python2.7/site-packages', '/home/tony/.kegbot', '/etc/kegbot']

Server time: Sat, 2 Feb 2013 15:40:43 -0500 Error during template rendering

In template /home/tony/kb/local/lib/python2.7/site-packages/crispy_forms/templates/bootstrap/field.html, error at line 23 Brewer matching query does not exist. 13 {% if field|css_class == "checkboxselectmultiple" %} 14 {% include 'bootstrap/layout/checkboxselectmultiple.html' %} 15 {% endif %} 16
17 {% if field|css_class == "radioselect" %} 18 {% include 'bootstrap/layout/radioselect.html' %} 19 {% endif %} 20
21 {% if field|css_class != "checkboxselectmultiple" and field|css_class != "radioselect" %} 22

23 {% if field|is_checkbox %} 24 29 {% else %} 30 {% crispy_field field %} 31 {% include 'bootstrap/layout/help_text_and_errors.html' %} 32 {% endif %} 33
Traceback Switch to copy-and-paste view

/home/tony/kb/local/lib/python2.7/site-packages/django/core/handlers/base.py in get_response

                            response = callback(request, *callback_args, **callback_kwargs)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/contrib/admin/views/decorators.py in _checklogin

                return view_func(request, *args, **kwargs)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/pykeg/web/kegadmin/views.py in tap_list

      return render_to_response('kegadmin/tap-edit.html', context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/shortcuts/__init__.py in render_to_response

        return HttpResponse(loader.render_to_string(*args, **kwargs), **httpresponse_kwargs)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader.py in render_to_string

            return t.render(Context(dictionary))

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                return self._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

            return compiled_parent._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

            return compiled_parent._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

            return compiled_parent._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

                result = block.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

                result = block.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

                result = block.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                            nodelist.append(node.render(context))

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

            output = self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

            output = self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                    return nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render

                output = self.filter_expression.resolve(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in resolve

                    new_obj = func(obj, *arg_vals)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/crispy_forms/templatetags/crispy_forms_filters.py in as_crispy_form

        return template.render(c)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                return self._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/crispy_forms/templatetags/crispy_forms_utils.py in render

                self.nodelist.render(context).strip()

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                            nodelist.append(node.render(context))

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render

            return self.render_template(self.template, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/loader_tags.py in render_template

            output = template.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                return self._render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in _render

            return self.nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                    return nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                    return nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                    bit = self.render_node(node, context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/debug.py in render_node

                return node.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/defaulttags.py in render

                    return nodelist.render(context)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/template/base.py in render

                bits.append(force_unicode(bit))

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/utils/encoding.py in force_unicode

                    s = unicode(s)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/forms.py in __unicode__

            return self.as_widget()

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/forms.py in as_widget

            return widget.render(name, self.value(), attrs=attrs)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/widgets.py in render

            options = self.render_options(choices, [value])

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/widgets.py in render_options

            for option_value, option_label in chain(self.choices, choices):

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/models.py in __iter__

                    yield self.choice(obj)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/models.py in choice

            return (self.field.prepare_value(obj), self.field.label_from_instance(obj))

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/forms/models.py in label_from_instance

            return smart_unicode(obj)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/utils/encoding.py in smart_unicode

        return force_unicode(s, encoding, strings_only, errors)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/utils/encoding.py in force_unicode

                        s = unicode(str(s), encoding, errors)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/pykeg/beerdb/models.py in __str__

        return "%s by %s" % (self.name, self.brewer)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/db/models/fields/related.py in __get__

                rel_obj = qs.get(**params)

    ...
▶ Local vars
/home/tony/kb/local/lib/python2.7/site-packages/django/db/models/query.py in get

                        % self.model._meta.object_name)

    ...
▶ Local vars

Request information GET

No GET data POST

No POST data FILES

No FILES data COOKIES Variable Value csrftoken

'5rzxTr4ePQ48lSYVFyog6u2cF6puhPdY'

sessionid

'736a652af5f1d5465526c6f5652f3402'

META Variable Value wsgi.version

(1, 0)

wsgi.multiprocess

False

RUN_MAIN

'true'

HTTP_REFERER

'http://localhost:8000/'

GNOME_DESKTOP_SESSION_ID

'this-is-deprecated'

SERVER_PROTOCOL

'HTTP/1.1'

SERVER_SOFTWARE

'WSGIServer/0.1 Python/2.7.3'

SCRIPT_NAME

u''

LESSOPEN

'| /usr/bin/lesspipe %s'

REQUEST_METHOD

'GET'

LOGNAME

'tony'

USER

'tony'

PATH

'/home/tony/kb/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games'

QUERY_STRING

''

GNOME_KEYRING_CONTROL

'/run/user/tony/keyring-sAxTE4'

PS1

'(kb)[\e]0;\u@\h: \w\a]${debian_chroot:+($debian_chroot)}\u@\h:\w\$ '

DISPLAY

':0.0'

SSH_AGENT_PID

'1578'

LANG

'en_US.UTF-8'

TERM

'xterm'

SHELL

'/bin/bash'

XDG_SESSION_PATH

'/org/freedesktop/DisplayManager/Session0'

XAUTHORITY

'/home/tony/.Xauthority'

SERVER_NAME

'localhost'

SESSION_MANAGER

'local/tony-Latitude-D830:@/tmp/.ICE-unix/1520,unix/tony-Latitude-D830:/tmp/.ICE-unix/1520'

SHLVL

'1'

MANDATORY_PATH

'/usr/share/gconf/ubuntu.mandatory.path'

wsgi.url_scheme

'http'

COMPIZ_CONFIG_PROFILE

'ubuntu'

WINDOWID

'58720262'

SERVER_PORT

'8000'

CONTENT_LENGTH

''

GPG_AGENT_INFO

'/run/user/tony/keyring-sAxTE4/gpg:0:1'

HOME

'/home/tony'

WORKON_HOME

'/home/tony/.virtualenvs'

COMPIZ_BIN_PATH

'/usr/bin/'

XDG_RUNTIME_DIR

'/run/user/tony'

VIRTUALENVWRAPPER_HOOK_DIR

'/home/tony/.virtualenvs'

CONTENT_TYPE

'text/plain'

SSH_AUTH_SOCK

'/run/user/tony/keyring-sAxTE4/ssh'

VIRTUAL_ENV

'/home/tony/kb'

HTTP_CONNECTION

'keep-alive'

GDMSESSION

'ubuntu'

CELERY_LOADER

'djcelery.loaders.DjangoLoader'

REMOTE_ADDR

'127.0.0.1'

HTTP_USER_AGENT

'Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:16.0) Gecko/20100101 Firefox/16.0'

HTTP_HOST

'localhost:8000'

wsgi.multithread

True

XDG_SEAT_PATH

'/org/freedesktop/DisplayManager/Seat0'

LESSCLOSE

'/usr/bin/lesspipe %s %s'

CSRF_COOKIE_USED

True

XDG_CURRENT_DESKTOP

'Unity'

DBUS_SESSION_BUS_ADDRESS

'unix:abstract=/tmp/dbus-Q9SpMD2mNP,guid=cdf9bcd3348afd79e9344490510d764e'

_

'/home/tony/kb/bin/kegbot-admin.py'

XDG_SESSION_COOKIE

'f7d6490a1b06ec3d30558da7510d6268-1359836749.394922-174634797'

HTTP_ACCEPT

'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'

VIRTUALENVWRAPPER_PROJECT_FILENAME

'.project'

DESKTOP_SESSION

'ubuntu'

wsgi.file_wrapper

''

XDG_CONFIG_DIRS

'/etc/xdg/xdg-ubuntu:/etc/xdg'

DEFAULTS_PATH

'/usr/share/gconf/ubuntu.default.path'

UBUNTU_MENUPROXY

'libappmenu.so'

wsgi.run_once

False

CSRF_COOKIE

'5rzxTr4ePQ48lSYVFyog6u2cF6puhPdY'

wsgi.errors

<open file '', mode 'w' at 0xb74f20d0>

GATEWAY_INTERFACE

'CGI/1.1'

HTTP_ACCEPT_LANGUAGE

'en-US,en;q=0.5'

wsgi.input

<socket._fileobject object at 0xb5e9fb6c>

GTK_MODULES

'overlay-scrollbar'

XDG_DATA_DIRS

'/usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/'

PWD

'/home/tony'

DJANGO_SETTINGS_MODULE

'pykeg.settings'

TZ

'America/New_York'

COLORTERM

'gnome-terminal'

VIRTUALENVWRAPPER_LOG_DIR

'/home/tony/.virtualenvs'

LS_COLORS

'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.lzma=01;31:.tlz=01;31:.txz=01;31:.zip=01;31:.z=01;31:.Z=01;31:.dz=01;31:.gz=01;31:.lz=01;31:.xz=01;31:.bz2=01;31:.bz=01;31:.tbz=01;31:.tbz2=01;31:.tz=01;31:.deb=01;31:.rpm=01;31:.jar=01;31:.war=01;31:.ear=01;31:.sar=01;31:.rar=01;31:.ace=01;31:.zoo=01;31:.cpio=01;31:.7z=01;31:.rz=01;31:.jpg=01;35:.jpeg=01;35:.gif=01;35:.bmp=01;35:.pbm=01;35:.pgm=01;35:.ppm=01;35:.tga=01;35:.xbm=01;35:.xpm=01;35:.tif=01;35:.tiff=01;35:.png=01;35:.svg=01;35:.svgz=01;35:.mng=01;35:.pcx=01;35:.mov=01;35:.mpg=01;35:.mpeg=01;35:.m2v=01;35:.mkv=01;35:.webm=01;35:.ogm=01;35:.mp4=01;35:.m4v=01;35:.mp4v=01;35:.vob=01;35:.qt=01;35:.nuv=01;35:.wmv=01;35:.asf=01;35:.rm=01;35:.rmvb=01;35:.flc=01;35:.avi=01;35:.fli=01;35:.flv=01;35:.gl=01;35:.dl=01;35:.xcf=01;35:.xwd=01;35:.yuv=01;35:.cgm=01;35:.emf=01;35:.axv=01;35:.anx=01;35:.ogv=01;35:.ogx=01;35:.aac=00;36:.au=00;36:.flac=00;36:.mid=00;36:.midi=00;36:.mka=00;36:.mp3=00;36:.mpc=00;36:.ogg=00;36:.ra=00;36:.wav=00;36:.axa=00;36:.oga=00;36:.spx=00;36:.xspf=00;36:'

REMOTE_HOST

''

HTTP_ACCEPT_ENCODING

'gzip, deflate'

HTTP_COOKIE

'csrftoken=5rzxTr4ePQ48lSYVFyog6u2cF6puhPdY; sessionid=736a652af5f1d5465526c6f5652f3402'

PATH_INFO

u'/kegadmin/taps/'

Settings Using settings module pykeg.settings Setting Value USE_L10N

False

USE_THOUSAND_SEPARATOR

False

CSRF_COOKIE_SECURE

False

CELERY_DEFAULT_QUEUE

'default'

LANGUAGE_CODE

'en-us'

ROOT_URLCONF

'pykeg.web.urls'

MANAGERS

()

BROKER_URL

'django://'

ACCOUNT_ACTIVATION_DAYS

3

KEGBOT_ROOT

'/home/tony/kegbot-data'

STATIC_ROOT

'/home/tony/kegbot-data/static'

TWITTER_REQUEST_TOKEN_URL

u'****'

CACHE_MIDDLEWARE_ANONYMOUS_ONLY

True

MESSAGE_STORAGE

'django.contrib.messages.storage.fallback.FallbackStorage'

EMAIL_SUBJECT_PREFIX

'[Django] '

SEND_BROKEN_LINK_EMAILS

False

URL_VALIDATOR_USER_AGENT

'Django/1.4.3 (https://www.djangoproject.com)'

STATICFILES_FINDERS

('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder')

TWITTER_AUTHORIZATION_URL

'https://api.twitter.com/oauth/authorize'

SESSION_COOKIE_DOMAIN

None

SESSION_COOKIE_NAME

'sessionid'

ICANHAZ_APP_DIRNAMES

['static/jstemplates', 'jstemplates']

ADMIN_FOR

()

TIME_INPUT_FORMATS

('%H:%M:%S', '%H:%M')

DATABASES

{'default': {'ENGINE': 'django.db.backends.sqlite3', 'HOST': '', 'NAME': '/home/tony/kegbot-data/kegbot.sqlite', 'OPTIONS': {}, 'PASSWORD': u'****', 'PORT': '', 'TEST_CHARSET': None, 'TEST_COLLATION': None, 'TEST_MIRROR': None, 'TEST_NAME': None, 'TIME_ZONE': 'America/New_York', 'USER': ''}}

TWITTER_ACCESS_TOKEN_URL

u'****'

FILE_UPLOAD_PERMISSIONS

None

FILE_UPLOAD_HANDLERS

('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler')

DEFAULT_CONTENT_TYPE

'text/html'

SKIP_SOUTH_TESTS

True

FOURSQUARE_CLIENT_ID

''

APPEND_SLASH

True

FIRST_DAY_OF_WEEK

0

DATABASE_ROUTERS

[]

IMAGEKIT_DEFAULT_IMAGE_CACHE_BACKEND

'imagekit.imagecache.PessimisticImageCacheBackend'

YEAR_MONTH_FORMAT

'F Y'

STATICFILES_STORAGE

'django.contrib.staticfiles.storage.StaticFilesStorage'

CACHES

{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', 'LOCATION': 'cache'}}

SERVER_EMAIL

'root@localhost'

SESSION_COOKIE_PATH

'/'

MIDDLEWARE_CLASSES

('django.middleware.cache.UpdateCacheMiddleware', 'django.middleware.gzip.GZipMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.middleware.transaction.TransactionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'pykeg.web.api.middleware.WrapExceptionMiddleware', 'pykeg.web.middleware.KegbotSiteMiddleware', 'pykeg.web.middleware.SiteActiveMiddleware', 'pykeg.web.middleware.PrivacyMiddleware', 'pykeg.web.api.middleware.CheckAccessMiddleware', 'django.middleware.doc.XViewMiddleware', 'django.middleware.cache.FetchFromCacheMiddleware')

USE_I18N

True

THOUSAND_SEPARATOR

','

SECRET_KEY

u'****'

HAVE_SENTRY

False

DEFAULT_INDEX_TABLESPACE

''

CELERYD_CONCURRENCY

3

TRANSACTIONS_MANAGED

False

LOGGING_CONFIG

'django.utils.log.dictConfig'

SIGNING_BACKEND

'django.core.signing.TimestampSigner'

TEMPLATE_LOADERS

('django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader', 'django.template.loaders.eggs.Loader')

WSGI_APPLICATION

None

TEMPLATE_DEBUG

True

X_FRAME_OPTIONS

'SAMEORIGIN'

AUTHENTICATION_BACKENDS

('django.contrib.auth.backends.ModelBackend',)

FORCE_SCRIPT_NAME

None

USE_X_FORWARDED_HOST

False

DEFAULT_CHARSET

'utf-8'

SESSION_COOKIE_SECURE

False

CSRF_COOKIE_DOMAIN

None

HAVE_DJKOMBU

True

FILE_CHARSET

'utf-8'

DEBUG

True

SESSION_FILE_PATH

None

DEFAULT_FILE_STORAGE

'django.core.files.storage.FileSystemStorage'

INSTALLED_APPS

('django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.humanize', 'django.contrib.markup', 'django.contrib.messages', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.staticfiles', 'crispy_forms', 'django_extensions', 'imagekit', 'pykeg.beerdb', 'pykeg.connections', 'pykeg.connections.foursquare', 'pykeg.connections.twitter', 'pykeg.connections.untappd', 'pykeg.contrib.soundserver', 'pykeg.core', 'pykeg.web', 'pykeg.web.api', 'pykeg.web.account', 'pykeg.web.charts', 'pykeg.web.kegweb', 'pykeg.web.setup_wizard', 'gunicorn', 'icanhaz', 'registration', 'socialregistration', 'socialregistration.contrib.twitter', 'socialregistration.contrib.facebook', 'socialregistration.contrib.foursquare', 'south', 'django_nose', 'djcelery', 'djkombu')

LANGUAGES

(('ar', 'Arabic'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('bn', 'Bengali'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy-nl', 'Frisian'), ('ga', 'Irish'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('id', 'Indonesian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('nb', 'Norwegian Bokmal'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese'))

COMMENTS_ALLOW_PROFANITIES

False

STATICFILES_DIRS

()

PREPEND_WWW

False

SECURE_PROXY_SSL_HEADER

None

PASSWORD_RESET_TIMEOUT_DAYS

u'****'

SESSION_COOKIE_HTTPONLY

True

DEBUG_PROPAGATE_EXCEPTIONS

False

MONTH_DAY_FORMAT

'F j'

LOGIN_URL

'/accounts/login/'

SESSION_EXPIRE_AT_BROWSER_CLOSE

False

SOUTH_TESTS_MIGRATE

False

SESSION_SAVE_EVERY_REQUEST

False

TIME_FORMAT

'P'

HAVE_DEBUG_TOOLBAR

False

DATE_INPUT_FORMATS

('%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y')

CSRF_COOKIE_NAME

'csrftoken'

EMAIL_HOST_PASSWORD

u'****'

FACEBOOK_SECRET_KEY

u'****'

AUTH_PROFILE_MODULE

'core.UserProfile'

FACEBOOK_API_KEY

u'****'

CACHE_MIDDLEWARE_ALIAS

'default'

HAVE_DJCELERY

True

ADMIN_MEDIA_PREFIX

'/static/admin/'

NUMBER_GROUPING

0

SESSION_ENGINE

'django.contrib.sessions.backends.db'

CSRF_FAILURE_VIEW

'django.views.csrf.csrf_failure'

CSRF_COOKIE_PATH

'/'

LOGIN_REDIRECT_URL

'/account/'

LOGGING

{'disable_existing_loggers': True, 'filters': {'require_debug_true': {'()': 'pykeg.core.logger.RequireDebugTrue'}}, 'handlers': {'cache': {'class': 'pykeg.core.logger.CacheHandler', 'level': 'ERROR'}, 'console': {'class': 'logging.StreamHandler', 'filters': ['require_debug_true'], 'level': 'DEBUG'}, 'null': {'class': 'django.utils.log.NullHandler'}}, 'loggers': {'django': {'handlers': ['console', 'cache']}, 'pykeg': {'handlers': ['console', 'cache']}, 'raven': {'handlers': ['console'], 'level': 'DEBUG', 'propagate': False}, 'sentry.errors': {'handlers': ['console'], 'level': 'DEBUG', 'propagate': False}}, 'root': {'handlers': ['console'], 'level': 'WARNING'}, 'version': 1}

IGNORABLE_404_URLS

()

NOSE_ARGS

['--exe']

LOCALE_PATHS

()

TEMPLATE_STRING_IF_INVALID

''

LOGOUT_URL

'/accounts/logout/'

EMAIL_USE_TLS

False

FIXTURE_DIRS

()

EMAIL_HOST

'localhost'

DATE_FORMAT

'N j, Y'

MEDIA_ROOT

'/home/tony/kegbot-data/media'

FOURSQUARE_REQUEST_PERMISSIONS

''

DEFAULT_EXCEPTION_REPORTER_FILTER

'django.views.debug.SafeExceptionReporterFilter'

ADMINS

()

FORMAT_MODULE_PATH

None

DEFAULT_FROM_EMAIL

'webmaster@localhost'

MEDIA_URL

'/media/'

DATETIME_FORMAT

'N j, Y, P'

TEMPLATE_DIRS

('web/templates',)

TWITTER_CONSUMER_KEY

u'****'

HAVE_DJANGOTORNADO

False

SITE_ID

1

DISALLOWED_USER_AGENTS

()

ALLOWED_INCLUDE_ROOTS

()

DECIMAL_SEPARATOR

'.'

SHORT_DATE_FORMAT

'm/d/Y'

TEST_RUNNER

'django_nose.NoseTestSuiteRunner'

HAVE_CELERY

True

CACHE_MIDDLEWARE_KEY_PREFIX

u'****'

TIME_ZONE

'America/New_York'

FILE_UPLOAD_MAX_MEMORY_SIZE

2621440

EMAIL_BACKEND

'django.core.mail.backends.dummy.EmailBackend'

LANGUAGE_COOKIE_NAME

'django_language'

DEFAULT_TABLESPACE

''

TEMPLATE_CONTEXT_PROCESSORS

('django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.core.context_processors.static', 'django.core.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', 'pykeg.web.context_processors.enabled_features', 'pykeg.web.context_processors.kbsite')

CELERY_QUEUES

{'default': {'binding_key': 'default', 'exchange': 'default'}}

HAVE_RAVEN

False

SESSION_COOKIE_AGE

1209600

FOURSQUARE_CLIENT_SECRET

u'****'

SETTINGS_MODULE

'pykeg.settings'

USE_ETAGS

False

TWITTER_CONSUMER_SECRET_KEY

u'****'

LANGUAGES_BIDI

('he', 'ar', 'fa')

FILE_UPLOAD_TEMP_DIR

None

INTERNAL_IPS

('127.0.0.1',)

STATIC_URL

'/static/'

EMAIL_PORT

25

USE_TZ

False

SHORT_DATETIME_FORMAT

'm/d/Y P'

CELERY_RESULT_BACKEND

'database'

PASSWORD_HASHERS

u'****'

ABSOLUTE_URL_OVERRIDES

{}

CACHE_MIDDLEWARE_SECONDS

600

DATETIME_INPUT_FORMATS

('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y')

EMAIL_HOST_USER

''

PROFANITIES_LIST

u'****'

mik3y commented 11 years ago

Ugh. Please attach the output of pip freeze.

digitalthinker commented 11 years ago

(kb)tony@tony-Latitude-D830:~$ pip freeze Django==1.4.3 Pillow==1.7.8 South==0.7.6 amqp==1.0.6 anyjson==0.3.3 argparse==1.2.1 billiard==2.7.3.19 celery==3.0.13 distribute==0.6.24 django-appconf==0.6 django-autoslug==1.6.1 django-celery==3.0.11 django-crispy-forms==1.2.3 django-extensions==1.0.3 django-icanhaz==0.2.1 django-imagekit==2.0.2 django-kombu==0.9.4 django-nose==1.1 django-registration==0.8 django-socialregistration==0.5.10 facebook-sdk==0.4.0 foursquare==20130131 gunicorn==0.17.2 httplib2==0.7.7 kegbot==0.9.7 kegbot-api==0.1.6 kegbot-pyutils==0.1.5 kombu==2.5.4 mock==1.0.1 nose==1.2.1 oauth2==1.5.211 poster==0.8.1 protobuf==2.4.1 pylcdui==0.5.8 python-dateutil==1.5 python-gflags==2.0 python-openid==2.2.5 pytz==2012j requests==1.1.0 six==1.2.0 tweepy==1.13 wsgiref==0.1.2 (kb)tony@tony-Latitude-D830:~$

digitalthinker commented 11 years ago

I’ve been using different words than Ugh.

From: mike w [mailto:notifications@github.com] Sent: Saturday, February 02, 2013 3:49 PM To: Kegbot/kegbot Cc: digitalthinker Subject: Re: [kegbot] "Brewer matching query does not exist" for new install (#86)

Ugh. Please attach the output of pip freeze.

— Reply to this email directly or view it on GitHub https://github.com/Kegbot/kegbot/issues/86#issuecomment-13037076 .

Image removed by sender.

Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 9.0.0.2308, Virus/Spyware Database: 6.21020)

http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51

mik3y commented 11 years ago

Hmm. I just performed a fresh install and cannot reproduce the problem. Something seems to be subtly broken with sqlite.

I'd like to take a look at your DB. Would you mind sending this file to me: /home/tony/kegbot-data/kegbot.sqlite .

mik3y commented 11 years ago

OK, I see the problem. You hadn't mentioned (or I missed) one step: you created a new beer type. The problem seems to be there. I'm working on a fix; it will take a few hours, but managing beer types should be much nicer following this.

digitalthinker commented 11 years ago

Roger that! Thanks!

From: mike w [mailto:notifications@github.com] Sent: Saturday, February 02, 2013 4:19 PM To: Kegbot/kegbot Cc: digitalthinker Subject: Re: [kegbot] "Brewer matching query does not exist" for new install (#86)

OK, I see the problem. You hadn't mentioned one step: you created a new beer type. The problem seems to be there. I'm working on a fix; it will take a few hours, but managing beer types should be much nicer following this.

— Reply to this email directly or view it on GitHub https://github.com/Kegbot/kegbot/issues/86#issuecomment-13037558 .

Image removed by sender.

Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 9.0.0.2308, Virus/Spyware Database: 6.21020)

http://www.pctools.com http://www.pctools.com/?cclick=EmailFooterClean_51