1 Reply by boneill (edited by boneill 27-11-2009 15:59:03)

  • boneill
  • boneill
  • Member
  • Offline
  • From: Waterford, Ireland
  • Registered: 08-06-2009
  • Posts: 15

Re: Unable to Complete Request

Hi John,
Further to the bug fix for the earlier issue today I copied the updated sample model into the models folder. However some strange behaviour began to occur when I attempted to test it. I am fairly certain however that it is not caused by the sample model file. When I tried to post the form using the new model with or without a map showing the form would simply refresh but not save anything. Even if the fields were left blank the form would not throw any error messages. I transferred back in the old version of the sample file and the same bahaviour occurred. I decided that perhaps for some reason the indicia install had become corrupt so i reinstalled it and then encountered the trailing slash isssue in the helper_config file. I fixed this using your post regarding that issue on this forum. I am now in the process of setting up my taxon lists and test website again. I created a taxon group and then a taxon list. however when I click to edit the created taxon list to view the metadata it throw the unable to complete request page. I have turned on full debugging and the following is thrown when this behaviour occurs 

2009-11-27 15:33:11 +00:00 --- debug: PgSQL Database Driver Initialized
2009-11-27 15:33:11 +00:00 --- debug: Database Library initialized
2009-11-27 15:33:11 +00:00 --- debug: Disable magic_quotes_gpc! It is evil and deprecated: http://php.net/magic_quotes
2009-11-27 15:33:11 +00:00 --- debug: Global GET, POST and COOKIE data sanitized
2009-11-27 15:33:11 +00:00 --- debug: Session Cookie Driver Initialized
2009-11-27 15:33:11 +00:00 --- debug: Session Library initialized
2009-11-27 15:33:11 +00:00 --- debug: Auth Library loaded
2009-11-27 15:33:11 +00:00 --- debug: Auth Library loaded
2009-11-27 15:33:11 +00:00 --- debug: Session Library initialized
2009-11-27 15:33:11 +00:00 --- debug: Pagination Library initialized
2009-11-27 15:33:13 +00:00 --- debug: PgSQL Database Driver Initialized
2009-11-27 15:33:13 +00:00 --- debug: Database Library initialized
2009-11-27 15:33:13 +00:00 --- debug: Disable magic_quotes_gpc! It is evil and deprecated: http://php.net/magic_quotes
2009-11-27 15:33:13 +00:00 --- debug: Global GET, POST and COOKIE data sanitized
2009-11-27 15:33:13 +00:00 --- debug: Session Cookie Driver Initialized
2009-11-27 15:33:13 +00:00 --- debug: Session Library initialized
2009-11-27 15:33:13 +00:00 --- debug: Auth Library loaded
2009-11-27 15:33:13 +00:00 --- debug: Auth Library loaded
2009-11-27 15:33:13 +00:00 --- debug: Session Library initialized
2009-11-27 15:33:13 +00:00 --- error: Error occurred
2009-11-27 15:33:13 +00:00 --- error: 2
2009-11-27 15:33:13 +00:00 --- error: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  OFFSET must not be negative
2009-11-27 15:33:13 +00:00 --- error: In C:\xampp\htdocs\indicia\system\libraries\drivers\Database\Pgsql.php on line 86
2009-11-27 15:33:13 +00:00 --- error: Uncaught ErrorException: pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR:  OFFSET must not be negative in file C:/xampp/htdocs/indicia/system/libraries/drivers/Database/Pgsql.php on line 86

any ideas on whats happening? One more thing I download the version of indicia and the downloads page says that it is the latest version. However on the bottom of the administration pages the version shows as Version 0.1 - Release date 2009-01-15. I tried looking for a newer version in case the link was linking to the wrong file but I can't seem to find one. Could this be an older deprecated version.

Best Wishes,

Barry O' Neill, Data &  ICT Manager
National Biodiversity Data Centre, WIT West Campus, Carraiganore, Waterford, Ireland
+353 (0) 51-306247 | boneill@biodiversityireland.ie | http://www.biodiversityireland.ie

boneill's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Unable to Complete Request

Hi Barry

I'll have a look at the problem with the offset in a moment - I had this error a few months back so I'll try and remember what the solution was. Before I do that though, a couple of things. If you get an page which saves, but gives you no response, then what is happening is there is an error coming back but it is not attached to one of the controls, so has no where to display. If you look in your page code you will see something like 

  $response = data_entry_helper::forward_post_to('save', $submission);
  echo data_entry_helper::dump_errors($response);

You can change this to

  $response = data_entry_helper::forward_post_to('save', $submission);
  echo data_entry_helper::dump_errors($response, false);

Now, rather than place the errors "inline" beside the controls, Indicia will output an error block at the top for you, so you will see the error no matter what it is. I'd like to update the dump_errors method to handle the case where the error can't be attached to a control at some point so this isn't necessary - so I'll add this to the online issues list.

The other thing is the version number at the bottom of the home page will not be correct so don't worry about it. The reason is we have managed to get quite a nice auto-upgrade working in an incremental fashion, but have not had the time to split this properly out into separate version upgrades. So the version number at the bottom will stay at 0.1 until we manage to get some time to work on this. I guess it's just a case of picking off the highest priority stuff first.

Cheers

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Unable to Complete Request

Hi Barry

I meant to check - when you re-installed, how did you clean out the database? Did you delete it and start again? From memory, when I had this problem before it was data related which is why I ask.

Thanks

John van Breda
Biodiverse IT

johnvanbreda's Website