Got Error #1005: Can't create table (errno: 105)?
I got the error when the Flask-SQLAlchemy tries
to init_db() of my models.py.
Well here is the solution you could check. That
you have to do is to create index for the reference
ForeignKey column.
Hope It helps
Tuesday, July 30, 2013
MySQL, InnoDB: Operating system error number 13 in a file operation
Yeahh, it took me about an hour to two to figure it out.
I am using LAMPP 1.7 (old yes but i just personally decided
to use it) in Fedora14 64bit.
The steps were:
1. Check the error in your /opt/lampp/var/mysql/.err
** it is assumed that you copy the extracted xampp-linux-xxx.tar.gz in
your /opt
2. What got from #1
130730 13:12:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130730 13:12:59 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
3. And then i just chmod 777 -Rf /opt/lampp/var/mysql
4. Problem solved and hopefully not to add a new one :)
Hope it helps.
I am using LAMPP 1.7 (old yes but i just personally decided
to use it) in Fedora14 64bit.
The steps were:
1. Check the error in your /opt/lampp/var/mysql/
** it is assumed that you copy the extracted xampp-linux-xxx.tar.gz in
your /opt
2. What got from #1
130730 13:12:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130730 13:12:59 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
3. And then i just chmod 777 -Rf /opt/lampp/var/mysql
4. Problem solved and hopefully not to add a new one :)
Hope it helps.
Thursday, July 18, 2013
How gVim saved my day
Hi, in this article i personally record how gVim come very handy
to help me to filter out a CSV file.
Steps:
# to get rid the header
1. :g/^Sa...ka,,,,*/d
2. :g/^"General Ledger Detail",,,,*/d
3. :g/^"From 01 Jan .*",,,,*/d
4. :g/^"ACC.* Report",,,,*/d
4. :g/^"Printed.*",,,,*/d
5. :g/^"Page.*",,,*/d
6. :g/^,,,*/d
To use :g/regexRules/d <-- and="" d="" delete="" find="" is="" p="" to="">
Hope it helps.
-->
to help me to filter out a CSV file.
Steps:
# to get rid the header
1. :g/^Sa...ka,,,,*/d
2. :g/^"General Ledger Detail",,,,*/d
3. :g/^"From 01 Jan .*",,,,*/d
4. :g/^"ACC.* Report",,,,*/d
4. :g/^"Printed.*",,,,*/d
5. :g/^"Page.*",,,*/d
6. :g/^,,,*/d
To use :g/regexRules/d <-- and="" d="" delete="" find="" is="" p="" to="">
Hope it helps.
-->
Oracle Split String or Query Result
Hi, just found this Oracle split string. It saves me alot.
Since the first thing came into my head is like:
1. Query and fetch result.
2. Explode or split the result (i use PHP).
3. Perform array search.
Those are computational expensive due to large records.
Hope it helps.
Since the first thing came into my head is like:
1. Query and fetch result.
2. Explode or split the result (i use PHP).
3. Perform array search.
Those are computational expensive due to large records.
Hope it helps.
Subscribe to:
Posts (Atom)