![]() |
مشكله بقواعد البيانات
السلام عليكم ورحمة الله وبركاته
رمز PHP: Database error in vBulletin 3.6.0: 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 بدون اي فايده الرجاء الحل |
الساعة الآن 02:22 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.