Tumblelog by Soup.io
Newer posts are loading.
You are at the newest post.
Click here to check if anything new just came in.
lfittl

MySQL error 1025: Error on rename .. (errno: 152)

You are trying to delete a column in a table using:

ALTER TABLE sometable DROP foreign_something;

And MySQL gives you a strange error message like this:

ERROR 1025 (HY000): Error on rename of './somedatabase/sometable' to './somedatabase/#sql2-4aab-71' (errno: 152)

Turns out, the MySQL query parser thinks you want to delete a foreign key, because the column name starts with "foreign", and you didn't escape it properly.

ALTER TABLE sometable DROP `foreign_something`;
or ALTER TABLE sometable DROP COLUMN foreign_something;

works just fine.
lfittl

♫ Noah and the Whale - The First Days Of Spring

lfittl
3830_1ab7
The sweet magic of SSD
Delaying database scalability issues, pretty effectively.
Reposted byjooray jooray
lfittl
Play fullscreen
Teitur Lassen and Nico Muhly soundtrack their favorite YouTube videos in their series Confessions.
Reposted fromlfittl-inspiration lfittl-inspiration
lfittl

Steve Blank: Customer Development for Web Startups

lfittl

Cassandra @ Twitter: An Interview with Ryan King

lfittl
Play fullscreen
Constable Crescent warehouse conversion
The apartment I was living in for the first month in London. Good old times.

Though I'm still glad we moved to a much nicer place near London Bridge for the other months.
lfittl

Moscow-Vladivostok: Virtual Journey

lfittl
Play fullscreen
Max Richter - Song
lfittl

How to optimize web apps with KISSmetrics

Venture Hacks interview with Hiten Shah
Older posts are this way If this message doesn't go away, click anywhere on the page to continue loading posts.
Could not load more posts
Maybe Soup is currently being updated? I'll try again automatically in a few seconds...
Just a second, loading more posts...
You've reached the end.