[شيخ نفسه]

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


رمز PHP:

Database error in vBulletin 30:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

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




,post.pagetext
FROM thread AS thread







WHERE thread.threadid IN (0,9586,9608,8732,9156,9390,9432,9494,9525,9392,9391,9394,9461,9406,9387,9389,9385,9386,9388,9330,9322,8980,9336,9325,8901,9274,9218,9281,9086,8766,9206,5466,5416)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Unknown column 'post.pagetext' in 'field list'
Error Number : 1054

وعند تنفيذ هذا الامر


رمز PHP:

alter table `post` add `pagetext` mediumtext

الناتج


رمز PHP:

Duplicate column name 'pagetext'

وتم عمل ربير لك الجداول و لجدول

post


بدون اي فايده


الرجاء الحل