إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...

انضم الينا
استراحات زايد الصفحة الرئيسية


إضافة رد
 
LinkBack أدوات الموضوع انواع عرض الموضوع
  #1  
قديم 07-08-2010, 11:00 PM
عضو ماسي
بيانات محروم.كوم
 رقم العضوية : 503
 تاريخ التسجيل : Dec 2007
الجنس : female
علم الدوله :
 المشاركات : 2,100,610
عدد الـنقاط :3341
 تقييم المستوى : 2139

Hi,

I've encountered the follow problem with my vBulletin, copied and pasted from "Common Issues" thread.

Issue: Some users with Forums Only installations have reported receiving the following Database Error when trying to create a sitemap:

Database error in vBulletin 4.0.4:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate)
AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_cpcms AS phrasegroup_cpcms,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,

language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid =
user.userid) LEFT JOIN administrator AS administrator ON
(administrator.userid = user.userid) LEFT JOIN language AS language ON
(language.languageid = IF(user.languageid = 0, 2, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_cpcms' in 'field list'
Error Number : 1054
Request Date : Monday, July 5th 2010 @ 08:37:47 AM
Error Date : Monday, July 5th 2010 @ 08:37:47 AM
Script : http://www.site.com/admincp/sitemap.php
Referrer : http://www.site.com/admincp/index.php?do=nav
IP Address : 99.249.169.108
Username :
Classname : vB_Database_MySQLi
MySQL Version :




Bug:
Fixed in 4.0.5

Fix: Run the following query in phpMyAdmin:

ALTER TABLE `language` ADD `phrasegroup_cpcms` mediumtext NOT NULL;

I'm not 100% how to do this but from phpMyAdmin, I've selected the vBulletin database, clicked SQL tab and in the text box under "Run SQL query/queries on database " I've entered "ALTER TABLE `language` ADD `phrasegroup_cpcms` mediumtext NOT NULL;" as suggested, however, after clicking go, I get the error "#1146 - Table '.language' doesn't exist". I may be doing it wrong?

Any suggestions please?
__DEFINE_LIKE_SHARE__
رد مع اقتباس
إضافة رد

مواقع النشر (المفضلة)

أدوات الموضوع
انواع عرض الموضوع

تعليمات المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code is متاحة
كود [IMG] متاحة
كود HTML معطلة
Trackbacks are متاحة
Pingbacks are متاحة
Refbacks are متاحة



الساعة الآن 02:59 PM


Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By Almuhajir

RSS RSS 2.0 XML MAP HTML