مشکلات مانشت - نسخه‌ی قابل چاپ

کد:

MyBB has experienced an internal SQL error and cannot continue.



SQL Error:

    ۱۰۵۴ - Unknown column 'pos.thumbsup' in 'field list'

Query:

    SELECT t.*, u.username AS userusername, p.displaystyle AS threadprefix , t.yes as maneshtrateyes , t.no as maneshtrateno ,(sum(pos.thumbsup) - sum(pos.thumbsdown)) as thumbs FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid=t.uid) LEFT JOIN mybb_threadprefixes p ON (p.pid=t.prefix) WHERE t.tid IN (3958,519,32371,34163,34161,34177,34151,34176,34175,34140,31838,27389,34174,34165,6232,34111,34106,34082,34098,34168,34134,33955,34137,33851,26290,34153,3199,34173,34167,34171,34172,31822) AND t.visible>0 AND t.fid NOT IN ('270','112','370','371','372','373','374','375','376','377','378','379','380','381','430','431','432','434','433','495','496','497','498','499','491','492','493','494','487','488','489','490') AND t.fid NOT IN (270,370,371,372,373,374,375,376,377,378,379,380,381,430,431,432,434,433,495,496,497,498,499,491,492,493,494,487,488,489,490) AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost desc LIMIT 0, 20

کد:

if (isset($_GET['amount'])) {

۴۸ 

۴۹             $amount = intval($_GET['amount']);

۵۰             $tozihat = '';

۵۱             $invis = 0;

۵۲ 

۵۳             Yii::app()->dbf->createCommand("INSERT INTO mybb_donate SET uid='$uid',active=0, amount='$amount',invis='$invis',SaleReferenceId='',dateline = " . time() . ", refID = ''")->query();

۵۴             $orderId = Yii::app()->dbf->createCommand("SELECT LAST_INSERT_ID()")->queryScalar();

۵۵ 

۵۶ 

۵۷ 

۵۸             $client = new soapclient('https://bpm.shaparak.ir/pgwchannel/services/pgw?wsdl', array('uri' => 'http://interfaces.core.sw.bps.com/', 'trace' => true));

۵۹             $result = $client->bpPayRequest(array(

۶۰                 'terminalId' => 856735,

۶۱                 'userName' => 'manesht',

۶۲                 'userPassword' => '********',

۶۳                 'orderId' => $orderId,

۶۴                 'amount' => $amount . '0',

۶۵                 'localDate' => date("ymd"),

۶۶                 'localTime' => date("His"),

۶۷                 'additionalData' => $tozihat,

۶۸                 'callBackUrl' => 'https://manesht.ir/site/donate',

۶۹                 'payerId' => 0,

۷۰                     ));