anvip Posted May 19, 2008 Share Posted May 19, 2008 please send me your pdf_catalogue_info.php file email Quote Link to comment Share on other sites More sharing options...
zakya Posted May 19, 2008 Share Posted May 19, 2008 (edited) please send me your pdf_catalogue_info.php file email Dear Anvip, I have sent you an email with the following file: <?php /******************************************************************************/ /* PDF Catalogs v.2.0.1 for osCommerce v.2.2 MS2 */ /* */ /* by Infobroker (info@cooleshops.de), April 2006 */ /* by Antonios THROUVALAS (antonios@throuvalas.net), April 2004 */ /* by Mitch O`Brian (mitchobrian.de), juli2004 2004 */ /* by Nicolas Hilly (n.hilly@laposte.net), August 2004 */ /* by Christophe Buchi (chris@butch.ch), September 2004 */ /* by Ryan Kononoff (ryankononoff@shaw.ca), October 2004 */ /* */ /* Based on PDF Catalogs v.1.4 by gurvan.riou@laposte.net */ /* */ /* Uses FPDF (http://www.fpdf.org), Version 1.52, by Olivier PLATHEY */ /* modified by Infobroker */ /* */ /* Credit goes also to: */ /* - Yamasoft (http://www.yamasoft.com/php-gif.zip) for their GIF class, */ /* - Jerome FENAL (jerome.fenal@logicacmg.com) for introducing GIF Support */ /* in the FPDF Class, */ /* - The osC forums members (www.oscommerce.com/forums)! */ /* */ /* Please donate to the osCommerce Core Team! */ /* Freeware, You may use, modify and redistribute this software as you wish! */ /******************************************************************************/ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PDF_CATALOGUE); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PDF_CATALOGUE)); // Directory where the generated PDF files will be stored! // If you mofify the name of this directory, please modify accordingly the // catalog/admin/pdf_config.php file!! // Don't forget to change the permissions of this directory to 755! define('DIR_WS_PDF_CATALOGS','catalogues/'); // Filename to use as a base for the name of the generated PDF files. // If you mofify the name of this directory, please modify accordingly the // For Categories catalog // catalog/admin/pdf_config.php file!! define('PDF_FILENAME_CATEGORIES','categories'); // For catalog define('PDF_FILENAME','catalog'); ?> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <!-- body_text //--> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <!--Gesamtkatalog begin--> <!-- Show the Intro File <tr> <td class="main"><br><?//php include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PDF_DEFINE_INTRO); ?><br></td> </tr> --> <!-- Show the Description in the pdf_catalogue_info.php --> <tr> <td class="main" align="left"><?php echo TEXT_PDF_DESCRIPTION; ?></td> </tr> <tr> <td> </td> </tr> <tr> <td class="main" align="center"><?php $file = DIR_WS_PDF_CATALOGS . PDF_FILENAME . "_" . $languages_id . ".pdf"; $sizecatalog = filesize($file)/pow(2,20); $formatted = sprintf("%0.2f MB", $sizecatalog); echo '<img width="16" height="16" src="images/adobe_pdf.gif" align="middle"> '; echo '<a href="' . $file . '" target="_blank"><b>' . TEXT_PDF_FILE .'</b></a> (' . $formatted . ')'; ?> <p><br> </td> </tr> <!--Gesamtkatalog end--> <tr> <td class="main" align="left"><?php echo TEXT_PDF_DESCRIPTION2; ?></td> </tr> <tr> <td class="main" align="center"> <?php $file = DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES; //******************************************************************************** **************************************** if(!isset($GO_ON)){ //Neuerung v 1.6 by Michael Palmer //Anzeigen der Kategorien und auswahl 黚er checkbox mit speicherung in einem Array //躡ergeben des Array磗 黚er Standardvariable da die Session durch behinderung der Admin-Session //nicht benutzt werden konnte!!!!! echo '<form action="" method="post">'; $i = 0; echo '<table><tr><td class="main">'; $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { echo '<input name="KATEGORIE_SELECTED2['.$i.']" type="checkbox" value="'. $categories['categories_id'] .'">'. $categories['categories_name'] . $KATEGORIE_SELECTED2[$i].'<br>'; $i++; } echo '<input name="no_of_files" type="radio" value="one_file" checked="checked" />'. PDF_TXT_ONE_FILE.'<input name="no_of_files" type="radio" value="more_files" />'.PDF_TXT_ONE_FILE_PER_CATEGORY; echo '<input type="hidden" name="GO_ON" value="1">'; echo '<br><input type="hidden" name="ANZAHL" value="'.$i.'">'; echo '<input type="submit" name="submit" value="' . IMAGE_BUTTON_CONTINUE .'">'; echo '</form>'; echo '</td></tr></table>'; } if(isset($GO_ON) && isset($KATEGORIE_SELECTED2)){ //Neuerung v 1.6 by Michael Palmer //Best鋞igung der ausgew鋒lten Kategorien und abschicken des Formulars zur erzeugung der PDF echo tep_draw_form('pdf_quantity', tep_href_link(FILENAME_PDF_KATALOG, tep_get_all_get_params(array('action')) . '')); //echo "<form action=". FILENAME_PDF_KATALOG ." method=post>"; echo PDF_TXT_AUSWAHL ; $iCOUNT = 0; for ($i = 0; $i < $ANZAHL; $i++) { if ($KATEGORIE_SELECTED2[$i] != "") { $KATEGORIE_SELECTED[$iCOUNT] = $KATEGORIE_SELECTED2[$i]; $iCOUNT++; $categories_query = tep_db_query("select cd.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where cd.categories_id= '$KATEGORIE_SELECTED2[$i]' and cd.language_id='" . (int)$languages_id ."' order by cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { echo "<b>".$categories['categories_name']."</b><br>"; break; } } } echo PDF_TXT_KLICK; //Array in Normale Variable Speichern damit die Daten mit einer iFrame weiter gegeben werden k鰊nen!!!! for ($i = 0; $i < $iCOUNT; $i++) { if (!isset($KAT_SELECTED_ARRAY)) { $KAT_SELECTED_ARRAY = $KATEGORIE_SELECTED[$i]; } else { $KAT_SELECTED_ARRAY = $KAT_SELECTED_ARRAY."|".$KATEGORIE_SELECTED[$i]; } } //躡ergeben der Anzahl, PDF_ACTION und Array Variable echo '<input type="hidden" name="file" value="'.$file.'"><input type="hidden" name="KAT_SELECTED_ARRAY" value="'.$KAT_SELECTED_ARRAY.'"><input type="hidden" name="PDF_ACTION" value="1">'; echo '<br><br><input type="hidden" name="no_of_files" value="'.$no_of_files.'"><input type="hidden" name="ANZAHL_KATEGORIEN" value="'.$iCOUNT.'">'; echo '<input type="submit" name="submit" value="' . PDF_TXT_GENERATE .'">'; echo "</form>"; } elseif(isset($GO_ON)) { echo '<font color="#FF0000">'.PDF_TXT_ERROR1 .'<a href="java script:history.back()" TARGET="_self">'.PDF_TXT_ERROR2 ."</a>".PDF_TXT_ERROR3; } //******************************************************************************** **************************************** ?> </td> </tr> <tr> <td class="main" align="center"><?php echo TEXT_PDF_DOWNLOAD; ?></td> </tr> <tr> <td class="main" align="center"><?php echo '<a href="http://www.adobe.com/products/acrobat/readstep2.html" target="_blank">'; echo tep_image(DIR_WS_IMAGES . 'getacro.gif'); ?></a></td> </tr> <tr> <td class="main" align="center"><?php echo TEXT_PDF_END; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Edited May 19, 2008 by zakya Quote Link to comment Share on other sites More sharing options...
zakya Posted May 24, 2008 Share Posted May 24, 2008 Thanks to Anvip support, I finally got it working. Pour memoire: Make sure you have copied the folder font in the root directory of your catalog Check in pdf_catalogue_info2 around lines 43~45 and 54~56 ,the font you are using and assure you have the corresponding metric file in the font folder. Otherwise change to standard font (courier, helvetica, times, etc): echo '<center>==>Â <a href="'.$file_PDF.' all selected.pdf" target="_blank"><font size="2" face="verdana"><b>Download Catalog</b></font></a>Â <==</center>'; echo '<font color="#FFFFFF" class="mini">' Â 3. Around line 862 and line 883 $pdf->Output(DIR_WS_PDF_CATALOGS . PDF_FILENAME_CATEGORIES . "_" . $languages[$i]['id'] . " all selected.pdf",false); change to (no space before and after the dot DIR_WS_PDF_CATALOGS . PDF_FIL becomes DIR_WS_PDF_CATALOGS.PDF_FIL) $pdf->Output(DIR_WS_PDF_CATALOGS.PDF_FILENAME_CATEGORIES."_".$languages[$i]['id']." all selected.pdf",false); Hope this helps and thanks Anvip. Zakya Quote Link to comment Share on other sites More sharing options...
diy Posted May 27, 2008 Share Posted May 27, 2008 (edited) Sorry for the silly question but file MySQL 5 Fix.txt says  If you are using MySQL 5 you will need to change line [b]609 [/b]to: ......................................................... The only change is the addition of brackets after the FROM clause: (" . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd)   Line 609 of which file ??????? Edited May 27, 2008 by diy Quote Link to comment Share on other sites More sharing options...
zakya Posted May 28, 2008 Share Posted May 28, 2008 Sorry for the silly question but file MySQL 5 Fix.txt says If you are using MySQL 5 you will need to change line [b]609 [/b]to: ......................................................... The only change is the addition of brackets after the FROM clause: (" . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd)   Line 609 of which file ??????? I always believe that there is no silly question...but silly answers ( e.g look at all the files ). Anyway the needed change is in the file pdf_catalogue_info2.php. Instead of around line 609 ,mine is at line 706. Also if you don't get it to work at first shot, try to look at the errors (invisible if you have white background) just under the links to download the generate catalogs. This has helped me a lot to track what was going wrong. Quote Link to comment Share on other sites More sharing options...
Irin Posted May 28, 2008 Share Posted May 28, 2008 Hello, Â I have a problem with generating a category catalog. When I select to generate catalog for a specific category and click Continue button, then Generate PDF catalog button, the pdf_download_katalog.php is hanging. The status bar is moving but the catalog is never generated, it's always an empty frame and no link to Download. It takes more than 20 mins for the browser to load the page in the frame but only displays "Internet Explorer cannot display the webpage". Â Any help will be appreciated. Thanks. Quote Link to comment Share on other sites More sharing options...
zakya Posted May 28, 2008 Share Posted May 28, 2008 Hello, I have a problem with generating a category catalog. When I select to generate catalog for a specific category and click Continue button, then Generate PDF catalog button, the pdf_download_katalog.php is hanging. The status bar is moving but the catalog is never generated, it's always an empty frame and no link to Download. It takes more than 20 mins for the browser to load the page in the frame but only displays "Internet Explorer cannot display the webpage".  Any help will be appreciated. Thanks. Hi, Look at my posts above. I had encountered the same situation among others. It is usually a font problem. make sure you have copied the font folder in your root catalog and have specify the correct path in pdf_config.php Quote Link to comment Share on other sites More sharing options...
Irin Posted May 28, 2008 Share Posted May 28, 2008 (edited) Hi,Look at my posts above. I had encountered the same situation among others. It is usually a font problem. make sure you have copied the font folder in your root catalog and have specify the correct path in pdf_config.php Hi zakya, Â Thanks for your reply. I looked at your post above and made all the changes to pdf_catalogue_info2. I also checked for the font folder and it appears in both, admin and catalog sides. I also tried to change the verdana font <font size="2" face="verdana"><b>Download Catalog</b></font> to courier in pdf_catalogue_info2 as I have the corresponding courier.php font file in the font folder. In admin/pdf_config.php I have : // Directory where the Font files are stored define('FPDF_FONTPATH','font/'); Â Unfortunately, it didn't change anything in my store. It still doesn't show the link to the catalog. All I have is: Â Please have patience, until the status bar is loaded!!The link to Download the pdf file will be indicated between the arrows. And then below is just an empty frame and the status bar says: "Waiting for http://shop.com/pdf_download_katalog.php?l...age=en..." but the bar is not moving, it's hanging. Â Also, in my admin side, "who's online" shows the following link: http://shop.com/pdf_catalogue_info2.php?PD...EN=1&KAT_SE. It looks like that it's missing some definitions... Edited May 28, 2008 by Irin Quote Link to comment Share on other sites More sharing options...
marcus76 Posted June 4, 2008 Share Posted June 4, 2008 hi,  I installed this contrib, works in admin but when i go to the front side (create single categories), the page loads and displays the list of categories, i can select them but when i click 'Continue' the page simply refreshes reloading 'pdf_catalogue_info.php' - can someone please advise what i need to check , i feel i'm so close to getting this working...the following is an snippet of the 'pdf_catalogue.info.php' where i believe the form is submitted:  I very much appreciate any pointers with this, it's driving me crazy.. :blink:  Regards  Marcus  //******************************************************************************** **************************************** if(!isset($GO_ON)){ //Neuerung v 1.6 by Michael Palmer //Anzeigen der Kategorien und auswahl über checkbox mit speicherung in einem Array //Übergeben des Array´s über Standardvariable da die Session durch behinderung der Admin-Session //nicht benutzt werden konnte!!!!! echo '<form action="" method="post">'; $i = 0; echo '<table><tr><td class="main">'; $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { echo '<input name="KATEGORIE_SELECTED2['.$i.']" type="checkbox" value="'. $categories['categories_id'] .'">'. $categories['categories_name'] . $KATEGORIE_SELECTED2[$i].'<br>'; $i++; } echo '<input name="no_of_files" type="radio" value="one_file" checked="checked" />'. PDF_TXT_ONE_FILE.'<input name="no_of_files" type="radio" value="more_files" />'.PDF_TXT_ONE_FILE_PER_CATEGORY; echo '<input type="hidden" name="GO_ON" value="1">'; echo '<br><input type="hidden" name="ANZAHL" value="'.$i.'">'; echo '<input type="submit" name="submit" value="' . IMAGE_BUTTON_CONTINUE .'">'; echo '</form>'; echo '</td></tr></table>'; } if(isset($GO_ON) && isset($KATEGORIE_SELECTED2)){ //Neuerung v 1.6 by Michael Palmer //Bestätigung der ausgewählten Kategorien und abschicken des Formulars zur erzeugung der PDF echo tep_draw_form('pdf_quantity', tep_href_link(FILENAME_PDF_KATALOG, tep_get_all_get_params(array('action')) . '')); //echo "<form action=". FILENAME_PDF_KATALOG ." method=post>"; echo PDF_TXT_AUSWAHL ; $iCOUNT = 0; for ($i = 0; $i < $ANZAHL; $i++) { if ($KATEGORIE_SELECTED2[$i] != "") { $KATEGORIE_SELECTED[$iCOUNT] = $KATEGORIE_SELECTED2[$i]; $iCOUNT++; $categories_query = tep_db_query("select cd.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where cd.categories_id= '$KATEGORIE_SELECTED2[$i]' and cd.language_id='" . (int)$languages_id ."' order by cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { echo "<b>".$categories['categories_name']."</b><br>"; break; } } } echo PDF_TXT_KLICK; //Array in Normale Variable Speichern damit die Daten mit einer iFrame weiter gegeben werden können!!!! for ($i = 0; $i < $iCOUNT; $i++) { if (!isset($KAT_SELECTED_ARRAY)) { $KAT_SELECTED_ARRAY = $KATEGORIE_SELECTED[$i]; } else { $KAT_SELECTED_ARRAY = $KAT_SELECTED_ARRAY."|".$KATEGORIE_SELECTED[$i]; } } //Übergeben der Anzahl, PDF_ACTION und Array Variable echo '<input type="hidden" name="file" value="'.$file.'"><input type="hidden" name="KAT_SELECTED_ARRAY" value="'.$KAT_SELECTED_ARRAY.'"><input type="hidden" name="PDF_ACTION" value="1">'; echo '<br><br><input type="hidden" name="no_of_files" value="'.$no_of_files.'"><input type="hidden" name="ANZAHL_KATEGORIEN" value="'.$iCOUNT.'">'; echo '<input type="submit" name="submit" value="' . PDF_TXT_GENERATE .'">'; echo "</form>"; } elseif(isset($GO_ON)) { echo '<font color="#FF0000">'.PDF_TXT_ERROR1 .'<a href="java script:history.back()" TARGET="_self">'.PDF_TXT_ERROR2 ."</a>".PDF_TXT_ERROR3; } //******************************************************************************** **************************************** Quote Link to comment Share on other sites More sharing options...
zakya Posted June 4, 2008 Share Posted June 4, 2008 Hi zakya, Thanks for your reply. I looked at your post above and made all the changes to pdf_catalogue_info2. I also checked for the font folder and it appears in both, admin and catalog sides. I also tried to change the verdana font <font size="2" face="verdana"><b>Download Catalog</b></font> to courier in pdf_catalogue_info2 as I have the corresponding courier.php font file in the font folder. In admin/pdf_config.php I have : // Directory where the Font files are stored define('FPDF_FONTPATH','font/');  Unfortunately, it didn't change anything in my store. It still doesn't show the link to the catalog. All I have is:   And then below is just an empty frame and the status bar says: "Waiting for http://shop.com/pdf_download_katalog.php?l...age=en..." but the bar is not moving, it's hanging.  Also, in my admin side, "who's online" shows the following link: http://shop.com/pdf_catalogue_info2.php?PD...EN=1&KAT_SE. It looks like that it's missing some definitions...  Hi, Select the text inside the "empty frame", you will see what is the error encountered. Using the inspect element of firebug(mozilla firework), this has helped me tract down the errors. Quote Link to comment Share on other sites More sharing options...
Irin Posted June 4, 2008 Share Posted June 4, 2008 Hi,Select the text inside the "empty frame", you will see what is the error encountered. Using the inspect element of firebug(mozilla firework), this has helped me tract down the errors. Hi zakya, Â There is no text to select inside the frame, it's empty. If I view page source from IE7, it shows only <iframe src="pdf_catalogue_info2.php?PDF_ACTION=1&ANZAHL_KATEGORIEN=1&KAT_SELECTED_ARRAY=19&file_PDF=catalogues/categories_1&no_of_files=more_files" frameborder="0" frame="0" width="400" align="absmiddle"></iframe>. I'm also not getting any error messages and there is no way for me to track the problem. Â Thanks. Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 6, 2008 Share Posted June 6, 2008 I get this error when trying to creating the catalog:  Warning: fopen(/home/src/public_html/shop/catalogues/catalog_1.pdf) [function.fopen]: failed to open stream: No such file or directory in /home/src/public_html/shop/admin/pdf_fpdf.php on line 1687 FPDF error: Unable to create output file: /home/src/public_html/shop/catalogues/catalog_1.pdf  can anyone help? I wonder if it's a problem writing to the catalogues file?  Thanks Quote Link to comment Share on other sites More sharing options...
zakya Posted June 6, 2008 Share Posted June 6, 2008 I get this error when trying to creating the catalog: Warning: fopen(/home/src/public_html/shop/catalogues/catalog_1.pdf) [function.fopen]: failed to open stream: No such file or directory in /home/src/public_html/shop/admin/pdf_fpdf.php on line 1687 FPDF error: Unable to create output file: /home/src/public_html/shop/catalogues/catalog_1.pdf  can anyone help? I wonder if it's a problem writing to the catalogues file?  Thanks Hi PJ try setting the permission of the catalogues folder to 777 Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 6, 2008 Share Posted June 6, 2008 Hi PJ try setting the permission of the catalogues folder to 777 Hi I tried that - I had it at 775 first of all then changed to 777 but get the same problem :huh: - any other thoughts?  Thanks  Lotti Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 7, 2008 Share Posted June 7, 2008 Hi I tried that - I had it at 775 first of all then changed to 777 but get the same problem :huh: - any other thoughts? Thanks  Lotti  It's OK it's sorted, for some reason the catalogues folder was named catalogues/ instead of catalogues\ my hosting company fixed it for me. Thanks for your reply and assistance :rolleyes: Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 8, 2008 Share Posted June 8, 2008 It's OK it's sorted, for some reason the catalogues folder was named catalogues/ instead of catalogues\ my hosting company fixed it for me. Thanks for your reply and assistance :rolleyes: Sorry I have two more problems:  I cannot generate the catalog on the client side, I get this errorWarning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Warning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Warning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Fatal error: main() [function.require]: Failed opening required 'includes/languages/english/pdf_download_katalog.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/src/public_html/shop/pdf_download_katalog.php on line 28 I cannot write a PDF introduction - I have this message at the top of the screen:ERROR_FILE_NOT_WRITEABLE  A more minor thing, anyone know how to get the £ to the left of the price and how to avoid the space syntax -  showing in the description?  Sorry to have so many questions.  Lotti Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 8, 2008 Share Posted June 8, 2008 Sorry I have two more problems: I cannot generate the catalog on the client side, I get this errorWarning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Warning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Warning: main(includes/languages/english/pdf_download_katalog.php) [function.main]: failed to open stream: No such file or directory in /home/src/public_html/shop/pdf_download_katalog.php on line 28 Fatal error: main() [function.require]: Failed opening required 'includes/languages/english/pdf_download_katalog.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/src/public_html/shop/pdf_download_katalog.php on line 28 I cannot write a PDF introduction - I have this message at the top of the screen:ERROR_FILE_NOT_WRITEABLE  A more minor thing, anyone know how to get the £ to the left of the price and how to avoid the space syntax -  showing in the description?  Sorry to have so many questions.  Lotti  I found a 3 year old post with the solution to the  , I'll post the solutions provided incase anyone else wants to know!:  in pdf_catalogue.php  line 659:  Replace:  $description=rtrim(strip_tags($print_catalog_array[$j]['description']));  with  $description=rtrim(strip_tags(str_replace(' ', '', $print_catalog_array[$j]['description'])));  You can very easily move the £ sign to the left of the price in the pdf_config.php.  If someone can help me with generating the catalog on the client side, I'd really appreciate it!  Thanks  Lotti Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 8, 2008 Share Posted June 8, 2008 I found a 3 year old post with the solution to the  , I'll post the solutions provided incase anyone else wants to know!: in pdf_catalogue.php  line 659:  Replace:  $description=rtrim(strip_tags($print_catalog_array[$j]['description']));  with  $description=rtrim(strip_tags(str_replace(' ', '', $print_catalog_array[$j]['description'])));  You can very easily move the £ sign to the left of the price in the pdf_config.php.  If someone can help me with generating the catalog on the client side, I'd really appreciate it!  Thanks  Lotti   I now get to the Download generated file page - but it has the wording "Prenos kataloga" and I don't know what that means to translate into English - If I click on this I get file not found.  Any ideas?  Thanks Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted June 8, 2008 Share Posted June 8, 2008 I now get to the Download generated file page - but it has the wording "Prenos kataloga" and I don't know what that means to translate into English - If I click on this I get file not found. Any ideas?  Thanks  OK, I have everything working now apart from these two things:  1) When generating a PDF for a specific category I get all categories 2) I still am unable to define the intro from the admin screen  Thanks Quote Link to comment Share on other sites More sharing options...
Mike T Posted June 10, 2008 Share Posted June 10, 2008 Great contribution! Is it possible to use this to generate individual product pdfs? rather than entire category or entire store pdfs? Quote Link to comment Share on other sites More sharing options...
skhuu Posted June 11, 2008 Share Posted June 11, 2008 Hi Guys  have read through, but I couldnt fnd the solution to my problem. have nstalled all correct for the Rc2a, it gives me this error;  1054 - Unknown column 'p.products_id' in 'on clause'  select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id order by p.products_date_added DESC, pd.products_name  I did the Mysql5 fx and it didnt help either, still get this problem.  Is there anyone who've found the solution, help please. Quote Link to comment Share on other sites More sharing options...
Mike T Posted June 12, 2008 Share Posted June 12, 2008 I'm having limited success. I've been over my code & it looks ok.  I am able to generate (some) catalogs from the client side. But still none from the admin side.  I'm not sure why it would generate some catalogs & not others -  http://www.kickerfilms.com/pdf_catalogue_info.php  I still see the Warning: filesize(): Stat failed for catalogues/catalog_1.pdf (errno=2 - No such file or directory) in...  because I haven't been able to generate the catalog from admin.  Any help.. helps.. thanks. Quote Link to comment Share on other sites More sharing options...
papillon Posted June 19, 2008 Share Posted June 19, 2008 Hi Guys have read through, but I couldnt fnd the solution to my problem. have nstalled all correct for the Rc2a, it gives me this error;  1054 - Unknown column 'p.products_id' in 'on clause'  select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id order by p.products_date_added DESC, pd.products_name  I did the Mysql5 fx and it didnt help either, still get this problem.  Is there anyone who've found the solution, help please.  i think you need to change the line in Mysql5 fix in catalog/admin/pdf_catalogue.php AND in catalog/pdf_catalogue_info2.php Quote Link to comment Share on other sites More sharing options...
skhuu Posted June 20, 2008 Share Posted June 20, 2008 i think you need to change the line in Mysql5 fix in catalog/admin/pdf_catalogue.php AND in catalog/pdf_catalogue_info2.php  Hi, I have already done the fix on both files. I rechecked and all is okay. But it ust cant save the pdf files. Quote Link to comment Share on other sites More sharing options...
dorothai Posted June 23, 2008 Share Posted June 23, 2008 If you have problems with create catalog under customer, please replace pdf_catalogue_info2.php with this code: Â I have the same problem: php 5.2.2 and mysql 5 on server all works flawless in the admin panel the front end however displays the categories checkboxes with the radio buttons and the continue submit button. When clicking this button page refreshed without any result. I assume the part with 'You have selected "category name" and the generate pdf button are supposed to show up after having posted the first form (where we select the categories we want to have as pdf files). Conclusion: Values sent are lost or not saved in session. Â So installing this file didn't help - I have installed pretty much all versions which are downloadable/available (yes also MySql fix)- none of them worked, all show the same effect - no errors - no problems - error_log has no entry on server either. Cookies are enabled for the domain. Any idea? I lost already 3 days with this contribution. Â Any help is very much appreciated.... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.