parse error - can anyone assist

[ellisj]

Hi,

 

can anyone help please I have installed the All products contribution and am having difficulties getting this working. The "View all Items" Link appears in the category box. I click on it and I get the following parse error

 

Parse error: parse error in /homepages/23/d85309629/htdocs/includes/header.php on line 65

 

I then clicked on the existing categories in the categories box to see if they worked, but I got the following error appear

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and c.parent_id = '33' and c.categories_id = cd.categories_id a

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

 

I found that the instructions with the contribution were not all that user friendly!!

 

I'll list them and tell you how I translated them

 

1. Add this to catalog/includes/filenames.php:

 

//BEGIN allprods modification

define('FILENAME_ALLPRODS', 'allprods.php');

//END allprods modification

 

Did this ok, no problems

 

2. Add this to catalog/includes/languages/english.php (and/or the other languages u use):

 

//BEGIN allprods modification

define('BOX_INFORMATION_ALLPRODS', 'View All Products');

//END allprods modification

 

 

Did this ok, no problems

 

3. Upload included language file to catalog/includes/languages/english/ (and/or the other languages u use).

 

 

Did this ok, no problems. I presume I should have added the english.php to the above?!!

 

4. Add this hidden link to where ever you like it i placed it in the catalog/includes/Header.php but you can also place it in footer or whereecer you want too :-)

 

What link was this?? I presumed that this was the link appearing in number 5, so I added this. The hidden link in 4 must be really well hidden as I couldn't locate it!

 

5. Add the link to one of your infoboxes. This file originally recommended that you add the link to information.php. You can do so simply by adding this to catalog/includes/boxes/informationm.php:

 

'<a href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' . BOX_INFORMATION_ALLPRODS . '</a><br>' .

 

I did the above ok

 

I preferred to add it to the bottom of the categories box, which seems to make a bit more sense:

 

find:

 

new infoBox($info_box_contents);

 

and replace with:

 

$info_box_contents[] = array('align' => 'center',

'text' => '<font size=-2><a href="' . tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL') . '">' . BOX_INFORMATION_ALLPRODS . '</a></font>');

 

new infoBox($info_box_contents);

 

I did not do this

 

 

6). Replace or compare the files included in catalog/includes/boxes

 

I did this

 

 

 

7). If you dont want to show Model, then just rename ' allprods_without_model.php' to 'allprods.php'

 

That should do it!!

 

Did not do this

 

I am going to have another look, at header.php, but I don't see why I dhould be getting a sql error too.

 

Can anyone help !!!??

 

Thanks

[millyramsey]

I got the same sql error because i uploaded the boxes/categories.php file included in the contribution by accedent. Then after I realized what I had done, I used compare and merge program to put a few changes into my original file instead, and that got rid of that error and the categories box is working ok now.

 

As for the header link- the link in step 4 doesn't exsist - at least I couldn't find it either. The link in step 5 is not for the header. It is for the information infobox (the one with "Shipping and Returns", "privacy" etc.... I'm not sure what the hidden link is either. If you take that link from the header that should help out with that error.