Error 1005
ALTER TABLE video_thumb ADD <span class='keyword_code'>FOREIGN KEY</span> (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-engineError 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
Last update: 250 days ago