Developers

developers@phpmyadmin.net

7002 discussions

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

Fallback to default table names and database
by Manish Bisht 28 Jul '17

28 Jul '17

Hi, I am working on this feature https://github.com/phpmyadmin/phpmyadmin/issues/12887 Till now I have set default database and table names. Should I set the default control user also to `phpmyadmin` So that you only have to set the control pass in the `config.inc.php` file. I think people give the user name according to user preference so its better so set it from `config.inc.php` file but I am looking for the community feedback so that I can implement in that way. Pull Request: https://github.com/phpmyadmin/phpmyadmin/pull/13524 Thanks, Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me

2 1

Re: [phpMyAdmin Developers] phpmyadmin database update
by Raghuram Vadapalli 20 Jul '17

20 Jul '17

Hi Manish, When you are dealing with configuration storage, you need to use controluser link for database interface. Otherwise, it will use current user to execute queries. Current user may not have permissions to even access phpmyadmin database. You can do this by passing $GLOBALS['controluser'] as parameter to any function operating with DBI. I am assuming that you have set up controluser and similar parameters in config.inc.php file. If it still doesn't work, please share the error you are getting. Regards, Raghuram On 17-Jul-2017 3:16 PM, "Manish Bisht" <manish.bisht490(a)gmail.com> wrote: How to use the phpmyadmin configuration database properly. I am using the following code. $GLOBALS['dbi']->selectDb('phpmyadmin'); $GLOBALS['dbi']->tryQuery('INSERT INTO `pma__progress` VALUES ("sas", "sas", 50, 100)'); Let me know if I am correct or wrong. I think I am missing something. Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me On Sat, Jul 15, 2017 at 5:07 PM, Manish Bisht <manish.bisht490(a)gmail.com> wrote: > Thanks > > Just created the table by running import. > > How to save data in the tables by running queries from any file. > > Manish Bisht > Email : hi(a)manishbisht.me > Website : https://manishbisht.me > > > On Sat, Jul 15, 2017 at 5:02 PM, Raghuram Vadapalli < > raghuram.vadapalli(a)research.iiit.ac.in> wrote: > >> Hi, >> >> You have to run that sql file. Running it is part of installation process >> as far as I know. >> >> Regards, >> Raghuram >> >> >> On 15-Jul-2017 4:38 PM, "Manish Bisht" <manish.bisht490(a)gmail.com> wrote: >> >>> Hi, >>> >>> To store the import/export progress I have added one new table in >>> sql/create_tables.sql file but I can't see my new table in the phpmyadmin >>> database. How to update phpmyadmin database from that file. I guess there >>> is something that do it automatically instead of manually executing the >>> statement. >>> >>> Thanks, >>> >>> Manish Bisht >>> Email : hi(a)manishbisht.me >>> Website : https://manishbisht.me >>> >>> >>> _______________________________________________ >>> Developers mailing list >>> Developers(a)phpmyadmin.net >>> https://lists.phpmyadmin.net/mailman/listinfo/developers >>> >>> >> _______________________________________________ >> Developers mailing list >> Developers(a)phpmyadmin.net >> https://lists.phpmyadmin.net/mailman/listinfo/developers >> >> > _______________________________________________ Developers mailing list Developers(a)phpmyadmin.net https://lists.phpmyadmin.net/mailman/listinfo/developers

4 11

phpMyAdmin 4.7.3 is released
by Isaac Bennetch 20 Jul '17

20 Jul '17

Welcome to phpMyAdmin 4.7.3, a regular maintenance release containing bug fixes. A complete list of new features and bugs that have been fixed is available in the ChangeLog file or changelog.php included with this release. Notable changes since 4.7.2: * Fixed creating relations * Fixed export without back quotes * Improved handling of uploaded files with open_basedir * Fixed usage of some browser transformations * Automatically connect using SSL when server is configured for such There are many more improvements; please refer to the ChangeLog for full details. As always, downloads are available at https://www.phpmyadmin.net Thanks to our sponsors for helping to make this work possible! The phpMyAdmin Team

1 0

longtext datatype request error
by florent larose 20 Jul '17

20 Jul '17

I have a website project to develop for my company. I actually think about using PHP/ MySQL for that purpose. One of my difficulties concern phpmyadmin and is the following : I need to save a record with a datatype < LONGTEXT > or < MEDIUM TEXT > (in fact the textarea must content until 2.000.000 caracters). When I test to register I obtain a pinky messagebox from mysql server saying that it is gone away... And no record has been done. So how can I use those two datatypes for longtext records ? And is there a configuration to define for the mysql server for such requests ? Thanks for your help. [cid:image001.jpg@01D3016B.88D2A130]

1 0

Upcoming release
by Isaac Bennetch 18 Jul '17

18 Jul '17

Hi, It's nearly time for phpMyAdmin 4.7.3, especially considering that we planned a slightly earlier than usual release in [1]. As usual, let me know if you have any objections or issues that should block the release. I see nothing critical in the tracker, but will keep an eye on the milestone status. I'll probably do the release in a few days. Isaac 1 - https://github.com/phpmyadmin/phpmyadmin/issues/13465

1 0

phpmyadmin database update
by Manish Bisht 17 Jul '17

17 Jul '17

Hi, To store the import/export progress I have added one new table in sql/create_tables.sql file but I can't see my new table in the phpmyadmin database. How to update phpmyadmin database from that file. I guess there is something that do it automatically instead of manually executing the statement. Thanks, Manish Bisht Email : hi(a)manishbisht.me Website : https://manishbisht.me

3 4

IRC meeting for tomorrow
by Isaac Bennetch 12 Jul '17

12 Jul '17

Hello developers, The monthly IRC meeting is scheduled for tomorrow, but there isn't anything on the agenda. If no one has any topics to add, I suggest we skip this meeting. Isaac

4 3

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers