• Registered: 2008-10-27
  • Posts: 8

Topic: shipment_edit.php issue

PHP Version:    5.1.6
MySql Version:    5.0.27
Qcodo Version:    0.3.32 (Qcodo Beta 3)

Fresh and nice installation. After install and respective changes in configuration files faced minor installation problems which are solved for now.

My problem is - I can't ship anything, i.e. Companies, Inventory, Contacts, etc. are created, but when I hit Save on shipment_edit - nothing happens. No error message, no records in error logs on server side, no entry in shipment table of database created, just nothing!
Rest of soft works like charm - I can receive goods, etc. so far I didn't find anything else what wouldn't work!

Yeas, I received goods first prior to try to ship them. Yeas, I have enough stock so I must be able to do a shipment.

After reading http://www.tracmor.com/forum/topic/240/ … php-error/ I discovered that I can't create Default Company in Admin - Shipping/Receiving. So I manually ran " UPDATE admin_setting SET value = 1 WHERE short_description = 'company_id'; "
So " SELECT * FROM admin_setting" produces:
     setting_id          short_description         value
              1    company_id    2
              2    image_upload_prefix    
              3    fedex_gateway_URI    NULL
              4    company_logo    empty.gif
              5    packing_list_terms    NULL
              6    packing_list_logo    NULL
              7    min_asset_code    
              8    fedex_account_id    NULL
              9    autodetect_tracking_numbers    NULL
              10    custom_shipment_numbers    1
              11    custom_receipt_numbers    1
              12    receive_to_last_location    NULL
              13    portable_pin_required    1
              14    user_limit    NULL

I must to admit that so far I'm going desperate cose can't get this marvelous piece of soft working ;-(
Can anybody provide a help?

  • Registered: 2008-10-27
  • Posts: 8

Re: shipment_edit.php issue

BTW You can take a look on http://varis.lv/tracmor/ P:admin U:admin to see how it works mad

  • Registered: 2008-10-27
  • Posts: 8

Re: shipment_edit.php issue

Well... it looks that my problem is related to structure of database... I did my best while installing Tracmor, but...

Anyhow - it would be VERY-VERY helpfull if someone mail me an SQL with correct and working structure of database, cose I'm really desperate trying to get it working in a proper way.

Please mail me at shadowvoice@inbox.lv

  • From: San Francisco, California, USA
  • Registered: 2008-05-13
  • Posts: 347

Re: shipment_edit.php issue

Hi there,

Can I ask why you think your problem is related to the database structure? The downloads available on the tracmor website include the necessary SQL scrips in the data_model directory. Run the create script first, then the data script, per the install instructions.

Also note that the system requirements on our download page specify you must have at least PHP 5.2, and it appears as though you are running PHP 5.1.6.

I suspect that upgrading to PHP 5.2 will solve your issue.

Justin Sinclair

Got Inventory? Get Tracmor.

jsinclair's Website

  • Registered: 2008-10-27
  • Posts: 8

Re: shipment_edit.php issue

Sure... I ran two first SQL's one to create tables, second for basic data.
When tried to run db-update faced mistakes like - "table already exist", doubling entrances, etc..... so i skipped it for beginning.
Without db_update SQL I faced issue to unable enter default company and do any shipment.
Than I decided to mess with db_update SQL which comes together with installation. Had to cut it into pieces to get most of it performerd as if I run it in one go - querry is stopped as soon as wrong conditions met - namely it tries to create tables, which arleady exist...
When I did most of db_update SQL - it became better, now I can enter default company, system reacts to if I try to ship more items than I have on specific place, etc, so I face serious improvemets ;-)

Therefore I assume that I did changes in DB structure which looks to be leading to normal functionality and would like to be sure that structure I'm using for now is correct.

  • From: San Francisco, California, USA
  • Registered: 2008-05-13
  • Posts: 347

Re: shipment_edit.php issue

Please be sure to follow the installation instructions. The db-update script is only for upgrading from 0.1.0 to 0.2.0. If this was a new installation, you do not need to run the db-update script.

I recommend upgrading to PHP 5.2 if you want to use tracmor, as the Shipping module is known to not work with PHP 5.1.6.

Justin Sinclair

Got Inventory? Get Tracmor.

jsinclair's Website

  • Registered: 2008-10-27
  • Posts: 8

Re: shipment_edit.php issue

Sorry, I was wrong. Really as soon as I install Tracmore on PHP 5.2.12 - everything worked like charm.:P

OK, I also had that error after installation:
E_NOTICE

Source File:   /homepages/13/d192451571/htdocs/crr/inventory/includes/qcodo/_core/qform/QFormBase.class.php     Line:   158
which can be easily overcame by clearing browser cache.


So You're absolutely right about PHP version required.

But still faced same problem to be unable to set default company - had to do it manually via MySQL cool Hope You fix this issue in next reliese... roll

  • Registered: 2011-07-27
  • Posts: 1

Re: shipment_edit.php issue

I hate to bring up an old thread, but this is almost exactly my issue.

PHP 5.3.6 (cli) (built: Apr 25 2011 10:45:29)
MySQL Server version: 5.0.77
OS: CentOS 5.6

None of my changes that I select in the Shipment page work at all. It is as if the "Save" button does not work.
Everything else in the software works except saving the Shipment settings.

How can I fix the saving issue?

Edit:
I can't ship packages either. I am using a FedEx Developer Test Account/Meter right now and I get "cURL ERROR: 3: malformed
unable to process express_ship." However if I choose Ground, no errors or anything. But no tracking number or page change.

If I try to save a shipment, "MySqli Error: Cannot add or update a child row: a foreign key constraint fails (`tracmor/fedex_shipment`, CONSTRAINT `fedex_shipment_ibfk_2` FOREIGN KEY (`shipment_id`) REFERENCES `shipment` (`shipment_id`) ON DELETE CASCADE ON UPDATE NO ACTION)"
Line 3794:                                $this->objFedexShipment->Save();

Can these errors be fixed?

Last edited by RLindsay (2011-07-27 22:07:35)

  • From: San Francisco, California, USA
  • Registered: 2008-05-13
  • Posts: 347

Re: shipment_edit.php issue

Note that next year FedEx will be retiring the Ship Manager Direct API that Tracmor uses for FedEx integration. We will be posting an announcement here in the forums shortly to notify users that FedEx integration will no longer be supported in Tracmor.

To troubleshoot your problem, have you tried scheduling a shipment not using the FedEx integration (choose Other for courier)? Post back here with any errors you receive.

Justin Sinclair

Got Inventory? Get Tracmor.

jsinclair's Website