Latest News: (loading..)

bradybarrows

Members
  • Content count

    215
  • Joined

  • Last visited

1 Follower

About bradybarrows

Profile Information

  • Real Name
    Brady Barrows
  1. 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://forums.oscommerce.com/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. 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. 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. This might help you: http://freeoscommerce.com/2009/04/osc-3-al...emplate-issues/
  6. 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.
  7. 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?
  8. 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.
  9. 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
  10. 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?
  11. 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.
  12. The instructions didn't say anything about this. Is there any details somewhere about this?
  13. 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
  14. Big Mahalos to you!!!
  15. 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.