minte9
LearnRemember   MYSQL





Error 1005 

 
ALTER TABLE video_thumb ADD FOREIGN KEY (video_id) REFERENCES video (id)
ON DELETE CASCADE;
    -> Error Code : 1005
Solution: Check if video_id and id has identical definition (ex. Unsigned, Int)

Error 28

Means "No space left on device". Even if there is a lot of space left, the query you are executing may need to create temporary tables and such during it's execution, which will obviously require extra space. http://bytes.com/topic/mysql/answers/818003-1030-got-error-28-storage-engine

Error 1093

How to avoid error 1093, witch basicaly appears when you are using subqueries. 
 
DELETE FROM catg_path
WHERE t1.descendant IN (
    SELECT descendant 
    FROM catg_path 
    WHERE ancestor = 7
);
    # Error Code : 1093 
    # You can't specify target table 't1' for update in FROM clause
Solution: 
 
DELETE FROM catg_path
WHERE descendant IN (
    SELECT descendant 
    FROM (SELECT * FROM catg_path) t2 
    WHERE ancestor = 7
);
    # work!
http://www.mysqlfaqs.net/mysql-faqs/Errors/1093-You-can-not-specify-target-table-comments-for-update-in-FROM-clause

Max user connections

What to do when you get max_user_connections error. MYSQL Error << user **** has already more than 'max_user_connections' active connections >> Make sure that persistent_connections is turned off in your config.php file



References: