pip install --allow-unverified django-admin-tools django-admin-tools==0.5.1
my python/Java notes
Ярлыки
- Задачки (3)
- Поиск маршрутов (1)
- Amazon (2)
- apache (2)
- Celery (3)
- curl (1)
- Django (9)
- english (1)
- fabric (1)
- GLPK (1)
- HTML (1)
- java (6)
- Job (1)
- JS (1)
- knockout JS (3)
- LP (2)
- mongo (1)
- MySQL (9)
- neo4j (5)
- Oracle (1)
- parallel (1)
- PostgreSQL (3)
- PsyCo (1)
- PyQt (17)
- Python (30)
- routers finding (3)
- Soft (1)
- SSH (4)
- supervisor (1)
- SVG (2)
- SVN (1)
- TEX (1)
- Ubuntu (15)
- web (1)
- wsgi (1)
среда, 23 апреля 2014 г.
четверг, 10 апреля 2014 г.
воскресенье, 6 апреля 2014 г.
MySql compressed row format ("Row size too large" error resolve)
I have follow error:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/ dist-packages/django/core/ management/base.py", line 222, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/local/lib/python2.7/ dist-packages/django/core/ management/base.py", line 255, in execute
output = self.handle(*args, **options)
File "/home/vinger4/Projects/a360/ router/management/commands/ places_update.py", line 428, in handle
airport.save()
File "/home/vinger4/Projects/a360/ content/models.py", line 545, in save
super(Airport, self).save(*args, **kwargs)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ models/base.py", line 546, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ models/base.py", line 626, in save_base
rows = manager.using(using).filter( pk=pk_val)._update(values)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ models/query.py", line 605, in _update
return query.get_compiler(self.db). execute_sql(None)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ models/sql/compiler.py", line 1020, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ models/sql/compiler.py", line 846, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/ dist-packages/django/db/ backends/mysql/base.py", line 128, in execute
six.reraise(utils. DatabaseError, utils.DatabaseError(*tuple(e. args)), sys.exc_info()[2])
File "/usr/local/lib/python2.7/ dist-packages/django/db/ backends/mysql/base.py", line 120, in execute
return self.cursor.execute(query, args)
File "/usr/lib/python2.7/dist- packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist- packages/MySQLdb/connections. py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
DatabaseError: (1118, 'Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.')
Set ROW_FORMAT=COMPRESSED for my_table:
mysql> SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL innodb_file_per_table=ON; ALTER TABLE my_table ROW_FORMAT=COMPRESSED;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 258 rows affected (0.35 sec)
Records: 258 Duplicates: 0 Warnings: 0
mysql>
понедельник, 17 марта 2014 г.
generate html for correct view SVG
<embed src="GDP.svg" width="5000" height="8000"
type="image/svg+xml"
pluginspage="http://www.adobe. com/svg/viewer/install/" />
pluginspage="http://www.adobe.
Подписаться на:
Сообщения (Atom)