teşekkürler. peki bana neden böyle dedi bunlar. benim kendi ulaşabileceğim bir bölümemi ekleniyor acaba. yeda en iyisi tekrarmı yazsam onlara bu meseleyi
teşk kardeşim
şablon açılmadan değişiklik yapılamaz tabi. Ben bu sorunu öyle çözmüştüm ama şablonlar açılıyordu. Üstadlar bir yol gösterir elbet. bende bulursam çözümün nasıl yapıldığını aktarırım buraya
nasıl yani. admin paneline girebiliyormusun? nereye kadar gidebiliyorsun? tüm ayarlar kısmından giriyorsan birde normal şablonları düzenleden girmeyi dene. o şablona eklediğin veya aldığın kod vardır ondan yapıyordur.
Selam arkadaşlar. Üyelerime email gidebilmesi için hosting yetkililerine danıştım. Bana smtp kimlik doğrulaması yapmam gerektiğini söylediler. Ve örnek asp ve php kodları verdiler. Bunları nereye ve nasıl eklemem gerekiyor
<%
On Error Resume Next
For Each Doldur In Request.Form
Message = Message & Doldur & ": " & Request.Form(Doldur) & CHR(10)
Next
Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = "mail.alanadi.com"
Mail.Username = "destek@alanadi.com"
Mail.Password = "1544856"
Mail.From = "deneme@alanadi.com"
Mail.FromName = " Web Form "
Mail.AddAddress "destek@alanadi.com", "destek@alanadi.com"
Mail.AddReplyTo "destek@alanadi.com"
Mail.Subject = "Websitesinden Mail"
Mail.Body = Message
Mail.Send
If ERR Then
Response.Write err.Description & "<br>Lütfen tekrar deneyiniz."
Else
Response.Write "<br>Mesajiniz iletilmiştir. Tesekkür ederiz."
End If
Set Mail=Nothing
%>
// Attempt to load XML extension if we don't have the XML functions
// already loaded. It is needed for utf8_encode()
if (!function_exists('xml_set_element_handler'))
{
$extension_dir = ini_get('extension_dir');
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
{
$extension_file = 'php_xml.dll';
}
else
{
$extension_file = 'xml.so';
}
if ($extension_dir AND file_exists($extension_dir . '/' . $extension_file))
{
ini_set('display_errors', true);
dl($extension_file);
}
}
/**
* Standard Mail Sending Object
*
* This class sends email from vBulletin using the PHP mail() function
*
* @package vBulletin
* @version $Revision: 31684 $
* @date $Date: 2009-08-04 1102 -0500 (Tue, 04 Aug 2009) $
* @copyright http://www.vbulletin.com/license.html
*
*/
class vB_Mail
{
/**
* Destination address
*
* @var string
*/
var $toemail = '';
/**
* Line delimiter
*
* @var string
*/
var $delimiter = "\r\n";
/**
* Registry object for any options we need
*
* @var vB_Registry
*/
var $registry = null;
/**
* Switch to enable/disable debugging. When enabled, warnings are not suppressed
*
* @var boolean
*/
var $debug = false;
/**
* Message to log if logging is enabled
*
* @var string
*/
var $log = '';
/**
* Constructor
*
* @param vB_Registry vBulletin registry object
*/
function vB_Mail(&$registry)
{
if (is_object($registry))
{
$this->registry =& $registry;
}
else
{
trigger_error('Registry object is not an object', E_USER_ERROR);
}
$sendmail_path = @ini_get('sendmail_path');
if (!$sendmail_path OR $this->registry->options['use_smtp'] OR defined('FORCE_MAIL_CRLF'))
{
// no sendmail, so we're using SMTP or a server that lines CRLF to send mail // the use_smtp part is for the MailQueue extension
$this->delimiter = "\r\n";
}
else
{
$this->delimiter = "\n";
}
}
/**
* Starts the process of sending an email - preps it so it's fully ready to send.
* Call send() to actually send it.
*
* @param string Destination email address
* @param string Email message subject
* @param string Email message body
* @param string Optional name/email to use in 'From' header
* @param string Additional headers
* @param string Username of person sending the email
*
* @param boolean True on success, false on failure
*/
function start($toemail, $subject, $message, $from = '', $uheaders = '', $username = '')
{
$toemail = $this->fetch_first_line($toemail);
global $stylevar;
if ((strtolower($stylevar['charset']) == 'iso-8859-1' OR $stylevar['charset'] == '') AND preg_match('/&[a-z0-9#]+;/i', $message))
{
$message = utf8_encode($message);
$subject = utf8_encode($subject);
$username = utf8_encode($username);
$encoding = 'UTF-8';
$unicode_decode = true;
}
else
{
// we know nothing about the message's encoding in relation to UTF-8,
// so we can't modify the message at all; just set the encoding
$encoding = $stylevar['charset'];
$unicode_decode = false;
}
// theses lines may need to call convert_int_to_utf8 directly
$message = unhtmlspecialchars($message, $unicode_decode);
$subject = $this->encode_email_header(unhtmlspecialchars($subject, $unicode_decode), $encoding, false, false);
$from = $this->fetch_first_line($from);
if (empty($from))
{
global $vbphrase;
if (isset($vbphrase['x_mailer']))
{
$mailfromname = construct_phrase($this->fetch_first_line($vbphrase['x_mailer']), $vbulletin->options['bbtitle']);
}
else
{
$mailfromname = $vbulletin->options['bbtitle'];
}
/**
* Returns the first line of a string -- good to prevent errors when sending emails (above)
*
* @param string String to be trimmed
*
* @return string
*/
function fetch_first_line($text)
{
$text = preg_replace("/(\r\n|\r|\n)/s", "\r\n", trim($text));
$pos = strpos($text, "\r\n");
if ($pos !== false)
{
return substr($text, 0, $pos);
}
return $text;
}
/**
* Encodes a mail header to be RFC 2047 compliant. This allows for support
* of non-ASCII character sets via the quoted-printable encoding.
*
* @param string The text to encode
* @param string The character set of the text
* @param bool Whether to force encoding into quoted-printable even if not necessary
* @param bool Whether to quote the string; applies only if encoding is not done
*
* @return string The encoded header
*/
function encode_email_header($text, $charset = 'utf-8', $force_encode = false, $quoted_string = true)
{
$text = trim($text);
if (!$charset)
{
// don't know how to encode, so we can't
return $text;
}
/**
* Sends instruction to SMTP server
*
* @param string Message to be sent to server
* @param mixed Message code expected to be returned or false if non expected
*
* @return boolean Returns false on error
*/
function sendMessage($msg, $expectedResult = false)
{
if ($msg !== false AND !empty($msg))
{
fputs($this->smtpSocket, $msg . "\r\n");
}
if ($expectedResult !== false)
{
$result = '';
while ($line = @fgets($this->smtpSocket, 1024))
{
$result .= $line;
if (preg_match('#^(\d{3}) #', $line, $matches))
{
break;
}
}
$this->smtpReturn = intval($matches[1]);
return ($this->smtpReturn == $expectedResult);
}
return true;
}
/**
* Triggers PHP warning on error
*
* @param string Error message to be shown
*
* @return boolean Always returns false (error)
*/
function errorMessage($msg)
{
if ($this->debug)
{
trigger_error($msg, E_USER_WARNING);
}
$this->log_email($msg);
return false;
}
function sendHello()
{
if (!$this->smtpSocket)
{
return false;
}
if (!$this->sendMessage('EHLO ' . $this->smtpHost, 250))
{
if (!$this->sendMessage('HELO ' . $this->smtpHost, 250))
{
return false;
}
}
return true;
}
/**
* Attempts to send email based on parameters passed into start()/quick_set()
*
* @return boolean Returns false on error
*/
function send()
{
if (!$this->toemail)
{
return false;
}
if ($this->smtpSocket)
{
if (!$this->sendMessage(false, 220))
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response when connecting to SMTP server');
}
// do initial handshake
if (!$this->sendHello())
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response from SMTP server during handshake');
}
if ($this->secure == 'tls' AND function_exists('stream_socket_enable_crypto'))
{
if ($this->sendMessage('STARTTLS', 220))
{
if (!stream_socket_enable_crypto($this->smtpSocket, true, STREAM_CRYPTO_METHOD_TLS_CLIENT))
{
return $this->errorMessage('Unable to negotitate TLS handshake.');
}
}
// After TLS say Hi again
$this->sendHello();
}
if ($this->smtpUser AND $this->smtpPass)
{
if ($this->sendMessage('AUTH LOGIN', 334))
{
if (!$this->sendMessage(base64_encode($this->smtpUser), 334) OR !$this->sendMessage(base64_encode($this->smtpPass), 235))
{
return $this->errorMessage($this->smtpReturn . ' Authorization to the SMTP server failed');
}
}
}
if (!$this->sendMessage('MAIL FROM:<' . $this->fromemail . '>', 250))
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response from SMTP server during FROM address transmission');
}
// we could have multiple addresses since a few people might expect this to be the same as PHP
$addresses = explode(',', $this->toemail);
foreach ($addresses AS $address)
{
if (!$this->sendMessage('RCPT TO:<' . trim($address) . '>', 250))
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response from SMTP server during TO address transmission');
}
}
if ($this->sendMessage('DATA', 354))
{
$this->sendMessage('Date: ' . gmdate('r'), false);
$this->sendMessage('To: ' . $this->toemail, false);
$this->sendMessage(trim($this->headers), false); // trim to prevent double \r\n
$this->sendMessage('Subject: ' . $this->subject, false);
$this->sendMessage("\r\n", false); // this makes a double \r\n
// catch any single dots on their own
$this->message = preg_replace('#^\.' . $this->delimiter . '#m', '..' . $this->delimiter, $this->message);
$this->sendMessage($this->message, false);
}
else
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response from SMTP server during data transmission');
}
if (!$this->sendMessage('.', 250))
{
return $this->errorMessage($this->smtpReturn . ' Unexpected response from SMTP server when ending transmission');
}
// Don't check that QUIT returns a valid result as some servers just kill the connection e.g. smtp.gmail.com
$this->sendMessage('QUIT', 221);
fclose($this->smtpSocket);
$this->log_email();
return true;
}
else
{
return $this->errorMessage('Unable to connect to SMTP server');
}
}
}
/**
* Mail queueing class. This class should be accessed as a singleton via fetch_instance()!
* This class does not actually send emails, but rather queues them to be sent later in a batch.
*
* @package vBulletin
* @version $Revision: 31684 $
* @date $Date: 2009-08-04 1102 -0500 (Tue, 04 Aug 2009) $
* @copyright http://www.vbulletin.com/license.html
*
*/
class vB_QueueMail extends vB_Mail
{
/**
* The SQL to insert into the mail queue
*
* @var string
*/
var $mailsql = '';
/**
* The number of mails being inserted into the queue
*
* @var string
*/
var $mailcounter = '';
/**
* Whether to do bulk inserts into the database.
* Never set this option directly!
*
* @var boolean
*/
var $bulk = false;
/**
* Inserts the message into the queue instead of sending it.
*
* @return string True on success, false on failure
*/
function send()
{
if (!$this->toemail)
{
return false;
}
if ($this->bulk)
{
if (!empty($this->mailsql))
{
$this->mailsql .= ',';
}
$this->mailsql .= $data;
$this->mailcounter++;
// current insert exceeds half megabyte, insert it and start over
if (strlen($this->mailsql) > 524288)
{
$this->set_bulk(false);
$this->set_bulk(true);
}
}
else
{
/*insert query*/
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "mailqueue
(dateline, toemail, fromemail, subject, message, header)
VALUES
" . $data
);
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "datastore SET
data = data + 1
WHERE title = 'mailqueue'
");
// if we're using a alternate datastore, we need to give it an integer value
// this may not be atomic
if (method_exists($vbulletin->datastore, 'build'))
{
$mailqueue_db = $vbulletin->db->query_first("
SELECT data
FROM " . TABLE_PREFIX . "datastore
WHERE title = 'mailqueue'
");
$vbulletin->datastore->build('mailqueue', intval($mailqueue_db['data']));
}
}
return true;
}
/**
* Sets the bulk option. If disabling the option, this also flushes
* the cache into the database.
*
* @param boolean
*/
function set_bulk($bulk)
{
if ($bulk)
{
$this->bulk = true;
$this->mailcounter = 0;
$this->mailsql = '';
}
else if ($this->mailcounter AND $this->mailsql)
{
// turning off bulk sending, so save all the mails
$vbulletin =& $this->registry;
/*insert query*/
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "mailqueue
(dateline, toemail, fromemail, subject, message, header)
VALUES
" . $this->mailsql
);
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "datastore
SET data = data + " . intval($this->mailcounter) . "
WHERE title = 'mailqueue'
");
// if we're using a alternate datastore, we need to give it an integer value
// this may not be atomic
if (method_exists($vbulletin->datastore, 'build'))
{
$mailqueue_db = $vbulletin->db->query_first("
SELECT data
FROM " . TABLE_PREFIX . "datastore
WHERE title = 'mailqueue'
");
$vbulletin->datastore->build('mailqueue', intval($mailqueue_db['data']));
}
}
/**
* Singleton emulator. Fetches the instance if it doesn't exist.
* Be sure to accept a reference if using this function!
*
* @return vB_QueueMail Reference to the instance
*/
function &fetch_instance()
{
static $instance = null;
if ($instance === null)
{
global $vbulletin;
$instance =& new vB_QueueMail($vbulletin);
}
return $instance;
}
/**
* The only part of this class which actually sends an email.
* Sends mail from the queue.
*/
function exec_queue()
{
$vbulletin =& $this->registry;
if ($vbulletin->options['usemailqueue'] == 2)
{
// Lock mailqueue table so that only one process can
// send a batch of emails and then delete them
$vbulletin->db->lock_tables(array('mailqueue' => 'WRITE'));
}
$emails = $vbulletin->db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "mailqueue
ORDER BY mailqueueid
LIMIT " . intval($vbulletin->options['emailsendnum'])
);
$mailqueueids = '';
$newmail = 0;
$emailarray = array();
while ($email = $vbulletin->db->fetch_array($emails))
{
// count up number of mails about to send
$mailqueueids .= ',' . $email['mailqueueid'];
$newmail++;
$emailarray[] = $email;
}
if (!empty($mailqueueids))
{
// remove mails from queue - to stop duplicates being sent
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "mailqueue
WHERE mailqueueid IN (0 $mailqueueids)
");
if ($vbulletin->options['usemailqueue'] == 2)
{
$vbulletin->db->unlock_tables();
}
if ($vbulletin->options['use_smtp'])
{
$prototype =& new vB_SmtpMail($vbulletin);
}
else
{
$prototype =& new vB_Mail($vbulletin);
}
// update number of mails remaining
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "datastore SET
data = " . $newmail . ",
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue'
");
// if we're using a alternate datastore, we need to give it an integer value
// this may not be atomic
if (method_exists($vbulletin->datastore, 'build'))
{
$mailqueue_db = $vbulletin->db->query_first("
SELECT data
FROM " . TABLE_PREFIX . "datastore
WHERE title = 'mailqueue'
");
$vbulletin->datastore->build('mailqueue', intval($mailqueue_db['data']));
}
}
}
resmi birde bu şekilde koyayım dedim.
FreddyKrueger teşekkür ederim. Peki ben hosting şirketiyle görüşürsem onlar kendilerinden kaynaklı olup olmadığını bilirler değilmi?
hemen mail atıyorum onlra. tşkler
Slm arkadaşlar. Benim mail sorunum var. Üyelere özel msj geldiğinde mail ile haber verilsin istiyorum ama mail gitmiyor. admin panelinde bakım bölümünde mail test yaptım. bazı hatalar verdi. O hatalar bu resimde. Bu nasıl düzelir. Bilgisi oln yardım ederse sevinirim.
selam ile
Arkadaşlar konu başlığına bile ne yazacağımı bilemedim. garip birşey. birkaç gündür sitede sanki aniden kendi kendine reset atılıyor ve bütün üyeler düşüyor. online bölümüne bakınca normalde 50 / 60 kişi varken (üyeler ve misafirler) bu dediğim olduktan sonra 1 / 2 kişi filan görünüyor sonra tekrar toplanıyor. nedir bu bilgisi olan varsa yardım ederse sevinirim.
Çok teşekkür ederim ama sorun çözülmedi. Bügün siteme erişemedim yine. daha sonra erişim sağlanınca admin panelinden tabloları optimize ettim. bazı tabloların karşısında bir hata yazıyordu. tamamını kopyaladım. umarım faydalı olur.
[HTML]Check Status: OK
access Optimize Status: Table is already up to date
adminhelp Check Status: OK
adminhelp Optimize Status: Table is already up to date
administrator Check Status: OK
administrator Optimize Status: Table is already up to date
adminlog Check Warning: 2 clients are using or haven't closed the table properly
adminlog Check Status: OK
adminlog Optimize Status: OK
adminmessage Check Status: OK
adminmessage Optimize Status: Table is already up to date
adminutil Check Status: OK
adminutil Optimize Status: Table is already up to date
album Check Status: OK
album Optimize Status: Table is already up to date
albumpicture Check Status: OK
albumpicture Optimize Status: Table is already up to date
albumupdate Check Status: OK
albumupdate Optimize Status: Table is already up to date
announcement Check Status: OK
announcement Optimize Status: Table is already up to date
announcementread Check Status: OK
announcementread Optimize Status: Table is already up to date
attachment Check Status: OK
attachment Optimize Status: Table is already up to date
attachmentpermission Check Status: OK
attachmentpermission Optimize Status: Table is already up to date
attachmenttype Check Status: OK
attachmenttype Optimize Status: Table is already up to date
attachmentviews Check Status: OK
attachmentviews Optimize Status: Table is already up to date
avatar Check Status: OK
avatar Optimize Status: Table is already up to date
bbcode Check Warning: 1 client is using or hasn't closed the table properly
bbcode Check Status: OK
bbcode Optimize Status: Table is already up to date
bookmarksite Check Status: OK
bookmarksite Optimize Status: Table is already up to date
calendar Check Status: OK
calendar Optimize Status: Table is already up to date
calendarcustomfield Check Status: OK
calendarcustomfield Optimize Status: Table is already up to date
calendarmoderator Check Status: OK
calendarmoderator Optimize Status: Table is already up to date
calendarpermission Check Status: OK
calendarpermission Optimize Status: Table is already up to date
cron Check Warning: 2 clients are using or haven't closed the table properly
cron Check Status: OK
cron Optimize Status: Table is already up to date
cronlog Check Status: OK
cronlog Optimize Status: Table is already up to date
customavatar Check Warning: 1 client is using or hasn't closed the table properly
customavatar Check Status: OK
customavatar Optimize Status: OK
customprofilepic Check Warning: 1 client is using or hasn't closed the table properly
customprofilepic Check Status: OK
customprofilepic Optimize Status: Table is already up to date
datastore Check Warning: 2 clients are using or haven't closed the table properly
datastore Check Status: OK
datastore Optimize Status: OK
deletionlog Check Status: OK
deletionlog Optimize Status: Table is already up to date
discussion Check Status: OK
discussion Optimize Status: Table is already up to date
discussionread Check Status: OK
discussionread Optimize Status: Table is already up to date
editlog Check Warning: 1 client is using or hasn't closed the table properly
editlog Check Status: OK
editlog Optimize Status: Table is already up to date
event Check Status: OK
event Optimize Status: Table is already up to date
externalcache Check Status: OK
externalcache Optimize Status: Table is already up to date
faq Check Status: OK
faq Optimize Status: Table is already up to date
forum Check Warning: 1 client is using or hasn't closed the table properly
forum Check Status: OK
forum Optimize Status: OK
forumpermission Check Status: OK
forumpermission Optimize Status: Table is already up to date
forumprefixset Check Status: OK
forumprefixset Optimize Status: Table is already up to date
forumread Check Status: OK
forumread Optimize Status: Table is already up to date
groupmessage Check Status: OK
groupmessage Optimize Status: Table is already up to date
groupmessage_hash Check Status: OK
groupmessage_hash Optimize Status: Table is already up to date
groupread Check Status: OK
groupread Optimize Status: Table is already up to date
holiday Check Status: OK
holiday Optimize Status: Table is already up to date
humanverify Check Status: OK
humanverify Optimize Status: Table is already up to date
hvanswer Check Status: OK
hvanswer Optimize Status: Table is already up to date
hvquestion Check Status: OK
hvquestion Optimize Status: Table is already up to date
icon Check Status: OK
icon Optimize Status: Table is already up to date
imagecategory Check Status: OK
imagecategory Optimize Status: Table is already up to date
imagecategorypermission Check Status: OK
imagecategorypermission Optimize Status: Table is already up to date
infraction Check Status: OK
infraction Optimize Status: Table is already up to date
infractionban Check Status: OK
infractionban Optimize Status: Table is already up to date
infractiongroup Check Status: OK
infractiongroup Optimize Status: Table is already up to date
infractionlevel Check Status: OK
infractionlevel Optimize Status: Table is already up to date
language Check Status: OK
language Optimize Status: Table is already up to date
mailqueue Check Warning: 1 client is using or hasn't closed the table properly
mailqueue Check Status: OK
mailqueue Optimize Status: OK
moderation Check Status: OK
moderation Optimize Status: Table is already up to date
moderator Check Status: OK
moderator Optimize Status: Table is already up to date
moderatorlog Check Warning: 1 client is using or hasn't closed the table properly
moderatorlog Check Status: OK
moderatorlog Optimize Status: Table is already up to date
notice Check Status: OK
notice Optimize Status: Table is already up to date
noticecriteria Check Status: OK
noticecriteria Optimize Status: Table is already up to date
noticedismissed Check Status: OK
noticedismissed Optimize Status: Table is already up to date
passwordhistory Check Warning: 1 client is using or hasn't closed the table properly
passwordhistory Check Status: OK
passwordhistory Optimize Status: Table is already up to date
paymentapi Check Status: OK
paymentapi Optimize Status: Table is already up to date
paymentinfo Check Status: OK
paymentinfo Optimize Status: Table is already up to date
paymenttransaction Check Status: OK
paymenttransaction Optimize Status: Table is already up to date
phrase Check Status: OK
phrase Optimize Status: Table is already up to date
phrasetype Check Status: OK
phrasetype Optimize Status: Table is already up to date
picture Check Status: OK
picture Optimize Status: Table is already up to date
picturecomment Check Status: OK
picturecomment Optimize Status: Table is already up to date
picturecomment_hash Check Status: OK
picturecomment_hash Optimize Status: Table is already up to date
plugin Check Status: OK
plugin Optimize Status: Table is already up to date
pm Check Warning: 2 clients are using or haven't closed the table properly
pm Check Status: OK
pm Optimize Status: OK
pmreceipt Check Warning: 1 client is using or hasn't closed the table properly
pmreceipt Check Status: OK
pmreceipt Optimize Status: OK
pmtext Check Warning: 1 client is using or hasn't closed the table properly
pmtext Check Status: OK
pmtext Optimize Status: OK
pmthrottle Check Status: OK
pmthrottle Optimize Status: Table is already up to date
podcast Check Status: OK
podcast Optimize Status: Table is already up to date
podcastitem Check Status: OK
podcastitem Optimize Status: Table is already up to date
poll Check Status: OK
poll Optimize Status: Table is already up to date
pollvote Check Status: OK
pollvote Optimize Status: Table is already up to date
post Check Warning: 1 client is using or hasn't closed the table properly
post Check Status: OK
post Optimize Status: OK
postedithistory Check Warning: 1 client is using or hasn't closed the table properly
postedithistory Check Status: OK
postedithistory Optimize Status: Table is already up to date
posthash Check Warning: 2 clients are using or haven't closed the table properly
posthash Check Status: OK
posthash Optimize Status: OK
postindex Check Status: OK
postindex Optimize Status: Table is already up to date
postlog Check Warning: 1 client is using or hasn't closed the table properly
postlog Check Status: OK
postlog Optimize Status: OK
postparsed Check Warning: 2 clients are using or haven't closed the table properly
postparsed Check Status: OK
postparsed Optimize Status: OK
prefix Check Status: OK
prefix Optimize Status: Table is already up to date
prefixpermission Check Status: OK
prefixpermission Optimize Status: Table is already up to date
prefixset Check Status: OK
prefixset Optimize Status: Table is already up to date
product Check Status: OK
product Optimize Status: Table is already up to date
productcode Check Status: OK
productcode Optimize Status: Table is already up to date
productdependency Check Status: OK
productdependency Optimize Status: Table is already up to date
profileblockprivacy Check Status: OK
profileblockprivacy Optimize Status: Table is already up to date
profilefield Check Status: OK
profilefield Optimize Status: Table is already up to date
profilefieldcategory Check Status: OK
profilefieldcategory Optimize Status: Table is already up to date
profilevisitor Check Warning: 1 client is using or hasn't closed the table properly
profilevisitor Check Status: OK
profilevisitor Optimize Status: OK
ranks Check Status: OK
ranks Optimize Status: Table is already up to date
reminder Check Status: OK
reminder Optimize Status: Table is already up to date
reputation Check Status: OK
reputation Optimize Status: Table is already up to date
reputationlevel Check Status: OK
reputationlevel Optimize Status: Table is already up to date
rssfeed Check Status: OK
rssfeed Optimize Status: Table is already up to date
rsslog Check Status: OK
rsslog Optimize Status: Table is already up to date
search Check Warning: 2 clients are using or haven't closed the table properly
search Check Status: OK
search Optimize Status: OK
setting Check Status: OK
setting Optimize Status: Table is already up to date
settinggroup Check Status: OK
settinggroup Optimize Status: Table is already up to date
sigparsed Check Warning: 1 client is using or hasn't closed the table properly
sigparsed Check Status: OK
sigparsed Optimize Status: OK
sigpic Check Status: OK
sigpic Optimize Status: Table is already up to date
smilie Check Status: OK
smilie Optimize Status: Table is already up to date
socialgroup Check Status: OK
socialgroup Optimize Status: Table is already up to date
socialgroupcategory Check Status: OK
socialgroupcategory Optimize Status: Table is already up to date
socialgroupicon Check Status: OK
socialgroupicon Optimize Status: Table is already up to date
socialgroupmember Check Status: OK
socialgroupmember Optimize Status: Table is already up to date
socialgrouppicture Check Status: OK
socialgrouppicture Optimize Status: Table is already up to date
spamlog Check Status: OK
spamlog Optimize Status: Table is already up to date
stats Check Status: OK
stats Optimize Status: Table is already up to date
strikes Check Status: OK
strikes Optimize Status: Table is already up to date
style Check Status: OK
style Optimize Status: Table is already up to date
subscribediscussion Check Status: OK
subscribediscussion Optimize Status: Table is already up to date
subscribeevent Check Status: OK
subscribeevent Optimize Status: Table is already up to date
subscribeforum Check Status: OK
subscribeforum Optimize Status: Table is already up to date
subscribegroup Check Status: OK
subscribegroup Optimize Status: Table is already up to date
subscribethread Check Warning: 1 client is using or hasn't closed the table properly
subscribethread Check Status: OK
subscribethread Optimize Status: OK
subscription Check Status: OK
subscription Optimize Status: Table is already up to date
subscriptionlog Check Status: OK
subscriptionlog Optimize Status: Table is already up to date
subscriptionpermission Check Status: OK
subscriptionpermission Optimize Status: Table is already up to date
tachyforumcounter Check Status: OK
tachyforumcounter Optimize Status: Table is already up to date
tachyforumpost Check Status: OK
tachyforumpost Optimize Status: Table is already up to date
tachythreadcounter Check Status: OK
tachythreadcounter Optimize Status: Table is already up to date
tachythreadpost Check Status: OK
tachythreadpost Optimize Status: Table is already up to date
tag Check Warning: 1 client is using or hasn't closed the table properly
tag Check Status: OK
tag Optimize Status: Table is already up to date
tagsearch Check Warning: 1 client is using or hasn't closed the table properly
tagsearch Check Status: OK
tagsearch Optimize Status: Table is already up to date
tagthread Check Warning: 1 client is using or hasn't closed the table properly
tagthread Check Status: OK
tagthread Optimize Status: OK
template Check Status: OK
template Optimize Status: Table is already up to date
templatehistory Check Status: OK
templatehistory Optimize Status: Table is already up to date
thread Check Warning: 2 clients are using or haven't closed the table properly
thread Check Status: OK
thread Optimize Status: OK
threadrate Check Warning: 1 client is using or hasn't closed the table properly
threadrate Check Status: OK
threadrate Optimize Status: Table is already up to date
threadread Check Status: OK
threadread Optimize Status: Table is already up to date
threadredirect Check Warning: 1 client is using or hasn't closed the table properly
threadredirect Check Status: OK
threadredirect Optimize Status: Table is already up to date
threadviews Check Status: OK
threadviews Optimize Status: Table is already up to date
upgradelog Check Status: OK
upgradelog Optimize Status: Table is already up to date
user Check Warning: 2 clients are using or haven't closed the table properly
user Check Status: OK
user Optimize Status: OK
useractivation Check Status: OK
useractivation Optimize Status: Table is already up to date
userban Check Status: OK
userban Optimize Status: Table is already up to date
userchangelog Check Status: OK
userchangelog Optimize Status: Table is already up to date
usercss Check Status: OK
usercss Optimize Status: Table is already up to date
usercsscache Check Status: OK
usercsscache Optimize Status: Table is already up to date
userfield Check Warning: 1 client is using or hasn't closed the table properly
userfield Check Status: OK
userfield Optimize Status: Table is already up to date
usergroup Check Status: OK
usergroup Optimize Status: Table is already up to date
usergroupleader Check Status: OK
usergroupleader Optimize Status: Table is already up to date
usergrouprequest Check Status: OK
usergrouprequest Optimize Status: Table is already up to date
userlist Check Warning: 1 client is using or hasn't closed the table properly
userlist Check Status: OK
userlist Optimize Status: Table is already up to date
usernote Check Status: OK
usernote Optimize Status: Table is already up to date
userpromotion Check Status: OK
userpromotion Optimize Status: Table is already up to date
usertextfield Check Warning: 1 client is using or hasn't closed the table properly
usertextfield Check Status: OK
usertextfield Optimize Status: OK
usertitle Check Status: OK
usertitle Optimize Status: Table is already up to date
vbfields Check Status: OK
vbfields Optimize Status: Table is already up to date
visitormessage Check Warning: 2 clients are using or haven't closed the table properly
visitormessage Check Status: OK
visitormessage Optimize Status: OK
visitormessage_hash Check Warning: 2 clients are using or haven't closed the table properly
visitormessage_hash Check Status: OK
visitormessage_hash Optimize Status: OK
word Check Status: OK
word Optimize Status: Table is already up to date
zseo_ad Check Status: OK
zseo_ad Optimize Status: Table is already up to date
zseo_ad_key Check Status: OK
zseo_ad_key Optimize Status: Table is already up to date
zseo_ad_placement Check Status: OK
zseo_ad_placement Optimize Status: Table is already up to date
[/HTML]
$config['Database']['dbname'] = 'aaa';
$config['MasterServer']['username'] = 'bbb';
$config['MasterServer']['password'] = 'ccc';
ben kendi üye adımı sonradan değişmiştim. ondan olabilirmi? ilk db açtığımda kullandığım üye adımı değişmiştim sonradan. acaba ondanmı oldu?
teşekkürler şimdiden
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">ruhsesi.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The ruhsesi.com forum technical staff have been notified of the error, though you may <a href="[EMAIL=""]mailto:[/EMAIL]">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/var/www/vhosts/ruhsesi.com/httpdocs/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Monday, April 12th 2010 @ 0339 PM
Error Date : Monday, April 12th 2010 @ 0343 PM
Script : http://ruhsesi.com/online.php
Referrer : http://ruhsesi.com/
IP Address : 88.242.123.167
Username :
Classname : vB_Database
MySQL Version :
-->
Şuan tabloları optimize ettiğim için hata vermiyor. kısa süre sonra yine yapacaktır. Hemen sayfa kaynağından hata mesajını alıp buraya yazıcam. Teşekkürler Değerli FreddyKruegger
arkadaşlar bu sorun başıma bela oldu. Sitemi başka bir hosta taşıdım. bu yeni yer linux. ama taşıdıktan sonra bazen database error hatası almaya başladım. bu sitede gördüğüm bir konudakini uyguluyorum. yani bakım/tabloları onar/ optimize et/ hepsini onar/ işlemi tekrarla. bunu yapınca kısa süre hata vermiyor. ama sonra olmadık sayfada hata veriyor yine. bazan anasayfa bu hatayı veriyor. bazende rastgele bir sayfa database error veriyor. Neden olduğunu çözemedim gitti. Bilginize ihtiyacım var. Şimdiden teşekkürler