phpBB-Italia.it

Codice: Seleziona tutto

			//CONTEGGIO DEL NUMERO DEGLI ARGOMENTI (Topics)
			$tot = $this->db->sql_query("SELECT t.forum_id, t.topic_id, count(t.topic_id) AS total
			FROM ". TOPICS_TABLE." t
			WHERE t.forum_id IN($where_list)
			AND t.topic_moved_id = 0
			AND t.topic_last_post_time  > $data_post
			ORDER BY t.topic_id");
			$row_tot = $this->db->sql_fetchrow($tot);			
			
			//####################################################
			$total_topics	= $row_tot['total'];    				// totale dei topics selezionati

Codice: Seleziona tutto

			//CONTEGGIO DEL NUMERO DEGLI ARGOMENTI (Topics)
			$tot = $this->db->sql_query("SELECT forum_id, topic_id, count(topic_id) AS total
			FROM ". TOPICS_TABLE." 
			WHERE forum_id IN($where_list)
			AND topic_moved_id = 0
			AND topic_last_post_time  > $data_post
			ORDER BY topic_id");
			$row_tot = $this->db->sql_fetchrow($tot);			
			
			//####################################################
			$total_topics	= $row_tot['total'];    				// totale dei topics selezionati

Codice: Seleziona tutto

SQL ERROR [ mysqli ]

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'Sql1573107_1.avphpbb_topics.forum_id'; this is incompatible with sql_mode=only_full_group_by [1140]

SQL

SELECT forum_id, topic_id, count(topic_id) AS total FROM avphpbb_topics WHERE forum_id IN(150,149,147,148) AND topic_moved_id = 0 AND topic_last_post_time > 0 ORDER BY topic_id

BACKTRACE

Codice: Seleziona tutto

			//CONTEGGIO DEL NUMERO DEGLI ARGOMENTI (Topics)
			$tot = $this->db->sql_query("SELECT t.forum_id, t.topic_id, count(t.topic_id) AS total
			FROM ". TOPICS_TABLE." t
			WHERE t.forum_id IN($where_list)
			AND t.topic_moved_id = 0
			AND t.topic_last_post_time  > $data_post
			ORDER BY t.topic_id");
			$row_tot = $this->db->sql_fetchrow($tot);			
			//####################################################
			$total_topics	= $row_tot['total'];    				// totale dei topics selezionati

Codice: Seleziona tutto

			// CONTEGGIO DEL NUMERO DEGLI ARGOMENTI (Topics) NEW
			$tot = $this->db->sql_query("SELECT * FROM ". TOPICS_TABLE." 
			WHERE forum_id IN($where_list)
			AND topic_moved_id = 0
			AND topic_last_post_time  > $data_post
			ORDER BY topic_id");
			$n=0;
			while ($tot_row = $this->db->sql_fetchrow($tot))
			{
				++$n;
			}            
			//####################################################
			$total_topics  = $n + 1;

Codice: Seleziona tutto

[ ttlist=tizio ]45,46[ /ttlist ]

Codice: Seleziona tutto

[ ttlist=12 ]45,46[ /ttlist ]