[ فهــرس ســوالـف ] لحل مــشـــاكــل قــواعــد البـيـانـات

[eng_medo]

انتظر ردودكم

Data**** error in vBulletin 3.6.5:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, thread.stampid, stamps.title, stamps.icon AS stampicon, stamps.color, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , attachment.filesize AS filesize ,attachment.filename AS filename, MIN(attachment.attachmentid) AS attachmentid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN stamps AS stamps ON(thread.stampid = stamps.stampid)LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid) LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid)
WHERE thread.threadid IN (0) GROUP BY thread.threadid GROUP BY thread.threadid
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066
Date : Sunday, April 15th 2007 @ 07:08:04 AM
Script : http://www.cgway.net/forumdisplay.php?f=45
Referrer :
IP Address :************
Username : 000000000
Classname : vb_data****

[eng_medo]

اخي الكريم
انتظر ردك

[eng_medo]

انتظر منكم الرد علي مشكلتي

[ahmed-samara]

انتظر ردودكم

Data**** error in vBulletin 3.6.5:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, thread.stampid, stamps.title, stamps.icon AS stampicon, stamps.color, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , attachment.filesize AS filesize ,attachment.filename AS filename, MIN(attachment.attachmentid) AS attachmentid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN stamps AS stamps ON(thread.stampid = stamps.stampid)LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid) LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid)
WHERE thread.threadid IN (0) GROUP BY thread.threadid GROUP BY thread.threadid
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066
Date : Sunday, April 15th 2007 @ 07:08:04 AM
Script : http://www.cgway.net/forumdisplay.php?f=45
Referrer :
IP Address :************
Username : 000000000
Classname : vb_data****

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

[eng_medo]

اخي الكريم
قمت بعمل ما قلت وحذفت هاك الأختام نهائيا ولاكن نفس المشكله موجوده

[ahmed-samara]

وقف الهاكات

 define('DISABLE_HOOKS', 1); 

في أخر ملف الكونفج
قبل علامة ?>

وشوف هاك ايش الى عامل الخلل هذا ووقفة

وبالتوفيق

[eng_medo]

اخي الكريم
انا مركيب vbadvanced portal
لو وقفت عمل الهاكات كلها المنتدي سيقف تماما

ارجوا منك افادتي افادك الله

[serag777]

لدى مشكلة غريبة جدا عند تسجيل عضو جديد يظهر هذا الخطاء

Invalid SQL:
INSERT INTO userfield
(userid)
VALUES
(1538);

MySQL Error : Duplicate entry '1538' for key 1
Error Number : 1062
Date : Wednesday, April 18th 2007 @ 11:04:54 AM

واسم العضو الجديد لايظهر بالمنتدى


وشكرا

[الإبداع]

ممكن تلقون نظره على هالمشكله

http://www.swalif.net/softs/showthre...70#post1404670

[ahmed-samara]

ميدو تعالة على الميل

سراج تعالة ميل بردك

ممكن تلقون نظره على هالمشكله

http://www.swalif.net/softs/showthre...70#post1404670

الحل بأذن الله

 ALTER TABLE `forum` ADD `defaultsortfield` VARCHAR( 50 ) DEFAULT 'lastpost' NOT NULL 

ازرع الامر فى قاعدة البيانات

[الإبداع]

اهلين اخوي
اذا سويت زرع للامر يطلع لي كذا

المره الاولى ماتغير شي .. ولما زرعت مره ثانيه طلع لي كذا

Error
SQL query:

ALTER TABLE `forum` ADD `defaultsortfield` VARCHAR( 50 ) DEFAULT 'lastpost' NOT NULL

MySQL said:

#1060 - Duplicate column name 'defaultsortfield'

[M® Mostafa]

ممكن تلقون نظره على هالمشكله

http://www.swalif.net/softs/showthre...70#post1404670

ازرع هالأمر

ALTER TABLE forum ADD defaultsortfield VARCHAR(50) NOT NULL DEFAULT 'lastpost'; 

ثم أزرع بعده هالأمر

ALTER TABLE forum ADD defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc'; 

[M® Mostafa]

لدى مشكلة غريبة جدا عند تسجيل عضو جديد يظهر هذا الخطاء

Invalid SQL:
INSERT INTO userfield
(userid)
VALUES
(1538);

MySQL Error : Duplicate entry '1538' for key 1
Error Number : 1062
Date : Wednesday, April 18th 2007 @ 11:04:54 AM

واسم العضو الجديد لايظهر بالمنتدى


وشكرا

وهذا نتيجة تركيب برودكت او بلقنز بشكل خطا او اذا هو غير متوافق مع نسختك


ازرع الامر التالي وان شاء الله بتنحل مشكلتك

ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT; 

[الإبداع]

ازرع هالأمر

ALTER TABLE forum ADD defaultsortfield VARCHAR(50) NOT NULL DEFAULT 'lastpost'; 

ثم أزرع بعده هالأمر

ALTER TABLE forum ADD defaultsortorder ENUM('asc', 'desc') NOT NULL DEFAULT 'desc'; 

زرعت الامر الاول وطلع لي كذا

Error
SQL query: 

ALTER TABLE forum ADD defaultsortfield VARCHAR( 50 ) NOT NULL DEFAULT 'lastpost' 

MySQL said:  

#1060 - Duplicate column name 'defaultsortfield'

وزرعت الامر الثاني وطلع كذا

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

[ahmed-samara]

زرعت الامر الاول وطلع لي كذا

Error
SQL query: 

ALTER TABLE forum ADD defaultsortfield VARCHAR( 50 ) NOT NULL DEFAULT 'lastpost' 

MySQL said:  

#1060 - Duplicate column name 'defaultsortfield'

وزرعت الامر الثاني وطلع كذا

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

ازرع هذه الأوامر سطر سطر وإذا ظهرت لك مشكلة أثناء الزرع تجاوزها وازرع الامر وبالترتيب :

Alter table `forum`  DROP `defaultsortfield`;   
Alter table `forum` DROP `defaultsortorder`;   
 Alter table `forum` ADD `defaultsortfield` varchar(50) NOT NULL default 'lastpost';   
   Alter table `forum` ADD `defaultsortorder` enum('asc','desc') NOT NULL default 'desc';   
Alter table `forum` ADD `showprivate` tinyint(3) unsigned NOT NULL default '0';