Could not get data from ignore table

Βοήθεια λύσεις και νέα από τον χώρο των open source ή έτοιμων εφαρμογών που έχουν φτιαχτεί με την PHP όπως oscommerce, κ.α.

Συντονιστές: WebDev Moderators, Super-Moderators, PHP Moderators

Απάντηση
elena23
Δημοσιεύσεις: 129
Εγγραφή: 04 Νοέμ 2004 15:42

Could not get data from ignore table

Δημοσίευση από elena23 » 11 Μάιος 2007 20:02

Pernaw to ignore mod kai mou bgazei auto to sfalma :

Could not get data from ignore table

DEBUG MODE

SQL Error : 1146 Table 'despina_vandi_db2.phpbb_ignore' doesn't exist

Line : /home/despina-vandi.info/www/forum/viewtopic.php
File : SELECT user_ignore FROM phpbb_ignore WHERE user_id = 7 AND user_ignore = 482


enw eimai sigouri oti exw perasei tis ekshs entles sthn sql sumfwna me to mod :

Κώδικας: Επιλογή όλων

CREATE TABLE phpbb_ignore (
  user_id mediumint(8) NOT NULL default '0',
  user_ignore mediumint(8) NOT NULL default '0'
) TYPE=MyISAM DEFAULT CHARSET=greek COLLATE=greek_general_ci
oi allages pou gnontai sto viewtopic:

Κώδικας: Επιλογή όλων

# 
#-----[ OPEN ]------------------------------------------ 
#
viewtopic.php

# 
#-----[ FIND ]------------------------------------------ 
#
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
$post_bypass = isset($HTTP_GET_VARS['bypass']) ? intval($HTTP_GET_VARS['bypass']) : 0;

# 
#-----[ FIND ]------------------------------------------ 
#
//
$sql = "SELECT u.
#
#-----[ IN-LINE FIND ]------------------------------------------
#
u.user_posts,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
 u.user_level,
# 
#-----[ FIND ]------------------------------------------ 
#
for&#40;$i = 0; $i < $total_posts; $i++&#41;

# 
#-----&#91; BEFORE, ADD &#93;------------------------------------------ 
#
$user_id = $userdata&#91;'user_id'&#93;;
$counter = 0;

# 
#-----&#91; FIND &#93;------------------------------------------ 
#
        $poster_id = $postrow&#91;$i&#93;&#91;'user_id'&#93;;


# 
#-----&#91; AFTER, ADD &#93;------------------------------------------ 
#
  if &#40; $user_id != ANONYMOUS &#41;
  &#123;
        $sql = "SELECT user_ignore
          FROM " . IGNORE_TABLE . "
          WHERE user_id = $user_id
                        AND user_ignore = $poster_id";
        if&#40; !$result = $db->sql_query&#40;$sql&#41;&#41;
        &#123;
           message_die&#40;GENERAL_ERROR, 'Could not get data from ignore table', __LINE__, __FILE__, $sql&#41;;
        &#125;
        $post_ignored = $db->sql_numrows&#40;$result&#41;;
  &#125;
  else
  &#123;
        $post_ignored = 0;
  &#125;

        $counter++;

# 
#-----&#91; FIND &#93;------------------------------------------ 
#
        $poster = &#40; $poster_id == ANONYMOUS &#41; ? $lang&#91;'Guest'&#93; &#58; $postrow&#91;$i&#93;&#91;'username'&#93;;

# 
#-----&#91; AFTER, ADD &#93;------------------------------------------ 
#
    if &#40;&#40; $post_ignored > 0 &#41; && &#40; $poster_id != ANONYMOUS &#41; && &#40; $post_bypass != $postrow&#91;$i&#93;&#91;'post_id'&#93; &#41; && &#40;$postrow&#91;$i&#93;&#91;'user_level'&#93; != ADMIN&#41; && &#40;$postrow&#91;$i&#93;&#91;'user_level'&#93; != MOD&#41;&#41;
    &#123;

        $post_date = create_date&#40;$board_config&#91;'default_dateformat'&#93;, $postrow&#91;$i&#93;&#91;'post_time'&#93;, $board_config&#91;'board_timezone'&#93;&#41;;

        //
        // Define the little post icon
        //
        if &#40; $userdata&#91;'session_logged_in'&#93; && $postrow&#91;$i&#93;&#91;'post_time'&#93; > $userdata&#91;'user_lastvisit'&#93; && $postrow&#91;$i&#93;&#91;'post_time'&#93; > $topic_last_read &#41;
        &#123;
                $mini_post_img = $images&#91;'icon_minipost_new'&#93;;
                $mini_post_alt = $lang&#91;'New_post'&#93;;
        &#125;
        else
        &#123;
                $mini_post_img = $images&#91;'icon_minipost'&#93;;
                $mini_post_alt = $lang&#91;'Post'&#93;;
        &#125;

        $message = $lang&#91;'Post_user_ignored'&#93; . ' ' . sprintf&#40;$lang&#91;'Click_view_ignore'&#93;, '<a href="' . append_sid&#40;"viewtopic.$phpEx?p=" . $postrow&#91;$i&#93;&#91;'post_id'&#93; . "&amp;bypass=" . $postrow&#91;$i&#93;&#91;'post_id'&#93; . "#" . $postrow&#91;$i&#93;&#91;'post_id'&#93;&#41; . '">', '</a>'&#41;;

	$ignore = '';

        $poster_rank = '';
        $rank_image = '';
        $poster_joined = '';
        $poster_posts = '';
        $poster_from = '';
        $poster_avatar = '';
        $poster_member = '';
        $post_subject = '';

        $user_sig = '';
        $l_edited_by = '';

        $mini_post_img = '';
        $search_img = '';
        $search = '';

        $edit_img = '';
        $edit = '';
        $quote_img = '';
        $quote = '';
        $ip_img = '';
        $ip = '';

        $delpost_img = '';
        $delpost = '';

        $profile_img = '';
        $profile = '';
        $pm_img = '';
        $pm = '';
        $email_img = '';
        $email = '';
        $www_img = '';
        $www = '';
        $icq_status_img = '';
        $icq_img = '';
        $icq = '';
        $aim_img = '';
        $aim = '';
        $msn_img = '';
        $msn = '';
        $yim_img = '';
        $yim = '';

    &#125;
    else
    &#123;

# 
#-----&#91; FIND &#93;------------------------------------------ 
#
                $temp_url = append_sid&#40;"profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$poster_id"&#41;;
                $profile_img = '<a href="' . $temp_url . '"><img src="' . $images&#91;'icon_profile'&#93; . '" alt="' . $lang&#91;'Read_profile'&#93; . '" title="' . $lang&#91;'Read_profile'&#93; . '" border="0" /></a>';

# 
#-----&#91; BEFORE, ADD &#93;------------------------------------------ 
#
                $temp_url = append_sid&#40;"ignore.$phpEx?mode=add&amp;username=$poster&amp;topic=$topic_id"&#41;;
                $ignore = '<a href="' . $temp_url . '"><img src="' . $images&#91;'icon_ignore'&#93; . '" alt="' . $lang&#91;'Ignore_add'&#93; . '" title="' . $lang&#91;'Ignore_add'&#93; . '" border="0" /></a>';


# 
#-----&#91; FIND &#93;------------------------------------------ 
#
        &#125;
        else
        &#123;
                $profile_img = '';
                $profile = '';

# 
#-----&#91; AFTER, ADD &#93;------------------------------------------ 
#
                $ignore = '';


# 
#-----&#91; FIND &#93;------------------------------------------ 
#
        else
        &#123;
                $l_edited_by = '';
        &#125;


# 
#-----&#91; AFTER, ADD &#93;------------------------------------------ 
#
    &#125;

# 
#-----&#91; FIND &#93;------------------------------------------ 
#
        $row_color = &#40; !&#40;$i % 2&#41; &#41; ? $theme&#91;'td_color1'&#93; &#58; $theme&#91;'td_color2'&#93;;
        $row_class = &#40; !&#40;$i % 2&#41; &#41; ? $theme&#91;'td_class1'&#93; &#58; $theme&#91;'td_class2'&#93;;


# 
#-----&#91; REPLACE WITH &#93;------------------------------------------ 
#
        $row_color = &#40; !&#40;$counter % 2&#41; &#41; ? $theme&#91;'td_color1'&#93; &#58; $theme&#91;'td_color2'&#93;;
        $row_class = &#40; !&#40;$counter % 2&#41; &#41; ? $theme&#91;'td_class1'&#93; &#58; $theme&#91;'td_class2'&#93;;

# 
#-----&#91; FIND &#93;------------------------------------------ 
#
                'MINI_POST_IMG' => $mini_post_img,
                'PROFILE_IMG' => $profile_img,
                'PROFILE' => $profile,

# 
#-----&#91; AFTER, ADD &#93;------------------------------------------ 
#
                'IGNORE' => $ignore,
Εικόνα

Άβαταρ μέλους
tix-3-
Δημοσιεύσεις: 827
Εγγραφή: 25 Μαρ 2004 05:12
Τοποθεσία: Θεσσαλονικη-Καβαλα-βεροια(το τριγωνο της καταρας)
Επικοινωνία:

Could not get data from ignore table

Δημοσίευση από tix-3- » 17 Μάιος 2007 23:52

Δεν εχει δημιουργηθει ο πινακας.
Check it με phpmyadmin
Αν δεν υπήρχανε οι κνίτες κι'η ηρωίνη...

elena23
Δημοσιεύσεις: 129
Εγγραφή: 04 Νοέμ 2004 15:42

Could not get data from ignore table

Δημοσίευση από elena23 » 18 Μάιος 2007 00:21

ayto einai to periergo...oti yparxei o pinakas.
Εικόνα

Απάντηση

Επιστροφή στο “PHP έτοιμες εφαρμογές”

Μέλη σε σύνδεση

Μέλη σε αυτήν τη Δ. Συζήτηση: Δεν υπάρχουν εγγεγραμμένα μέλη και 2 επισκέπτες