Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bradybarrows

Pioneers
  • Posts

    215
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by bradybarrows

  1. My site monitor was working fine. However, due to a new security alert found here:

     

    http://www.oscommerce.com/forums/index.php?showtopic=340995

     

    about changing the admin directory to a new secret name, when I did this I got the following error message when using Site Monitor:

     

    Warning: opendir(/catalog/) [function.opendir]: failed to open dir: No such file or directory in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 168

     

    Warning: readdir(): supplied argument is not a valid Directory resource in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 170

     

    Warning: closedir(): supplied argument is not a valid Directory resource in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 182

     

    Can you give me a detailed step list to fix these error messages? Thanks.

     

    I kept working on it and found the configure.php file wasn't correct and fixed it. Never mind.

  2. My site monitor was working fine. However, due to a new security alert found here:

     

    http://www.oscommerce.com/forums/index.php?showtopic=340995

     

    about changing the admin directory to a new secret name, when I did this I got the following error message when using Site Monitor:

     

    Warning: opendir(/catalog/) [function.opendir]: failed to open dir: No such file or directory in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 168

     

    Warning: readdir(): supplied argument is not a valid Directory resource in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 170

     

    Warning: closedir(): supplied argument is not a valid Directory resource in /home/43/dbasename/htdocs/my_domaindirectory/catalog/my_new_admin_name/includes/functions/sitemonitor_functions.php on line 182

     

    Can you give me a detailed step list to fix these error messages? Thanks.

  3. The next version will set that automatically. Although, any host that doesn't know what the server path is can't really call themselves a host. I can only thing they must not have understood the question.

     

    Jack

     

    I was talking to some person from a foreign country and she wanted me to wait on the line while she tried to figure it out and I figured it would be simply easier to read through all the posts in this thread and told her to forget it, and sure enough around page 10 there was the answer. Finding the answer to a problem is probably somewhere in some forum on this site if one has the patience and determination to find it. As Sam just recently told me when I asked him a question, 'Free doesn't mean there isn't any work involved' or something similar.

  4. It's saying home/MyActual Username/public_html isn't valid. Go to admin->tools->Database Backup and the correct path is displayed there. Is it the same (except for the admin part)?

     

    Jack

     

    Aloha Jack,

     

    Excellent contribution but I had to read through the posts until I found the above instruction to get it to work. I had no idea what home/username/public_html meant. I called my host and they were clueless. I suggest in future instructions to add the above instruction so that it helps newbies like me. After I did this SiteMonitor works like a champ. Mahalo.

  5. I decided to upload a completely new osCommerce Online Merchant v2.2 Release Candidate 2a with Separate Pricing Per Customer v4.0 (Complete Revision) by Marvin Miller to see what happens. As you know, this is tedious doing it again. I am either not following the instructions correctly or there is some conflict with my MacOS browsers, because I get shopping cart just fine, but when I log into the admin control panel I get a different error message:

     

    1146 - Table 'db281075074.TABLE_ADMINISTRATORS' doesn't exist

     

    select id from TABLE_ADMINISTRATORS limit 1

     

    [TEP STOP]

     

    Can't someone please tell me what I am doing wrong? Why can't I get SPPC to work with OMv2.2?

     

    If I check mySQL I don't see any TABLE_ADMINSTRATORS.

     

    I have no idea how to correct this error message. I have no idea what 'select id from TABLE_ADMINSTRATORS means. Please, help me figure this out.

  6. What if I uninstall the files using sppc_v421_uninstall.sql and then install again using the sppc_v42_install.sql. I will try it and see what happens.

     

    I did uninstall v421 and uploaded v42 and the error message in the shopping cart I had before:

     

    Fatal error: Call to undefined function: tep_db_check_age_specials_retail_table() in /homepages/43/d101564082/htdocs/mountainwinery/store/index.php on line 157

     

    the above error message is gone. A little improvement. However, when I go into the admin control panel I still get the same error message when adding a new product or editing an existing product:

     

    1146 - Table 'db280358598.TABLE_CUSTOMERS_GROUPS' doesn't exist

     

    select customers_group_id, customers_group_name from TABLE_CUSTOMERS_GROUPS where customers_group_id != '0' order by customers_group_id

     

    [TEP STOP]

     

    Also the fields below Products Price (Gross): in the store/admin/categories.php?cPath=&action=new_product page are missing. The above error message is displayed on the page.

     

    Any ideas what I can do to fix this?

  7. I downloaded the version of leirisset but I can find all these things.

    The install instructions are all in HTML. Perhaps there is an error in there (that I would have introduced most likely) that hides code from you in the browser you use but that does not happen in other browsers?

    That particular function is supposed to have been added to catalog/includes/functions/database.php. You didn't by accident added it after the php closing tag ( ?> )did you?

     

    I checked catalog/includes/functions/database.php. and everything is before the ?>.

     

    I am using MacOS Safari and Firefox and get the same error messages. I have three times uploaded SPPC. The first time with 4.2.0 and it was the best one since I was able to see the different pricing when adding a new product. I guess I will have to go back to 4.2.0. My understanding of the install is to replace the files that come with osCommerce Online Merchant v2.2 Release Candidate 2a with the SPPC files. I haven't gone through every file and checked the changes since I found that the changes have all already been done in the SPPC files. After about six pages, I figured all the files were correct.

     

    Does this have something to do with mySQL not getting the tables? What if I uninstall the files using sppc_v421_uninstall.sql and then install again using the sppc_v42_install.sql. I will try it and see what happens.

  8.  

    Jan Zonjee,

     

    I initially installed Separate Pricing Per Customer v 4.2.2 full with french languages files by leirisset which didn't have on the in the admin/includes/database_tables.php file the following code:

     

    // BOF Separate Pricing Per Customer

    define('TABLE_PRODUCTS_GROUPS', 'products_groups');

    define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');

    define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');

    define('TABLE_PRODUCTS_ATTRIBUTES_GROUPS', 'products_attributes_groups');

    // EOF Separate Pricing Per Customer

     

    Also, in leirisset's version it didn't have in the catalog/includes/languages/english/login.php file the following code:

     

    // BOF Separate Pricing Per Customer

    // define the email address that can change customer_group_id on login

    define('SPPC_TOGGLE_LOGIN_PASSWORD', 'root@localhost');

    // EOF Separate Pricing Per Customer

     

    Since you supplied me the code and I then later noticed that you have the following download:

     

    Separate Pricing Per Customer (SPPC) Version 4.2.2

     

    I decided to delete the entire shopping cart, upload a clean version of the osCommerce Online Merchant v2.2 Release Candidate 2a and also downloaded your version of Separate Pricing Per Customer (SPPC) Version 4.2.2, upload everything, re-installed the mySQL database, and start all over. However, when I log into admin and click on CUSTOMERS I still get this following error message:

     

    1146 - Table 'db280358598.TABLE_CUSTOMERS_GROUPS' doesn't exist

     

    select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join TABLE_CUSTOMERS_GROUPS cg on c.customers_group_id = cg.customers_group_id

     

    I checked the admin/includes/database_tables.php file and the following code exits:

     

    // BOF Separate Pricing Per Customer

    define('TABLE_PRODUCTS_GROUPS', 'products_groups');

    define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');

    define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');

    define('TABLE_PRODUCTS_ATTRIBUTES_GROUPS', 'products_attributes_groups');

    // EOF Separate Pricing Per Customer

     

    What am I doing wrong? I am following the instructions and I still get the same error message. Also, if this is any help to you, I get this error message in my store when trying to access a product item:

     

    Fatal error: Call to undefined function: tep_db_check_age_specials_retail_table() in /homepages/43/d101564082/htdocs/mountainwinery/store/index.php on line 157

  9. Does SPPC 4.2.2 work with the new osCommerce Online Merchant v3.0 Alpha 5?

     

    And one other question, please indulge me:

     

    My server is using PHP Version 4.4.9 and osCOM v3.0 requires v5.2.0+ (with MySQLi extension). How does one install PHP 5.2 on the server if it is pre-stalled with my ISP host?

  10. It looks like you didn't add the define for this table in either the admin/includes/database_tables.php or the equivalent page on the catalog side.

     

    Does an earlier version of SPPC have these tables? It is odd to me that the download doesn't have certain tables and doesn't mention anything about this in the instructions.

  11. With 257 pages and no real search feature to find my problem, I am hoping that someone will help me figure this out. I went through several pages in this forum and can't find the answer. This particular add on, very cool, should have its own forum with categories so we can locate our problem and see where the post is resolved.

     

    I uploaded SPPC 4.2.0 and 4.2.2 and everything seems to be fine except when I created in the shopping cart a new user account this error message came up:

     

    1146 - Table 'db280358598.TABLE_CUSTOMERS_GROUPS' doesn't exist

     

    select c.customers_group_id, cg.customers_group_show_tax, cg.customers_group_tax_exempt, cg.group_specific_taxes_exempt from customers c left join TABLE_CUSTOMERS_GROUPS cg using(customers_group_id) where c.customers_id = '5'

     

    [TEP STOP]

     

    I have installed both sppc_v421_install.sql and sppc_v42_install.sql.

     

    In my SQL admin I don't see any of the above items. How I do I fix this?

     

    I am using osCommerce Online Merchant v2.2 RC2a

  12. Just add the following to that file (before the ?> at the bottom) and you will be fine:

    // BOF Separate Pricing Per Customer
    // define the email address that can change customer_group_id on login
    define('SPPC_TOGGLE_LOGIN_PASSWORD', 'root@localhost');
    // EOF Separate Pricing Per Customer

     

    Big Mahalos to you!!!

  13. Followed these instruction:

    Separate Pricing Per Customer 4.2.0

    Revised & Re-Written by JanZ & documented by Marvin Miller and JanZ

     

    I am running osCommerce Online Merchant v2.2 RC2a

     

    I am doing a manual installation and got to step 11 and am at loss.

     

    Here are the steps:

     

    Before beginning the manual install you need to:

     

    Upload five included image files to your site. They are (and located in):

     

    catalog/admin/includes/languages/english/images/buttons/ic_down.gif

     

    catalog/admin/includes/languages/english/images/buttons/ic_up.gif

     

    catalog/admin/includes/languages/english/images/buttons/button_group_prices.gif

     

    catalog/admin/images/icons/tick_black.gif

     

    catalog/admin/images/icons/icon_tick.gif

     

    The first two are used in admin/customers.php and the last three are used in admin/attributes.php and admin/attributes_groups.php.

     

    Upload four new .php files:

    catalog/admin/includes/languages/english/customers_groups.php, catalog/admin/includes/languages/english/attributes_groups.php, catalog/admin/customers_groups.php, and catalog/admin/attributes_groups.php.

     

    Run the spcc_v42_install.sql database installation file on your MySQL database.

     

    Modify the catalog/includes/languages/english/login.php file to include the Site Administrator's email address. This email address is used for wholesale account notifications. You can find the appropriate section of that file by doing a search for the keyword root.

    ------------------------------------------------------------------------------------------------------------------------------

     

    I was able to do everything but the last step. I opened the catalog/includes/languages/english/login.php file and can't figure out where to put the email address. I don't understand how to "find the appropriate section of that file by doing a search for the keyword root." Can someone please give me some details about this? Mahalo.

  14. Followed these instruction:

    Separate Pricing Per Customer 4.2.0

    Revised & Re-Written by JanZ & documented by Marvin Miller and JanZ

     

    I am running osCommerce Online Merchant v2.2 RC2a

     

    I am doing a manual installation and got to step 11 and am at loss.

     

    Here are the steps:

     

    Before beginning the manual install you need to:

     

    Upload five included image files to your site. They are (and located in):

     

    catalog/admin/includes/languages/english/images/buttons/ic_down.gif

     

    catalog/admin/includes/languages/english/images/buttons/ic_up.gif

     

    catalog/admin/includes/languages/english/images/buttons/button_group_prices.gif

     

    catalog/admin/images/icons/tick_black.gif

     

    catalog/admin/images/icons/icon_tick.gif

     

    The first two are used in admin/customers.php and the last three are used in admin/attributes.php and admin/attributes_groups.php.

     

    Upload four new .php files:

    catalog/admin/includes/languages/english/customers_groups.php, catalog/admin/includes/languages/english/attributes_groups.php, catalog/admin/customers_groups.php, and catalog/admin/attributes_groups.php.

     

    Run the spcc_v42_install.sql database installation file on your MySQL database.

     

    Modify the catalog/includes/languages/english/login.php file to include the Site Administrator's email address. This email address is used for wholesale account notifications. You can find the appropriate section of that file by doing a search for the keyword root.

    ------------------------------------------------------------------------------------------------------------------------------

     

    I was able to do everything but the last step. I opened the catalog/includes/languages/english/login.php file and can't figure out where to put the email address. I don't understand how to "find the appropriate section of that file by doing a search for the keyword root." Can someone please give me some details about this? Mahalo.

×
×
  • Create New...