Cuando el Cronj de referencia se ejecuta para entregar los bonos arroja este error:
USER ERROR: "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous
Query-Code:SELECT `username`, `ref_id`, `id`, `lang`, user.`universe`
FROM uni1_users user
INNER JOIN uni1_statpoints as stats
ON stats.`id_owner` = user.`id` AND stats.`stat_type` = 1 AND stats.`total_points` >= 50000
WHERE user.`ref_bonus` = 1;"
File: /www/wwwroot/xnovaone.online/includes/classes/Database.class.php | Line: 126
URL: xnovaone.online/cronjob.php?cronjobID=16 | Version: 1.8.git
Stack trace:
#0 /includes/classes/Database.class.php(193): Database->_query('SELECT `usernam...', Array, 'select')
#1 /includes/classes/cronjob/ReferralCronjob.class.php(41): Database->select('SELECT `usernam...', Array)
#2 /includes/classes/Cronjob.class.php(57): ReferralCronJob->run()
#3 /cronjob.php(54): Cronjob::execute(16)
#4 {main}
Como puedo solucionarlo ????
USER ERROR: "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous
Query-Code:SELECT `username`, `ref_id`, `id`, `lang`, user.`universe`
FROM uni1_users user
INNER JOIN uni1_statpoints as stats
ON stats.`id_owner` = user.`id` AND stats.`stat_type` = 1 AND stats.`total_points` >= 50000
WHERE user.`ref_bonus` = 1;"
File: /www/wwwroot/xnovaone.online/includes/classes/Database.class.php | Line: 126
URL: xnovaone.online/cronjob.php?cronjobID=16 | Version: 1.8.git
Stack trace:
#0 /includes/classes/Database.class.php(193): Database->_query('SELECT `usernam...', Array, 'select')
#1 /includes/classes/cronjob/ReferralCronjob.class.php(41): Database->select('SELECT `usernam...', Array)
#2 /includes/classes/Cronjob.class.php(57): ReferralCronJob->run()
#3 /cronjob.php(54): Cronjob::execute(16)
#4 {main}
Como puedo solucionarlo ????