avatar probleem: Could not update users table

[frankoptlandt]

als ik op mijn forum mijn avatar wil uploaden, krijg ik de melding 'Could not update users table'.
ik heb wel in me templates pagina's veranderd, maar daar ligt het als het goed is niet aan, want ik heb de ongewijzigde templates terug gezet en krijg nog steeds deze melding.
weet iemand wat er fout is?
dit is mijn site: http://members.lycos.nl/lunaticn/phpbb/

[frankoptlandt]

ik krijg de volgende melding in Debug Mode:

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notif' at line 2

UPDATE phpbb_users SET user_email = 'lunaticnight@wanadoo.nl', user_icq = '', user_website = 'http://www.frenkcky.tk', user_occ = '', user_from = 'Bodegraven', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = , user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1.00, user_dateformat = 'l d F Y, H:i', user_lang = 'dutch', user_style = 1, user_active = 1, user_actkey = '', user_avatar = 'd4819ed83ea7eb2e51fe2.jpg', user_avatar_type = 1 WHERE user_id = 2

Line : 441
File : /data/members/free/tripod/nl/l/u/n/lunaticn/htdocs/phpbb/includes/usercp_register.php

[KevinS]

Jah lycos...

Er zitten veel fouten in lycos waardoor phpbb niet goed werkt daar.
Maar ik zal eens voor je kijken....

[frankoptlandt]

Ik denk dat ik het probleem heb gevonden.
Ik had een paar opties uit profile_add_body template, de opties met JA en NEE, nu heb ik voor de gebruiker gekozen, zoals hier:

Code: Selecteer alles

Zo is het origineel:
   <tr> 
     <td class="row1"><span class="gen">{L_PUBLIC_VIEW_EMAIL}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="viewemail" value="1" {VIEW_EMAIL_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="viewemail" value="0" {VIEW_EMAIL_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_HIDE_USER}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="hideonline" value="1" {HIDE_USER_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="hideonline" value="0" {HIDE_USER_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_NOTIFY_ON_REPLY}:</span><br /> 
      <span class="gensmall">{L_NOTIFY_ON_REPLY_EXPLAIN}</span></td> 
     <td class="row2"> 
      <input type="radio" name="notifyreply" value="1" {NOTIFY_REPLY_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="notifyreply" value="0" {NOTIFY_REPLY_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_NOTIFY_ON_PRIVMSG}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="notifypm" value="1" {NOTIFY_PM_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="notifypm" value="0" {NOTIFY_PM_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_POPUP_ON_PRIVMSG}:</span><br /><span class="gensmall">{L_POPUP_ON_PRIVMSG_EXPLAIN}</span></td> 
     <td class="row2"> 
      <input type="radio" name="popup_pm" value="1" {POPUP_PM_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="popup_pm" value="0" {POPUP_PM_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_ALWAYS_ADD_SIGNATURE}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="attachsig" value="1" {ALWAYS_ADD_SIGNATURE_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="attachsig" value="0" {ALWAYS_ADD_SIGNATURE_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_ALWAYS_ALLOW_BBCODE}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="allowbbcode" value="1" {ALWAYS_ALLOW_BBCODE_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="allowbbcode" value="0" {ALWAYS_ALLOW_BBCODE_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_ALWAYS_ALLOW_HTML}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="allowhtml" value="1" {ALWAYS_ALLOW_HTML_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="allowhtml" value="0" {ALWAYS_ALLOW_HTML_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr> 
   <tr> 
     <td class="row1"><span class="gen">{L_ALWAYS_ALLOW_SMILIES}:</span></td> 
     <td class="row2"> 
      <input type="radio" name="allowsmilies" value="1" {ALWAYS_ALLOW_SMILIES_YES} /> 
      <span class="gen">{L_YES}</span>&& 
      <input type="radio" name="allowsmilies" value="0" {ALWAYS_ALLOW_SMILIES_NO} /> 
      <span class="gen">{L_NO}</span></td> 
   </tr>

maar nu heb ik het zo:

Code: Selecteer alles

<input type="hidden" name="hideonline" value="0" /> 
<input type="hidden" name="popup_pm" value="1" /> 
<input type="hidden" name="attachsig" value="1" /> 
<input type="hidden" name="allowbbcode" value="1" /> 
<input type="hidden" name="allowhtml" value="1" /> 
<input type="hidden" name="allowsmilies" value="1" />

Het werkt perfect nu, maar in ieder geval heel erg bedankt!

Frank