Blank screen adding new stock item

View: New views
17 Messages — Rating Filter:   Alert me  

Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Nathan,

perp svn 3644

I already found other posts that describe it, but I don't found an answer.
When I try to save a new stock item, refresh to a blank screen and no errors on log.
I have suppliers, price lists and already added stock items on past.
If someone that has passed for it know the solution, it will be welcome!

Thanks and regards,

Re: Blank screen adding new stock item

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 25-Jun-09, at 1:11 PM, PCS-Lists wrote:

> I already found other posts that describe it, but I don't found an  
> answer.
> When I try to save a new stock item, refresh to a blank screen and  
> no errors
> on log.
> I have suppliers, price lists and already added stock items on past.
> If someone that has passed for it know the solution, it will be  
> welcome!

Can you edit previous stock items?
Any other things you've checked?
I can confirm that it is not happening in our site, so it sounds like  
something in the data or setup.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>Can you edit previous stock items?
no, I can't.

>Any other things you've checked?
I have permissions to do all on inventory.

In witch file can I debug this? Have you some idea?

Re: Blank screen adding new stock item

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 30-Jun-09, at 9:51 AM, PCS-Lists wrote:

> In witch file can I debug this? Have you some idea?

Check your apache log for error messages.
It's usually found in /var/log/apache2/error.log

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>Check your apache log for error messages.
>It's usually found in /var/log/apache2/error.log

Thanks for information, but I already know this log and it not register nothing related to our difficult.
Is there a file where I can use _debug_array() or similar to extract some information?
In addition stock categories, what data I need to have pre-registered to add a stock item?

thanks.

Re: Blank screen adding new stock item

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 6-Jul-09, at 12:02 PM, PCS-Lists wrote:

>
>> Check your apache log for error messages.
>> It's usually found in /var/log/apache2/error.log
>
> Thanks for information, but I already know this log and it not  
> register
> nothing related to our difficult.
> Is there a file where I can use _debug_array() or similar to extract  
> some
> information?

You can try going through /perp_inventory/inc/
class.ui_perp_stock.inc.php, function edit().
Check that when saving, it does save.  Does the new item go into the DB?
Is it returning the new stock_id?

> In addition stock categories, what data I need to have pre-
> registered to add
> a stock item?

That's the only thing I can think of.  Since you mentioned earlier  
that you have previously added stock items, you should have everything  
you need.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Parent Message unknown Re: Add new components to BOM

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 7-Jul-09, at 10:09 AM, Klaus Buecher wrote:

> how do I enter parts into a bill of materials?
> I tried the demo. I don't know what to enter into the field under  
> add new component: neither stock code nor component name leads to  
> the BOM saving the part.

Expected:
Type the stock code or part of the name to search.  Select your  
desired component from the list.
Enter quantity, and optionally select the work center and time.
Press 'Add'.  Part should show up in the tree below.

Press save, BOM should be written.

In the demo, I confirm that some new parts (washers) are not saved.  
Some (airhandle) are.
Looks like you found a bug.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Add new components to BOM

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 7-Jul-09, at 10:19 AM, Nathan Gray wrote:

> In the demo, I confirm that some new parts (washers) are not saved.
> Some (airhandle) are.
> Looks like you found a bug.

Someone deleted all the units of measure.  Items with a missing UOM  
were not displayed.
This is no longer possible (SVN r3690).  Unfortunately, all the UOMs  
in demo are still gone...

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Add new components to BOM

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Nathan,
perp svn 3720, updated few minutes ago.
Inventory add stock items still refreshing to a blank screen.
I have tree stock categories on admin>>inventory>>Stock categories, but the table perp_stock_categories don't shows this entries. It's empty. I'm don't able to erase my categories from GW. I click in delete and nothing happens. The table perp_stock_categories has this fields:
        category_id
        on_hand_gl_account
        work_in_progress_gl_account
        shrinkage_gl_account
        adjustment_gl_account
It's correct? What can I do?

Re: Add new components to BOM

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 9-Jul-09, at 12:03 PM, PCS-Lists wrote:

>
> Nathan,
> perp svn 3720, updated few minutes ago.
> Inventory add stock items still refreshing to a blank screen.
> I have tree stock categories on admin>>inventory>>Stock categories,  
> but the
> table perp_stock_categories don't shows this entries. It's empty.  
> I'm don't
> able to erase my categories from GW. I click in delete and nothing  
> happens.
> The table perp_stock_categories has this fields:
>        category_id
> on_hand_gl_account
> work_in_progress_gl_account
> shrinkage_gl_account
> adjustment_gl_account
> It's correct? What can I do?

The table structure looks fine, but this is not correct.  It should  
not be empty.

You should also check your units of measure.  If they're missing, it  
can cause problems.

Some steps to take:
1.  Have you done the updates in /setup ?  If you don't do those,  
things will stop working.
2.  Figure out where your stock categories went.
3.  You can try to recreate your stock categories by editing + saving  
the stock categories you have.  Maybe they'll write and fix things.
4.  Try this SQL:
DELETE FROM egw_categories WHERE cat_appname = 'perp_inventory'
You'll have to re-create your stock categories, and edit every one of  
your existing stock items to correctly set the stock category again.

Ω.  Restore your last known good database backup.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Add new components to BOM

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>The table structure looks fine, but this is not correct.  It should  
>not be empty.
>You should also check your units of measure.  If they're missing, it  
>can cause problems.
>Some steps to take:
>...

Nathan,

I followed the steps that you suggested and I saw that  the problem really is in my database. I created another installation of GW 1.6.002 and pERP svn 3826 with no data. I made the tests with inventory and it worked fine, but when I restored my dababase, it doesn't worked again, with the same blank screen, but now the apache log showed this:
[Wed Jul 29 14:25:42 2009] [error] [client 127.0.0.1] PHP Warning:  require_once(/usr/share/egroupware/workflow/inc/class.workflow_instance.inc.php) [function.require-once]: failed to open stream: No such fileor directory in /usr/share/egroupware/perp_manufacturing/inc/class.bo_perp_workflow.inc.php on line 15, referer: http://127.0.0.1/egroupware/index.php?menuaction=perp_inventory.ui_perp_stock.stock_edit&new=1&popup=
[Wed Jul 29 14:25:42 2009] [error] [client 127.0.0.1] PHP Fatal error:  require_once() [function.require]: Failed opening required '/usr/share/egroupware/workflow/inc/class.workflow_instance.inc.php' (include_path='/usr/share/egroupware/egw-pear:.:/usr/share/pear') in /usr/share/egroupware/perp_manufacturing/inc/class.bo_perp_workflow.inc.php on line 15, referer: http://127.0.0.1/egroupware/index.php?menuaction=perp_inventory.ui_perp_stock.stock_edit&new=1&popup=


It not made sense for me.
Then I uninstall and reinstall perp_inventory on setup (for clean all inventory tables) and after this, recreated a stock category, an inventory location and tried to create a stock item. Not worked, blank screen and same above error!
My DB has many current informations of all the GW apps and perp ledger, ap, ar, and old information in inventory.
Do you have idea about what tables can be related to this problem?
My idea is erase the entries of this tables and test. Is there a better way?

Thanks

Re: Add new components to BOM

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 29-Jul-09, at 11:41 AM, PCS-Lists wrote:

> ...
> require_once(/usr/share/egroupware/workflow/inc/
> class.workflow_instance.inc.php)

Are you using workflow?
This error is coming from the manufacturing application.
Are you trying to use manufacturing at all?
If not, take away permission.  If you are, finish your setup before  
you try to add any stock items.

http://www.projecterp.org/mediawiki/index.php/Site_Installation#Minimum_Data

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>Are you using workflow?
>This error is coming from the manufacturing application.
>Are you trying to use manufacturing at all?
>If not, take away permission.  If you are, finish your setup before  
>you try to add any stock items.


I have all the minimum data required on above link. I don't have workflow installed and I'm not using manufacturing. Forgiveness, troubles of language. What did you mean with "If not, take away permission" ? Should I uninstall it on setup, disable it on admin. What should I do? I removed the manufacturing access permissions for me (group Admins) on admin>>user groups, but it not made any difference for the problem.

Also, can you explain me what tables are related to inventory beyond the tables of perp_inventory and what are the relations between this tables, primary keys, foreign keys...for that I try to understand what data is causing the problems with my base.

Re: Blank screen adding new stock item

by constant :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

.
Try installing workflow.


PCS-Lists wrote:
>Are you using workflow?
>This error is coming from the manufacturing application.
>Are you trying to use manufacturing at all?
>If not, take away permission.  If you are, finish your setup before  
>you try to add any stock items.


I have all the minimum data required on above link. I don't have workflow installed and I'm not using manufacturing. Forgiveness, troubles of language. What did you mean with "If not, take away permission" ? Should I uninstall it on setup, disable it on admin. What should I do? I removed the manufacturing access permissions for me (group Admins) on admin>>user groups, but it not made any difference for the problem.

Also, can you explain me what tables are related to inventory beyond the tables of perp_inventory and what are the relations between this tables, primary keys, foreign keys...for that I try to understand what data is causing the problems with my base.

Re: Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I installed workflow and perp_inventory is now working!

Thank you so much!

constant wrote:
.
Try installing workflow.

Re: Blank screen adding new stock item

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 3-Aug-09, at 8:49 AM, PCS-Lists wrote:

>
> I installed workflow and perp_inventory is now working!
>
> Thank you so much!
>
>
> constant wrote:
>>
>> .
>> Try installing workflow.



It looks like the DB you were loading had workflow installed at some  
point.  I've added an extra check, hopefully to prevent this weird  
situation.

Database structure:
http://www.projecterp.org/mediawiki/index.php/Developer_Documentation#Database_Structure
A little old, but the changes have been mostly additive.


Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: Blank screen adding new stock item

by PCS-Lists :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Many thanks Nathan and Constant!!!


Nathan Gray wrote:
On 3-Aug-09, at 8:49 AM, PCS-Lists wrote:

>
> I installed workflow and perp_inventory is now working!
>
> Thank you so much!
>
>
> constant wrote:
>>
>> .
>> Try installing workflow.



It looks like the DB you were loading had workflow installed at some  
point.  I've added an extra check, hopefully to prevent this weird  
situation.

Database structure:
http://www.projecterp.org/mediawiki/index.php/Developer_Documentation#Database_Structure
A little old, but the changes have been mostly additive.


Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers