March 2015 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] post to the list
by Mhamdi Rayen 19 Mar '15

19 Mar '15

Greeting,I'am new in phpmyadmin-devel and I want to post to the list!!!

2 1

Re: [Phpmyadmin-devel] GSoC 2015 (regarding random data generation)
by Tapan Halani 19 Mar '15

19 Mar '15

Hello, The following link contains the api of generatedata . It has also all the usage information regarding the api . It is of the site itself and I think that they permit its usage for other UI's . I think it is a good idea to use this api to implement this feature. Any suggestions are welcome.

1 0

[Phpmyadmin-devel] Regarding project proposal
by Tapan Halani 19 Mar '15

19 Mar '15

I have added all the 5 tasks in the idea "user interface improvements" in my proposal. I saw last few year's proposals , containing 10-12 tasks for UI- improvements. But, right now I cannot think of any other ideas to be implemented in this domain . Is it sufficient ( in order of time) to include these 5 tasks in my proposal for the whole coding period of GSOC 2015? Or is it advisable to come uup with other tasks too.?

2 1

[Phpmyadmin-devel] GSoC 2015
by Harish 19 Mar '15

19 Mar '15

Hello, I am a GSoC aspirant and currently working on UI improvements. I thought of adding another feature to my proposal i.e generating random data. I would like to use the api from http://generatedata.com/ for implementing this feature. it would be really a great feature for phpMyAdmin. Any suggestions regarding this idea? Thank you -- Harish

3 2

[Phpmyadmin-devel] CI for 4.4 branch
by Madhura Jayaratne 19 Mar '15

19 Mar '15

Hi devs, I think it would better if we can have continuous integration configured for 4.4 branch at https://ci.phpmyadmin.net/ -- Thanks and Regards, Madhura Jayaratne

2 2

[Phpmyadmin-devel] Build failed in Jenkins: phpMyAdmin-4.4 #1
by Jenkins Daemon 19 Mar '15

19 Mar '15

See <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/1/> ------------------------------------------ Started by user Michal Čihař [EnvInject] - Loading node environment variables. Building in workspace <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/> Cloning the remote Git repository Cloning repository git://github.com/phpmyadmin/phpmyadmin.git > git init <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/> # timeout=10 Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git > git --version # timeout=10 > git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/* > git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 > git config remote.origin.url git://github.com/phpmyadmin/phpmyadmin.git # timeout=10 Fetching upstream changes from git://github.com/phpmyadmin/phpmyadmin.git > git -c core.askpass=true fetch --tags --progress git://github.com/phpmyadmin/phpmyadmin.git +refs/heads/*:refs/remotes/origin/* > git rev-parse origin/QA_4_4^{commit} # timeout=10 Checking out Revision a9220d89cfd308fe9e29c7c9b7e88895c908877b (origin/QA_4_4) > git config core.sparsecheckout # timeout=10 > git checkout -f a9220d89cfd308fe9e29c7c9b7e88895c908877b First time build. Skipping changelog. Empty changeset, running build. [workspace] $ /bin/sh -xe /tmp/hudson2836780345958061721.sh + ./scripts/generate-mo --quiet [workspace] $ ant clean locales phpunit pdepend phpmd phpcpd phpcs phploc jshint jshint-checkstyle lint Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-6-openjdk-amd64/lib/tools.jar Buildfile: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build.xml> clean: [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/api> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/code-browser> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/coverage> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs> [mkdir] Created dir: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/pdepend> locales: phpunit: BUILD FAILED <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build.xml>:27: Execute failed: java.io.IOException: Cannot run program "<https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/vendor/bin/phpunit">: java.io.IOException: error=2, No such file or directory at java.lang.ProcessBuilder.start(ProcessBuilder.java:494) at java.lang.Runtime.exec(Runtime.java:612) at org.apache.tools.ant.taskdefs.Execute$Java13CommandLauncher.exec(Execute.java:862) at org.apache.tools.ant.taskdefs.Execute.launch(Execute.java:481) at org.apache.tools.ant.taskdefs.Execute.execute(Execute.java:495) at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:631) at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:672) at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:498) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:622) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:390) at org.apache.tools.ant.Target.performTasks(Target.java:411) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) at org.apache.tools.ant.Project.executeTarget(Project.java:1368) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1251) at org.apache.tools.ant.Main.runBuild(Main.java:809) at org.apache.tools.ant.Main.startAnt(Main.java:217) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Caused by: java.io.IOException: java.io.IOException: error=2, No such file or directory at java.lang.UNIXProcess.<init>(UNIXProcess.java:164) at java.lang.ProcessImpl.start(ProcessImpl.java:81) at java.lang.ProcessBuilder.start(ProcessBuilder.java:476) ... 23 more Total time: 10 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 [PMD] Skipping publisher since build result is FAILURE [DRY] Collecting duplicate code analysis files... [DRY] Finding all files that match the pattern build/logs/pmd-cpd.xml [TASKS] Skipping publisher since build result is FAILURE Recording plot data Publishing Clover coverage report... No Clover report will be published due to a Build Failure [xUnit] [INFO] - Starting to record. [xUnit] [INFO] - Processing PHPUnit-3.x (default) [xUnit] [INFO] - [PHPUnit-3.x (default)] - No test report file(s) were found with the pattern 'build/logs/junit.xml' relative to '<https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/'> for the testing framework 'PHPUnit-3.x (default)'. Did you enter a pattern relative to the correct directory? Did you generate the result report(s) for 'PHPUnit-3.x (default)'? [xUnit] [ERROR] - No test reports found for the metric 'PHPUnit' with the resolved pattern 'build/logs/junit.xml'. Configuration error?. [xUnit] [INFO] - Failing BUILD. [xUnit] [INFO] - There are errors when processing test results. [xUnit] [INFO] - Skipping tests recording. [xUnit] [INFO] - Stop build. [JDepend] JDepend plugin is ready [JDepend] Couldn't generate JDepend file at 'build/logs/jdepend.xml'java.io.FileNotFoundException: <https://ci.phpmyadmin.net/job/phpMyAdmin-4.4/ws/build/logs/jdepend.xml> (No such file or directory)

1 0

[Phpmyadmin-devel] Certain queries about Gsoc project
by Resheil Agarwal 19 Mar '15

19 Mar '15

Hello Marc, I have certain queries like in this mention idea only the UI design has to be done using JQuery, Html ans CSS or there is some backhand in PHP also..? If there are some documents to refer then please send the links . And is phpmyadmin similar designing a web-application?

2 1

[Phpmyadmin-devel] Regarding upgrading phpmyadmin
by Tapan Halani 18 Mar '15

18 Mar '15

I have phpmyadmin 4.3.11 installed in my ubuntu 14.04 OS. How can I upgrade to verson 4.3.12 ? Is there any different process , as I have cloned the repository and forked the github repository?

3 3

[Phpmyadmin-devel] GSoC Synchronization Project
by Jay Jayswal 17 Mar '15

17 Mar '15

Hello, i am GSoC Participant. i am interested in Synchronization Project. what i understood is we have to build PHP Scripts which connect to Remote Machine and Synchronize data. which means same database structure at both end and we are coping each end's new row's to another end. Right? i have started with my proposal. i wanted to ask what should be length of proposal? 7 or 8 page is okay or Do i have to make it short? Actually, i already did something like this in my past project.i can't disclose code because i signed Non-Disclosure Agreement of that company. it was two platform project. web-application(PHP) and Desktop application(C# WPF). data is stored at desktop database(SQLite) locally, so user can view, update, delete data offline. and when internet available, system will run script to synchronize data. I have faced many problems while solving the problem that i have listed below. can you send me your expected solution for those problem so that i can understand your expectations and project requirement. Problems: *Insert**:* Case 1: insert at DB1 DB1 DB2 Before Synchronization Step1: Two record with ID 1 & 2 in inserted Current rows :1,2 Current rows : null After Synchronization Current rows :1,2 Two record with ID 1 & 2 in inserted Current rows :1,2 Case 2: insert at DB2 DB1 DB2 Before Synchronization Current rows :1,2 Step1: Two record with ID 3 & 4 in inserted Current rows :1,2,3,4 After Synchronization Two record with ID 3 & 4 in inserted Current rows :1,2,3,4 Current rows :1,2,3,4 Case 3: Insert at Both DB1&DB2 DB1 DB2 Before Synchronization Current rows :1,2,3,4 Current rows :1,2,3,4 Step 1: one new record inserted with id 5 Current rows :1,2,3,4,5(of DB1) Current rows :1,2,3,4 Current rows :1,2,3,4,5(of DB1) Step 2: one new record inserted with id 5 Current rows :1,2,3,4,5(of DB2) After Synchronization What should happen in this case? If we want to sync this we need some differentiate to identify both DB. In my past project I provided Device ID. Means PRIMARY KEY and DEVICE ID both will make Composite Key which make it unique to identify. What is your preferred solution? *Update**: in this case we required updated row timestamp, I am assuming there is update_timestamp column in each table* Case 1: update at DB1 DB1 DB2 Before Synchronization Step1: updating row with id 1 Current rows :1(updated),2,3,4 Current rows :1(old),2,3,4 After Synchronization Current rows :1(updated),2,3,4 update row with id 1 Current rows :1(updated),2,3,4 Case 2: update at DB2 DB1 DB2 Before Synchronization Current rows :1(updated),2(old),3,4 Step1: updating row with id 2 Current rows :1(updated),2(updated),3,4 After Synchronization update row with id 2 Current rows :1(updated),2(updated),3,4 Current rows :1(updated),2(updated),3,4 Case 3: update at both side but different timestamp DB1 DB2 Before Synchronization Step1: updating row with id 2 Current rows :1,2(updated),3,4 Current rows :1,2(old),3,4 Current rows :1,2(updated),3,4 Step1: updating row with id 2 Current rows :1,2(updated),3,4 After Synchronization (both update is different and timestamp is also different) In this case both side update is different, what should be final record. I think I should be last one updated. Right? What is preferred solution? Case 4: update at both side but same timestamp DB1 DB2 Before Synchronization Step1: updating row with id 2 Current rows :1,2(updated),3,4 Step1: updating row with id 2 Current rows :1,2(updated),3,4 After Synchronization (both update is different but time stamp is same) In this case both side update is different and time stamp is same!! So here again we need DEVICE ID by which we can identify that both update is different. And what should I store finally, because which one we have to finally store is depends on timestamp, which is SAME for BOTH DB!!! What is preferred solution? *Delete**:* Case 1: deleted at DB1 DB1 DB2 Before Synchronization Step1: row with id 3 is deleted. Current rows :1,2,4 Current rows :1,2,3,4 After Synchronization In this case row with id 3 will be added at DB1 because for SYSTEM it’s newly added row at DB2. To handle this problem in my past project I maintained Activity logs. Which stores that row with id 3 is deleted, so when synchronization take place, I fetch logs from activity log and first delete row with ID 3 in DB2. What is your preferred Solution? Current rows :1,2,3,4 Current rows :1,2,3,4 Regards, Jay Jayswal

2 1

[Phpmyadmin-devel] Regarding first patch after application deadline and making proposal
by Tapan Halani 16 Mar '15

16 Mar '15

According to phpmyadmin applicant guide for GSOC 2015, all applicants must submit at least one working patch by 3 April 2015. Is this patch meant to contain any implementation of our proposed ideas in our project proposals? If so, is it necessary to at-least have some implementation of all the ideas that have been submitted in proposal? Also, I am trying to create a new account in phpmyadmin.net to add my proposal on site. But I cannot create a new account, as everytime I do so , I get redirected to error page containing *Fatal error*: Call to a member function xpath() on a non-object in */usr/share/mediawiki/extensions-core/ConfirmEdit/Asirra.class.php* on line *44* Please guide me through this. Thank you.

2 1