search

kazimakgul / betatoork

Clone Projesi
http://clone.gs
0 stars 0 forks source link

Best Channel server sorunu #20

Closed kazimakgul closed 12 years ago

kazimakgul commented 12 years ago

Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Games.user_id' in 'where clause'

<p class="notice">
    <strong>SQL Query: </strong>
    SELECT `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`role`, `User`.`active`, `User`.`created`, `User`.`country_id`, `User`.`birth_date`, `User`.`gender`, `User`.`adcode`, `User`.`picture`, (SELECT COUNT(id) FROM games where `Games`.`user_id`=`User`.`id`) AS  `User__uploadcount`, ((SELECT SUM(current) FROM rates where `Rates`.`game_id` IN (SELECT id FROM games where `Games`.`user_id`=`User`.`id`))) AS  `User__totalrate`, `Country`.`id`, `Country`.`name` FROM `NewDB`.`users` AS `User` LEFT JOIN `NewDB`.`countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`)  WHERE `User`.`id` IS NULL    LIMIT 1 </p>

kazimakgul commented 12 years ago

serverda database sorunu veriyor sorunu yapistirdim buraya anlamadim neden odugunu bende kapattim bestchannel i yoksa siteyi patlatiyordu,