Tuesday, July 30, 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 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

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.

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.



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.