search

sizzlelab / side

t3rc
6 stars 3 forks source link

The SIDEdb.php stop works in get&check #36

Closed miyula closed 12 years ago

miyula commented 12 years ago

According to the uploading file reports: http://jimu.cs.hut.fi/getcheck/admin/reports/sideuploadfile

The php stripe stops the status on reading, and the data is not recorded.

Please fix the problem.

mataanin commented 12 years ago

Talked with @zxhwd2008 on the phone and he promissed to check this tonight.

@zxhwd2008 , when you look at it, please, provide an estimate of time, how long would it take you to fix it.

zxhwd2008 commented 12 years ago

Please give me a test account which can access to the production website.

miyula commented 12 years ago

Xiaohang,

Your account on getcheck is: username: XiaoHang.Zou password: side2011

And you can see the upload file status here: http://jimu.cs.hut.fi/getcheck/admin/reports/sideuploadfile

BR, Shuyan

2011/11/15 Xiaohang < reply@reply.github.com

Please give me a test account which can access to the production website.

Reply to this email directly or view it on GitHub: https://github.com/sizzlelab/side/issues/36#issuecomment-2751299

Zeng Shuyan Tel: +358 44 939 6248 Email: miyula1988@gmail.com

mataanin commented 12 years ago

Processing by the script does not work, because either database file uploaded from the mobile application is broken or it is produced by other version of sqlite

mataanin commented 12 years ago

Situation is that we use sqlite database files to upload data from mobile phone to the server. The problem is that Samsung Galaxy S has newer sqlite version and files uploaded from Samsung Galaxy cannot be read with sqlite on the server. Eventually, we found that you need sqlite > 3.7 to read the data uploaded from Galaxy.

This could be solved in two ways:

  1. Change the format of data (csv, json, xml, etc)
  2. Update the version of sqlite to the newest.

At the moment 2. is half done. I don't have much experience in RedHat administration, so I eventually got stuck.

What is done:

  1. Downloaded sources from sqlite.org
  2. ./configure; make; make install

Status: console sqlite3 utility is now 3.7.9

What still needs to be done:

  1. reconfigure or update php_pdo extension to use the library compiled from sources. (Now if you look at http://jimu.cs.hut.fi/side/phpinfo.php , Sqlite version is 3.3.6 )
mataanin commented 12 years ago

Note: I have asked XiaoHang to estimate the "1. Change format of the data" scenario in issue #51.

cristim1 commented 12 years ago

I have talked with Jyrki and the best option is to get a new server and to install there whatever we need. Because now on jimu there are other services and our instals may impact others work

mataanin commented 12 years ago

Thanks to @cristim1 & Jyrki we got the new server.

@miyula after you move production and development environments, please update this issue with specific urls and reassign to @katuta

@katuta please, let me know if the issue is not clear - would be happy to explain it.

mataanin commented 12 years ago

New server acquired and bug is verified in new development environment.

mataanin commented 12 years ago

upload works ok in production now