API tools faq
paste
Guest User

Untitled

a guest
May 25th, 2018
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.42 KB | None | 0 0
raw download clone embed print report
  1. _bunrui_nm_eng` AS `dd_bunrui_nm_en`, `bunrui`.`d_bunrui_nm_eng` AS `d_bunrui_nm_en`, `bunrui`.`c_bunrui_nm_eng` AS `c_bunrui_nm_en`, `bunrui`.`s_bunrui_nm_eng` AS `s_bunrui_nm_en`, `zaiko_trans`.`osusume_pointeger` AS `osusume_pointeger_en`, `zaiko_trans`.`rules_comment` AS `rules_comment_en`, `zaiko_trans`.`shouhin_memo` AS `shouhin_memo_en`, `zaiko_trans`.`tokki` AS `tokki_en`, `shouhin_maker`.`name_eng` AS `maker_nm_en`, `zaiko_trans`.`shouhin_nm` AS `shouhin_nm_en`, `tenpo`.`name_eng` AS `screen_nm_en`, `zaiko_trans`.`design_kubun` AS `design_kubun_en`, `zaiko_trans`.`shaken_taiou_umu` AS `shaken_taiou_umu_en`, `auction_item`.`start_price` AS `start_price`, `auction_item`.`bid_price` AS `bid_price`, `auction_item`.`end_time` AS `end_time`, `auction`.`bid_count` AS `bid_count`, CASE WHEN `review`.`rating` IS NOT NULL THEN `review`.`rating` ELSE 0 END AS `rating`, `tenpo`.`upgweb_display_flag` AS `is_upgweb_display`, CASE WHEN DATE(`auction_item`.`end_time`) = DATE(NOW()) THEN 1 ELSE 0 END AS `is_auction_end_date`, `zaiko_etc_inf`.`tire_units` AS `tire_units`, `zaiko_etc_inf`.`wear_size` AS `wear_size`, `zaiko_etc_inf`.`wear_color` AS `wear_color`, `zaiko_etc_inf`.`wear_pad` AS `wear_pad`, `zaiko_etc_inf`.`wheel_width_f` AS `wheel_width_f`, `zaiko_etc_inf`.`wheel_inch_f` AS `wheel_inch_f`, `zaiko_etc_inf`.`wheel_offset_f` AS `wheel_offset_f`, `zaiko_etc_inf`.`wheel_width_r` AS `wheel_width_r`, `zaiko_etc_inf`.`wheel_inch_r` AS `wheel_inch_r`, `zaiko_etc_inf`.`wheel_offset_r` AS `wheel_offset_r`, CASE WHEN `zaiko_etc_inf`.`pcd1` = TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) ELSE `zaiko_etc_inf`.`pcd1` END AS `pcd1`, `zaiko_etc_inf`.`number_of_holes1` AS `number_of_holes1`, CASE WHEN `zaiko_etc_inf`.`pcd2` = TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) ELSE `zaiko_etc_inf`.`pcd2` END AS `pcd2`, `zaiko_etc_inf`.`number_of_holes2` AS `number_of_holes2`, CASE WHEN `zaiko_etc_inf`.`pcd3` = TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) ELSE `zaiko_etc_inf`.`pcd3` END AS `pcd3`, `zaiko_etc_inf`.`number_of_holes3` AS `number_of_holes3`, `zaiko_etc_inf`.`tire_width_f` AS `tire_width_f`, `zaiko_etc_inf`.`tire_flat_rate_f` AS `tire_flat_rate_f`, `zaiko_etc_inf`.`tire_symbol_structure_f` `tire_symbol_structure_f`, `zaiko_etc_inf`.`tire_inch_f` AS `tire_inch_f`, `zaiko_etc_inf`.`tire_width_r` AS `tire_width_r`, `zaiko_etc_inf`.`tire_flat_rate_r` AS `tire_flat_rate_r`, `zaiko_etc_inf`.`tire_symbol_structure_r` `tire_symbol_structure_r`, `zaiko_etc_inf`.`tire_inch_r` AS `tire_inch_r`, `zaiko_etc_inf`.`operation_check` as `operation_check` FROM `shopitem` INNER JOIN `critem` ON `shopitem`.`critem_id` = `critem`.`critem_id` INNER JOIN `zaiko` ON `shopitem`.`kameiten_id` = `zaiko`.`kameiten_id` AND `shopitem`.`tenpo_id` = `zaiko`.`tenpo_id` AND `shopitem`.`shouhin_cd` = `zaiko`.`shouhin_cd` INNER JOIN `zaiko_etc_inf` ON `zaiko`.`kameiten_id` = `zaiko_etc_inf`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_etc_inf`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_etc_inf`.`shouhin_cd` INNER JOIN `tenpo` ON `shopitem`.`kameiten_id` = `tenpo`.`kameiten_id` AND `shopitem`.`tenpo_id` = `tenpo`.`id` INNER JOIN `crshop` ON `shopitem`.`kameiten_id` = `crshop`.`kameiten_id` AND `shopitem`.`tenpo_id` = `crshop`.`tenpo_id` INNER JOIN `bunrui` ON `zaiko`.`dd_bunrui_cd` = `bunrui`.`dd_bunrui_cd` AND `zaiko`.`d_bunrui_cd` = `bunrui`.`d_bunrui_cd` AND `zaiko`.`c_bunrui_cd` = `bunrui`.`c_bunrui_cd` AND `zaiko`.`s_bunrui_cd` = `bunrui`.`s_bunrui_cd` INNER JOIN `shouhin_maker` ON `zaiko`.`maker_id` = `shouhin_maker`.`id` LEFT OUTER JOIN `zaiko_crbr` ON `zaiko`.`kameiten_id` = `zaiko_crbr`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_crbr`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_crbr`.`shouhin_cd` LEFT OUTER JOIN `zaiko_campaign` ON `zaiko`.`kameiten_id` = `zaiko_campaign`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_campaign`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_campaign`.`shouhin_cd` LEFT OUTER JOIN `zaiko_trans` ON `zaiko_trans`.`kameiten_id` = `zaiko`.`kameiten_id` AND `zaiko_trans`.`tenpo_id` = `zaiko`.`tenpo_id` AND `zaiko_trans`.`shouhin_cd` = `zaiko`.`shouhin_cd` AND `zaiko_trans`.`lang_cd` = 'en' LEFT OUTER JOIN `auction_item` ON `shopitem`.`critem_id` = `auction_item`.`shop_item_id` LEFT OUTER JOIN `auction` ON `shopitem`.`critem_id` = `auction`.`shop_item_id` LEFT OUTER JOIN (SELECT tenpo_id,kameiten_id,AVG(rate) as rating FROM review_shop r group by kameiten_id, tenpo_id) as review ON `shopitem`.`kameiten_id` = `review`.`kameiten_id` AND `shopitem`.`tenpo_id` = `review`.`tenpo_id` WHERE `shopitem`.`display_flag` = 1 AND `tenpo`.`shouhin_display_flag` = 1 AND `zaiko`.`su` > 0 AND `zaiko`.`tanka` > 0 AND (`auction_item`.`end_time` IS NULL OR TIMESTAMP(`auction_item`.`end_time`) > TIMESTAMP(NOW())) Processing Document # 1
  2. at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:406)
  3. at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:319)
  4. at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:227)
  5. ... 3 more
  6. Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: SELECT CONCAT(`critem`.`critem_type`, '_', `critem`.`critem_id`) AS `critem_cd`, CAST(`critem`.`critem_id` AS CHAR CHARACTER SET utf8) AS `critem_id`, `critem`.`critem_type` AS `critem_type`, `bunrui`.`dd_bunrui_nm` AS `dd_bunrui_nm`, `bunrui`.`d_bunrui_nm` AS `d_bunrui_nm`, `bunrui`.`c_bunrui_nm` AS `c_bunrui_nm`, `bunrui`.`s_bunrui_nm` AS `s_bunrui_nm`, `zaiko_etc_inf`.`osusume_pointeger` AS `osusume_pointeger`, `zaiko_etc_inf`.`rules_comment` AS `rules_comment`, `zaiko`.`shouhin_memo` AS `shouhin_memo`, `zaiko_crbr`.`tokki` AS `tokki`, `zaiko`.`house_cd` AS `house_cd`, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-0, 1) WHEN '1' THEN '取扱説明書' END AS accessoriesbit_1, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-1, 1) WHEN '1' THEN '取付説明書' END AS accessoriesbit_2, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-2, 1) WHEN '1' THEN '車速線' END AS accessoriesbit_3, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-3, 1) WHEN '1' THEN 'リモコン' END AS accessoriesbit_4, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-4, 1) WHEN '1' THEN 'アンテナ' END AS accessoriesbit_5, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-5, 1) WHEN '1' THEN 'GPS' END AS accessoriesbit_6, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-6, 1) WHEN '1' THEN 'マイク' END AS accessoriesbit_7, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-7, 1) WHEN '1' THEN 'スタンド' END AS accessoriesbit_8, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-8, 1) WHEN '1' THEN '専用ナット' END AS accessoriesbit_9, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-9, 1) WHEN '1' THEN 'キャップ外し' END AS accessoriesbit_10, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-10, 1) WHEN '1' THEN 'レン チ' END AS accessoriesbit_11, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-11, 1) WHEN '1' THEN 'ダイアル' END AS accessoriesbit_12, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-12, 1) WHEN '1' THEN '書類' END AS accessoriesbit_13, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-13, 1) WHEN '1' THEN 'インナーサイレンサー' END AS accessoriesbit_14, CASE SUBSTRING(`zaiko_etc_inf`.`accessoriesbit`, LENGTH(accessoriesbit)-14, 1) WHEN '1' THEN 'メーカー保証書' END AS accessoriesbit_15, `zaiko`.`kataban` AS `kataban`, `bunrui`.`dd_bunrui_nm` AS `vehicle_type`, `shopitem`.`kameiten_id` AS `kameiten_id`, `shopitem`.`tenpo_id` AS `tenpo_id`, `shopitem`.`shouhin_cd` AS `shouhin_cd`, `zaiko`.`dd_bunrui_cd` AS `dd_bunrui_cd`, `zaiko`.`d_bunrui_cd` AS `d_bunrui_cd`, `zaiko`.`c_bunrui_cd` AS `c_bunrui_cd`, `zaiko`.`s_bunrui_cd` AS `s_bunrui_cd`, `zaiko_etc_inf`.`stars_division` AS `stars_division`, `zaiko`.`tanka`+`zaiko`.`zei` AS `kakaku`, CASE WHEN DATE(NOW() - INTERVAL 3 DAY) <= DATE(`zaiko`.`nyuko_date`) THEN 1 ELSE 0 END AS `is_new`, CASE WHEN `auction_item`.`end_time` IS NOT NULL AND TIMESTAMP(NOW()) < TIMESTAMP(`auction_item`.`end_time`) THEN 1 ELSE 0 END AS `is_auction`, DATE(`zaiko`.`nyuko_date`) AS `nyuko_date`, `zaiko`.`maker_id` AS `maker_id`, `shouhin_maker`.`name` AS `maker_nm`, `zaiko`.`shouhin_nm` AS `shouhin_nm`, `tenpo`.`name` AS `screen_nm`, `zaiko_etc_inf`.`design_kubun` AS `design_kubun`, `zaiko_etc_inf`.`shaken_taiou_umu` AS `shaken_taiou_umu`, `zaiko`.`iro_id` AS `iro_id`, CASE `zaiko_etc_inf`.`stars_division` WHEN '00' THEN '4' WHEN '10' THEN '3' WHEN '20' THEN '3' WHEN '30' THEN '3' WHEN '40' THEN '3' WHEN '50' THEN '1' END AS `shouhin_jotai_cd`, `crshop`.`wws_flag` AS `is_wws`, CASE `zaiko`.`set_cd` WHEN '0000000000000' THEN 1 ELSE 0 END AS `is_set`, CASE WHEN `auction_item`.`end_time` IS NOT NULL AND TIMESTAMP(NOW()) < TIMESTAMP(`auction_item`.`end_time`) THEN 0 WHEN `zaiko_campaign`.`campaign_id` IS NOT NULL THEN 1 ELSE 0 END AS `is_campaign`, CASE `zaiko`.`shouhin_size` WHEN 0 THEN 1 ELSE 0 END AS `is_ask`, CASE CONCAT( `zaiko_etc_inf`.`tire_width_f` , `zaiko_etc_inf`.`tire_flat_rate_f` , `zaiko_etc_inf`.`tire_symbol_structure_f` , `zaiko_etc_inf`.`tire_inch_f` ) WHEN '000' THEN '' ELSE CONCAT( `zaiko_etc_inf`.`tire_width_f` , '/' , `zaiko_etc_inf`.`tire_flat_rate_f` , `zaiko_etc_inf`.`tire_symbol_structure_f` , `zaiko_etc_inf`.`tire_inch_f` ) END AS tire_f , CASE CONCAT( `zaiko_etc_inf`.`tire_width_r` , `zaiko_etc_inf`.`tire_flat_rate_r` , `zaiko_etc_inf`.`tire_symbol_structure_r` , `zaiko_etc_inf`.`tire_inch_r` ) WHEN '000' THEN '' ELSE CONCAT( `zaiko_etc_inf`.`tire_width_r` , '/' , `zaiko_etc_inf`.`tire_flat_rate_r` , `zaiko_etc_inf`.`tire_symbol_structure_r` , `zaiko_etc_inf`.`tire_inch_r` ) END AS tire_r , CASE CONCAT( `zaiko_etc_inf`.`wheel_width_f` , `zaiko_etc_inf`.`wheel_inch_f` , `zaiko_etc_inf`.`wheel_offset_f` ) WHEN '0.000' THEN '' ELSE CONCAT( `zaiko_etc_inf`.`wheel_width_f` , 'Jx' , `zaiko_etc_inf`.`wheel_inch_f` , '+' , `zaiko_etc_inf`.`wheel_offset_f` ) END AS wheel_f , CASE CONCAT( `zaiko_etc_inf`.`wheel_width_r` , `zaiko_etc_inf`.`wheel_inch_r` , `zaiko_etc_inf`.`wheel_offset_r` ) WHEN '0.000' THEN '' ELSE CONCAT( `zaiko_etc_inf`.`wheel_width_r` , 'Jx' , `zaiko_etc_inf`.`wheel_inch_r` , '+' , `zaiko_etc_inf`.`wheel_offset_r` ) END AS wheel_r , CASE CONCAT( `zaiko_etc_inf`.`pcd1` , `zaiko_etc_inf`.`number_of_holes1` ) WHEN '0.00' THEN '' ELSE CONCAT( CASE WHEN `zaiko_etc_inf`.`pcd1` = TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) ELSE `zaiko_etc_inf`.`pcd1` END , '-' , `zaiko_etc_inf`.`number_of_holes1` , 'H' ) END AS pcd_hole1 , CASE CONCAT( `zaiko_etc_inf`.`pcd2` , `zaiko_etc_inf`.`number_of_holes2` ) WHEN '0.00' THEN '' ELSE CONCAT( CASE WHEN `zaiko_etc_inf`.`pcd2` = TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) ELSE `zaiko_etc_inf`.`pcd2` END , '-' , `zaiko_etc_inf`.`number_of_holes2` , 'H' ) END AS pcd_hole2 , CASE CONCAT( `zaiko_etc_inf`.`pcd3` , `zaiko_etc_inf`.`number_of_holes3` ) WHEN '0.00' THEN '' ELSE CONCAT( CASE WHEN `zaiko_etc_inf`.`pcd3` = TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) ELSE `zaiko_etc_inf`.`pcd3` END , '-' , `zaiko_etc_inf`.`number_of_holes3` , 'H' ) END AS pcd_hole3, cast(`zaiko_crbr`.`description` as char character set utf8) AS description, `bunrui`.`dd_bunrui_nm_eng` AS `dd_bunrui_nm_en`, `bunrui`.`d_bunrui_nm_eng` AS `d_bunrui_nm_en`, `bunrui`.`c_bunrui_nm_eng` AS `c_bunrui_nm_en`, `bunrui`.`s_bunrui_nm_eng` AS `s_bunrui_nm_en`, `zaiko_trans`.`osusume_pointeger` AS `osusume_pointeger_en`, `zaiko_trans`.`rules_comment` AS `rules_comment_en`, `zaiko_trans`.`shouhin_memo` AS `shouhin_memo_en`, `zaiko_trans`.`tokki` AS `tokki_en`, `shouhin_maker`.`name_eng` AS `maker_nm_en`, `zaiko_trans`.`shouhin_nm` AS `shouhin_nm_en`, `tenpo`.`name_eng` AS `screen_nm_en`, `zaiko_trans`.`design_kubun` AS `design_kubun_en`, `zaiko_trans`.`shaken_taiou_umu` AS `shaken_taiou_umu_en`, `auction_item`.`start_price` AS `start_price`, `auction_item`.`bid_price` AS `bid_price`, `auction_item`.`end_time` AS `end_time`, `auction`.`bid_count` AS `bid_count`, CASE WHEN `review`.`rating` IS NOT NULL THEN `review`.`rating` ELSE 0 END AS `rating`, `tenpo`.`upgweb_display_flag` AS `is_upgweb_display`, CASE WHEN DATE(`auction_item`.`end_time`) = DATE(NOW()) THEN 1 ELSE 0 END AS `is_auction_end_date`, `zaiko_etc_inf`.`tire_units` AS `tire_units`, `zaiko_etc_inf`.`wear_size` AS `wear_size`, `zaiko_etc_inf`.`wear_color` AS `wear_color`, `zaiko_etc_inf`.`wear_pad` AS `wear_pad`, `zaiko_etc_inf`.`wheel_width_f` AS `wheel_width_f`, `zaiko_etc_inf`.`wheel_inch_f` AS `wheel_inch_f`, `zaiko_etc_inf`.`wheel_offset_f` AS `wheel_offset_f`, `zaiko_etc_inf`.`wheel_width_r` AS `wheel_width_r`, `zaiko_etc_inf`.`wheel_inch_r` AS `wheel_inch_r`, `zaiko_etc_inf`.`wheel_offset_r` AS `wheel_offset_r`, CASE WHEN `zaiko_etc_inf`.`pcd1` = TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd1`,0) ELSE `zaiko_etc_inf`.`pcd1` END AS `pcd1`, `zaiko_etc_inf`.`number_of_holes1` AS `number_of_holes1`, CASE WHEN `zaiko_etc_inf`.`pcd2` = TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd2`,0) ELSE `zaiko_etc_inf`.`pcd2` END AS `pcd2`, `zaiko_etc_inf`.`number_of_holes2` AS `number_of_holes2`, CASE WHEN `zaiko_etc_inf`.`pcd3` = TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) THEN TRUNCATE(`zaiko_etc_inf`.`pcd3`,0) ELSE `zaiko_etc_inf`.`pcd3` END AS `pcd3`, `zaiko_etc_inf`.`number_of_holes3` AS `number_of_holes3`, `zaiko_etc_inf`.`tire_width_f` AS `tire_width_f`, `zaiko_etc_inf`.`tire_flat_rate_f` AS `tire_flat_rate_f`, `zaiko_etc_inf`.`tire_symbol_structure_f` `tire_symbol_structure_f`, `zaiko_etc_inf`.`tire_inch_f` AS `tire_inch_f`, `zaiko_etc_inf`.`tire_width_r` AS `tire_width_r`, `zaiko_etc_inf`.`tire_flat_rate_r` AS `tire_flat_rate_r`, `zaiko_etc_inf`.`tire_symbol_structure_r` `tire_symbol_structure_r`, `zaiko_etc_inf`.`tire_inch_r` AS `tire_inch_r`, `zaiko_etc_inf`.`operation_check` as `operation_check` FROM `shopitem` INNER JOIN `critem` ON `shopitem`.`critem_id` = `critem`.`critem_id` INNER JOIN `zaiko` ON `shopitem`.`kameiten_id` = `zaiko`.`kameiten_id` AND `shopitem`.`tenpo_id` = `zaiko`.`tenpo_id` AND `shopitem`.`shouhin_cd` = `zaiko`.`shouhin_cd` INNER JOIN `zaiko_etc_inf` ON `zaiko`.`kameiten_id` = `zaiko_etc_inf`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_etc_inf`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_etc_inf`.`shouhin_cd` INNER JOIN `tenpo` ON `shopitem`.`kameiten_id` = `tenpo`.`kameiten_id` AND `shopitem`.`tenpo_id` = `tenpo`.`id` INNER JOIN `crshop` ON `shopitem`.`kameiten_id` = `crshop`.`kameiten_id` AND `shopitem`.`tenpo_id` = `crshop`.`tenpo_id` INNER JOIN `bunrui` ON `zaiko`.`dd_bunrui_cd` = `bunrui`.`dd_bunrui_cd` AND `zaiko`.`d_bunrui_cd` = `bunrui`.`d_bunrui_cd` AND `zaiko`.`c_bunrui_cd` = `bunrui`.`c_bunrui_cd` AND `zaiko`.`s_bunrui_cd` = `bunrui`.`s_bunrui_cd` INNER JOIN `shouhin_maker` ON `zaiko`.`maker_id` = `shouhin_maker`.`id` LEFT OUTER JOIN `zaiko_crbr` ON `zaiko`.`kameiten_id` = `zaiko_crbr`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_crbr`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_crbr`.`shouhin_cd` LEFT OUTER JOIN `zaiko_campaign` ON `zaiko`.`kameiten_id` = `zaiko_campaign`.`kameiten_id` AND `zaiko`.`tenpo_id` = `zaiko_campaign`.`tenpo_id` AND `zaiko`.`shouhin_cd` = `zaiko_campaign`.`shouhin_cd` LEFT OUTER JOIN `zaiko_trans` ON `zaiko_trans`.`kameiten_id` = `zaiko`.`kameiten_id` AND `zaiko_trans`.`tenpo_id` = `zaiko`.`tenpo_id` AND `zaiko_trans`.`shouhin_cd` = `zaiko`.`shouhin_cd` AND `zaiko_trans`.`lang_cd` = 'en' LEFT OUTER JOIN `auction_item` ON `shopitem`.`critem_id` = `auction_item`.`shop_item_id` LEFT OUTER JOIN `auction` ON `shopitem`.`critem_id` = `auction`.`shop_item_id` LEFT OUTER JOIN (SELECT tenpo_id,kameiten_id,AVG(rate) as rating FROM review_shop r group by kameiten_id, tenpo_id) as review ON `shopitem`.`kameiten_id` = `review`.`kameiten_id` AND `shopitem`.`tenpo_id` = `review`.`tenpo_id` WHERE `shopitem`.`display_flag` = 1 AND `tenpo`.`shouhin_display_flag` = 1 AND `zaiko`.`su` > 0 AND `zaiko`.`tanka` > 0 AND (`auction_item`.`end_time` IS NULL OR TIMESTAMP(`auction_item`.`end_time`) > TIMESTAMP(NOW())) Processing Document # 1
  7. at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
  8. at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
  9. at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
  10. at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
  11. at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
  12. at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
  13. at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
  14. at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:465)
  15. at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
  16. ... 5 more
  17. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'zaiko_etc_inf.wear_size' in 'field list'
  18. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  19. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  20. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  21. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  22. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  23. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  24. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  25. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
  26. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
  27. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
  28. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
  29. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
  30. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
  31. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
  32. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
  33. at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:246)
  34. ... 12 more
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!