Pixy

Okay - I am a bit slow today Should I just uplaod a new database.php file? or should I edit the database file?

Please HELP I installed SPPC and also the hide products contribition now I get this error In my online catalog Fatal error: Call to undefined function: tep_db_check_age_specials_retail_table() in /usr/www/users/webassi/catalog/index.php on line 155

I installed EP and I have done the changes as per the read me file but I do not get it to show as a menu item? all that shows is this: FILENAME_IMP_EXP_CATALOG In the read me file there are to fields: // Easy polulate //define('FILENAME_IMP_EXP_CATALOG', 'easypopulate.php'); // END 7. Edit files \admin\includes\languages\english.php and \admin\includes\languages\italian.php and add in bottom before ?> : // Easy polulatedefine('BOX_CATALOG_IMP_EXP', 'Utility Import Export'); // END I assumed that it should have been Easy Populate and changed it other than that I followed the instructions 100% I also have SPPC installed but I didnt think that will cause a problem?

I installed EP and I have done the changes as per the read me file but I do not get it to show as a menu item? all that shows is this: FILENAME_IMP_EXP_CATALOG In the read me file there are to fields: // Easy polulate //define('FILENAME_IMP_EXP_CATALOG', 'easypopulate.php'); // END 7. Edit files \admin\includes\languages\english.php and \admin\includes\languages\italian.php and add in bottom before ?> : // Easy polulatedefine('BOX_CATALOG_IMP_EXP', 'Utility Import Export'); // END I assumed that it should have been Easy Populate and changed it other than that I followed the instructions 100% I also have SPPC installed but I didnt think that will cause a problem?

JanZ I restored all the original files of OSCMM2 and now it works. I am kinda starting from scratch I am working from the original template installing SPPC and then doing all the template changes again. It seems to be working that way. Tahnks for your help

I used compare and merge this time and did a manual installation now I get these errrors: Parse error: parse error, unexpected $ in /usr/www/users/paperc/catalog/admin/categories.php on line 1113 Parse error: parse error, unexpected $ in /usr/www/users/paperc/catalog/admin/customers.php on line 1244 There is no $ on either of these lines I checked and checked again And my online catalog now looks like this Parse error: parse error, unexpected $ in /usr/www/users/paperc/catalog/admin/customers.php on line 1244 I am really at my wits end I need to get this site up and running. Does anyone know why it is doing this?

Janz I downloaded the file (admin/includes/database_tables.php) to check the script and it is as per the instructions: // BOF Separate Pricing per Customer define('TABLE_PRODUCTS_GROUPS', 'products_groups'); define('TABLE_CUSTOMERS_GROUPS', 'customers_groups'); // EOF Separate Pricing per Customer

JanZ - sorry I am not that good with sql I thought that running the install file and uploading the files will do all of that? Should I go to the file and manualy add the script in?

UGH GRRR - HELP I ran the install file as per the instructions and I also loaded all the required files (as per the instructions) BUT it is still giving me this error in Admin under Customer GroupsGroups Search: Name Action 1146 - Table 'webassi_oscommerce.TABLE_CUSTOMERS_GROUPS' doesn't exist select count(*) as total from TABLE_CUSTOMERS_GROUPS g [TEP STOP] The table is in the SQL database - I think that I might have a problem with the sql script can anyone help me? I am desperate to get this working as soon as possible!

I installed the contribition but I get this error in my admin panel Under Customer Groups 1146 - Table 'webassi_oscommerce.TABLE_CUSTOMERS_GROUPS' doesn't exist select count(*) as total from TABLE_CUSTOMERS_GROUPS g and Under Customers 1146 - Table 'webassi_oscommerce.TABLE_CUSTOMERS_GROUPS' doesn't exist select customers_group_id, customers_group_name from TABLE_CUSTOMERS_GROUPS order by customers_group_id I have run the install document as per the read file. Please help me as both the tables are in MYSql database

I did run the install file but I am not good with sql and I am not sure where to put the Values in? When I open the table there are 5 colums Field Type Function Null and Value I assume I have to put in by the value colum but it keeps giving me errors do I do the entire entry : ('0','Retail','1','0','',''); on one line? eg I have a field customers_group_id do I put the entire line there? I did run the install file but I am not good with sql and I am not sure where to put the Values in? When I open the table there are 5 colums Field Type Function Null and Value I assume I have to put in by the value colum but it keeps giving me errors do I do the entire entry : ('0','Retail','1','0','',''); on one line? eg I have a field customers_group_id do I put the entire line there?

PLEASE HELP ME!! I installed the package according to the instructions but now my front page says this: 1054 - Unknown column 'customers_group_id' in 'where clause' select specials_new_products_price from specials where products_id = '1405' and status and customers_group_id = '0' [TEP STOP] And when I go to my customers via Admin it show this: 1146 - Table 'paperc_paperc_newoscomm.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 customers_groups cg on c.customers_group_id = cg.customers_group_id [TEP STOP] PLEASE HELP ME - My client is going to kill me and I dont want to die I am to young (and apperntly stupid) Just for clarity I installed the NEW separate pricing per customer

PLEASE HELP ME!! I installed the package according to the instructions but now my front page says this: 1054 - Unknown column 'customers_group_id' in 'where clause' select specials_new_products_price from specials where products_id = '1405' and status and customers_group_id = '0' [TEP STOP] And when I go to my customers via Admin it show this: 1146 - Table 'paperc_paperc_newoscomm.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 customers_groups cg on c.customers_group_id = cg.customers_group_id [TEP STOP] PLEASE HELP ME - My client is going to kill me and I dont want to die I am to young (and apperntly stupid) Just for clarity I installed the NEW separate pricing per customer

I hope you can help in EZ_Price_Updater my Visisble Price - List does not have all my products in, is there somewhere that I need to refresh or update this list?

When I go to update Visible price update not all of my products show, I checked and made sure that all the products are active. I notice that when I add new products to my database they do not appear on Visible p/u but they are on All p/u? What am I doing wrong? :(

Did you find a solution yet?

I did and it still does not work

The only thing that I thought might be a problem is the images, they are on the system though? This is from the txt file that I tried to import. 25849 25849.jpg Rub-ons Alphabet Mixed Large Muted "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 28/06/2005 00:00 06/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 43 mb 4 59 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR 25846 25846.jpg Rub-ons Alphabet Mixed Large White "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 29/06/2005 00:00 07/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 44 mb 4 60 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR

Okay the file uploads and gives me this File uploaded. Temporary filename: /tmp/phpxdgOj0 User filename: EP2005May10-2008.txt Size: 350012 But I do not see the products?

THANK YOU!!! It worked!! Thank you so much for your time! :thumbsup:

I do not follow any of that?? Should i go change the code ? can you give me more instructions? Sorry but I am not good with this at all. :blush:

I hope this is it? <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://papercrazy.co.za'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', '/usr/www/users/paperc/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/usr/www/users/paperc/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

I just copied it <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'papercrazy.co.za'); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', ''); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', ''); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/usr/www/users/paperc/catalog/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'dedi4a.your-server.co.za'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'paperc_nos'); define('DB_SERVER_PASSWORD', 'XAbBbJXz'); define('DB_DATABASE', 'paperc_paperc_newoscomm'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' /* define('DB_SERVER', 'dedi4a.your-server.co.za'); define('DB_SERVER_USERNAME', 'paperc_os'); define('DB_SERVER_PASSWORD', 'XAbBbJXz'); define('DB_DATABASE', 'paperc_oscommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); */ ?>

I got an error because my temp file had two // so I went and deleted the temp file in in my file manager and tried to create a new temp file hoping that this will solve the problem but no such luck. So how do I get rid of the // ?? :'( I really need some urgent help with this so any ideas would really be appreciated!

I am not sure which version of OSC we are working on - I did not install it and the person that did is not available - is there anywhere that I can look? There is no database_tables.php in admin/includes/ I also created the catalog/temp folder but I have no idea how to set the premission or what they mean by: it's permissions are set to allow writes to that directory, that would be 777 or rwxrwxrwx (in shell access - while you're in the catalog directory, execute "chmod 777 temp"