Seite 1 von 2
MapMod - Fehlermeldung nach änderung das Profils
Verfasst: 22.05.2005 12:34
von Swat
Hi ich habe ein kleinmes Problme nach einbau des Mp Mods, wenn ich die Koordinaten eigebe und auf adsenden klicke kommt folgende Fehlermeldung :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php on line 214
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 554
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 556
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 557
und das kommt auch noch:
Could not update map table.
DEBUG MODE
SQL Error : 1062 Duplicate entry '2' for key 1
INSERT INTO phpbb_map_mod_user VALUES (2, 10.5667,52.9667)
Line : 706
File : usercp_register.php
Hier mal der Code aus der myspl4 :
Code: Alles auswählen
{
$query_id = $this->query_result;
}
if( $query_id )
{
214 ---> $this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);
return $this->row[$query_id];
}
else
{
return false;
}
}
function sql_fetchrowset($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
und hier das auf der page_header :
Code: Alles auswählen
{
header ('Cache-Control: no-cache, pre-check=0, post-check=0');
}
else
{
header ('Cache-Control: private, pre-check=0, post-check=0, max-age=0'); <--554
}
header ('Expires: 0'); <-- 556
header ('Pragma: no-cache'); <-- 557
//-- mod : ranks -----------------------------------------------------------------------------------
//-- add
Hat jemand eine Idee was da los ist ???
SWAT
Verfasst: 22.05.2005 15:29
von kratzer54847
verlink mal die Seite als TXT,auf der der Fehler erscheint
mfg Johny
Verfasst: 22.05.2005 16:05
von Swat
also die erste fehlermeldung habe ich bei der änderung des Profils wenn man auf absenden klicket :
profile.php
dann habe ich das jetzt auch bei der ansicht der beiträge :
viewforum.php
die fehelr melung leutet da auf
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id phpbb_posts_text pt WHE' at line 2
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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude FROM phpbb_posts p, phpbb_users u, LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id phpbb_posts_text pt WHERE p.topic_id = 120 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20
Line : 399
File : viewtopic.php
hoffe ihr könnt damit was anfangen
SWAT
Verfasst: 22.05.2005 16:09
von kratzer54847
für die Ansicht der Beiträge ist die viewtopic.php zuständig
wie lautet der Fehler im Profil?
Verfasst: 22.05.2005 16:27
von Swat
die fehlermeldung beim profil steht oben
Allgemeiner Fehler
Could not update map table.
DEBUG MODE
SQL Error : 1062 Duplicate entry '2' for key 1
INSERT INTO phpbb_map_mod_user VALUES (2, 10.5667,52.9667)
Line : 706
File : usercp_register.php
und da drüber steht :
Code: Alles auswählen
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php on line 214
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 554
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 556
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/db/mysql4.php:214) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 557
so und hier nochmal die
viewtopic.php.txt
SWAT
Verfasst: 22.05.2005 16:31
von kratzer54847
ersetze:
Code: Alles auswählen
$sql = "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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, LEFT JOIN " . MAP_MOD_USER_TABLE . " m ON u.user_id=m.user_id
" . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
$limit_posts_time
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];
mit
Code: Alles auswählen
$sql = "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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt, LEFT JOIN " . MAP_MOD_USER_TABLE . " m ON u.user_id=m.user_id
WHERE p.topic_id = $topic_id
$limit_posts_time
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];
Verfasst: 22.05.2005 16:40
von Swat
auch nach der änderung noch der gleiche Fehlermeldung der viewtopic.php
Allgemeiner Fehler
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id WHERE p.topic_id = 119' at line 2
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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id WHERE p.topic_id = 119 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20
Line : 398
File : viewtopic.php
Verfasst: 22.05.2005 16:41
von kratzer54847
kannst du mal nach
ein
einfügen und hier den Output posten?
mfg Johny
Verfasst: 22.05.2005 16:44
von Swat
mit echo $sql; :
oben :
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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id WHERE p.topic_id = 122 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/viewtopic.php:395) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 554
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/viewtopic.php:395) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 556
Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/ftpuser/swat/phpBB2/viewtopic.php:395) in /opt/lampp/htdocs/ftpuser/swat/phpBB2/includes/page_header.php on line 557
im normalen forum feld:
Allgemeiner Fehler
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id WHERE p.topic_id = 122' at line 2
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, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, m.longitude, m.latitude FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, LEFT JOIN phpbb_map_mod_user m ON u.user_id=m.user_id WHERE p.topic_id = 122 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 20
Line : 398
File : viewtopic.php
[/code]
Verfasst: 22.05.2005 16:47
von kratzer54847
entfern mal das Komma nach
mfg Johny