World of Bauds

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

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.

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.

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.