Re: [Wikitech-l] RAND for sql

2016-07-30 Thread yonnel kurtz
It's cache because when i wait more (3mn mini), it's ok Great. With my new extension, i can find, with hazard, some pages from category i choose. just my first. So no complicated, but i can understand more mediawiki. And for my wiki, it's usefull Thank's for all john and bartosz. You are very ki

Re: [Wikitech-l] Parsoid Exception HTTP 500

2016-07-30 Thread Julian Loferer
Am 29.07.2016 um 22:54 schrieb Arlo Breault: On Jul 29, 2016, at 12:24 PM, Julian Loferer wrote: Yeah here is my localsettings.js file: https://phabricator.wikimedia.org/P3603 Thanks! And i have installed it as an ubuntu package so with apt-get install parsoid . I'm assuming you have v0.

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread yonnel kurtz
so, it's very kind to help me to understand (sorry for my english, i'm french) for rand(), i'm agree; But my problem is to have for example 5 pages in the return of perhaps 50. tag extension : page_random is not possible, because if i want 5, the code could find only one (page_ramdom just limit

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread Bartosz Dziewoński
You have to do it like this: 'ORDER BY' => 'rand()', Note that 'rand()' is in quotes, to send this string to MySQL and call the SQL rand() function – otherwise, you'd call the rand() function in PHP and send a random number to MySQL. In general this is a bad idea, though, since this does

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread yonnel kurtz
Sure, this field exist and i see un number associate to each row. But if i do a refresh of result, i will have the same result, because the number un each row is fixe. no ? yonnel 2016-07-30 17:40 GMT+02:00 John : > It's a random number already stored in the page table > > On Saturday, July 30

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread John
It's a random number already stored in the page table On Saturday, July 30, 2016, yonnel kurtz wrote: > Thank's, > > but i'm beginner... > So i don't understand. > > How use it inside my code : > array( > 'ORDER BY' => 'page_title ASC' > #'ORDER BY' => rand(), >

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread yonnel kurtz
Thank's, but i'm beginner... So i don't understand. How use it inside my code : array( 'ORDER BY' => 'page_title ASC' #'ORDER BY' => rand(), 'LIMIT' => 10, ), yonnel 2016-07-30 16:44 GMT+02:00 John : > You can use page_random for that > > On Sat, Jul 30,

Re: [Wikitech-l] RAND for sql

2016-07-30 Thread John
You can use page_random for that On Sat, Jul 30, 2016 at 10:42 AM, yonnel kurtz wrote: > Hello, > > I prepare an extension for category (for myself). I need to find page in a > sql select with "order by rand()" (mysql). > > How to do ? I have each time an error when i try. > This is my syntax

[Wikitech-l] RAND for sql

2016-07-30 Thread yonnel kurtz
Hello, I prepare an extension for category (for myself). I need to find page in a sql select with "order by rand()" (mysql). How to do ? I have each time an error when i try. This is my syntax i have : $res = $dbr->select( array( 'page', 'categorylinks' ), array( 'page_title' )