Jump to content
detsouvalas

PDF Catalog v.1.5

Recommended Posts

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 (forums.oscommerce.com)!                          */
/*                                                                            */
/* 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 by zakya

Share this post


Link to post
Share on other sites

Thanks to Anvip support, I finally got it working. Pour memoire:

  1. Make sure you have copied the folder font in the root directory of your catalog
  2. 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

Share this post


Link to post
Share on other sites

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 by diy

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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 by Irin

Share this post


Link to post
Share on other sites

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;
		}

//********************************************************************************
****************************************

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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:

Share this post


Link to post
Share on other sites
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:

 

  1. I cannot generate the catalog on the client side, I get this error
    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
    
    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


  2. 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

Share this post


Link to post
Share on other sites
Sorry I have two more problems:

 

  1. I cannot generate the catalog on the client side, I get this error
    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
    
    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


  2. 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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Great contribution! Is it possible to use this to generate individual product pdfs? rather than entire category or entire store pdfs?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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....

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×