[1.0.3] ??????? ?????
مرسل: الأربعاء سبتمبر 08, 2010 2:15 pm
???? ???? ??????? 1.0.4 ???? ?????? ?????
الدعم العربي لمنتديات phpBB
http://www.phpbbarabia.com/community/
???? ???? كتب:??? ????? ????? ????? ?????? ??????? ???????? ?????..
???? ??? ???? ?????? ????????
?? ???? ????? [???????] ?????? ??????? ???????...
?? ???? ?????? ?????? ???? [?????? ??? ????????]
???? ????? ??? ?????? ???????? ??? ???? ?????? ?? ????? ???????? ????? ???? ????????..
????? ??????? ?????? ?????:
????? ??????:
???? ???????:
????? ???????:
كود: تحديد الكل
??? ???
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
????????
كود: تحديد الكل
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']}");
كود: تحديد الكل
#1146 - Table 'mysite_alghzil.phpbb_users' doesn't exist
كود: تحديد الكل
#1146 - Table 'mysite_alghzil.phpbb_users' doesn't exist
كود: تحديد الكل
phpbb_
كود: تحديد الكل
$table_prefix
كود: تحديد الكل
<?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);
?>