Jak naprawić ten błąd ?

 

Strona 1 z 1 [ 7 posty(ów) ]

Widok do druku | « Poprzedni temat | Następny temat »

Temat

• Wysłany: 14 Cze 2007, 14:21

  McQueen

  

  
  Rejestracja: 25 Maj 2007, 19:14
  Posty: 21
  Siemka
  
  Przy próbie edycji for przez panel administracyjny wywala mi taki błąd:
  
  

  Kod:

  Couldn't update forum 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 '', enable_minuspoints = '1, prune_enable = 0, raport_on = 1, forum_postcount = 1' at line 2
  
  UPDATE phpbb_forums SET forum_name = 'Poszukiwania/Requests', forum_color = '', cat_id = 3, forum_desc = 'Szukasz filmu ? Pisz tutaj...', forum_tags_list = 'RMVB,X264,XVID,DVD-R,SVCD,INNY,', forum_require_tag = '1', forum_status = 0, enable_pluspoints = 1', enable_minuspoints = '1, prune_enable = 0, raport_on = 1, forum_postcount = 1 WHERE forum_id = 13
  
  Line : 482
  File : admin_forums.php

  
  
  Wiem że jest to związane z zapytaniem do bazy ale zupełnie nie wiem co może byc źle
  
  To moje dwa kody sql z admin_forums.php
  
  

  Kod:

  // There is no problem having duplicate forum names so we won't check for it.
           $sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, forum_color, cat_id, forum_desc, forum_tags_list, forum_require_tag, forum_order, forum_status, enable_pluspoints, enable_minuspoints, prune_enable, forum_postcount" . $field_sql . ")
              VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_color']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', '" . htmlspecialchars(trim($HTTP_POST_VARS['forum_tags_list'])) . "', '" . intval($HTTP_POST_VARS['forum_require_tag']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($_POST['enable_plus']) . ", " . intval($_POST['enable_minus']) . ", "  .  intval($HTTP_POST_VARS['prune_enable']) . ", " . intval($HTTP_POST_VARS['forum_postcount']) . $value_sql . ")";
  

  
  
  

  Kod:

        $sql = "UPDATE " . FORUMS_TABLE . "
              SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', forum_color = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_color']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_tags_list = '" . htmlspecialchars(trim($HTTP_POST_VARS['forum_tags_list'])) ."', forum_require_tag = '" . intval($HTTP_POST_VARS['forum_require_tag']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", enable_pluspoints = ". intval($_POST['enable_plus']) . "', enable_minuspoints = '" . intval($_POST['enable_minus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ", raport_on = " . $raport_on . ", forum_postcount = " . intval($HTTP_POST_VARS['forum_postcount']) . "
              WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);

  

Odpowiedzi

• Wysłany: 14 Cze 2007, 14:43

  Kudlaty

  

  

  

  
  Rejestracja: 28 Gru 2005, 02:30
  Posty: 1054
  Pochwały: 97
  zmien to:
  
  [sql]enable_pluspoints = ". intval($_POST['enable_plus']) . "', enable_minuspoints = '" . intval($_POST['enable_minus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ", raport_on = " . $raport_on . ", forum_postcount = " . intval($HTTP_POST_VARS['forum_postcount']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);[/sql]
  
  na:
  
  [sql]enable_pluspoints = ". intval($_POST['enable_plus']) . ", enable_minuspoints = " . intval($_POST['enable_minus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ", raport_on = " . $raport_on . ", forum_postcount = " . intval($HTTP_POST_VARS['forum_postcount']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]) . "";[/sql]

  ---

  Jeśli chcesz coś ode mnie to pisz na FORUM!!
  
  World of Warcraft

  

• Wysłany: 14 Cze 2007, 16:15

  McQueen

  

  
  Rejestracja: 25 Maj 2007, 19:14
  Posty: 21
  niestety nie pomogło
  
  

  Kod:

  Couldn't update forum 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 ' forum_postCOUNT = 1 WHERE forum_id = 13' at line 2
  
  UPDATE phpbb_forums SET forum_name = 'Poszukiwania/Requests', forum_color = '', cat_id = 3, forum_desc = 'Szukasz filmu ? Pisz tutaj...', forum_tags_list = 'RMVB,X264,XVID,DVD-R,SVCD,INNY,', forum_require_tag = '1', forum_status = 0, enable_pluspoints = 1, enable_minuspoints = 1, prune_enable = 0, raport_ON = , forum_postCOUNT = 1 WHERE forum_id = 13
  
  Line : 483
  File : admin_forums.php

  
  
  A może ten błąd jeszcze jest dlatego że jeszcze nie dodałem tego:
  
  

  Kod:

  #
  #-----[ FIND ]------------------------------------------
  #
  intval($HTTP_POST_VARS['prune_enable']) .
  #
  #-----[ IN-LINE FIND ]------------------------------------------
  #
  intval($HTTP_POST_VARS['prune_enable']) .
  #
  #-----[ IN-LINE AFTER, ADD ]------------------------------------------
  #
  ", " . intval($HTTP_POST_VARS['separate_enable']) . ", " . intval($HTTP_POST_VARS['separate_sticky']) . ", " . intval($HTTP_POST_VARS['separate_box']) .
  #
  #-----[ FIND ]------------------------------------------
  #
  prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) .
  #
  #-----[ IN-LINE FIND ]------------------------------------------
  #
  prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) .
  #
  #-----[ IN-LINE AFTER, ADD ]------------------------------------------
  #
  ", separate_enable = " . intval($HTTP_POST_VARS['separate_enable']) . ", separate_sticky = " . intval($HTTP_POST_VARS['separate_sticky']) . ", separate_box = " . intval($HTTP_POST_VARS['separate_box']) . "

  
  
  ?
  
  

  ---

  Moje forum
  
  

  

• Wysłany: 14 Cze 2007, 16:38

  Kudlaty

  

  

  

  
  Rejestracja: 28 Gru 2005, 02:30
  Posty: 1054
  Pochwały: 97
  no powinieneś najpierw to dodać...
  ale i tak miałeś coś namieszane w tym zapytaniu... najlepiej by było go tak dać:
  
  [sql]$sql = "UPDATE " . FORUMS_TABLE . "
  SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', forum_color = '" . str_replace("\'", "''", $HTTP_POST_VARS['forum_color']) . "', cat_id = '" . intval($HTTP_POST_VARS[POST_CAT_URL]) . "', forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_tags_list = '" . htmlspecialchars(trim($HTTP_POST_VARS['forum_tags_list'])) ."', forum_require_tag = '" . intval($HTTP_POST_VARS['forum_require_tag']) . "', forum_status = '" . intval($HTTP_POST_VARS['forumstatus']) . "', enable_pluspoints = '". intval($_POST['enable_plus']) . "', enable_minuspoints = '" . intval($_POST['enable_minus']) . "', prune_enable = '" . intval($HTTP_POST_VARS['prune_enable']) . "', raport_on = '" . $raport_on . "', forum_postcount = '" . intval($HTTP_POST_VARS['forum_postcount']) . "'
  WHERE forum_id = '" . intval($HTTP_POST_VARS[POST_FORUM_URL]) . "';"[/sql]

  ---

  Jeśli chcesz coś ode mnie to pisz na FORUM!!
  
  World of Warcraft

  

• Wysłany: 14 Cze 2007, 17:23

  McQueen

  

  
  Rejestracja: 25 Maj 2007, 19:14
  Posty: 21
  Teraz taki bład w indexie administracji (tam gdzie menu)
  
  

  Kod:

  Parse error: syntax error, unexpected T_IF in /home/xxxxxxxxx/domains/xxxxxxxxxx.rwi.pl/public_html/admin/admin_forums.php on line 483

  
  
  
  a linia 483 to jest linia zaraz po tym ostatnim "

  

• Wysłany: 14 Cze 2007, 18:14

  Kudlaty

  

  

  

  
  Rejestracja: 28 Gru 2005, 02:30
  Posty: 1054
  Pochwały: 97
  yyy możliwe.. bo się pomyliłem... zamień kolejność ostatnich znaczków...
  
  ma tam być "'"; a nie "';"
  
  sorka

  Autor postu otrzymał pochwałę

  ---

  Jeśli chcesz coś ode mnie to pisz na FORUM!!
  
  World of Warcraft

  

• Wysłany: 14 Cze 2007, 18:31

  Pyton

  

  

  
  Rejestracja: 14 Maj 2005, 10:17
  Posty: 2971
  Miejscowość: Ciechanowiec / Białystok
  Pochwały: 204
  Cytuj:

  Jak naprawić ten błąd ?

  
  Przed zadaniem pytania przeczytać treść FAQ lub poszukać na forum i skonsultować się z administratorem lub moderatorem w celu poprawienia błedu.

  ---

  Jak nie to nie, łaski bez...

  

 

Strona 1 z 1 [ 7 posty(ów) ]