1 Topic by member (edited by member 01/27/2010 01:13:27 am)

  • Registered: 01/27/2010
  • Posts: 8

Topic: Browser timing out on most reports

I can find the reports (Excel or PDF) in \company\0\pdf_files, although they are temporary. 

The browser gets an error message and won't show the PDF or Excel reports in the program.  Sometimes they do work (not often), but then they don't, even on the same report.

I am trying to work strictly with inventory.  I am trying to enter the info manually into the database to start. I have loaded data into several inventory and purchase tables, maybe I missed something.  The reports appear to be complete, if I open them from the file, so I think I am doing it correctly.

I have tried messing with the debug, but it spits out jiberish.  I can't understand it.   My company file is not set to read only. Is there anything simple I can change?


Thank You

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

I tried to find something in the forum that would help me resolve this.  I found a similar post, the problem was that the report would not print.  I am just wanting to see the report, I haven't worked up to printing yet.
I tried looking at the advice given by Joe in that post:



Check the Display Setup (or Preferences) that the printing support is set to Browser Printing Support (It might have been set to a printer by mistake). These printers will only work with network printers.
The Browser Printing Support uses a PDF reader for presenting the reports. They can be printed from here.

/Joe



I have the Browser Printing Support option selected (that is how it was set) in the display preferences and I still cannot see the report in the browser.  If I were to try to print, it would be a network printer, but the other options don't really make any sense to me.  I tried central, just to see and that did not stop the warning.png image from showing up.

Does anyone know what the problem is?

Thanks

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Browser timing out on most reports

Have you tried to look into the error_log?
Even if the debug reports jibberish, it might tell us something, or?

/Joe

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Browser timing out on most reports

Try switch js off in your browser and run the report while go_debug=1 or 0 in your config.php.
Hope it will show you exact error message.
Janusz

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

Itronics,

That worked.  I turned off allow scripts and the report showed up. 

I can't consistantly get an error in my error log.  I was planning to reinstall and try again, because I had erased the error log.  When trying to check it for Joe I could not get it to show anything in the error log.

I get some english in place of the report when the pdf debug is on, but nothing at all in the error log.

%PDF-1.3
3 0 obj
<</Type /Page
/Parent 1 0 R
/MediaBox [0 0 612.00 792.00]
/Resources 2 0 R
/Contents 4 0 R>>
endobj
4 0 obj
<</Filter /FlateDecode /Length 2608>>
stream
this is where the jiberish I mentioned shows up (see below)
endstream
endobj
5 0 obj


What I referred to as jiberish was a lot of text like this øT´#“õ¯o±Ý¤›l=@°h‹ÅÄ£u´™




The go debug was not showing in the error log, but after trying several times with it on and off, I got this:
[02-Feb-2010 16:07:54] 0:admin:prn_redirect.php:91: require() [<a href='function.require'>function.require</a>]: Filename cannot be empty


I think I can live with disabling my scripting, unless you have further instructions for me.

Thank You Both!

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Browser timing out on most reports

Hi,
Maybe your folder /company/X/pdf_files,  where X is your company number, is write protected?

/Joe

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

I am using wampserver on my computer.  All of the folders have a blue shade in the read only, but unmarking and changing all folders and subfolders does not change this the folder it stays marked blue when you check again.  I think it is a windows thing.  I am using Vista, lucky me.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Browser timing out on most reports

Please update FA sources to just released 2.2.5 version (it has a couple of error handling fixes), and check whether you have no errors displayon System Diagnostics page.

Janusz

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

Ok, I was planning on reinstalling anyway.  Thanks for letting me know.

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

Maybe I had a bad install the first time.  I started over and was able to get the import items to work (which was not the case the first time).
I changed permissions on the company file to not be read only for all files and folders.  I still have my scripting on and everything seems to work.

I would suggest that the import items instructions mention the following:

Go to access setup in the  setup tab.  You have to put a check mark by the module name for the system administrator to give permission. Log out and back in again. Then the module will work properly. I put in a test item first and exported, because it was difficult to understand what fields I was really supposed to be trying to import.  I guess I am saying to dumb down the instructions.

Thanks for all of your help.  I hope I can figure out the report generator module.  I am getting ready to reinstall.  It seems way over my head.
I do run a heavily modified (by me) Zen Cart website, so maybe I'll figure it out.


Thank You

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 326

Re: Browser timing out on most reports

I would love to work with you and see if the osCommerce Import module I wrote will work with ZC or maybe a configuration flag to modify the SQL needed to extract the data

Tom
(ex osCommerce Core Developer)

tom's Website

12 Reply by member (edited by member 02/04/2010 05:58:02 pm)

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

Tom,

Thank you for the offer to work with me.  I am afraid that would be you doing all of the work, because I don't really know anything.  I am pretty much just adding info into the database of FA until I get what I need for what I am attempting to accomplish.

I am actually trying to use FA to keep records of when I buy inventory and then divide each unit of 12 between a website and an offline store (as needed).

I have used openoffice spreadsheet in the past to do this, but it is really messy.  I am starting to understand how mysql databases works, using phpmyadmin.  I have looked at so many inventory programs and accounting programs and FA seems like it would probably be possible to tweak the reports to get what I want.

I looked at the openoffice database and I cannot begin to understand it.  I tried to create tables in a mysql database myself but I could not begin to write all of the sql statements to get what I want.

I basically need to start with x amount of product.  Then I need the ability to track and subtract the defective items removed from inventory and the amount that I allocate to the ZC . 

Then with the product that I have left I need to inventory every few weeks manually.  My offline store is selling sunglasses at fairs and festivals.  I don't have a way to know which style and color sells, except to know what I started with and what I still have left.  Then after counting, I will know roughly how many of a style I sold.  I hope to do the math and then itsert the differences as one big sale.

Therefore my goal is to know how many went to ZC, but more importantly I want to be able to say, for example I had 48 pair on the stand, now I have 25, so I sold 23 pair in three weeks time.  Therefore 23 pc divided by 3= 7.6 (8) times 8 weeks =64 minus 25 on hand  = 39 so I need to order 3 or 4 dozen of that style to hold me for two months.

I don't even know if I can do all of this, but I am hard headed.

I am not really interested in anything but the inventory portions, because I have created a bookkeeping system that works well for me using spreadsheets.  I have a section that pulls all of the totals together. It emulates an end of year tax return.  That way I always know how much I need to pay in estimated taxes.

Maybe I will figure it out.  Again, I appreciate the offer, but I wouldn't want you to have to rewrite the program for me.

Thanks

  • tom
  • Senior Member
  • Offline
  • From: USA, FL, Tampa
  • Registered: 03/24/2009
  • Posts: 326

Re: Browser timing out on most reports

Well I am sure FA can do it.
In FA you will have 2 locations, 1- Online, 2 - Offline and you can transfer stock as needed between locations.

If you can handle having an item go out of stock online after the online order was made, then you could have ZC always take orders and if you ran out of something contact the customer.

Then you can still keep one location (Your physical inventory) which could keep it simpler.

I believe FA has reports for forecasting, I am not sure, I have not looked, maybe someone else can address that.

All I know is the osC (ZC basis) database

tom

tom's Website

14 Reply by member (edited by member 02/05/2010 05:16:13 pm)

  • Registered: 01/27/2010
  • Posts: 8

Re: Browser timing out on most reports

Thanks for writing, I can count the monthly web sales on my hands, so not much pressure there.  Restocking is not much of an issue.  If I ever figure out how to get more people to my website I won't have share the inventory.  Paying for Adwords is almost useless, I won't even get started on that.  I appreciate the encouragement.