291 replies to this topic

[JonathanR]

Now this is where I will fall down, because I don't have a clue why that error has been caused. I had made such a mess of my osCommerce install and database that I started from scratch by creating a brand new empty database and running http://yourserver/catalog/install/ again, and assigning that database to my new osCommerce installation.

It was a pain, because it meant all the other code alterations and other Contributions I had installed needed reapplying, but I was happier having a clean install and working from that, and this Contribution was extremely important to how the site needs to look. It was also an excellent learning exercise! I was fortunate in that I am just testing all of this for the moment and getting it ready for the new Spring collection clothing range that our client wants to start selling next month.

All I can suggest is that you copy your current Catalog folder off your server as a back-up (ESSENTIAL!) before deleting it from your server, and then copy the default Catalog folder that comes with the osCommerce download onto your server. Then create a brand new blank mySQL database, and then by following the documentation.pdf installation guide, install a fresh osCommerce catalog, linking that to your newly created blank database.

Then run through the installation of the More Categories Boxes contribution. This will at least show you whether the problem exists in your current database, and then you can decided whether you want to proceed from that point on.

I am suggesting all of this in the absence of any other help - and only because it worked for me! Performing this on a completely default installation ensures you haven't altered any files that may otherwise affect how the contribution runs.

HTH - and good luck!

Jonathan

[Jennifer24]

Is there a solution to use this great contribution in different languages?

[hanler]

Hi,

This is a great contribution. Worked fine to install.

It would be great hough to be able to choose the sub categories instead. Any "easy" way around this?

Hans

[Webcraft]

Great contribution, easy to install and works well but . . .  I would really like all my category boxes to be drop-down lists. I know this question was asked before (twice) in this thread, but it was a year or so back so . . . has anyone done this, or does anyone have any idea how to do it?

- Webcraft

[TCDK]

TCDK, on Jan 15 2009, 12:29 PM, said:

I just installed this and can manage the categories in admin, but the new categories are not showing in the shop.

Im using RC2.

Anyone had this problem?

I still have this problem.

The admins section works fine, but there is no changes on the catalog section.

[alex.galpin]

Hi,

I have followed the instructions for adding this contribution, but I keep getting a sql error when importing the new table i.e. "#1366 - Incorrect integer value: '' for column 'configuration_id' at row 1"

Can anybody shed some light please?
Thanks

[Kevin360]

I really enjoy this contrib... thanks.   Two notes.  I had added additional contribs and noticed that I need to to make some slight changes to the code of this one coming in.  Nothing big... (I'm no coder.. I just barely know my way around PHP) but there would have been some extra semicolons and brackets if I had copied the code exactly.....  lets see.. in Step 4 - admin/includes/boxes/catalog.php

Replace the following lines:
								   '<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>');
  }

  
With this:
								   '<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a><br>' .
								   '<a href="' . tep_href_link(FILENAME_MORE_CATEGORIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_MORE_CATEGORIES . '</a>');
  }

the code was put in but instead of the last few characters  my current file showed an ending of

'</a><br>'

  so instead of inserting

 '</a>');  }

I inserted the above again... the semicolon and closing bracket were further down on the page...

Maybe this will help someone without any PHP knowledge.  

I have one questions though.  All my extra category boxes are not in the same style as my default categories box.  I like the style of the default box better... as it sticks to the theme of my site with smaller text and green text subcatagories.   Any ideas on how I can get them uniform??

[dgougoul]

I install the files attached in zip file added in "More Category Boxes with 4 Languages" but when i open my index page i take the following mesage:

1146 - Table 'oscommerce.table_categories_more_languages' doesn't exist

select * from categories_more,TABLE_CATEGORIES_MORE_LANGUAGES where enabled = 1 and languages_id = '1' and box_id_language= box_id

Have somebody any idea what is the problem?

[dgougoul]

I try to install the contribution but there are problems with it. The files that are in page http://addons.oscommerce.com/info/3327 are ok? I try all the versions in it but i always take messages with mistakes. I have installed the osCommerce Online Merchant v2.2 Release Candidate 2a under XAMPP.

Please help me

[kallike]

dgougoul, on May 20 2009, 12:04 AM, said:

I install the files attached in zip file added in "More Category Boxes with 4 Languages" but when i open my index page i take the following mesage:

1146 - Table 'oscommerce.table_categories_more_languages' doesn't exist

select * from categories_more,TABLE_CATEGORIES_MORE_LANGUAGES where enabled = 1 and languages_id = '1' and box_id_language= box_id

Have somebody any idea what is the problem?

first i got this also... then i fixet column left..

then i got this

Fatal Eror..... \includes\application_top.php on line 533

[stubbsy]

Hi there,

I've been using this contribution for ages on one site and I'm just setting up a new website and have made a copy of my original site on the same server. The problem I have though is when I try and create a new category box on admin/more_categories.php when I hit update I get a 1064 error.

I'm stumped as this is a duplicate of a site on which this is working and its on the same server??

The error is

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 '' at line 1

select * from categories_more where box_id = 

[TEP STOP]

Any ideas?

Thanks

Dave

[stubbsy]

Sorry sorted - just deleted all more_categories info from the database and reinstalled the whole thing.

[tpp]

Hi,

Does anyone know if it is possible to use this contrib with the "More Category Boxes" contrib?


Thanks,

Martin

[tpp]

tpp, on Jun 24 2009, 11:42 AM, said:

Hi,

Does anyone know if it is possible to use this contrib with the "More Category Boxes" contrib?


Thanks,

Martin

Apologies

Should be, is it possible to use this contrib with "dm_categories" contrib?

Thanks,

Martin.

[cigarjoe2003]

Hi,
Thanks for the super contribution.  I have it installed and working succesfully but I would like to have more than 10 category boxes.  I have added the additional info to the database and it does show on the shopping cart, however they are not showing in the admin side to allow me to add categories to the new boxes.  I am sure I am missing something easy, but I cannot figure it out.  Any help would be apprecisted.

Thanks,

[rocdy]

I have just tested the more category latest version in here http://www.oscommerce.com/community/contributions,3327
I find out that the look in browser Internet Browser are not good, but it's run well in ire fox browser. Any idea about that?

[rocdy]

rocdy, on Jul 21 2009, 06:42 AM, said:

I have just tested the more category latest version in here http://www.oscommerce.com/community/contributions,3327
I find out that the look in browser Internet Browser are not good, but it's run well in ire fox browser. Any idea about that?

Sorry, my problem was fixed. I just go to Admin-Configuration-Images and set Images Required to "false".
:-)

[Ackis]

dgougoul, on May 19 2009, 11:04 PM, said:

I install the files attached in zip file added in "More Category Boxes with 4 Languages" but when i open my index page i take the following mesage:

1146 - Table 'oscommerce.table_categories_more_languages' doesn't exist

select * from categories_more,TABLE_CATEGORIES_MORE_LANGUAGES where enabled = 1 and languages_id = '1' and box_id_language= box_id

Have somebody any idea what is the problem?

Hi,
Have you solved this problem?
I got them same  

Best regards
Jessica

[janssen-militaria]

Great contrib...but

>> BUG FIX <<
>> table 1 = table 11 <<

Noticed 1 (one!!) question here about the problem that table 11 gets the same entry as table 1 when updating the categories in the categorie boxes. I had the same problem and was updating database entries manually in the database (which is stupid). This problem only gets a real problem when you want to use all the 25 positions in the categoerie boxes. Because table 1 entry becomes the same as table 11 you will only be able to list 24 categories in a box. When you have the same problem and want to use all the 25 positions in a box change this:

in more_categories.php find (appr. line 73)

, category11_id = '" . $category1 .

change into

, category11_id = '" . $category11 .

I checked several (all?) contribution updates and it seems to be a problem in all files named more_categories.php (and in one contribution also the file named more_categories_org.php) there is NO problem in the contibution with 50 categories (more_categories-50.php). Perhaps someone can change this when adding a new full package for this contrib.

That's all...
Greetingz and happy programming,
Peter

[janssen-militaria]

Ackis, on Sep 9 2009, 08:04 AM, said:

Hi,
Have you solved this problem?
I got them same  

Best regards
Jessica

I did not use the "German" language pack. But perhaps I can help a bit.
TABLE_CATEGORIES_MORE_LANGUAGES is not part of the sql query in that package, so will not become a table in the database.
Perhaps you can add another line in database_tables.php? Something like:
define('TABLE_CATEGORIES_MORE_LANGUAGES', 'categories_more');
When this doesn't work there is an error in one of the php files in that package or lines are missing in the sql query in that package.

Peter