- Wat is het probleem? Mijn forum geeft een foutmelding
Waneer onstond het probleem? Vandaag, om 18.11 toen ik, Add new field to profile Mod installeerde
Adres van je forum: http://www.forum.gamemaniak.nl
Geïnstalleerde mods: Een hele waslijst
Huidige template: subSilver, aangepast
phpBB versie: 2.0.19
Host: Flexwebhosting
Heb je onlangs een mod of stijl geïnstalleerd? Jah, deze
Heb je gezocht naar een antwoord?
Overige opmerkingen:
Jah, hij geeft deze foutmelding:
Dit is het stukje van usercp_register.php van regel 588 t/m 91:Could not update users table
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 ''Test' , user_sig = 'Visit Gamemaniak Every Day!!!', user_sig_bb
UPDATE phpbb_users SET user_email = 'beheerder@gamemaniak.nl', user_icq = '', user_website = 'http://www.gamemaniak.nl', user_occ = 'Folders Rondbrengen (dit is eigenlijk een bijbaantje)', user_from = 'Gametown', user_interests = 'Gamen, Websitesbouwen (deze bijvoorbeeld)', user_birthday = '7961', user_next_birthday_greeting = '2006' = user_info 'Test' , user_sig = 'Visit Gamemaniak Every Day!!!', user_sig_bbcode_uid = '4f95fbc29a', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = 'marc_van_hec@hotmail.com', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'd M Y G:i', user_lang = 'dutch', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2
Line : 593
File : usercp_register.php
Code: Selecteer alles
$sql = "UPDATE " . USERS_TABLE . "
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting' = user_info '" . str_replace("\'", "''", $info) . "' , user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
