Wenn ich einen Gästebuch-Eintrag machen will bekomme ich folgende Meldung:
Code: Alles auswählen
Konnte Gästebucheintrag nicht hinzufügen!
Could not add entry!
DEBUG MODE
SQL Error : 1270 Illegal mix of collations (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'
SELECT COUNT(an) AS zaehle FROM phpbb_nickpagegb WHERE von = '2' AND an = '2' AND zeit BETWEEN '1104879950' AND '1104879981'
Line : 255
File : C:\Programme\apachefriends\xampp\htdocs\forum\nickpage_gb.phpDanke AntjeNDR
Edit:
Line 255 in der nickpage_gb.php:
Code: Alles auswählen
//Sicherheit
$sql = "SELECT safe_gb FROM ".NICKPAGE_TABLE." WHERE $uid='".$uid."'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Konnte UID nicht bestimmen!Could not get user id!', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
//User möchte das nur eingeloggte USer ins GB schreiben dürfen
if($row['safe_gb'] == "1" AND $userdata['user_id'] == "-1")
{
message_die(GENERAL_ERROR, $lang['NP_STOP'].': <b>'.$HTTP_GET_VARS['user'].'</b> '.$lang['NP_GB_USER_WANTS'].'!');
}
//Admin möchte, das nur ...
if($guestbook_writer == "1" AND $userdata['user_id'] == "-1")
{
message_die(GENERAL_ERROR, $lang['NP_STOP'].': '.$lang['NP_GB_REGISTERED_ONLY'].'!');
}
//Gästebuch ist gesperrt
if($allow_guestbook == "0")
{
message_die(GENERAL_ERROR, $lang['NP_STOP'].': '.$lang['NP_GB_FORBIDDEN_FROM_ADMIN'].'!');
}
if($HTTP_POST_VARS['addgbentry'] AND $HTTP_POST_VARS['message'] != "")
{
if($userdata['user_id'] == "-1")
{
$von_uid = -1;
$username = safeHTML($HTTP_POST_VARS['autor']);
}
else
{
$von_uid = $userdata['user_id'];
$username = $userdata['username'];
}
//Spam?
$sql = "SELECT COUNT(an) AS zaehle FROM ".GAESTEBUCH_TABLE." WHERE von = '".$von_uid."' AND an = '".$uid."' AND zeit BETWEEN '".(time()-30)."' AND '".(time()+1)."'";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Konnte Gästebucheintrag nicht hinzufügen!<br><br>Could not add entry!', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
if($row['zaehle'] == "0")
{
$sql = "INSERT INTO ".GAESTEBUCH_TABLE." (von, an, autor, zeit, message) VALUES ('".$von_uid."', '".$uid."', '".$username."', '".time()."', '".bbencode_first_pass(safeHTML($HTTP_POST_VARS['message']),$uid)."')";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Konnte Gästebucheintrag nicht hinzufügen!<br><br>Could not add entry!', '', __LINE__, __FILE__, $sql);
}
if(mysql_affected_rows() == "1")
{
mailto($uid);
echo '<span class="genmed"><br>
<br>
<br>
<center>'.$lang['NP_GB_THX'].'<br>
'.$lang['NP_WINDOW_CLOSE'].'</center></span>
<script type="text/javascript">
<!--
window.setTimeout("window.close()",5000);
//-->
</script>
';
exit;
}
}
else
{
echo '<span class="genmed"><br>
<br>
<br>
<center>'.$lang['NP_GB_THX'].'<br>
'.$lang['NP_WINDOW_CLOSE'].'</center></span>
<script type="text/javascript">
<!--
window.setTimeout("window.close()",5000);
//-->
</script>
';
exit;
}
}
if($userdata['user_id'] == "-1")
{
$template->assign_block_vars('Autor',array());
}
$template->assign_vars(array(
'U_WARNING' => $lang['NP_WARNING'],
'U_YOUR_NAME' => $lang['NP_YOUR_NAME'],
'U_MESSAGE_TO' => $lang['NP_MESSAGE_TO'],
'U_ADD_ENTRY' => $lang['NP_ADD_ENTRY'],
'U_RESET_ENTRY' => $lang['NP_RESET_ENTRY'],
'Nickname' => $HTTP_GET_VARS['user'],
));
