Showing posts from July, 2013

Flask-SQLAlchemy, Mysql, Error #1005: Can't create table (errno: 105)?

Got Error #1005: Can't create table (errno: 105)? I got the error when the Flask-SQLAlchemy tries to init_db() of my 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

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.

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.

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.