المساعد الشخصي الرقمي

عرض الإصدار الكامل : مشكلة بقواعد البيانات


أبو المقداد
09-24-2006, 03:00 PM
السلام عليكم


اخواني ممكن تشوفون لي حل لهذي المشكلة


Database error in vBulletin 3.6.1:

Invalid SQL:

REPLACE INTO phrase
(languageid, fieldname, varname, ****, product, username, dateline, version)
VALUES

(-1,
'cphelp****',
'accessmask_****',
'<b>Related General Help Topics:</b><br />\r\n<a href=\"help.php?s=&do=answer&page=user&pageaction=&option=\">Users</a><br />\r\n<a href=\"help.php?s=&do=answer&page=usertools&pageaction=&option=\">User Tools</a><br />\r\n<a href=\"help.php?s=&do=answer&page=banning&pageaction=&option=\">User Banning</a><br />\r\n<a href=\"help.php?s=&do=answer&page=email&pageaction=&option=\">Emailing Users</a><br />\r\n<a href=\"help.php?s=&do=answer&page=accessmask&pageaction=&option=\">Access Masks</a><br /><br />\r\n\r\n<b>Access Masks:</b><br />\r\nAccess Masks allow you grant permission to view a forum, or alternatively to deny permission to view a forum, on a per-user basis without making an additional usergroup. This works in conjunction with the Forum Permission system.<br /><br />\r\n\r\nNote that inheritance applies here; if you allow a user to view a parent forum, they will also have access to any children forums.<br /><br />\r\n\r\nYou must enable access masks in your <a href=\"options.php?dogroup=general&do=options\" target=\"_blank\">vBulletin options</a>, otherwise changes made here will do nothing.',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_title',
'About Access Masks',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_edit_****',
'Below is a list of all users who have access mask permissions set for this forum. Here you can edit forum access for these users at the user level (as opposed to the group level).\r\n<br /><br />\r\nMake sure access masks are enabled <a href=\"options.php?dogroup=general&do=options\" target=\"_blank\"><b>here</b></a> or these user-level permissions will not work.',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_edit_title',
'Access Masks For This Forum',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_modify_****',
'On this screen you can see at a glance which forums have access masks. (Remember, inheritance applies here! If a user is granted or denied permission to a parent forum, this will be inherited through all child forums of that parent unless there is an opposite access mask somewhere in the lineage.)<br /><br />\r\n\r\nYou can also view a list of the users who are granted access, denied access, or all users with access masks related to a given forum. You can remove all access masks from a forum by clicking the Reset link next to it.<br /><br />\r\n\r\nAt the top of the page you can use the \'Delete All Access Masks\' link to remove every access mask from all forums. (You will be prompted for confirmation, but be careful as this is not undoable!)<br /><br />\r\n\r\nThe \'Access Masks Quick Editor\' allows you to list every access on a page, with Yes, No, and Default buttons for each mask to quickly mass-modify masks.',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_modify_title',
'Modifying User Forum Access',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_quickedit_****',
'On this screen you are given a list of every access mask currently in the system. For each mask, a row containing the affected user\'s name, the forum it applies to, and Yes/No/Default buttons appear. Yes means grant access, No means deny access, and Default means use the default usergroup/forum permission for that forum. (Setting any row to Default will remove that mask.) The \'All Yes\', \'All No\', and \'All Default\' buttons allow you to quickly mass-set all radio buttons to the selection you choose.',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_quickedit_title',
'Access Masks Quick Editor',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_resetall_****',
'Click the \"Yes\" button below to delete all access masks. This action cannot be undone!',
'vbulletin',
'',
0,
'')
,

(-1,
'cphelp****',
'accessmask_resetall_title',
'Delete All Access Masks',
'vbulletin',
'',
0,
'');

MySQL Error : Unknown column 'username' in 'field list'
Error Number : 1054
Date : Sunday, September 24th 2006 @ 03:01:27 PM
****** : http://www.oshag-alferdos.com/*****/install/finalupgrade.php?step=2
Referrer : http://www.oshag-alferdos.com/*****/install/finalupgrade.php?step=1
IP Address : ******
Username :
Classname : vb_databaseوجزاكم الله خير

MSHAER
09-24-2006, 05:13 PM
ازرع يابطل


CREATE TABLE userfield (
userid int(10) unsigned DEFAULT '0' NOT NULL,
field1 char(250) NOT NULL,
field2 char(250) NOT NULL,
field3 char(250) NOT NULL,
field4 char(250) NOT NULL,
PRIMARY KEY (userid)

أبو المقداد
09-24-2006, 05:43 PM
ازرع يابطل


CREATE TABLE userfield (
userid int(10) unsigned DEFAULT '0' NOT NULL,
field1 char(250) NOT NULL,
field2 char(250) NOT NULL,
field3 char(250) NOT NULL,
field4 char(250) NOT NULL,
PRIMARY KEY (userid)

والله شكل ما لنا نصيب بالترقيه من مشكلة لمشكلة خلنا على النسخة الاولى احسن لنا

جزاك الله خير اخوي مشاعر على ما قدمته لي من خدمات والله يجعله في ميزان حسناتك

MSHAER
09-24-2006, 06:12 PM
ماسوينا غير الواجب اخوي بس دامك مرخص رقي مع الايام بتلقى الناس وصلو 3.9.1
وانت 3.0.11
لو كنت ترق باستمرار مستحيل تواجه مشاكل

ألفا
09-24-2006, 06:49 PM
ابو المقداد ..

اذا انتــ مرخص

اسحبــ نسخة 3.0.9

ورق نسختكــ .. لان حسب ما عرفتـ نسختكـ 3.0.11

المهم..

لا رقيت الى 3.0.9

رق الى 3.6.1

وكذا تتلافى مشاكل كثيـــــــــــر

أبو المقداد
09-24-2006, 09:04 PM
ابشرك الحمد لله رقينا لكن عندي مشكلة ان شاء الله بسيطه وهي

Database error in vBulletin 3.6.1:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('32bbc580c982b9fab7a0d83b178ad3e2', 1, '212.76.68.208', 'be42f05c82c134f9ec43e04320749106', 1159120880, '/vb/admincp/index.php?do=nav', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Avant Browser; Avant Browser)', 0, 0);

MySQL Error : Unknown column 'profileupdate' in 'field list'
Error Number : 1054
Date : Sunday, September 24th 2006 @ 09:08:24 PM
****** : http://www.oshag-alferdos.com/*****/admincp/index.php?do=nav
Referrer : http://www.oshag-alferdos.com/*****/admincp/
IP Address : *****
Username : ***
Classname : vb_database

وش الحل

MSHAER
09-24-2006, 09:18 PM
ابو المقداد

انت بدلت الملفات القديمه بالجديده ؟

أبو المقداد
09-24-2006, 10:28 PM
ابو المقداد

انت بدلت الملفات القديمه بالجديده ؟

انا رافع الجديدهـ بمجلد خاص واعمل الترقيه به المهم ابشرك حلت المشكلة

MSHAER
09-24-2006, 10:30 PM
ملفات القديمه مستحيل تشتغل على الجديده لازم تبدلهم كلهم
ولاتنسى تعمل تحديث العدادات كامله وصيانة الجداول والحمد لله انها انحلت