1 Topic by ssuch

  • ssuch
  • Member
  • Offline

Topic: Adding Orders to Order Table

First, this is a great piece of software that meets our lab ordering needs almost exactly.  Thanks for sharing it.

However, I have had a few small problem setting up. 

Problem 1.  Everything works ok, until it comes time to adding the order to the database.  After adding items to the order and going to the Finalize page, to fill in Quantity, Name, Grant, Comments, you press 'Print' to print the order.  No problem but when I subsequently go to View/Adjust Past Orders, the order never appears.  There doesn't seem to be a 'Complete Order' button - so just wondering how do orders get added to the 'Order" table?

Problem 2.  While setting up I reinstalled the 'Item' table probably when I didn't need to.  Anyway, this overwrote the configuration and reset all the fields which I then had to re-customize.  I think i've got all fields ok, except for the 'order_date' field.  How should I set this up.  (screen shot would do)

Many thanks in advance for any assistance you can provide

2 Reply by ssuch

  • ssuch
  • Member
  • Offline

Re: Adding Orders to Order Table

Ok, problems fixed.  I hadn't changed the allowed IP addresses in Authorization section of config.php.  Pretty basic really...

3 Reply by kml23956

  • kml23956
  • Member
  • Offline

Re: Adding Orders to Order Table

How did you get this to work?   I am still having the same issue.

4 Reply by testly

  • testly
  • Member
  • Offline

Re: Adding Orders to Order Table

Check file config.php for settings for these:

$all_order_history = "no"; //yes/no
$allowed1=array( // allowed for these ip addresses
"129.98.50.118",
"129.98.50.211",
"127.0.0.1",
"129.98.51.136"
);

If $all_order_history is 'no' then only orders from computers at the designated IP addresses are recorded in the order history.

5 Reply by kml23956

  • kml23956
  • Member
  • Offline

Re: Adding Orders to Order Table

Thanks for your help.

Yes.  The config file is correct.  This is what happens.  Maybe you have seen this before.  I select an item. I then  press the finalize button, input my name and press print.  The order appears.  Then nothing.  No new buttons.  There is some mention about allowing background printing on my browser but I can find no documentation in the Firefox help that mentions how to configure this.  Any Ideas?

6 Reply by testly

  • testly
  • Member
  • Offline

Re: Adding Orders to Order Table

One is supposed to just print out the order. The software does not print it out or email or send it for downloading or send it to a second party.

7 Reply by kml23956

  • kml23956
  • Member
  • Offline

Re: Adding Orders to Order Table

That's fine but the order is supposed to save when I hit the print button?   If so, it' is not anywhere in the database.

8 Reply by kml23956

  • kml23956
  • Member
  • Offline

Re: Adding Orders to Order Table

The following errors occur when inserting into the  'dadabik_item' table using the provided sql.  Could this cause an issue?
Script line: 4    Data truncated for column 'other_choices_field' at row 1
Script line: 6    Data truncated for column 'other_choices_field' at row 1
Script line: 8    Data truncated for column 'other_choices_field' at row 1
Script line: 10    Data truncated for column 'other_choices_field' at row 1

9 Reply by testly (edited by testly 2007-09-24 18:39:58)

  • testly
  • Member
  • Offline

Re: Adding Orders to Order Table

Your last message suggests that the MySQL is running in strict mode. Because of that perhaps the tables were not installed properly during setup (I also had issues with the provided .sql files when MySQL was in strict mode). The latest OrderSys download has the .sql file edited to address this issue -- http://bioinformatics.org/phplabware/sourceer/ordersys/laborder.sql -- use it to reinstall the tables.

If problem persists, I suggest you set up OrderSys afresh, and check if the issue recurs.