August 2017 - Developers - lists.phpmyadmin.net

Build failed in Jenkins: documentation #460
by Jenkins Daemon 13 Aug '17

13 Aug '17

1 1

Line from file deleted
by Heard Entertainment 12 Aug '17

12 Aug '17

In my phpmyadmin.net line was deleted and i don't know exactly which one. I am trying to find out how I can tell where my backup of previous files would be or if you could guide me in the right direction to locating and fixing this problem. This is tied to an app that we developed. Our server is Linode. Our app is on apple stores. Is there anything I can do.

2 1

Re: [phpMyAdmin Developers] Developers Digest, Vol 26, Issue 6
by Shriti Arora 08 Aug '17

08 Aug '17

Greetings! We really appreciate the help. We look forward to work with all of you. Regards Shriti Arora On 7 Aug 2017 15:30, <developers-request(a)phpmyadmin.net> wrote: > Send Developers mailing list submissions to > developers(a)phpmyadmin.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.phpmyadmin.net/mailman/listinfo/developers > or, via email, send a message with subject or body 'help' to > developers-request(a)phpmyadmin.net > > You can reach the person managing the list at > developers-owner(a)phpmyadmin.net > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Developers digest..." > > > Today's Topics: > > 1. CONTRIBUTION IN PHPMYADMIN (Shriti Arora) > 2. Re: CONTRIBUTION IN PHPMYADMIN (Manish Bisht) > 3. Re: CONTRIBUTION IN PHPMYADMIN (Raghuram Vadapalli) > 4. Jenkins build is back to normal : documentation #455 > (Jenkins Daemon) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 6 Aug 2017 20:56:35 +0530 > From: Shriti Arora <shriti.arora(a)gmail.com> > To: developers(a)phpmyadmin.net > Subject: [phpMyAdmin Developers] CONTRIBUTION IN PHPMYADMIN > Message-ID: > <CAMyBxX5XcmAg0n4wf7niHTNxHXHnJcfrUOUOkLuaK2m1Erq7=g@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Dear Sir/Ma'am > > I am Shriti Arora , an engineering student majoring in Computer Science > from India. > My team members and I are deeply interested in contributing in the open > source of Phpmyadmin. > As novice open source developers, we'd like to know how can we contribute > to Phpmyadmin so that it aids in your growth as well as our learning > experience. Having gone through similar projects, We have the following > idea: > While working on this project our main focus would be fixing issues that > come up daily along with contributing in the code for the upcoming future > features. > We have taken this as a college project , which would be graded at the end > of the semester. > > Your assistance in this matter is highly appreciated.Looking forward to > hearing from you > > Regards, > Shriti Arora >

1 0

CONTRIBUTION IN PHPMYADMIN
by Shriti Arora 07 Aug '17

07 Aug '17

Dear Sir/Ma'am I am Shriti Arora , an engineering student majoring in Computer Science from India. My team members and I are deeply interested in contributing in the open source of Phpmyadmin. As novice open source developers, we'd like to know how can we contribute to Phpmyadmin so that it aids in your growth as well as our learning experience. Having gone through similar projects, We have the following idea: While working on this project our main focus would be fixing issues that come up daily along with contributing in the code for the upcoming future features. We have taken this as a college project , which would be graded at the end of the semester. Your assistance in this matter is highly appreciated.Looking forward to hearing from you Regards, Shriti Arora

4 3

Build failed in Jenkins: documentation #454
by Jenkins Daemon 07 Aug '17

07 Aug '17

1 1

Build failed in Jenkins: documentation #452
by Jenkins Daemon 05 Aug '17

05 Aug '17

1 1

Re: [phpMyAdmin Developers] Developers Digest, Vol 26, Issue 3
by tkirby2605＠gmail.com 04 Aug '17

04 Aug '17

unsubscribe -----Original Message----- From: Developers [mailto:developers-bounces@phpmyadmin.net] On Behalf Of developers-request(a)phpmyadmin.net Sent: Friday, August 4, 2017 6:00 AM To: developers(a)phpmyadmin.net Subject: Developers Digest, Vol 26, Issue 3 Send Developers mailing list submissions to developers(a)phpmyadmin.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.phpmyadmin.net/mailman/listinfo/developers or, via email, send a message with subject or body 'help' to developers-request(a)phpmyadmin.net You can reach the person managing the list at developers-owner(a)phpmyadmin.net When replying, please edit your Subject line so it is more specific than "Re: Contents of Developers digest..." Today's Topics: 1. Re: get the table name from sql query (Manish Bisht) 2. Build failed in Jenkins: documentation #452 (Jenkins Daemon) ---------------------------------------------------------------------- Message: 1 Date: Thu, 3 Aug 2017 20:34:55 +0530 From: Manish Bisht <manish.bisht490(a)gmail.com> To: phpMyAdmin developers <developers(a)phpmyadmin.net> Subject: Re: [phpMyAdmin Developers] get the table name from sql query Message-ID: <CAO1FkOd3ATA_5589U3cazt_q8=JK-gvm_qF=agfrXFt7c1Jj=g(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I am trying to send data to page using $response->addJSON('key', 'value'); How I can I show the above JSON value on the page ? Where does this value actually gets stored. Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me On Wed, Aug 2, 2017 at 8:30 PM, Manish Bisht <manish.bisht490(a)gmail.com> wrote: > According to my view I think this `$response->addJSON('ajax_reload', > $ajax_reload);` is used to reload the left and top navigation. > > And all the import queries are executed first and then displayed on the page. > > Correct me if I am missing something. > > > Manish Bisht > Email : hi(a)manishbisht.me > Website : https://manishbisht.me > > > > On Wed, Aug 2, 2017 at 8:18 PM, Manish Bisht <manish.bisht490(a)gmail.com> wrote: >> Thanks, >> >> One more thing for the import page (import.php) does the query on >> import page are shown as soon as they are executed using ajax or all >> the import queries are executed first and then shown on the page. >> >> Also what is the use of this link `$response->addJSON('ajax_reload', >> $ajax_reload);` in import.php file >> Manish Bisht >> Email : hi(a)manishbisht.me >> Website : https://manishbisht.me >> >> >> >> On Wed, Aug 2, 2017 at 5:21 PM, Michal Čihař <michal(a)cihar.com> wrote: >>> Hi >>> >>> Manish Bisht píše v St 02. 08. 2017 v 16:48 +0530: >>>> I have one create sql query in one variable. >>>> >>>> Is there any way I can get the table name from the sql query using >>>> sql >>>> parser or any other other way. >>> >>> Yes, SQL parser can do that: >>> >>> <?php >>> >>> require 'vendor/autoload.php'; >>> >>> use PhpMyAdmin\SqlParser\Parser; >>> use PhpMyAdmin\SqlParser\Utils\Query; >>> use PhpMyAdmin\SqlParser\Statements\CreateStatement; >>> >>> $query = 'CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE >>> utf8_bin)'; >>> >>> $parser = new Parser($query); >>> $statement = $parser->statements[0]; >>> foreach ($parser->statements as $statement) { >>> if ($statement instanceof CreateStatement) { >>> echo "Creating table $statement->name\n"; >>> } >>> } >>> >>>> >>>> I am thinking of splitting the query by single space and then using >>>> the 3 value of the array as the table name. >>> >>> No, please do not make any assumptions on the SQL query structure, this >>> is very easy to break: >>> >>> CRATE TABLE `table with spaces` ... >>> >>> CREATE TABLE IF NOT EXIST `table` ... >>> >>> CREATE TABLE /* comment */ `table` ... >>> >>> -- >>> Michal Čihař | https://cihar.com/ | https://weblate.org/ >>> >>> _______________________________________________ >>> Developers mailing list >>> Developers(a)phpmyadmin.net >>> https://lists.phpmyadmin.net/mailman/listinfo/developers >>> ------------------------------ Message: 2 Date: Fri, 4 Aug 2017 04:02:30 +0200 (CEST) From: Jenkins Daemon <jenkins(a)phpmyadmin.net> To: developers(a)phpmyadmin.net Subject: [phpMyAdmin Developers] Build failed in Jenkins: documentation #452 Message-ID: <1761298704.1.1501812150990.JavaMail.jenkins@pmaci> Content-Type: text/plain; charset=UTF-8 See <https://ci.phpmyadmin.net/job/documentation/452/display/redirect?page=chang…> Changes: [weblate] Translated using Weblate (Punjabi) [noreply] Fix typo [weblate] Translated using Weblate (Basque) [weblate] Translated using Weblate (Spanish) [noreply] Fix CGI link in glossary.rst ------------------------------------------ [...truncated 1.54 KB...] (line 27) ok http://www.jqplot.com/ writing output... [ 13%] config (line 712) ok https://secure.php.net/manual/en/reference.pcre.pattern.syntax.php (line 296) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 276) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 924) ok https://dev.mysql.com/doc/refman/5.7/en/grant.html (line 316) ok https://dev.mysql.com/doc/refman/5.7/en/connecting.html (line 1433) ok https://secure.php.net/manual/en/function.session-get-cookie-params.php (line 1270) ok https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html (line 1566) ok https://secure.php.net/manual/en/features.persistent-connections.php (line 1570) ok https://secure.php.net/manual/en/function.mysql-pconnect.php (line 1572) ok https://secure.php.net/manual/en/mysqli.persistconns.php (line 1851) ok https://www.google.com/recaptcha/intro/ (line 1841) ok https://www.google.com/recaptcha/intro/ (line 3323) ok https://www.phpmyadmin.net/try/ (line 1609) ok https://secure.php.net/session_save_path (line 1760) ok https://secure.php.net/manual/en/session.configuration.php#ini.session.gc-m… (line 3470) ok https://bugs.php.net/bug.php?id=72048 (line 2567) ok https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html (line 2614) redirect https://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.h… - with Found to https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-… writing output... [ 18%] copyright (line 28) ok https://www.gnu.org/licenses/ writing output... [ 22%] credits (line 181) ok http://www.fpdf.org/ (line 206) ok https://tcpdf.org (line 181) ok https://tcpdf.org/ (line 139) ok https://sourceforge.net/projects/phpmysqlformgen/ (line 181) ok https://acko.net/blog/ufpdf-unicode-utf-8-extension-for-fpdf/ writing output... [ 27%] developers (line 10) ok https://www.phpmyadmin.net/contribute/ writing output... [ 31%] faq (line 6) ok https://www.phpmyadmin.net/docs/ (line 197) ok https://www.phpmyadmin.net/downloads/ (line 180) ok http://www.ozerov.de/bigdump/ (line 46) ok https://bugs.php.net/bug.php?id=12061 (line 208) ok https://secure.php.net/mysqli (line 197) ok https://www.mysql.com/ (line 134) ok https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html (line 201) ok https://mariadb.org/ (line 469) ok https://httpd.apache.org (line 367) ok https://bugs.php.net/bug.php?id=21079 (line 208) ok https://dev.mysql.com/doc/refman/5.7/en/old-client.html (line 548) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-vars (line 550) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-vars (line 552) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-array-in… (line 554) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-array-index… (line 556) ok https://suhosin.org/stories/configuration.html#suhosin-request-max-totalnam… (line 558) ok https://suhosin.org/stories/configuration.html#suhosin-post-max-totalname-l… (line 560) ok https://suhosin.org/stories/configuration.html#suhosin-get-max-value-length (line 328) ok https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html (line 564) ok https://suhosin.org/stories/configuration.html#logging-configuration (line 567) ok https://suhosin.org/stories/configuration.html#suhosin-sql-union (line 562) ok https://suhosin.org/stories/configuration.html#suhosin-sql-bailout-on-error (line 569) ok https://suhosin.org/stories/configuration.html#suhosin-sql-multiselect (line 576) ok https://suhosin.org/stories/configuration.html#suhosin-executor-include-max… (line 571) ok https://suhosin.org/stories/configuration.html#suhosin-sql-comment (line 580) ok https://suhosin.org/stories/configuration.html#suhosin-cookie-encrypt (line 582) ok https://suhosin.org/stories/configuration.html#suhosin-executor-disable-emo… (line 599) ok https://httpd.apache.org/docs/2.4/mod/mod_ssl.html (line 628) ok https://httpd.apache.org/docs/2.2/mod/mod_proxy.html (line 822) ok https://suhosin.org/stories/index.html (line 822) ok https://suhosin.org/stories/faq.html (line 813) ok https://bugs.php.net/bug.php?id=31134 (line 824) ok https://bugs.php.net/bug.php?id=39842 (line 457) ok https://tools.ietf.org/html/rfc2616.html (line 833) ok https://secure.php.net/manual/en/book.apc.php (line 757) ok https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html (line 833) ok https://pecl.php.net/package/uploadprogress (line 879) ok https://bugs.mysql.com/bug.php?id=21704 (line 953) ok https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html (line 846) ok https://tools.ietf.org/html/rfc1867.html (line 1063) ok https://github.com/phpmyadmin/phpmyadmin/issues/12232 (line 953) ok https://github.com/phpmyadmin/phpmyadmin/issues/7383 (line 1063) ok https://secure.php.net/manual/en/mysqli.real-connect.php#refsect1-mysqli.re… (line 1266) ok https://bugzilla.mozilla.org/ (line 1587) ok https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html (line 1636) ok https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html (line 1615) ok https://dev.mysql.com/doc/refman/5.7/en/drop-table.html (line 1638) ok https://dev.mysql.com/doc/refman/5.7/en/insert.html (line 1800) ok https://secure.php.net/strftime (line 2167) ok https://www.phpmyadmin.net/security (line 2176) ok https://www.phpmyadmin.net/translate/ (line 2204) ok https://www.phpmyadmin.net/security/ (line 1732) ok https://bugs.mysql.com/bug.php?id=179 (line 2167) ok https://github.com/phpmyadmin/phpmyadmin/issues (line 2137) ok https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innod… (line 2254) ok https://sites.google.com/site/bughunteruniversity/nonvuln/csv-excel-formula… (line 2176) ok https://hosted.weblate.org/projects/phpmyadmin/ writing output... [ 36%] glossary (line 31) ok https://en.wikipedia.org/wiki/Bzip2 (line 13) ok https://en.wikipedia.org/wiki/.htaccess (line 21) ok https://en.wikipedia.org/wiki/Blowfish_(cipher) (line 38) ok https://en.wikipedia.org/wiki/Common_Gateway_Interface (line 26) ok https://en.wikipedia.org/wiki/Web_browser (line 53) ok https://en.wikipedia.org/wiki/Column_(database) (line 43) ok https://en.wikipedia.org/wiki/Changelog (line 58) ok https://en.wikipedia.org/wiki/HTTP_cookie (line 48) ok https://en.wikipedia.org/wiki/Client_(computing) (line 63) ok https://en.wikipedia.org/wiki/Comma-separated_values (line 79) ok https://en.wikipedia.org/wiki/Software_extension (line 71) ok https://en.wikipedia.org/wiki/Database (line 97) ok https://en.wikipedia.org/wiki/Foreign_key (line 90) ok https://en.wikipedia.org/wiki/Field_(computer_science) (line 85) ok https://en.wikipedia.org/wiki/FAQ (line 107) ok https://en.wikipedia.org/wiki/GD_Graphics_Library (line 120) ok https://en.wikipedia.org/wiki/Host (line 115) ok https://en.wikipedia.org/wiki/Gzip (line 125) ok https://en.wikipedia.org/wiki/Hostname (line 145) ok https://en.wikipedia.org/wiki/Internet_Information_Services (line 157) ok https://en.wikipedia.org/wiki/Internet_Protocol (line 136) ok https://en.wikipedia.org/wiki/Https:_URI_scheme (line 150) ok https://en.wikipedia.org/wiki/Index_(database) (line 131) ok https://en.wikipedia.org/wiki/HyperText_Transfer_Protocol (line 162) ok https://en.wikipedia.org/wiki/IP_Address (line 169) ok https://en.wikipedia.org/wiki/IPv6 (line 174) ok https://en.wikipedia.org/wiki/ISAPI (line 188) ok https://en.wikipedia.org/wiki/JPEG (line 199) ok https://en.wikipedia.org/wiki/LaTeX (line 209) ok https://en.wikipedia.org/wiki/Mac_OS_X (line 204) ok https://en.wikipedia.org/wiki/Mac (line 180) ok https://en.wikipedia.org/wiki/ISP (line 232) ok https://en.wikipedia.org/wiki/MIME (line 221) ok https://en.wikipedia.org/wiki/MCrypt (line 237) ok https://en.wikipedia.org/wiki/Apache_HTTP_Server (line 246) ok https://en.wikipedia.org/wiki/MySQL (line 261) ok https://en.wikipedia.org/wiki/OpenDocument (line 266) ok https://en.wikipedia.org/wiki/OS_X (line 273) ok https://en.wikipedia.org/wiki/Portable_Document_Format (line 216) ok https://secure.php.net/manual/en/book.mbstring.php (line 226) ok https://secure.php.net/mcrypt (line 292) ok https://en.wikipedia.org/wiki/PHP (line 251) ok https://secure.php.net/manual/en/book.mysqli.php (line 278) ok https://pear.php.net/ (line 256) ok https://secure.php.net/manual/en/book.mysql.php (line 297) ok https://en.wikipedia.org/wiki/Port_(computing) (line 321) ok https://en.wikipedia.org/wiki/Request_for_Comments (line 336) ok https://en.wikipedia.org/wiki/Server_(computing) (line 331) ok https://en.wikipedia.org/wiki/Row_(database) (line 358) ok https://en.wikipedia.org/wiki/Secure_Sockets_Layer (line 352) ok https://en.wikipedia.org/wiki/Unix_domain_socket (line 363) ok https://en.wikipedia.org/wiki/Stored_procedure (line 368) ok https://en.wikipedia.org/wiki/SQL (line 284) ok https://secure.php.net/pcre (line 376) ok https://en.wikipedia.org/wiki/Table_(database) (line 381) ok https://en.wikipedia.org/wiki/Tar_(file_format) (line 387) ok https://en.wikipedia.org/wiki/TCP (line 397) ok https://en.wikipedia.org/wiki/Database_trigger (line 414) ok https://en.wikipedia.org/wiki/URL (line 326) ok https://tools.ietf.org/html/rfc1952.html (line 431) ok https://en.wikipedia.org/wiki/ZIP_(file_format) (line 426) ok https://en.wikipedia.org/wiki/XML (line 436) ok https://en.wikipedia.org/wiki/Zlib (line 419) ok https://en.wikipedia.org/wiki/Webserver (line 347) ok https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html writing output... [ 40%] import_export (line 125) ok https://en.wikipedia.org/wiki/NHibernate (line 282) ok http://odf-converter.sourceforge.net/ (line 242) ok https://www.ctan.org/ (line 242) ok https://www.ctan.org/tex/ (line 340) ok https://texy.info/en/try/4q5we (line 340) ok https://texy.info/ (line 355) ok http://www.yaml.org (line 319) ok https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html (line 335) ok http://www.scriptalicious.com/blog/2009/04/complete-inserts-or-extended-ins… writing output... [ 45%] index writing output... [ 50%] intro (line 47) ok https://www.phpmyadmin.net/translations/ writing output... [ 54%] other (line 21) ok https://cihar.com/publications/linuxsoft/ (line 27) ok http://www.php-editors.com/articles/sql_phpmyadmin.php (line 26) ok http://garv.in/tops/texte/mimetutorial (line 33) redirect http://php-myadmin.ru/ - permanently to https://php-myadmin.ru/ (line 28) ok http://www.iis-aid.com/articles/how_to_guides/install_and_configure_phpmyad… writing output... [ 59%] privileges writing output... [ 63%] relations writing output... [ 68%] require (line 31) ok https://secure.php.net/libxml (line 34) ok https://secure.php.net/openssl (line 26) ok https://secure.php.net/openssl (line 59) ok https://jquery.com/browser-support/ (line 37) ok https://secure.php.net/curl writing output... [ 72%] security (line 106) ok https://files.phpmyadmin.net/phpmyadmin.keyring (line 37) ok https://en.wikipedia.org/wiki/Cross-site_scripting (line 71) ok https://en.wikipedia.org/wiki/SQL_injection (line 85) ok https://en.wikipedia.org/wiki/Brute-force_attack (line 56) ok https://en.wikipedia.org/wiki/Cross-site_request_forgery (line 106) ok https://keybase.io/phpmyadmin_sec (line 110) ok https://github.com/phpmyadmin/phpmyadmin/labels/hardening writing output... [ 77%] settings writing output... [ 81%] setup (line 85) ok https://fedoraproject.org/wiki/EPEL/FAQ#howtouse (line 85) ok https://fedoraproject.org/wiki/EPEL (line 102) ok https://en.wikipedia.org/wiki/List_of_AMP_packages (line 114) ok https://getcomposer.org/ (line 133) ok https://packagist.org/ (line 53) ok https://launchpad.net/~nijel/+archive/ubuntu/phpmyadmin (line 47) broken https://software.opensuse.org/package/phpMyAdmin - HTTP Error 503: Service Unavailable (line 149) ok https://www.phpmyadmin.net/packages.json (line 41) ok https://anonscm.debian.org/cgit/collab-maint/phpmyadmin.git/tree/debian/REA… (line 98) redirect https://www.apachefriends.org/ - with Found to https://www.apachefriends.org/index.html (line 579) ok https://www.phpmyadmin.net/ (line 579) redirect https://demo.phpmyadmin.net/STABLE/setup/ - with Found to http://demo.phpmyadmin.net/master/setup/ (line 243) ok https://hub.docker.com/r/_/mysql/ (line 243) ok https://hub.docker.com/r/_/mariadb/ (line 162) ok https://hub.docker.com/r/phpmyadmin/phpmyadmin/ (line 666) ok https://www.gnupg.org/gph/en/manual.html#AEN335 (line 338) ok https://github.com/phpmyadmin/docker (line 598) ok https://keybase.io/lem9 (line 607) ok https://keybase.io/ibennetch (line 616) ok https://keybase.io/nijel (line 1010) ok https://secure.php.net/manual/en/errorfunc.configuration.php#ini.display-er… (line 1101) ok https://github.com/phpmyadmin/phpmyadmin/issues/11922 (line 666) ok https://pgp.cs.uu.nl/paths/79be3e4300411886/to/ce752f178259bd92.html (line 1107) ok https://github.com/phpmyadmin/phpmyadmin/issues/11898 writing output... [ 86%] themes (line 6) ok https://www.phpmyadmin.net/themes/ writing output... [ 90%] transformations (line 135) ok https://secure.php.net/mysql_fetch_field (line 135) ok https://secure.php.net/mysql_fetch_field writing output... [ 95%] user writing output... [100%] vendors build finished with problems. Makefile:179: recipe for target 'linkcheck' failed make: *** [linkcheck] Error 1 make: Leaving directory '<https://ci.phpmyadmin.net/job/documentation/ws/doc'> Build step 'Execute shell' marked build as failure [WARNINGS] Skipping publisher since build result is FAILURE ------------------------------ Subject: Digest Footer _______________________________________________ Developers mailing list Developers(a)phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers ------------------------------ End of Developers Digest, Vol 26, Issue 3 *****************************************

1 0

get the table name from sql query
by Manish Bisht 03 Aug '17

03 Aug '17

Hi, I have one create sql query in one variable. Is there any way I can get the table name from the sql query using sql parser or any other other way. I am thinking of splitting the query by single space and then using the 3 value of the array as the table name. Thanks, Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me

2 4

Build failed in Jenkins: phpMyAdmin-continuous #13315
by Jenkins Daemon 02 Aug '17

02 Aug '17

See <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/13315/display/redirect?…> Changes: [Michal Čihař] Fix error handling in ajax.php [Michal Čihař] Fix JSON error handling [Michal Čihař] Fixed handling AJAX request errors in case Response is already created [Michal Čihař] Remove no longer valid comment [Michal Čihař] Allow checking parameters in the request ------------------------------------------ [...truncated 18.03 KB...] [exec] [exec] 27) PMA_SeleniumExportTest::testServerExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2)')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 28) PMA_SeleniumExportTest::testServerExport with data set #2 ('JSON', array('{"id":"1","val":"2"}')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 29) PMA_SeleniumExportTest::testDbExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 30) PMA_SeleniumExportTest::testDbExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2)')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 31) PMA_SeleniumExportTest::testDbExport with data set #2 ('JSON', array('{"id":"1","val":"2"}')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 32) PMA_SeleniumExportTest::testTableExport with data set #0 ('CSV', array('"1","2"')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 33) PMA_SeleniumExportTest::testTableExport with data set #1 ('SQL', array('CREATE TABLE IF NOT EXISTS `t...table`', 'INSERT INTO `test_table` (`id...VALUES', '(1, 2)')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 34) PMA_SeleniumExportTest::testTableExport with data set #2 ('JSON', array('{"id":"1","val":"2"}')) [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 35) PMA_SeleniumImportTest::testServerImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 36) PMA_SeleniumImportTest::testDbImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 37) PMA_SeleniumImportTest::testTableImport [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 38) PMA_SeleniumLoginTest::testSuccessfulLogin [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 39) PMA_SeleniumLoginTest::testLoginWithWrongPassword [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 40) PMA_SeleniumNormalizationTest::testNormalizationTo1NF [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 41) PMA_SeleniumSettingsTest::testHideDatabase [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 42) PMA_SeleniumSettingsTest::testSettingsTabsAreDisplayed [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 43) PMA_SeleniumSettingsTest::testHideLogo [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 44) PMA_SeleniumTableBrowseTest::testSortRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 45) PMA_SeleniumTableBrowseTest::testChangeRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 46) PMA_SeleniumTableBrowseTest::testChangeRecordsByDoubleClick [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 47) PMA_SeleniumTableBrowseTest::testCopyRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 48) PMA_SeleniumTableBrowseTest::testSearchRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 49) PMA_SeleniumTableBrowseTest::testDeleteRecords [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 50) PMA_SeleniumTableCreateTest::testCreateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] 51) PMA_SeleniumTableInsertTest::testAddData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:29 [exec] [exec] 52) PMA_SeleniumTableOperationsTest::testChangeTableOrder [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 53) PMA_SeleniumTableOperationsTest::testMoveTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 54) PMA_SeleniumTableOperationsTest::testRenameTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 55) PMA_SeleniumTableOperationsTest::testCopyTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 56) PMA_SeleniumTableOperationsTest::testTruncateTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 57) PMA_SeleniumTableOperationsTest::testDropTable [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 58) PMA_SeleniumTableStructureTest::testAddColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 59) PMA_SeleniumTableStructureTest::testChangeColumn [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 60) PMA_SeleniumTableStructureTest::testDropColumns [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 61) PMA_SeleniumTrackingTest::testTrackingData [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 62) PMA_SeleniumTrackingTest::testDeactivateTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 63) PMA_SeleniumTrackingTest::testDropTracking [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 64) PMA_SeleniumTrackingTest::testStructureSnapshot [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/PmaSel…>:28 [exec] [exec] 65) PMA_SeleniumXSSTest::testQueryTabWithNullValue [exec] Selenium testing not configured. [exec] [exec] <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/test/selenium/TestBa…>:169 [exec] [exec] FAILURES! [exec] Tests: 2359, Assertions: 6392, Failures: 7, Skipped: 65, Incomplete: 5, Risky: 1. BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/build.xml>:33: exec returned: 1 Total time: 18 seconds Build step 'Invoke Ant' marked build as failure [CHECKSTYLE] Skipping publisher since build result is FAILURE [JSLINT] Skipping publisher since build result is FAILURE [DRY] Collecting duplicate code analysis files... [DRY] Searching for all files in <https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/> that match the pattern build/logs/pmd-cpd.xml [DRY] No files found. Configuration error? [DRY] Computing warning deltas based on reference build #13314 [TASKS] Skipping publisher since build result is FAILURE [ANALYSIS-COLLECTOR] Computing warning deltas based on reference build #13314 Recording plot data [xUnit] [INFO] - Starting to record. [xUnit] [INFO] - Processing PHPUnit-3.x (default) [xUnit] [INFO] - [PHPUnit-3.x (default)] - 1 test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<https://ci.phpmyadmin.net/job/phpMyAdmin-continuous/ws/'> for the testing framework 'PHPUnit-3.x (default)'. [xUnit] [INFO] - Check 'Failed Tests' threshold. [xUnit] [INFO] - Check 'Skipped Tests' threshold. [xUnit] [INFO] - Setting the build status to FAILURE [xUnit] [INFO] - Stopping recording.

1 0