From: emdeex <em...@gm...> - 2008-08-07 03:47:38
|
actually more like, UPDATE `stockmaster` SET `appendfile` = '0' WHERE `stockid` = ''whatever" On Thu, Aug 7, 2008 at 1:46 PM, emdeex <em...@gm...> wrote: > UPDATE `stockmaster` SET `appendfile` = '0' > > On Wed, Aug 6, 2008 at 11:34 PM, sunshine33777 <tro...@gm...> wrote: >> >> I changed the default to "0", but have to change that in about 3000 products. >> Is there a quick way in phpmyadmin to change everything in "appendfile" from >> "none" to "0"? >> >> I have not tested this result yet. >> >> >> >> >> >> emdeex wrote: >>> >>> See where your database field "appendfile" has the default set as >>> "none", the default should be "0". >>> >>> Check that the items your are invoicing, in stockmaster, have the >>> correct default setting for that field. >>> >>> This should be set in the upgrade scripts, I'll look into it. Let me >>> know if this fixes your problem. >>> >>> regards, >>> Murray >>> >>> On Wed, Jul 30, 2008 at 11:27 PM, sunshine33777 <tro...@gm...> >>> wrote: >>>> >>>> 1) I did a WinMerge comparison of the PrintCustTransPortrait.php and >>>> PrintCustTrans.php >>>> >>>> I was expecting identical code except for the physical layout. Wrong. >>>> There is extra code for this and for that in each of the 2 files. >>>> >>>> >>>> 2) The stockmaster table does have this: >>>> >>>> appendfile varchar(40) latin1_swedish_ci No >>>> none >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> emdeex wrote: >>>>> >>>>> I'm using Landscape invoices, and 3.09, and they print fine. So there >>>>> is something with the configuration that is causing your problem. >>>>> >>>>> Can you check your stockmaster table, do you have the field... >>>>> >>>>> appendfile varchar(40) latin1_swedish_ci Null:no Default:0 >>>>> >>>>> >>>>> >>>>> On Wed, Jul 30, 2008 at 1:27 PM, sunshine33777 <tro...@gm...> >>>>> wrote: >>>>>> >>>>>> No, no, no... I put the landscape file PrintCustTrans.php in there as >>>>>> it >>>>>> came from 3.0.9 and it's not working at all. Same error. >>>>>> >>>>>> Now, when I switch to portrait, the invoice prints, so I'm 99% certain >>>>>> there's a bug in the PrintCustTrans.php in the 3.0.9 version. >>>>>> >>>>>> I just don't have time at the moment to find it. I've driven my wife >>>>>> insane >>>>>> about it tonight I'm sure and she wants to get to sleep. (Sucks having >>>>>> the >>>>>> office next to the bedroom.) >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> sunshine33777 wrote: >>>>>>> >>>>>>> I think I know what's up now. >>>>>>> >>>>>>> I just used my old invoice pdf that I created because the layout was >>>>>>> exactly as I had it customized for my liking. >>>>>>> >>>>>>> I changed to the "portrait" setting in the setup and it prints. So I >>>>>>> assume there's a few mistakes in my landscape template. >>>>>>> >>>>>>> So I'm going to re-upload the landscape document as it came from the >>>>>>> weberp folder and apply my changes to it one line at a time. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> sunshine33777 wrote: >>>>>>>> >>>>>>>> Still have a problem, but did these things to no success: >>>>>>>> >>>>>>>> I originally had pdf_append in the root weberp directory, as >>>>>>>> suggested >>>>>>>> in >>>>>>>> other posts for help. >>>>>>>> >>>>>>>> Then I did a search with InfoRapid and it would suggest in stocks.php >>>>>>>> that pdf_append needs to be in the company directory as such >>>>>>>> weberp/companies/thiscompany/pdf_append >>>>>>>> >>>>>>>> I moved the pdf_append directory from the weberp root into the >>>>>>>> directory >>>>>>>> as above, but still the same errors. >>>>>>>> >>>>>>>> It's going to take some time to get the PHP logs from my host. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> sunshine33777 wrote: >>>>>>>>> >>>>>>>>> I just upgraded from 3.0.7 to 3.0.9 and ran both upgrade scripts to >>>>>>>>> get >>>>>>>>> to 3.0.9. >>>>>>>>> >>>>>>>>> Now, when I try to print a PDF invoice I get the following message: >>>>>>>>> >>>>>>>>> FPDF error: Unable to create output file: invoice.pdf >>>>>>>>> >>>>>>>>> My browser address is partially as: >>>>>>>>> >>>>>>>>> https://www.SECURED.com/WEBERPDIRECTORY/PrintCustTrans.php?FromTransNo=1364&InvOrCredit=Invoice&PrintPDF=True >>>>>>>>> >>>>>>>>> What am I doing wrong? >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/FPDF-error%3A-Unable-to-create-output-file%3A-invoice.pdf-tp18722829p18725505.html >>>>>> Sent from the web-erp-developers mailing list archive at Nabble.com. >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------- >>>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>>>> challenge >>>>>> Build the coolest Linux based applications with Moblin SDK & win great >>>>>> prizes >>>>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>>>> world >>>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>>> _______________________________________________ >>>>>> Web-erp-developers mailing list >>>>>> Web...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>>>> >>>>> >>>>> ------------------------------------------------------------------------- >>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>>> challenge >>>>> Build the coolest Linux based applications with Moblin SDK & win great >>>>> prizes >>>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>>> world >>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>> _______________________________________________ >>>>> Web-erp-developers mailing list >>>>> Web...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>>> >>>>> >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/FPDF-error%3A-Unable-to-create-output-file%3A-invoice.pdf-tp18722829p18733187.html >>>> Sent from the web-erp-developers mailing list archive at Nabble.com. >>>> >>>> >>>> ------------------------------------------------------------------------- >>>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>>> challenge >>>> Build the coolest Linux based applications with Moblin SDK & win great >>>> prizes >>>> Grand prize is a trip for two to an Open Source event anywhere in the >>>> world >>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>> _______________________________________________ >>>> Web-erp-developers mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>>> >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the >>> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >>> >> >> -- >> View this message in context: http://www.nabble.com/FPDF-error%3A-Unable-to-create-output-file%3A-invoice.pdf-tp18722829p18851310.html >> Sent from the web-erp-developers mailing list archive at Nabble.com. >> >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > |