Discussion :

[webfranc]

Bonsoir a toute et tous,
je viens de rajouter dans le formulaire d'enregistrement 4 champs: banner, description, title, category et j'ai modifié le fichier usercp_register de sorte a envoyer les enregistrement sur la base de donnée , le code sql pour insérer les enregistrement marche bien, par contre pour mettre à jour les données de l'utilisateur j'ai ce message d'erreur:

Code X :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
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 'test5.com', title = 'test5', description = 'test5', category =

UPDATE phpbb_users SET user_email = 'test5@test5.com', user_icq = '', user_website = 'http://test5.com', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, 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 d, Y g:i a', user_lang = 'french', user_style = 1, user_active = 1, user_actkey = ''', banner = 'test5.com', title = 'test5', description = 'test5', category = '36' WHERE user_id = 1790

Line : 531
File : usercp_register.php

voici le code pour update:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
$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_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 . "', banner = '" . str_replace
 
("\'", "''", $banner) . "', title = '" . str_replace("\'", "''", $title) . "', description = '" . str_replace("\'", "''", 
 
$description) . "', category = '" . str_replace("\'", "''", $category) . "'
				WHERE user_id = $user_id";

[mathieu]

enlève l'apostrophe qui est juste avant ", banner"