Can't DROP COLUMN 'customer_id'

[dodgen247]

Just pulled the latest and received the below error during the inventree container start up. Any help would be appreciated!

MySQLdb._exceptions.OperationalError: (1091, "Can't DROP COLUMN customer_id; check that it exists")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "manage.py", line 22, in
execute_from_command_line(sys.argv)
File "/opt/venv/lib/python3.8/site-packages/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/opt/venv/lib/python3.8/site-packages/django/core/management/init.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 328, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 369, in execute
output = self.handle(*args, **options)
File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/venv/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 231, in handle
post_migrate_state = executor.migrate(
File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 245, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/operations/fields.py", line 178, in database_forwards
schema_editor.remove_field(from_model, from_model._meta.get_field(self.name))
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 517, in remove_field
self.execute(sql)
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 142, in execute
cursor.execute(sql, params)
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 68, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
File "/opt/venv/lib/python3.8/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
File "/opt/venv/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 74, in execute
return self.cursor.execute(query, args)
File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 209, in execute
res = self._query(query)
File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 315, in _query
db.query(q)
File "/opt/venv/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1091, "Can't DROP COLUMN customer_id; check that it exists")
make: *** [Makefile:15: migrate] Error 1

[Zeigren]

Yeah I'm a bit behind on updating it. InvenTree is on version 0.1.0 now and the last version I checked was 0.0.10

[Zeigren]

Did you run a migration by setting MIGRATE_STATIC=True? I made a minor update but it shouldn't make any difference.

[dodgen247]

Yes the migrate_static was set to True for the version change. Changing it to false does allow the system to boot up though.

[Zeigren]

Hmm when MIGRATE_STATIC is set to true it'll still run once its finished. You technically can leave it on all the time it just slows down the boot process. Do you get any errors when running the migration?
Since it can't find the customer_id column you might want to use phpmyadmin or something else to check the database. See if you can connect and whether that column is actually missing or not. You can borrow the bit from the development.yml to get that running.

[dodgen247]

The migration actually kills the inventree container. I have included the logs to where it dies below. I ran the below query in the mariadb and found that the column does exist in the order_salesorder table.

SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='customer_id'

Config file already exists (skipping),
Test connection to database,
Success!,
Give the database a few seconds to warm up,
make: Entering directory '/usr/src/app',
cd InvenTree && python3 manage.py makemigrations,
InvenTree: Checking Part image thumbnails,
Could not generate Part thumbnails,
InvenTree: Checking Company image thumbnails,
Loading barcode plugins,
Loading barcode plugins,
Discovered 2 barcode plugins:,

• DigikeyBarcodePlugin,
• InvenTreeBarcodePlugin,
  Loading action plugins,
  Loading action plugins,
  Discovered 1 action plugins:,
• SimpleActionPlugin,
  No changes detected,
  cd InvenTree && python3 manage.py migrate,
  InvenTree: Checking Part image thumbnails,
  Could not generate Part thumbnails,
  InvenTree: Checking Company image thumbnails,
  Loading barcode plugins,
  Loading barcode plugins,
  Discovered 2 barcode plugins:,
• DigikeyBarcodePlugin,
• InvenTreeBarcodePlugin,
  Loading action plugins,
  Loading action plugins,
  Discovered 1 action plugins:,
• SimpleActionPlugin,
  Operations to perform:,
  Apply all migrations: admin, auth, authtoken, build, common, company, contenttypes, order, part, sessions, stock,
  Running migrations:,
  Traceback (most recent call last):,
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 86, in _execute,
  return self.cursor.execute(sql, params),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 74, in execute,
  return self.cursor.execute(query, args),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 209, in execute,
  res = self._query(query),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 315, in _query,
  db.query(q),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query,
  _mysql.connection.query(self, query),
  MySQLdb._exceptions.OperationalError: (1091, "Can't DROP COLUMN customer_id; check that it exists"),
  ,
  The above exception was the direct cause of the following exception:,
  ,
  Traceback (most recent call last):,
  File "manage.py", line 22, in ,
  execute_from_command_line(sys.argv),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/init.py", line 401, in execute_from_command_line,
  utility.execute(),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/init.py", line 395, in execute,
  self.fetch_command(subcommand).run_from_argv(self.argv),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 328, in run_from_argv,
  self.execute(*args, **cmd_options),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 369, in execute,
  output = self.handle(*args, **options),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/base.py", line 83, in wrapped,
  res = handle_func(*args, **kwargs),
  File "/opt/venv/lib/python3.8/site-packages/django/core/management/commands/migrate.py", line 231, in handle,
  post_migrate_state = executor.migrate(,
  File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 117, in migrate,
  state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial),
  File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards,
  state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial),
  File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/executor.py", line 245, in apply_migration,
  state = migration.apply(state, schema_editor),
  File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/migration.py", line 124, in apply,
  operation.database_forwards(self.app_label, schema_editor, old_state, project_state),
  File "/opt/venv/lib/python3.8/site-packages/django/db/migrations/operations/fields.py", line 178, in database_forwards,
  schema_editor.remove_field(from_model, from_model._meta.get_field(self.name)),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 517, in remove_field,
  self.execute(sql),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/base/schema.py", line 142, in execute,
  cursor.execute(sql, params),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 68, in execute,
  return self._execute_with_wrappers(sql, params, many=False, executor=self._execute),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers,
  return executor(sql, params, many, context),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 86, in _execute,
  return self.cursor.execute(sql, params),
  File "/opt/venv/lib/python3.8/site-packages/django/db/utils.py", line 90, in exit,
  raise dj_exc_value.with_traceback(traceback) from exc_value,
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/utils.py", line 86, in _execute,
  return self.cursor.execute(sql, params),
  File "/opt/venv/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 74, in execute,
  return self.cursor.execute(query, args),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 209, in execute,
  res = self._query(query),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/cursors.py", line 315, in _query,
  db.query(q),
  File "/opt/venv/lib/python3.8/site-packages/MySQLdb/connections.py", line 239, in query,
  _mysql.connection.query(self, query),
  django.db.utils.OperationalError: (1091, "Can't DROP COLUMN customer_id; check that it exists"),
  Applying stock.0034_auto_20200426_0602...make: Leaving directory '/usr/src/app',
  make: *** [Makefile:15: migrate] Error 1,