Вообщем хотел купить чешую с р25гер нажал Магазин товаров, нашол айди ввожу его и начинается загрузка ( мол ищет предмет ) и резко выдает ошибку
MysqliAdapter::_query : unable to execute SQL query (select SQL_CALC_FOUND_ROWS i.entry as entry, if(loc.name_loc8 IS NULL, i.name, loc.name_loc8) as name, RequiredLevel, ItemLevel, ip.fprice as fprice, ip.fprice*1 as cost from (donate_sync.s5_item_template i left join donate_sync.s5_item_template_disabled dis on i.entry = dis.dis_entry) left join donate_sync.s1_locales_item loc on loc.entry = i.entry left join donate_cp.TItemPrice ip on ip.fkey = i.entry and ip.f_server = 5 WHERE ip.fkey is not null and dis_entry is null and fenable='Y' and class=2 and if(fautoSync,itemLevel>10 and itemLevel<500 and RequiredLevel>10 and RequiredLevel<=80,1) and if(0,if(class=12,1,0),1) and `entry` like '%%54590%%' order by name ASC limit 50). MySQL error: "Column 'entry' in where clause is ambiguous" (Error #1052)
че делать как быть?
- - - Updated - - -
а все разобрался