[fpc-devel] Testsuite database

2013-02-02 Thread Nikolai Zhubr

Hello devels,

Apparently the test suite database needs some love?

E.g. see this URL (generated automatically by webpage, not by me): 
http://www.freepascal.org/testsuite/cgi-bin/testsuite.cgi?os=1cpu=8version=44date=submitter=machine=comment=cond=Category=1action=View+history


The application encountered the following error:

* Error: : Error executing query: You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near ') AND (TU_VERSION_FK=44) AND 
(TU_OS_FK=1) ORDER BY TU_ID DESC LIMIT 50' at line 1

* Stack trace:
  $0049DDD4 line 2147 of fcl-db/src/base/db.pas

Nikolai
___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel


Re: [fpc-devel] Testsuite database

2013-02-02 Thread Alexander Klenin
On Sat, Feb 2, 2013 at 7:42 PM, Nikolai Zhubr n-a-zh...@yandex.ru wrote:

 Apparently the test suite database needs some love?

Wow, I did not even know such a thing existed! How is it populated?

--
Alexander S. Klenin
___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel


Re: [fpc-devel] Testsuite database

2013-02-02 Thread Jonas Maebe

On 02 Feb 2013, at 09:53, Alexander Klenin wrote:

 On Sat, Feb 2, 2013 at 7:42 PM, Nikolai Zhubr n-a-zh...@yandex.ru wrote:
 
 Apparently the test suite database needs some love?
 
 Wow, I did not even know such a thing existed! How is it populated?

Mostly via automated nightly regression tests by the FPC developers.


Jonas
___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel


RE: [fpc-devel] Testsuite database

2013-02-02 Thread Pierre Free Pascal
  Thanks to your email,
  Yuri Sidorov (member of the core team) 
took the time to look at the problems of the
testsuite.cgi program and fixed several issues he found.

  Please test and report if you still find problems...

Pierre Muller

 -Message d'origine-
 De : fpc-devel-boun...@lists.freepascal.org [mailto:fpc-devel-
 boun...@lists.freepascal.org] De la part de Nikolai Zhubr
 Envoyé : samedi 2 février 2013 09:43
 À : FPC developers' list
 Objet : [fpc-devel] Testsuite database
 
 Hello devels,
 
 Apparently the test suite database needs some love?
 
 E.g. see this URL (generated automatically by webpage, not by me):
 http://www.freepascal.org/testsuite/cgi-

bin/testsuite.cgi?os=1cpu=8version=44date=submitter=machine=comment=c
 ond=Category=1action=View+history
 
 The application encountered the following error:
 
  * Error: : Error executing query: You have an error in your SQL
 syntax; check the manual that corresponds to your MySQL server version
 for the right syntax to use near ') AND (TU_VERSION_FK=44) AND
 (TU_OS_FK=1) ORDER BY TU_ID DESC LIMIT 50' at line 1
  * Stack trace:
$0049DDD4 line 2147 of fcl-db/src/base/db.pas
 
 Nikolai
 ___
 fpc-devel maillist  -  fpc-devel@lists.freepascal.org
 http://lists.freepascal.org/mailman/listinfo/fpc-devel

___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel


Re: [fpc-devel] Testsuite database

2013-02-02 Thread Jonas Maebe

On 02 Feb 2013, at 18:00, Pierre Free Pascal wrote:

  Thanks to your email,
  Yuri Sidorov (member of the core team) 
 took the time to look at the problems of the
 testsuite.cgi program and fixed several issues he found.

Maybe one thing: please limit your accesses and queries of the testsuite to 
what is absolutely necessary, because that database is huge and several kinds 
of testsuite queries put a big load on idefix (the machine that also serves the 
bug tracker, svn and main website).


Jonas___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel