MOD Sortierung der Antworten! Datenbankfehler??

FooFan · Beitrag von **FooFan** » 19.12.2005 18:02

Hallo ich habe den Mod Title: user_option_posts_sort eingebaut (details zum MOD)
wenn ich im Profil die Reihenfolge der Beiträge ändern will, kommt folgende Fehlermeldung.

Code: Alles auswählen

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 ' user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang =

UPDATE phpbb_users SET user_email = 'webmaster@domain.de', user_icq = '128419983', user_website = 'http://www.domain.de', user_occ = 'Holztechniker - Tischlermeister', user_from = 'Hildesheim', user_interests = 'Musik - Foo Fighters!!', user_sig = 'gruss Stephan', user_sig_bbcode_uid = '312b080e48', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', 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 = , user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '', user_post_sort = 1 WHERE user_id = 2

Line : 597
File : usercp_register.php

die install_upsp_mod.php habe ich ohne Fehlermeldung ausgeführt!
Liegt das an der Datenbank?

danke für eure Hilfe schon einmal!!

Stephan

Beitrag von **Markus67** » 20.12.2005 11:03

Hi ...

verlinke mal bitte die usercp_register.php als txt-Datei.
KB:datei

Markus

FooFan · Beitrag von **FooFan** » 20.12.2005 11:49

Hi Markus!

hier ist die Datei:
usercp_register.php

gruss Stephan

FooFan · Beitrag von **FooFan** » 21.12.2005 15:55

ich pushe mal etwas

vielleicht kann sich einer mein Problem ansehen!
Neue Leute konnten sich im Forum auch nicht mehr registrieren!

besten Dank

WeimiSandra · Beitrag von **WeimiSandra** » 07.01.2006 13:22

Huhu, ich habe das gleiche Problem, hat schon jemand eine Lösung gefunden??

Gruß
Sandra

Fennias Maxim · Beitrag von **Fennias Maxim** » 07.01.2006 22:10

Das ist wohl ein fehler in der instalationsanleitung.

Such mal alle

Code: Alles auswählen

$popuppm

in der usercp_register.php

und ersetzte sie durch

Code: Alles auswählen

$popup_pm

dürften genau 2 sein.

@Foofan: Wenn du dir mal den Thread genauer durchgelesen hättest, hättest du das hier gefunden:

doddi hat geschrieben:Super! Vielen Dank!

Die Version ist zwar nicht mehr mit 2.0.11 100% kompatibel aber es gibt noch eine neuere!

Hat sich das lange suchen doch noch gelohnt!

Emilino · Beitrag von **Emilino** » 02.11.2006 22:05

Hi,

also ich hatte das selbe Problem und habe es leider noch immer.
Habe, wie Fennias Maxim geraten hat, die kleine Änderung voggenommen und bin trotzdem nicht erfolgreich

Neu angemeldete und von mir freigeschaltete User können sich auch nicht mehr einloggen!?

Folgende Fehlermeldung kommt:

Code: Alles auswählen

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 ' user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang =

UPDATE phpbb_users SET user_email = 'MAIL', user_icq = '', user_website = 'http://www.URL.eu', user_occ = 'Berufung finden.', user_from = 'Wien', user_interests = 'siehe Beruf.', user_sig = 'NAME', user_sig_bbcode_uid = '2ff79abfae', 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 = 1, user_notify_pm = 1, user_popup_pm = , user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '', WHERE user_id = 2

Line : 523
File : usercp_register.php

Hier der Link zu meiner usercp_register.php als .txt File.

Danke schon mal für die Hilfe,

Emilino

Beitrag von **Markus67** » 16.11.2006 00:20

Hi ...

suche in der usercp_register.php

Code: Alles auswählen

$user_actkey) . "'" . $avatar_sql . ",

ersetze mit:

Code: Alles auswählen

$user_actkey) . "'" . $avatar_sql . "

Markus

Emilino · Beitrag von **Emilino** » 16.11.2006 00:29

Hi Markus,

yea, ich wusste: Auf dich ist Verlass. Danke!
Hab die Änderung gleich vorgenommen und die Fehlermeldung ist weg!

Leider aber wird die im Profil vorgenommene Änderung nicht übernommen.
Wenn ich also auswähle, dass die neuensten Einträge zuerst dargestellt werden sollen, kommen wieder die ältesten zuerst.
Im Profil schauts dann so aus, alsob nie eine Änderung vorgenommen worden wäre

Hast du da noch eine Idee?

EDIT: Es können sich immer noch keine neuen Benutzer anmelden!

Beitrag von **Markus67** » 16.11.2006 00:48

Hi ...

hast du die neueste Version von dem MOD eingebaut? 1.0.2

Code: Alles auswählen

########################################################
## Mod Title:  user_option_posts_sort
## Mod Version: 1.0.2
## Author:       Adam Ismay <admin@boardz.tk>
##       Shannado <sven@shannado.nl> Sven http://www.shannado.nl/forumorg (v1.0.1)
## Description:  Allows users to choose whether they want
##               posts displayed newest or oldest first by
##         default in thier profile.
##
## Installation Level:  easy
## Installation Time:   2-3 Minutes
## Files To Edit:       viewtopic.php, profile.php, profile_add_body.tpl
## Included Files:  install_sort_mod.php
##############################################################
## This MOD is released under the GPL License.
## Intellectual Property is retained by the MOD Author(s) listed above
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Authors Notes:
##      Thanks go out to Shannado for fixing the main mod for phpBB2.0.1+
##      Checked upto 2.0.2.
##      Please see readme for full instructions.
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################


#
#--- [ OPEN ] --------
#

viewtopic.php

#
#-- [ FIND ]----
#
# (line 195)

if ( !empty($post_id) )
{
   $start = floor(($forum_topic_data['prev_posts'] - 1) / $board_config['posts_per_page']) * $board_config['posts_per_page'];
}

#
#---- [ REPLACE WITH ]-----
#

//
// Decide how to order the post display
//
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) )
{
   $post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder'];
   $post_time_order = ($post_order == "asc") ? "ASC" : "DESC";
}
else
{
   $post_order = ( $userdata['user_post_sort'] == TRUE ) ? 'desc' : 'asc';
   $post_time_order = ( $userdata['user_post_sort'] == TRUE ) ? 'DESC' : 'ASC';
}

if(!empty($post_id) )
{
   $posts_before = ( $post_order == 'desc' )? (($forum_topic_data['topic_replies'] + 1) - $forum_topic_data['prev_posts']) : ($forum_topic_data['prev_posts'] - 1);
   $start = floor( $posts_before / $board_config['posts_per_page']) * $board_config['posts_per_page'];
}


#
#--- [ DELETE ] --------
#
# (line 358)

//
// Decide how to order the post display
//
if ( !empty($HTTP_POST_VARS['postorder']) || !empty($HTTP_GET_VARS['postorder']) )
{
   $post_order = (!empty($HTTP_POST_VARS['postorder'])) ? $HTTP_POST_VARS['postorder'] : $HTTP_GET_VARS['postorder'];
   $post_time_order = ($post_order == "asc") ? "ASC" : "DESC";
}
else
{
   $post_order = 'asc';
   $post_time_order = 'ASC';
}



#
#--- [ OPEN ] --------
#

includes\usercp_register.php

#
#--- [ FIND ] --------
#
#  (line 175)

$user_avatar_type = ( empty($user_avatar_loc) && $mode == "editprofile" ) ? $userdata['user_avatar_type'] : "";

#
#--- [ AFTER, ADD ] --------
#

$user_post_sort = ($HTTP_POST_VARS['user_post_sort'] == 1) ? 1 : 0;

#
#--- [ FIND ] --------
#
# (line 437)

         $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 = $popuppm, 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";


#
#--- [ REPLACE WITH ] --------
#


         $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 = $popuppm, 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 . ", user_post_sort = $user_post_sort
         WHERE user_id = $user_id";


#
#--- [ FIND ] --------
#
# (line 501)

         $sql = "INSERT INTO " . USERS_TABLE . "   (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";


#
#--- [ REPLACE WITH ] --------
#



         $sql = "INSERT INTO " . USERS_TABLE . "   (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_post_sort, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, $user_post_sort, 0, 1, ";



#
#--- [ FIND ] --------
#
# (line 902)

      'L_PROFILE_INFO' => $lang['Profile_info'],
      'L_PROFILE_INFO_NOTICE' => $lang['Profile_info_warn'],
      'L_EMAIL_ADDRESS' => $lang['Email_address'],

#
#--- [ AFTER, ADD ] --------
#



                'L_OLDEST_FIRST' => $lang['Oldest_First'],
                'L_NEWEST_FIRST' => $lang['Newest_First'],
                'L_POSTS_SORT' => $lang['Posts'] . ' ' . $lang['Sort_by'],
                'U_SORT_OLDEST' => $userdata['user_post_sort'] ? '' : 'checked="checked"',
                'U_SORT_NEWEST' => $userdata['user_post_sort']? 'checked="checked"' : '',


#  This is just an example for subSilver. Don't forget to add to all templates.
#
#--- [ OPEN ] --------
#

templates/subSilver/profile_add_body.tpl


#
#--- [ FIND ] --------
#
# (line 184)

   <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>&nbsp;&nbsp;
      <input type="radio" name="allowsmilies" value="0" {ALWAYS_ALLOW_SMILIES_NO} />
      <span class="gen">{L_NO}</span></td>
   </tr>

#
#--- [ AFTER, ADD ] --------
#

   <tr>
     <td class="row1"><span class="gen">{L_POSTS_SORT}:</span></td>
     <td class="row2">
      <input type="radio" name="user_post_sort" value="0" {U_SORT_OLDEST} />
      <span class="gen">{L_OLDEST_FIRST}</span>&nbsp;&nbsp;
      <input type="radio" name="user_post_sort" value="1" {U_SORT_NEWEST} />
      <span class="gen">{L_NEWEST_FIRST}</span></td>
   </tr>


#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Markus