/ftp doesn't work and gives errors

[Michiel.Schok]

<?xml version="1.0" encoding="UTF-8"?>
<response>

<header>

<item_count>0</item_count>
<item_count_total>0</item_count_total>
<item_offset>0</item_offset>
<request_matched_method>GET</request_matched_method>
<request_matched_uri>/ftp</request_matched_uri>
<request_process_time>0.0234</request_process_time>
<request_result>error</request_result>
<request_result_description>PDOException caught; SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vpcore.ftpuser' doesn't exist,

trace; #0 /var/opt/www/vpcore/htdocs/includes/database/database.inc(1735): PDOStatement-&gt;execute(Array)
#1 /var/opt/www/vpcore/htdocs/includes/database/database.inc(568): DatabaseStatementBase?-&gt;execute(Array, Array)
#2 /var/opt/www/vpcore/htdocs/includes/database/database.inc(1821): DatabaseConnection?-&gt;query('SELECT * FROM {...', Array, Array)
#3 [internal function]: db_query('SELECT * FROM {...', Array, Array)
#4 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/lib/mediamosa_db.inc(151): call_user_func_array('db_query', Array)
#5 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/lib/mediamosa_db.inc(250): mediamosa_db::query('db_query', Array)
#6 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/modules/ftp_user/mediamosa_ftp_user.rest.inc(76): mediamosa_db::db_query('SELECT * FROM {...', Array)
#7 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest_call.inc(269): mediamosa_rest_call_ftp_user_list-&gt;do_call()
#8 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/rest/mediamosa_rest.inc(304): mediamosa_rest_call-&gt;process_call()
#9 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/response/mediamosa_response.inc(125): mediamosa_rest-&gt;process_call(Array)
#10 /var/opt/www/vpcore/htdocs/sites/all/modules/mediamosa/mediamosa.module(94): mediamosa_response-&gt;process_rest()
#11 [internal function]: mediamosa_init()
#12 /var/opt/www/vpcore/htdocs/includes/module.inc(413): call_user_func_array('mediamosa_init', Array)
#13 /var/opt/www/vpcore/htdocs/includes/common.inc(3769): module_invoke_all('init')
#14 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1551): _drupal_bootstrap_full()
#15 /var/opt/www/vpcore/htdocs/includes/bootstrap.inc(1417): _drupal_bootstrap(8)
#16 /var/opt/www/vpcore/htdocs/index.php(21): drupal_bootstrap(8)
#17 {main},
Query string; SELECT * FROM {ftpuser} WHERE eua_id = :eua_id,
Args; Array
(

[:eua_id] =&gt; 5

)
</request_result_description>

<request_result_id>500</request_result_id>
<request_uri>[GET] /ftp</request_uri>
<version>2.1.0.236:07ebc5929cac</version>

</header>
<items/>

</response>

[robert]

release 2.1

[Frans]

Now we see a "REST call not found" message on the /ftp REST call

[robert]

Can you recheck if you entered the right url? /ftp seems to work fine. Or else paste the output of mediamosa here so I can check url/request you used.

[Frans]

I'm using the REST interface from the WLE 1.7. This gives an "REST call not found' on " http://app.acceptatie.vpcore.snkn.nl/ftp?user_id=admin&is_app_admin=TRUE"

Using the same command (/ftp) on the 1.7.3 version gives good result:

<?xml version="1.0"?>
<response>
  <header>
    <item_count>0</item_count>
    <request_process_time>0.0131</request_process_time>
    <request_query_count>12</request_query_count>
    <request_result>success</request_result>
    <request_result_description>FTP users</request_result_description>
    <request_result_id>601</request_result_id>
    <request_uri>[GET] ftp?user_id=admin&amp;is_app_admin=TRUE</request_uri>
    <vpx_version>1.7.3.4</vpx_version>
  </header>
  <items/>
</response>

[robert]

<?xml version="1.0" encoding="UTF-8"?>
<response>
  <header>
    <item_count>312</item_count>
    <item_count_total>312</item_count_total>
    <item_offset>0</item_offset>
    <request_class>mediamosa_rest_call_ftp_user_list</request_class>
    <request_matched_method>GET</request_matched_method>
    <request_matched_uri>/ftp</request_matched_uri>
    <request_process_time>0.0268</request_process_time>
    <request_result>success</request_result>
    <request_result_description></request_result_description>
    <request_result_id>601</request_result_id>
    <request_uri>[GET] ftp?app_id=1&amp;user_id=admin&amp;is_app_admin=TRUE</request_uri>
    <version>2.1.1.508:471dfedc1fa9</version>
  </header>
  <items>
    <item id="1">
      <userid>usera001</userid>
      <active>true</active>
      <modified>2008-06-24 09:35:23</modified>
    </item>
    <item id="2">
      <userid>testuser1001</userid>
      <active>true</active>
      <modified>0000-00-00 00:00:00</modified>
    </item>

    .......

Fixed 2.1.2.

[robert]

Send to peter forgacs for verification if it works fine now in wle.

[Frans]

Works now

<?xml version="1.0" encoding="UTF-8"?>
<response>
  <header>
    <item_count>1</item_count>
    <item_count_total>1</item_count_total>
    <item_offset>0</item_offset>
    <request_class>mediamosa_rest_call_ftp_user_list</request_class>
    <request_matched_method>GET</request_matched_method>
    <request_matched_uri>/ftp</request_matched_uri>
    <request_process_time>0.0275</request_process_time>
    <request_result>success</request_result>
    <request_result_description></request_result_description>
    <request_result_id>601</request_result_id>
    <request_uri>[GET] ftp?user_id=admin&amp;is_app_admin=TRUE</request_uri>
    <version>2.1.2.548:d1149b35afd3</version>
    <request_query_count>2</request_query_count>
  </header>
  <items>
    <item id="1">
      <userid>frans007</userid>
      <active>true</active>
      <modified>2009-12-16 16:05:21</modified>
    </item>
  </items>
</response>