phpBB España Oficial

Código: Seleccionar todo

Error General
SQL ERROR [ mysqli ]

Can't create/write to file '/var/log/mysql/tmp/#sql_1b99_0.MYI' (Errcode: 2) [1]

SQL

SELECT u.user_id, u.user_type, u.user_reminder_inactive, u.user_allow_massemail, u.user_lastvisit, u.user_email, u.user_notify_type, u.user_jabber, u.username, u.user_lang, u.username_clean, MAX(s.session_time) AS session_time FROM (phpbb3_users u) LEFT JOIN phpbb3_sessions s ON (s.session_user_id = u.user_id) WHERE u.user_id NOT IN ('', '29', '80', 1) AND u.user_type NOT IN (2, 1) AND u.user_reminder_inactive = 0 AND u.user_allow_massemail = 1 AND (u.user_lastvisit < 1284792652 OR session_time < 1284792652) GROUP BY u.user_id, u.user_type, u.user_reminder_inactive, u.user_allow_massemail, u.user_lastvisit, u.user_email, u.user_notify_type, u.user_jabber, u.username, u.user_lang, u.username_clean ORDER BY u.user_lastvisit DESC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user_reminder.php
LINE: 223
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 284
CALL: send_user_reminders()

Código: Seleccionar todo

Error General
SQL ERROR [ mysqli ]

Can't create/write to file '/var/log/mysql/tmp/#sql_1b99_0.MYI' (Errcode: 2) [1]

SQL

SELECT p.*, u.user_id, u.username, u.user_colour, r.rate_image_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments FROM phpbb3_gallery_images AS p LEFT JOIN phpbb3_users AS u ON p.image_user_id = u.user_id LEFT JOIN phpbb3_gallery_albums AS ct ON p.image_album_id = ct.album_id LEFT JOIN phpbb3_gallery_rates AS r ON p.image_id = r.rate_image_id LEFT JOIN phpbb3_gallery_comments AS c ON p.image_id = c.comment_image_id WHERE ((image_album_id IN ('25', '1', '22'))) AND ( p.image_status = 1) GROUP BY p.image_id ORDER BY RAND() LIMIT 4

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: portal/block/center_gallery_random_picsonly_body.php
LINE: 105
CALL: dbal_mysqli->sql_query()

FILE: portal/includes/viewforum_blocks.php
LINE: 53
CALL: include_once('portal/block/center_gallery_random_picsonly_body.php')

FILE: viewtopic.php
LINE: 92
CALL: include_once('portal/includes/viewforum_blocks.php')