Well,
Thanks kymation,
Just let you know that there was a conflict with "Access with Level Account" Module so I had to disabled for categories box in admin .
I am checking other functions and let you know if there is any problem .
Latest News: (loading..)
22
714 replies to this topic
#22
Posted 11 October 2009 - 03:11 PM
kymation, on 08 October 2009 - 05:01 PM, said:
1. I've never seen this, and none of the other people who are running this have reported it. I think you have an error in your modifications, or you have some other Contribution that's interfering. If it's the same as #2, see my answer below.
2. I assume that English is not your first language. Here's a translation for you: "Use Search-Engine Safe URLs (still in development) means (This is broken, don't use it). It wouldn't do anything useful even if it did work, so just leave it turned off.
3. You're looking in the wrong place. Read section 4.2.3 in the manual.
Regards
Jim
2. I assume that English is not your first language. Here's a translation for you: "Use Search-Engine Safe URLs (still in development) means (This is broken, don't use it). It wouldn't do anything useful even if it did work, so just leave it turned off.
3. You're looking in the wrong place. Read section 4.2.3 in the manual.
Regards
Jim
Dear Jim,
I found the problem
It relates to language ID !
As i delete English at first now I have english as ID 5 and another language as language ID 4
So the problem is in that case.
when I changed the English language ID to 1 the problem solved,
It seems this module should not be sensitive to language ID especually when english dont have ID = 1!
check it and let me know.
Just change the english language ID in languages table other than 1 and create some tables and check the situations.
Thanks.
#23 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 11 October 2009 - 05:56 PM
I don't have time to look through the entire codebase for a mystery error. If you can tell me exactly what the error is and how to reproduce it, I'll take a look.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#24
Posted 13 October 2009 - 07:14 AM
I think this issue is solved
Why language ID = 1 !
line 1888
echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu ('fid', tep_get_specification_filters ($specs_path, $languages_id = 1), $filter_id, 'onclick="this.form.submit();"');
change it to ==>
echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu ('fid', tep_get_specification_filters ($specs_path, $languages_id), $filter_id, 'onclick="this.form.submit();"');
Now seems working well in admin,
Other parts are checking too.
Why language ID = 1 !
line 1888
echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu ('fid', tep_get_specification_filters ($specs_path, $languages_id = 1), $filter_id, 'onclick="this.form.submit();"');
change it to ==>
echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu ('fid', tep_get_specification_filters ($specs_path, $languages_id), $filter_id, 'onclick="this.form.submit();"');
Now seems working well in admin,
Other parts are checking too.
#25 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 13 October 2009 - 04:43 PM
Thanks for the bug report. I've updated the master copy with your fix.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#26
Posted 11 November 2009 - 07:27 PM
Sorry about the repost, but I realized I posted this on the "old" message thread....
I installed this contribution last night. At first, my catalog did not display correctly, but then we found a stray </table> in the stylesheet (likely my own error).
When I logged into my admin side however, nothing shows up except the configuration box. Clicking the links inside the configuration box does nothing. The last item listed in the configuration box is products specifications, but again all links do notyhing.
I have all of my files backed up and I used "Beyond Compare 3" to see if I did not "copy" over this code properly. I did not notice anything right away other than two other contributions I have installed which are Easy Populate and More Category Boxes.
Thoughts?
Doug
I installed this contribution last night. At first, my catalog did not display correctly, but then we found a stray </table> in the stylesheet (likely my own error).
When I logged into my admin side however, nothing shows up except the configuration box. Clicking the links inside the configuration box does nothing. The last item listed in the configuration box is products specifications, but again all links do notyhing.
I have all of my files backed up and I used "Beyond Compare 3" to see if I did not "copy" over this code properly. I did not notice anything right away other than two other contributions I have installed which are Easy Populate and More Category Boxes.
Thoughts?
Doug
Doug
#27 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 11 November 2009 - 07:53 PM
This code doesn't make any changes to the Configuration box. That's all automatically generated from the database anyway. It sounds like you may have messed up your database. Check the configuration_group and configuration tables for errors or conflicts.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#28
Posted 12 November 2009 - 12:30 AM
kymation, on 11 November 2009 - 07:53 PM, said:
This code doesn't make any changes to the Configuration box. That's all automatically generated from the database anyway. It sounds like you may have messed up your database. Check the configuration_group and configuration tables for errors or conflicts.
Regards
Jim
Regards
Jim
I pulled up both tables in myphpadmin and under maintenance checked both tables and they check out OK. My script guy did a "view source" from the Admin panel and he says it looks like the script stops short for some reason.
Here is what I see:
[img]http://pokerchipzone.com/admin_panel.jpg[/img]
Below is the code from the "view source". Note I changed my domain name, admin folder name, and OSCADMINID number in case that could be used against me...
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html dir="ltr" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>osCommerce Online Merchant Administration Tool</title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();"> <!-- header //--> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><img src="images/oscommerce.gif" border="0" alt="osCommerce" title=" osCommerce " width="204" height="50"></td> <td align="right"><a href="http://www.oscommerce.com" target="_blank"><img src="images/header_support.gif" border="0" alt="Support Site" title=" Support Site " width="50" height="50"></a> <a href="my_address/./"><img src="images/header_checkout.gif" border="0" alt="Online Catalog" title=" Online Catalog " width="53" height="50"></a> <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting"><img src="images/header_administration.gif" border="0" alt="Administration" title=" Administration " width="50" height="50"></a> </td> </tr> <tr class="headerBar"> <td class="headerBarContent"> <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting" class="headerLink">Administration</a></td> <td class="headerBarContent" align="right"><a href="http://www.oscommerce.com" class="headerLink">Support Site</a> | <a href="my_address/./" class="headerLink">Online Catalog</a> | <a href="my_address/./my_admin_folder/index.php?osCAdminID=a_number_im_not_posting" class="headerLink">Administration</a> </td> </tr> </table><!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="125" valign="top"><table border="0" width="125" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <!-- configuration //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="menuBoxHeading" onmouseover="this.style.cursor='hand'" onclick="document.location.href='my_address/./my_admin_folder/configuration.php?gID=1&selected_box=configuration&osCAdminID=a_number_im_not_posting'"> <a href="my_address/./my_admin_folder/configuration.php?gID=1&selected_box=configuration&osCAdminID=a_number_im_not_posting" class="menuBoxHeadingLink">Configuration</a> </td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="menuBoxContent"><a href="http://my_address/./my_admin_folder/configuration.php?gID=1&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">My Store</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=2&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Minimum Values</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=3&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Maximum Values</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=4&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Images</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=5&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Customer Details</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=7&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Shipping/Packaging</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=8&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Product Listing</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=9&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Stock</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=10&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Logging</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=11&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Cache</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=12&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">E-Mail Options</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=13&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Download</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=14&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">GZip Compression</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=15&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Sessions</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=8675309&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">More Categories</a><br><a href="my_address/./my_admin_folder/configuration.php?gID=1610&osCAdminID=a_number_im_not_posting" class="menuBoxContentLink">Products Specifications</a><br></td> </tr> </table> </td> </tr> <!-- configuration_eof //-->
Doug
#29 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 12 November 2009 - 12:50 AM
Judging from that output, the configuration table is working. The next box is the Catalog box, so it's probably an error in the admin/includes/boxes/catalog.php or the /admin/categories.php file.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#30
Posted 12 November 2009 - 11:25 PM
Jim,
Thanks for the heads up. The error was definitely where you said it would be... From my script guy...
"In the admin/includes/boxes/catalog.php file, when the array statement for the product specifications link was added, the " ); " from the more_catagories statement should have been replaced with " <br>' . " The " ); " in the more_catagories statement was throwing the error. Once I replaced it with the " <br>' . " the admin was working."
Thanks again..
Doug
Thanks for the heads up. The error was definitely where you said it would be... From my script guy...
"In the admin/includes/boxes/catalog.php file, when the array statement for the product specifications link was added, the " ); " from the more_catagories statement should have been replaced with " <br>' . " The " ); " in the more_catagories statement was throwing the error. Once I replaced it with the " <br>' . " the admin was working."
Thanks again..
Doug
Doug
#31
Posted 14 November 2009 - 12:05 AM
Jim -
I sat down last night to start going through everything, and while my Admin panel loaded and I could access the Products Specifications in the configure tab, I could not access it in the Catalog tab. I also cannot access Categories/Products in the Catalog tab. On both, the file stops short at the same line...
For products specifications, the address bar reads /myadminfoldername/products_specifications.php?........ and it ends at:
And the Categories / Products loads the same way and ends at the same line:
Any ideas on where I might have gone wrong? Im not able to locate anything in "beyond compare" and I looked for any files I may have missed when I FTP'd the new files via FileZilla. The catalog side works great by the way. Those that I let "peak" at the site really like the look of your add.
Doug
I sat down last night to start going through everything, and while my Admin panel loaded and I could access the Products Specifications in the configure tab, I could not access it in the Catalog tab. I also cannot access Categories/Products in the Catalog tab. On both, the file stops short at the same line...
For products specifications, the address bar reads /myadminfoldername/products_specifications.php?........ and it ends at:
<!-- body_text //--> <td width="100%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Groups</td> <td class="pageHeading" align="right"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="40"></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="smallText" align="right"> <form name="search" action="http://mywebaddress/./myadminfoldername/products_specifications.php?osCAdminID=notpostingthis" method="get">Search for Group: <input type="text" name="search">
And the Categories / Products loads the same way and ends at the same line:
<!-- body_text //--> <td width="100%" valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Categories / Products</td> <td class="pageHeading" align="right"><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="40"></td> <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="smallText" align="right"> <form name="search" action="http://mywebaddress/./myadminfoldername/categories.php?osCAdminID=notpostingthis" method="get">Search: <input type="text" name="search">
Any ideas on where I might have gone wrong? Im not able to locate anything in "beyond compare" and I looked for any files I may have missed when I FTP'd the new files via FileZilla. The catalog side works great by the way. Those that I let "peak" at the site really like the look of your add.
Doug
Doug
#32 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 14 November 2009 - 01:43 AM
It appears to be halting at tep_hide_session_id(). That would indicate that you are trying to use this on a version of osCommerce older than 2.2RC1. tep_hide_session_id() is in the osCommerce code from RC1 on. You can get a copy from the current distribution and install it.
In any case, I strongly recommend that you update to RC2a due to the number of security fixes. That is in addition to the security precautions detailed elsewhere on the forum, of course.
Regards
Jim
In any case, I strongly recommend that you update to RC2a due to the number of security fixes. That is in addition to the security precautions detailed elsewhere on the forum, of course.
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#33
Posted 14 November 2009 - 02:34 AM
kymation, on 14 November 2009 - 01:43 AM, said:
It appears to be halting at tep_hide_session_id(). That would indicate that you are trying to use this on a version of osCommerce older than 2.2RC1. tep_hide_session_id() is in the osCommerce code from RC1 on. You can get a copy from the current distribution and install it.
In any case, I strongly recommend that you update to RC2a due to the number of security fixes. That is in addition to the security precautions detailed elsewhere on the forum, of course.
Regards
Jim
In any case, I strongly recommend that you update to RC2a due to the number of security fixes. That is in addition to the security precautions detailed elsewhere on the forum, of course.
Regards
Jim
Jim,
My hosting provider included the package with my hosting account. It looks like they install version 2.2ms2. I'm going to assume that this is prior to the RC versions and begin the process of upgrading. *sigh*
Thanks,
Doug
Doug
#34 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 14 November 2009 - 04:58 AM
Yes, that's an old version. There's an upgrade package in the Addons section. It takes time, but it's not particularly difficult to do. Depending on how many other addons you have installed, it might be easier to start with a fresh copy of 2.2RC2a and re-install from there. Your choice.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#35 ONLINE
bruyndoncx
-
- Members
- 2,656 posts
Problem Thinker
- Real Name:Carine Bruyndoncx
- Gender:Female
- Location:Belgium/ Antwerp/ Turnhout/ Arendonk
Posted 16 November 2009 - 12:54 AM
Hi jim,
have you been able to make progress on an bulk-import tool like (or integrating with) easy populate ?
BRgds
Carine
P.S. also started using your Get 1 free script recently too !
have you been able to make progress on an bulk-import tool like (or integrating with) easy populate ?
BRgds
Carine
P.S. also started using your Get 1 free script recently too !
Hava a nice day !
Carine Bruyndoncx
PS frustraded by the lack of feedback
<!--
Did you know 99% of all people benefiting from my posts, won't bother to repay the favor.
Wouldn't it be great if you are part of that exclusive 1% ?
post your findings in my responsive liive shop review thread ?
-->
Carine Bruyndoncx
PS frustraded by the lack of feedback
<!--
Did you know 99% of all people benefiting from my posts, won't bother to repay the favor.
Wouldn't it be great if you are part of that exclusive 1% ?
post your findings in my responsive liive shop review thread ?
-->
#36 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 16 November 2009 - 01:02 AM
I'm working on it right now. I keep getting interrupted, so no promises on a completion date, but I'm trying to finish it.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#37 ONLINE
bruyndoncx
-
- Members
- 2,656 posts
Problem Thinker
- Real Name:Carine Bruyndoncx
- Gender:Female
- Location:Belgium/ Antwerp/ Turnhout/ Arendonk
Posted 16 November 2009 - 01:32 AM
great, if you need someone for testing, just let me know.
Hava a nice day !
Carine Bruyndoncx
PS frustraded by the lack of feedback
<!--
Did you know 99% of all people benefiting from my posts, won't bother to repay the favor.
Wouldn't it be great if you are part of that exclusive 1% ?
post your findings in my responsive liive shop review thread ?
-->
Carine Bruyndoncx
PS frustraded by the lack of feedback
<!--
Did you know 99% of all people benefiting from my posts, won't bother to repay the favor.
Wouldn't it be great if you are part of that exclusive 1% ?
post your findings in my responsive liive shop review thread ?
-->
#38
Posted 22 November 2009 - 11:18 AM
Hello,
Thank you very much for this contribution. So far it works fine with pulldown boxes displaying filter options filtering products_specifications.specification. Is that what happens? But, I would like to have a text box filtering a custom field in the products_descriptions table.
1. I have added field `products_keywords` [varchar 255] in the products_description table. Some records have values like 'castles' or 'still lifes'.
2. I have a specification group 'Keywords' and a specification 'Keywords' within. Group Keywords is linked to all categories.
3. `products_column_name` in table `specification` for Keywords is `products_keywords`
4. The settings as they show in de admin
Specification Name: Keywords
Specification Description:
Specification Prefix:
Specification Suffix:
Sort Order: 5
Justification: Left
Column Name: products_keywords
Filter Class: partial
Display the Filter as: text
Filter Show All: False
Enter Specification Values as: text
Filters on this Specification: 0
5 A text box titled 'Keywords' shows up at my site. If I enter the text 'castle', press enter, I get the following:
Running: mysql 5.1.37 ubuntu 9.10 oscommerce RC2.2a with STS4 (no other contribs)
I hope anyone can help. I would really appreciate it.
Regards,
L.
Thank you very much for this contribution. So far it works fine with pulldown boxes displaying filter options filtering products_specifications.specification. Is that what happens? But, I would like to have a text box filtering a custom field in the products_descriptions table.
1. I have added field `products_keywords` [varchar 255] in the products_description table. Some records have values like 'castles' or 'still lifes'.
2. I have a specification group 'Keywords' and a specification 'Keywords' within. Group Keywords is linked to all categories.
3. `products_column_name` in table `specification` for Keywords is `products_keywords`
4. The settings as they show in de admin
Specification Name: Keywords
Specification Description:
Specification Prefix:
Specification Suffix:
Sort Order: 5
Justification: Left
Column Name: products_keywords
Filter Class: partial
Display the Filter as: text
Filter Show All: False
Enter Specification Values as: text
Filters on this Specification: 0
5 A text box titled 'Keywords' shows up at my site. If I enter the text 'castle', press enter, I get the following:
Quote
1054 - Unknown column 'products_keywords' in 'where clause'
select count(p.products_id) as count from (products p) join (products_to_categories p2c) on (p.products_id = p2c.products_id) left join (specials s) on (p.products_id = s.products_id) where p.products_status = '1' and p2c.categories_id = '111' and products_keywords like '%castle%'
[TEP STOP]
select count(p.products_id) as count from (products p) join (products_to_categories p2c) on (p.products_id = p2c.products_id) left join (specials s) on (p.products_id = s.products_id) where p.products_status = '1' and p2c.categories_id = '111' and products_keywords like '%castle%'
[TEP STOP]
Running: mysql 5.1.37 ubuntu 9.10 oscommerce RC2.2a with STS4 (no other contribs)
I hope anyone can help. I would really appreciate it.
Regards,
L.
#39 ONLINE
kymation
-
- Community Sponsor
-
- 6,687 posts
Believers
- Real Name:Jim Keebaugh
- Gender:Male
- Location:Aberdeen WA USA
Posted 22 November 2009 - 07:58 PM
The existing database fields option in Products Specifications was intended to support existing fields in stock osCommerce. You don't need to add a new database field to add a Specification. Just set up your Specification and it will be taken care of by the code. If that new field is a part of some other Addon, you'll need to modify the code to accept it.
Regards
Jim
Regards
Jim
My Addons
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
#40
Posted 26 November 2009 - 11:36 AM
Testing on a fresh installed 2.2RC2a. I have created a specification 'Period' (EN), 'Zeit' (DE). This specification has two filters: 1. 'Middle Ages'(EN), 'Mittelalter' (DE), 2. 'Modern' (EN), 'Neuzeit'(DE). The DVD starring Bruce Willis has been given the specification 'Modern'/'Neuzeit'. When browsing the catalog in English, the filter box says there is one DVD which is 'Modern'. When browsing in German, the filter box says no DVD's , zero, greyed out.
When I change language_id in products_specifications to 1 (so 'Neuzeit' has 1), it shows up black having 1 DVD.
Does the filter box only read language_id=1?
But when I change in the table products_specification field specification 'Neuzeit' to 'Modern' (so that I have two language_id's with the same specification value) the filter shows up in German. So is this intended, should the specifications all be the same for it to work?
Can I change something so the filter box shows different values for different languages?
Thanks,
L.
When I change language_id in products_specifications to 1 (so 'Neuzeit' has 1), it shows up black having 1 DVD.
Does the filter box only read language_id=1?
But when I change in the table products_specification field specification 'Neuzeit' to 'Modern' (so that I have two language_id's with the same specification value) the filter shows up in German. So is this intended, should the specifications all be the same for it to work?
Can I change something so the filter box shows different values for different languages?
Thanks,
L.
