Databases
StackOverflow2013
Postsdbo
PODataBase Error when running python manage.py runserver
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODataBase Error when running python manage.py runserver
    primarykey
    data
    text
    <p>I am working with Django 1.4.3 on PowerShell and I am getting a DataBase error after running <code>python manage.py</code> with the Exception Value: </p> <p><code>(1054, "Unknown column 'ventas_cliente.apellidos' in 'field list'")</code></p> <p>So I am following a Django tutorial and I have the following directory for a project: </p> <pre><code>demo/ demo/ apps/ ventas/ __init__.py admin.py models.py tests.py views.py __init.py __init__.py settings.py urls.py wsgi.py manage </code></pre> <p>And under admin.py I have:</p> <pre><code>from django.contrib import admin from demo.apps.ventas.models import cliente.producto # Register the ventas models admin.site.register(cliente) admin.site.register(producto) </code></pre> <p>And from models.py, </p> <pre><code>from django.db import models class cliente(models.Model): nombre = models.CharField(max_length=200) apellidos = models.CharField(max_length=200) status = models.BooleanField(default=True) class producto(models.Model): nombre = models.CharField(max_length=200) descripcion = models.TextField(max_length=300) status = models.BooleanField(default=True) </code></pre> <p>I am using MySQL and I am not changing databases. <code>runserver</code> did work and I am able to access localhost:8000/admin. There I have a new category called "ventas" which have the "cliente" and the "producto" subcategory. I can access "producto" but "cliente" gives me the DataBase error. </p> <p>What seems to be wrong? I suspect it has to do with my models.py file but I just don't know why. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDombey
    1. USDombey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI suspect you changed your schema before? Just an idea. Why don't you load an sqlite database right now, run syncdb and see if it works. If so, the schema in the current database might be out of sync and syncdb didn't handle it. syncdb doesn't handle changed schema for already created database. If my suspect is correct, try South to migrate. Change db in settings.py to a new sqlite db even if you were using postgresql or mysql already. just for testing right now.
      singulars
      1. PODataBase Error when running python manage.py runserver
      1. USCppLearner
    2. CO@CppLearner Yes, `syncdb` still works.
      singulars
      1. PODataBase Error when running python manage.py runserver
      1. USDombey
    3. COJust to make sure we are on the same page. You are saying after pointing settings.py to a new sqlite3 db, you are able to go into admin?
      singulars
      1. PODataBase Error when running python manage.py runserver
      1. USCppLearner
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload