Bug: version 7 update today Column 'track_seen' cannot be null

1

I have update today using bench update. I got this error any idea?

  File "/home/ccfiel/frappe-bench/apps/frappe/frappe/model/base_document.py", line 282, in db_insert
    ), d.values())
  File "/home/ccfiel/frappe-bench/apps/frappe/frappe/database.py", line 136, in sql
    self._cursor.execute(query, values)
  File "/home/ccfiel/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/ccfiel/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1048, "Column 'track_seen' cannot be null")
2

Are all your apps (frappe & erpnext) on the same branch?

3

@rmehta yes its the same.

from setuptools import setup, find_packages
from pip.req import parse_requirements

version = "6.27.21"
requirements = parse_requirements("requirements.txt", session="")

setup(
	name='frappe',
	version=version,
	description='Metadata driven, full-stack web framework',
	author='Frappe Technologies',
	author_email='info@frappe.io',
	packages=find_packages(),
	zip_safe=False,
	include_package_data=True,
	install_requires=[str(ir.req) for ir in requirements],
	dependency_links=[str(ir._link) for ir in requirements if ir._link]
)

INFO:bench.utils:updating bench
Already up-to-date.
from setuptools import setup, find_packages
from pip.req import parse_requirements

version = "6.27.21"
requirements = parse_requirements("requirements.txt", session="")

setup(
	name='frappe',
	version=version,
	description='Metadata driven, full-stack web framework',
	author='Frappe Technologies',
	author_email='info@frappe.io',
	packages=find_packages(),
	zip_safe=False,
	include_package_data=True,
	install_requires=[str(ir.req) for ir in requirements],
	dependency_links=[str(ir._link) for ir in requirements if ir._link]
)

from setuptools import setup, find_packages
from pip.req import parse_requirements

version = "6.27.21"
requirements = parse_requirements("requirements.txt", session="")

setup(
	name='frappe',
	version=version,
	description='Metadata driven, full-stack web framework',
	author='Frappe Technologies',
	author_email='info@frappe.io',
	packages=find_packages(),
	zip_safe=False,
	include_package_data=True,
	install_requires=[str(ir.req) for ir in requirements],
	dependency_links=[str(ir._link) for ir in requirements if ir._link]
)

Requirement already satisfied (use --upgrade to upgrade): Pillow in ./env/lib/python2.7/site-packages
INFO:bench.app:pulling frappe
From https://github.com/frappe/frappe
 * branch            develop    -> FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling erpnext
From https://github.com/frappe/erpnext
 * branch            develop    -> FETCH_HEAD
Already up-to-date.

Any idea why? :slight_smile:

My hack was removing the null restriction.

ALTER TABLE tabDocType MODIFY track_seen INT(1) DEFAULT '0';
ALTER TABLE tabDocType MODIFY beta INT(1) DEFAULT '0';
ALTER TABLE tabDocType MODIFY quick_entry INT(1) DEFAULT '1';

I do know if this is ok?