Radicore Forum: RADICORE Installation Issues » V 2.17.0

Home » RADICORE » RADICORE Installation Issues » V 2.17.0 - dml.mysqili.class.inc

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: V 2.17.0 - dml.mysqili.class.inc [message #7530 is a reply to message #7529]

Sun, 06 December 2020 12:12

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

As the SQL_CALC_FOUND_ROWS query modifier is being deprecated in MySQL 8 (refer to https://dev.mysql.com/doc/refman/8.0/en/information-function s.html#function_found-rows) I have had to perform the count in a separate query. I do this by enclosing the query in the following

SELECT count(*) FROM (
   ... your query ...
) AS x

If your query starts with 'SELECT *' and joins to one or more other tables, then any column name which appears in more than one table will be flagged as a duplicate. You can get around this by specifying 'SELECT <table>.*' so that it ignores columns on any JOINed tables.

I am surprised that the call to selectAllColumns() within the _sqlAssembleWhere() method of std.table.class.inc did not automatically replace '*' with a full list of column names. This is followed by a call to removeDuplicateFromSelect() which is supposed to remove any duplicate column names and so avoid this issue.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		V 2.17.0 - dml.mysqili.class.inc By: htManager on Sun, 06 December 2020 08:49
		Re: V 2.17.0 - dml.mysqili.class.inc By: AJM on Sun, 06 December 2020 12:12
		Re: V 2.17.0 - dml.mysqili.class.inc By: htManager on Mon, 07 December 2020 11:03
		Re: V 2.17.0 - dml.mysqili.class.inc By: htManager on Mon, 07 December 2020 11:12
		Re: V 2.17.0 - dml.mysqili.class.inc By: AJM on Mon, 07 December 2020 11:50
		Re: V 2.17.0 - dml.mysqili.class.inc By: htManager on Tue, 08 December 2020 04:06
		Re: V 2.17.0 - dml.mysqili.class.inc By: AJM on Tue, 08 December 2020 04:50
		Re: V 2.17.0 - dml.mysqili.class.inc By: htManager on Wed, 09 December 2020 06:47

Previous Topic:	Logon issue at installation
Next Topic:	Installation issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 11 14:54:47 EDT 2025

Total time taken to generate the page: 0.09776 seconds