Menu

#65 Error inserting database for migrating location

v2.3
open
nobody
None
1
2014-08-30
2014-08-26
Teplok
No

I have a problem while inserting the database for migrating inventory location in this version.

Thanks for the help anyway ^^

Here is the error log from the SQL:
SQL query: Documentation

INSERT INTO ospos_stock_locations( location_name ) (

SELECT location
FROM ospos_items
WHERE NOT
EXISTS (

SELECT location
FROM ospos_stock_locations
WHERE location_name = location
)
);

MySQL said: Documentation

1054 - Unknown column 'location' in 'field list'

Discussion

  • jekkos

    jekkos - 2014-08-26

    it seems that the location column is not present in your database. I assume that you created the tables from scratch as it will only be present in case you migrate from 2.2.2 to 2.3.

     
  • Teplok

    Teplok - 2014-08-26

    Hi Jekkos

    I used the database from 2.3 (database.sql) and I just assumed that if I want to use location migration I should install 2.3_migrate_location.sql
    Is it correct?
    Or I did wrong step ?

    Thank Jekkos

     
  • jekkos

    jekkos - 2014-08-27

    No this is not the case, maybe I should of put that more clearly in the filename. The script is only useful if you were using location fields on the item before to denote the stock location. In case you're doing a fresh install, it's not needed.

     
  • Teplok

    Teplok - 2014-08-27

    Hi jekkos

    Thank you for your reply...
    Just another question about the stock here.
    If I want to use separate location example warehouse and store.
    Is there any possibility to can move the stock from one location to another with this version?
    Thank you so much

     
  • jekkos

    jekkos - 2014-08-28

    yes there is an additional mode added in the receivings called requisitions. . here you can move quantities of a selected item from one stock to another.

     
  • Teplok

    Teplok - 2014-08-28

    Thank you so much jekkos.....

     
  • Teplok

    Teplok - 2014-08-29

    Hi jekkos...

    Sorry to bother you again with another question.
    In receiving page there are only two option : receive and return
    There is no requisitions like you mentioned above.
    Here is the screenshoot of mine :

     
  • jekkos

    jekkos - 2014-08-29

    ok you haven't configured an extra stock location yet. Mabye this isn't very clear from the docs, but in the config secion you need to add the names of your stock locations comma separated.

    Once there are multiple locations the requisition option will appear in the receivings page.

     
  • Teplok

    Teplok - 2014-08-30

    Owh...I get it jekkos.
    Thank you very much.

     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.