提示：500

SELECT u.*,i.classname FROM byb2b_user u,byb2b_industry_class i where i.id=u.b_industry_1 and b_industry_1 in (9,1,11,19,18,2) and u.id in (select uid from (select count(*) as c,uid from byb2b_product where industry_1 in (9,1,11,19,18,2) group by uid ) as ttt where c>3) order by create_time desc limit 2
<br/>SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_60ff_1.MYI'; try to repair it<br/>/data/www/byb2b.com/framework/db/CSnsConnection.php<br/>119

源文件

/data/www/byb2b.com/framework/db/CSnsDbTools.php(228)

00216:                 $pluginId = RUN_MODE != RUN_MODEL_API ? $app->getController()->module->getId(): 'API';
00217:                 $actionId= RUN_MODE != RUN_MODEL_API ? $app->getController()->action->id: 'API';
00218:                 $queryStr = (isset($_SERVER['QUERY_STRING']))?$_SERVER['QUERY_STRING']:'';
00219:                 $app = null;
00220:                 $message = "SQL:{$sql},TIME:{$times['time']}>  rollBack();

00228:             throw new CSnsDbException($ex->getMessage());

00229:         }        
00230:         
00231:         if (isset($returns[RETURN_SINGLE])) {
00232:             if (isset($result[0])) {
00233:                 return $result[0];
00234:             }
00235:             else {
00236:                 return false;
00237:             }
00238:         }        
00239:             
00240:         else if (isset($returns[RETURN_INSERT]))

堆栈追踪

#0 /data/www/byb2b.com/www/plugins/default/class/impls/DefaultModel.php(328): CSnsDbTools->execute('SELECT u.*,i.cl...')
#1 /data/www/byb2b.com/www/plugins/default/controllers/DefaultController.php(32): DefaultModel->getUserByIndustry('9,1,11,19,18,2', 2, true)
#2 /data/www/byb2b.com/framework/web/actions/CInlineAction.php(32): DefaultController->actionIndex()
#3 /data/www/byb2b.com/framework/web/CSnsController.php(120): CInlineAction->run()
#4 /data/www/byb2b.com/framework/web/CSnsController.php(104): CSnsController->runAction(Object(CInlineAction))
#5 /data/www/byb2b.com/framework/web/CSnsController.php(93): CSnsController->runActionWithFilters(Object(CInlineAction), Array)
#6 /data/www/byb2b.com/framework/web/CSnsWebApplication.php(442): CSnsController->run('index')
#7 /data/www/byb2b.com/framework/web/CSnsWebApplication.php(89): CSnsWebApplication->runController('default/default...')
#8 /data/www/byb2b.com/framework/base/CSnsApplication.php(137): CSnsWebApplication->processRequest()
#9 /data/www/byb2b.com/www/web/index.php(22): CApplication->run()
#10 {main}

当网页服务器处理您的请求时, 发生以上错误.

如果您认为此错误是服务器造成的,请与