Форум сетевых администраторов (http://netadmin.ws/forum/index.php)
- Установка и настройка (http://netadmin.ws/forum/forumdisplay.php?forumid=28)
-- Проблема с MySQL (http://netadmin.ws/forum/showthread.php?threadid=5292)

Проблема с MySQL

Что за ерундистика, ничего не понимаю, что означает вот такая ошибка?

Общая ошибка

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1 Can't create/write to file '/tmp/#sql6cc9_7dc8_0.MYI' (Errcode: 122)

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM nuke_phpbb_posts p, nuke_phpbb_users u, nuke_phpbb_posts_text pt WHERE p.topic_id = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 411
File : /home/webadmin/cvyouth.com/html/portal/modules/PNphpBB2/viewtopic.php

Или вот такое

DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM gallery_categories c LEFT JOIN gallery_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1051138332 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Can't create/write to file '/tmp/#sql6cc9_7dd4_0.MYI' (Errcode: 122)

Warning: Cannot add header information - headers already sent by (output started at /home/webadmin/cvyouth.com/html/gallery/includes/db_mysql.php:188) in /home/webadmin/cvyouth.com/html/gallery/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/webadmin/cvyouth.com/html/gallery/includes/db_mysql.php:188) in /home/webadmin/cvyouth.com/html/gallery/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/webadmin/cvyouth.com/html/gallery/includes/db_mysql.php:188) in /home/webadmin/cvyouth.com/html/gallery/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/webadmin/cvyouth.com/html/gallery/includes/db_mysql.php:188) in /home/webadmin/cvyouth.com/html/gallery/includes/sessions.php on line 85

Не может записать в файл. У меня была похожая проблема в php с сессиями. После того как я создал пустой файл с нужным именем у меня все заработало.
А вообще по проблемам с бд можно обратиться к хостеру. Пусть он думает.

__________________
Мой форум для программистов

/tmp директорию почистить надо, в ней места уже нет

__________________
http://www.phpdevs.com
�_усский ресурс о PHP