استفسار بسيط الى خبراء المنتديات

[شباب السعودية]

السلام عليكم ورحمة الله وبركاته

اخواني حبيت استفسر عن شيء بسيط :

انا كان عندي منتدى في موقع قديم

قبل ماالغي المنتدى اخذت نسخة من جدول يوزر

والحين فتحت موقع جديد وركبت فيه منتدى

هل اقدر اركب جدول اليوزر في المنتدى الجديد ويصيرون الاعضاء الي كانوا بالمنتدى القديم بالمنتدى الجديد وبدون مشاكل؟

واذا كان اقدر اركبه :: ارجوا شرح ذلك ::

:shy:


ويعطيكم الف عافية

تحياتي
شباب السعودية

[Mr.Fahad]

ارفع جدول اليوزر .SQL إلى قاعدة المنتدى ،
واعمل تحديث للعدادات ..

[شباب السعودية]

الف الف شكر لك اخي مستر فهد على الإفادة


ويعطيك الف عافية يالغالي

دائما اشوفك تتواجد بمواضبعي

اشكرك من كل قلبي

وانا راح اخذ نسخة احتياطية

وراح ارفع جدول اليوزر

تحياتي
شباب السعودية

[شباب السعودية]

اخي الكريم حصبلت لي مشكلة عندما رفعت جدول اليوزر :

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112


There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Invalid Identifer @ 135
STR: 4.0.
SQL: -- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- ǡ㒦Ϻ localhost
-- äԆ ݭ: 02 ��2005 ǡӇډ 11:25
-- ŕχщ ǡ㒦Ϻ 4.0.22
-- PHP ŕχщ: 4.3.11
--
-- އڏɠǡȭǤNJ: `safwa_vb`
--

-- --------------------------------------------------------

--
-- Ȥ퉠ǡ̏桠`user`
--

CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` char(50) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '15',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`msn` char(100) NOT NULL default '',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`arcadesettings` int(13) unsigned NOT NULL default '15',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`),
KEY `birthday_search` (`birthday_search`)
) TYPE=MyISAM AUTO_INCREMENT=170

SQL query:

-- phpMyAdmin SQL Dump -- version 2.6.1-pl2 -- http://www.phpmyadmin.net -- -- ǡ㒦Ϻ localhost -- äԆ ݭ: 02 ��2005 ǡӇډ 11:25 -- ŕχщ ǡ㒦Ϻ 4.0.22 -- PHP ŕχщ: 4.3.11 -- -- އڏɠǡȭǤNJ: `safwa_vb` -- -- -------------------------------------------------------- -- -- Ȥ퉠ǡ̏桠`user` -- CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `usergroupid` smallint(5) unsigned NOT NULL default '0', `membergroupids` char(250) NOT NULL default '', `displaygroupid` smallint(5) unsigned NOT NULL default '0', `username` char(50) NOT NULL default '', `password` char(32) NOT NULL default '', `passworddate` date NOT NULL default '0000-00-00', `email` char(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `parentemail` char(50) NOT NULL default '', `homepage` char(100) NOT NULL default '', `icq` char(20) NOT NULL default '', `aim` char(20) NOT NULL default '', `yahoo` char(32) NOT NULL default '', `showvbcode` smallint(5) unsigned NOT NULL default '0', `usertitle` char(250) NOT NULL default '', `customtitle` smallint(6) NOT NULL default '0', `joindate` int(10) unsigned NOT NULL default '0', `daysprune` smallint(6) NOT NULL default '0', `lastvisit` int(10) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastpost` int(10) unsigned NOT NULL default '0', `posts` int(10) unsigned NOT NULL default '0', `reputation` int(11) NOT NULL default '10', `reputationlevelid` int(10) unsigned NOT NULL default '1', `timezoneoffset` char(4) NOT NULL default '', `pmpopup` smallint(6) NOT NULL default '0', `avatarid` smallint(6) NOT NULL default '0', `avatarrevision` int(10) unsigned NOT NULL default '0', `options` int(10) unsigned NOT NULL default '15', `birthday` char(10) NOT NULL default '', `birthday_search` date NOT NULL default '0000-00-00', `maxposts` smallint(6) NOT NULL default '-1', `startofweek` smallint(6) NOT NULL default '1', `ipaddress` char(15) NOT NULL default '', `referrerid` int(10) unsigned NOT NULL default '0', `languageid` smallint(5) unsigned NOT NULL default '0', `msn` char(100) NOT NULL default '', `emailstamp` int(10) unsigned NOT NULL default '0', `threadedmode` smallint(5) unsigned NOT NULL default '0', `autosubscribe` smallint(6) NOT NULL default '-1', `pmtotal` smallint(5) unsigned NOT NULL default '0', `pmunread` smallint(5) unsigned NOT NULL default '0', `salt` char(3) NOT NULL default '', `arcadesettings` int(13) unsigned NOT NULL default '15', PRIMARY KEY (`userid`), KEY `usergroupid` (`usergroupid`), KEY `username` (`username`), KEY `birthday` (`birthday`), KEY `birthday_search` (`birthday_search`) ) TYPE=MyISAM AUTO_INCREMENT=170
MySQL said:

#1050 - Table 'user' already exists


أرجوا المساعدة

تحياتي
شباب السعودية