Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jazzy_b

Archived
  • Posts

    12
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ben

jazzy_b's Achievements

  1. Hello - just in case this helps anyone I mananged to fix the problem. I am now quite sure that the initial problem is that the windows server I am using does not have permissions set to allow a web page to create tables within a database. So I looked in Admin > Includes > additional_images_configure.php Begining from line 212 is the following code: // this array is used for creating new tables $tables_array = array(); $tables_array [] = array ( 'tablename' => 'additional_images', 'create' => "CREATE TABLE additional_images ( additional_images_id int(11) NOT NULL auto_increment, products_id int(11) NOT NULL default '0', images_description varchar(64) default NULL, thumb_images varchar(64) default NULL, medium_images varchar(64) default NULL, popup_images varchar(64) default NULL, PRIMARY KEY (additional_images_id), KEY products_id (products_id) );", 'remove' => "DROP TABLE IF EXISTS additional_images;" ); // this array is used for altering table that already exist in the default osC shop $table_mods_array = array(); $table_mods_array [] = array ( 'tablename' => 'products', 'columnname' => 'products_image_med', 'create' => "ALTER TABLE products ADD products_image_med VARCHAR(64) default NULL AFTER products_image;", 'remove' => "ALTER TABLE products DROP products_image_med" ); $table_mods_array [] = array ( 'tablename' => 'products', 'columnname' => 'products_image_pop', 'create' => "ALTER TABLE products ADD products_image_pop VARCHAR(64) default NULL AFTER products_image_med;", 'remove' => "ALTER TABLE products DROP products_image_pop" ); $table_mods_array [] = array ( 'tablename' => 'products', 'columnname' => 'products_image_description', 'create' => "ALTER TABLE products ADD products_image_description VARCHAR(64) default NULL AFTER products_image_pop;", 'remove' => "ALTER TABLE products DROP products_image_description" ); // table mod added to catch earlier versions of Additional Images $table_mods_array [] = array ( 'tablename' => 'additional_images', 'columnname' => 'thumb_images', 'create' => "ALTER TABLE additional_images ADD thumb_images VARCHAR(64) default NULL AFTER images_description;", 'remove' => "ALTER TABLE additional_images DROP thumb_images" ); I gave this to my techie mate and he manually created the tables using php myadmin Then I logged in and went to http://www.mydomain.com/catalog/admin/addi...s_configure.php and it said that some of the items were not installed and I clicked on the "Force Configuration Defaults" and lciked the button and hey presto it all worked!!! I must admit this whole problem would have been much simpler if the sql for a fresh install had been included.. great contribution otherwise!!
  2. Hello I hope someone can help with this - it's driving me nuts!! I have had a good search of the forum and google and it seems a few other people are getting this problem, so hopefully someone may be able to help. I have tried to reinstall this contribution three times now and I am sure all of the code is perfectly copied over. The porblem I have is that I can't get Step B. DATABASE INSTALLATION to work: where I have to go to http://www.mydomain.com/admin/additional_i...s_configure.php. My shop for the moment is in a folder called catalog, so the address I have been going to is: http://www.mydomain.com/catalog/admin/addi...s_configure.php The page appears to display fine, but I get the following messages on screen: Your database requires updates. Configuration Group "Additional Images" does not exist. Configuration Group "Images" exists. Checking for items... Configuration Key "DISPLAY_IMAGE_WIDTH" does not exist. Configuration Key "DISPLAY_IMAGE_HEIGHT" does not exist. Configuration Key "POPUP_IMAGE_WIDTH" does not exist. Configuration Key "POPUP_IMAGE_HEIGHT" does not exist. Checking for Tables... Table "additional_images" was not found. Checking for Columns... Column "products_image_med" not found in Table "products". Column "products_image_pop" not found in Table "products". Column "products_image_description" not found in Table "products". Table "additional_images" was not found, column check not performed. no matter how many times I click on the "run Configuraito Utlity" nothing happens other than the page refreshes to itself. I am on a Windows 2003 server, PHP Version 4.3.11, register globals is on, and the latest download of OS Commerce. I am guessing, but I think it is something to do with the page not being able the database as it doesn't have permissions to insert tables? - but I could be wrong. Does anyone know of a fix for this, or even better - does anyone have the sql statement for inserting new tables and configs etc into the dtabase. I did try reading the php, with a view to maually adding the tables and rows into the databse but I couldn;t really make head or tail of it. Any help in fixing this or maully updating the database would be cool. thanks
  3. Hello, I have searched the forums and not found anything on this, but appologies if someone has found a solution to this. I am looking after a store for a friend. They are running QTPro (which I believe manges the product attributes and stock quantities for those attributes). For some reason the Protx Form module (not the direct one) processes the payments correctly, but the admin section only updates the stock quantity of the product and not the attributes. For example, a picture frame has 2 sizes: large and small. There are 2 large and 1 small in stock. If a customer orders either a large or small picture frame the initial stock quantity (which prior to order correctly displays 3 in stock), is updated and correctly displays 2 in stock. But when I click on the Stock button, the next screen displaying the item attributes stock is not updated and still shows the original quantities. The only thing I have done recently that might interfere with it is that I upgraded the Paypal payment module to the Paypal IPN module (which works fine and updates the product attributes stock quantity). Has anyone else had these issues? Please help! Thanks
  4. jazzy_b

    SecPay Payment Module

    I agree. I got the same error when I manual tried to change the coding in the secpay.php include page. I found that I had to go back to the original document and upload that. then to get around my other problem of not being to reach the callback page properly (which was the reason I hand coded the callback URL) I had to add the following text after the merchant id in the admin area (the changed the call back method - fixed my problem and made my customer a very happy person indeed). -jredir E.g. my merchant name might be: funboy02 I changed this to: funboy02-jredir And everything worked - the DB updated with the order details and the OSCommerce email notifcation got sent. lovely.
  5. jazzy_b

    Secpay Help!

    Hi Guys, I was having the same problem as you. After 7 hours writing the coding here and there, I spoke to Secpay's tech support. I put all the pages back to their orignal php and added the following bit of text after the merchant ID (in the admin section) "-jredir" Log in to Admin > Modules > Payment > SECpay > click edit > Under Merchant ID type the text above after your merchant id. For example if my merchant ID was: funboy01 The new ID would read: funboy01-jredir According to SECpay this makes the callback a java redirect. It worked for me!! http://www.oscommerce.com/forums/style_images/...icons/icon6.gif
×
×
  • Create New...