Здравствуйте!
Как-то начали жаловаться пользователи форума vBulletin 3.8.6, что бывает ловят ошибки базы данных, сами ошибки приведены ниже. Форум уже три дня вдоль и поперек излапатил, точное решение не нашел.
Как я только не плясал с бубном так ничего и не добился ... Я в тупике :(
Что было сделано мною:
- обратился к хостеру, от которого получил ответ:
Все эти ошибки указывают на недостаток памяти ( Cannot allocate memory in )
C уважением, системный администратор
- проверил память memory_limit=128M
Что еще можно предпринять?
У меня форум установлен на выделенном сервере,
Процессор 3000 Mhz
Оперативная память 1200 MB
Одновременно на форуме сидит не более 50 человек
Подскажите пожалуйста, что еще можно предпринять?
WHERE post.postid IN (0,198924,203242)
ORDER BY post.dateline;
Ошибка MySQL : Can't find file: './nazvanie/vB_editlog.frm' (errno: 12)
Номер ошибки : 1017
Дата запроса : Thursday, March 24th 2011 @ 04:13:17 PM
Дата ошибки : Thursday, March 24th 2011 @ 04:13:18 PM
Скрипт :
http://nazvanie-club.ru/showthread.php?t=10565
Реферрер :
http://nazvanie-club.ru/showthread.php?t=10565
IP адрес : 94.179.19.127
Имя пользователя : sabid
Имя класса : vB_Database
Версия MySQL : 5.0.51a-24+lenny4
Еще одна ошибка
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM vB_post AS post
LEFT JOIN vB_user AS user ON(user.userid = post.userid)
LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vB_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vB_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vB_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vB_spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN vB_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN vB_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vB_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)
LEFT JOIN vB_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)
LEFT JOIN vB_sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,4284,200131,200132,200134,200136,200137,200138, 200140,200141,200142,200144,200148,200149,200152,2 00163,4284)
ORDER BY post.dateline;
Ошибка MySQL : Can't find file: './nazvanie/vB_deletionlog.frm' (errno: 12)
Номер ошибки : 1017
Дата запроса : Friday, March 25th 2011 @ 12:36:23 PM
Дата ошибки : Friday, March 25th 2011 @ 12:36:23 PM
Скрипт :
http://nazvanie-club.ru/showthread.php?t=1071
Реферрер :
http://nazvanie-club.ru/forumdisplay.php?f=2076
IP адрес : 188.138.48.20
Имя пользователя : VIC
Имя класса : vB_Database
Версия MySQL : 5.0.51a-24+lenny4
Еще одна ошибка
Warning: require_once([path]/includes/class_hook.php) [function.require-once]: failed to open stream: Cannot allocate memory in [path]/includes/init.php on line 275
Fatal error: require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/class_hook.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/nazvanie/data/www/nazvanie-club.ru/includes/init.php on line 275
Еще одна ошибка
Warning: file_get_contents([path]/includes/database_error_message.html) [function.file-get-contents]: failed to open stream: Cannot allocate memory in [path]/includes/class_core.php on line 998
Warning: vB_Database::require_once([path]/includes/functions_log_error.php) [vb-database.require-once]: failed to open stream: Cannot allocate memory in [path]/includes/class_core.php on line 1000
Fatal error: vB_Database::require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/functions_log_error.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/nazvanie/data/www/nazvanie-club.ru/includes/class_core.php on line 1000
Еще одна при попытке отправить личное сообщение:
Warning: require_once([path]/includes/functions_user.php) [function.require-once]: failed to open stream: Cannot allocate memory in [path]/private.php on line 134
Fatal error: require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/functions_user.php' (include_path='.:/usr/share/php:/usr/share/pear') in/var/www/nazvanie/data/www/nazvanie-club.ru/private.php on line 134
Еще одна ошибка
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM vB_post AS post
LEFT JOIN vB_user AS user ON(user.userid = post.userid)
LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vB_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vB_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vB_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vB_spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN vB_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN vB_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vB_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)
LEFT JOIN vB_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)
LEFT JOIN vB_sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,203630,203676,203714,203754,203757,203763,20384 0,203861)
ORDER BY post.dateline;
Ошибка MySQL : File './nazvanie/vB_postparsed.MYD' not found (Errcode: 12)
Номер ошибки : 29
Дата запроса : Friday, March 25th 2011 @ 03:48:30 PM
Дата ошибки : Friday, March 25th 2011 @ 03:48:31 PM
Скрипт :
http://nazvanie-club.ru/showthread.php?p=203861
Реферрер :
http://nazvanie-club.ru/search.php?searchid=36196
IP адрес : 188.138.48.20
Имя пользователя : VIC
Имя класса : vB_Database
Версия MySQL : 5.0.51a-24+lenny4
Ошибки базы данных
