[1.0.4] موضوعات العضو

[m_abdou54]

???? ???? ??????? 1.0.4 ???? ?????? ?????

[أبو وديع]

??? ????? ????? ????? ?????? ??????? ???????? ?????..
???? ??? ???? ?????? ????????
?? ???? ????? [???????] ?????? ??????? ???????...

?? ???? ?????? ?????? ???? [?????? ??? ????????]



???? ????? ??? ?????? ???????? ??? ???? ?????? ?? ????? ???????? ????? ???? ????????..

????? ??????? ?????? ?????:

????? ??????:


???? ???????:


????? ???????:

??? ??? ??? ???? ???? ???

?????? ???? ?? ?? ??? ????? ???? ??? ?????? ??? ???????? ???? ??? ?????

كود: تحديد الكل

??? ???
SQL ERROR [ mysql4 ]

Unknown column 'user_topics' in 'field list' [1054]

SQL

UPDATE phpbb_users SET user_topics = 0 WHERE user_id = 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_main.php
LINE: 266
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_main->main()

FILE: adm/index.php
LINE: 74

?????? ?????? ?? ??? ??? ?????? ?

[مهند قمرة]

?? ????? ?????

[مهند قمرة]

??? ????
???? ?? ????? ????? ????? ???????
??? ????? SQL
????????

[أبو وديع]

??? ????
???? ?? ????? ????? ????? ???????
??? ????? SQL
????????

???? ?? ??? ???? ??? ??? ???? ????

??? ???? ??? ??? ????? sqL?

[أبو وديع]

????????? ??? ???? ?????? ??? ?? ???? ????? ????? ???? ?? ???? ??? ??????? ?????? ????????

[أبو وديع]

???? ???? ?? ??????? ??? ?????? ?????? ?? ???? ????? ?????

[أبو وديع]

????? ??? ????? ???? ?? ????? ?? ??? ????? ???? ????? ??? ?????? ??
includes/acp/acp_main.php

كود: تحديد الكل

                    case 'topics':
                        if (!$auth->acl_get('a_board'))
                        {
                            trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);
                        }

                        $sql = 'SELECT COUNT(p.post_id) AS num_topics, u.user_id
                            FROM ' . USERS_TABLE . ' u
                            LEFT JOIN    ' . TOPICS_TABLE . ' t ON (u.user_id = t.topic_poster)
                            LEFT JOIN    ' . POSTS_TABLE . ' p ON (p.post_id = t.topic_first_post_id AND p.post_postcount = 1)
                            GROUP BY u.user_id';
                        $result = $db->sql_query($sql);

                        while ($row = $db->sql_fetchrow($result))
                        {
                            $db->sql_query('UPDATE ' . USERS_TABLE . " SET user_topics = {$row['num_topics']} WHERE user_id = {$row['user_id']}");
                        }
                        $db->sql_freeresult($result);

                        add_log('admin', 'LOG_RESYNC_TOPICCOUNTS');

                    break;

??????? ??? ?? ?????

كود: تحديد الكل

$db->sql_query('UPDATE ' . USERS_TABLE . " SET user_topics = {$row['num_topics']} WHERE user_id = {$row['user_id']}");

?????? ?????? ???? ???? ??? ????? ?? ????? ???????? ????

[أبو وديع]

???? ??????? ??? ???????
???? ??? ?? ????? ??? ??? SQl

???? ??? ?????? ???? ?? ??? ???????

كود: تحديد الكل

#1146 - Table 'mysite_alghzil.phpbb_users' doesn't exist

??? ?????? ????? ??? SQL ?????? ??????? ???? ???

[مهند قمرة]

??? ??? SQL
???????? ????? ??????
http://www.phpbbarabia.com/community/vi ... 74&t=36170

[أبو وديع]

????? ???? ????? ??? ????? ??? ???? ????? ???? ???? ??? ???????

كود: تحديد الكل

    #1146 - Table 'mysite_alghzil.phpbb_users' doesn't exist

????? ????? ??

[مهند قمرة]

phpbb_users
??? ???? ???????

????? ??? ?? ?????? ?? ???? ????? ??????? ????

كود: تحديد الكل

phpbb_

??? ???? ????? ??????? ?? ???? ??????? ??? ??????? ????? ????

كود: تحديد الكل

$table_prefix

[أبو وديع]

????? ????? ??? ???????
???? ??? ??????? ????? ????? phpbb

[مهند قمرة]

????? ????? ?????? ??????? ???? ??? ??????? ????????? ????? ??????
??? ???? ?????????

[alghzil]

????? ??? ?????? ??? ???????

??? ??? ???? ???? ?? ???? ????? ?? ????? ?? ?????? ?????? ?? ????? ??? ????? ???? ???? ?????? ??????
??????? ??? ????? ?????

??? ?? ??? ???????

كود: تحديد الكل

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = '';
$dbport = '';
$dbname = '??? ??????? ';
$dbuser = '????????';
$dbpasswd = '????????';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

??? ?? ??????? ...