Added columns to StockEntry Table...

113 views
Skip to first unread message

partke...@gmail.com

unread,
Apr 5, 2018, 12:36:46 PM4/5/18
to PartKeepr Users
Hello Everyone,

I'm in need of a little assistance or advice.

I added two columns to the StockEntry table. Data is entered via a python script that fetches it from an entirely different schema (check out http://jam-py.com/ if you're looking for a slick and easy front-end for mysql apps). The extra two columns are necessary for this to work.

Sadly, PartKeepr now throws up a warning every time I log in:

"Your database schema is not up-to-date! Please re-run setup immediately!"

The data is all still and the StockEntry table is fine. The information simply doesn't show up in in PartKeepr's web gui... any thoughts or suggestions?

Thanks,

- Corey

Felicia Hummel

unread,
Apr 5, 2018, 12:45:01 PM4/5/18
to partkee...@googlegroups.com
> The data is all still and the StockEntry table is fine. The
> information simply doesn't show up in in PartKeepr's web gui... any
> thoughts or suggestions?

You need to add the fields including their data type to
src/PartKeepr/PartBundle/Entity/Part.php.

A simple declaration without getters and setters should work. Make sure
you re-run setup or re-generate your environment to ensure that the
data type specified in PHP also matches the field type in the database.

For more info, please read the doctrine documentation regarding
mappings [1].

All the best
Felicia

[1] http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/re
ference/basic-mapping.html#property-mapping

partke...@gmail.com

unread,
Apr 6, 2018, 12:55:37 PM4/6/18
to PartKeepr Users

Thanks Felicia! I'll let you know how it goes. 

partke...@gmail.com

unread,
Apr 10, 2018, 12:16:21 PM4/10/18
to PartKeepr Users
After some tinkering and enough error messages to give a migraine, I just made a new schema with a dedicated table for the two aforementioned columns. If you can do this it is much easier.
Reply all
Reply to author
Forward
0 new messages