Jump to content

  2. → Viewing Profile: dvharrison

Corporate Sponsors


Latest News: (loading..)

dvharrison

Member Since 31 Aug 2006
Offline Last Active May 10 2012, 10:15
-----

Posts I've Made

In Topic: Stock isn't deducting from PayPal

02 April 2012, 15:17

Ok, I have looked further and it seems to be tempremental. In most cases it works but sometimes it doesn't. Please, has anyone else had this trouble or could it be due to timeouts on the server?

In Topic: Stock isn't deducting from PayPal

27 March 2012, 20:29

Hi all

Its 2 weeks later, and apparently we are getting the same problem again. What seems to happen, is when we look under Customer > order :

We get the Preparing [PayPal IPN] row followed by
Verified PayPal IPN Verified [Completed (Verified; £x.xx)] (these are both marked with a red cross).

Then we get another Verified message shortly afterwards but this is marked with a green tick which seems to be when the stock deducts. It has worked but suddenly its not.

Please help!! :'(

In Topic: [Contribution] Cross Sell (X-Sell) Admin

23 March 2012, 11:38

@Mort-lemur

Actually on the product info adjustment, you have one to many '}' listed. So it should be

<?php
//added for cross -sell
	if ((USE_CACHE == 'true') && empty($SID)) {
	  echo tep_cache_xsell_products(3600); //added for Xsell
	  echo tep_cache_also_purchased(3600);
	} else {
	  include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS); //added for Xsell
	  include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
	}

?>

I have taken this out and the page at least shows. I haven't a clue if the rest works as I'm still going through it.

Hope this helps.

In Topic: [Contribution] Cross Sell (X-Sell) Admin

22 March 2012, 11:08

I was just copying and pasting in the Sql tab in phpmyadmin but I have just imported the database and that seems to work. However, I have just gone through all the changes religiously and the product_info.php page does not display at all and on clicking the cross-sell link on the catalog box, I get a 404 page where its trying to look for www.mydomain.com/myadmin/filename_xsell_products?oscadminid=etc

and such a filename doesn't exist anyway.

Please advise.

In Topic: [Contribution] Cross Sell (X-Sell) Admin

21 March 2012, 13:19

Hi

I have OSCommerce 2.3.1 on my website using mySQL 5.0.95 and PHPmyadmin 3.4.9

I am trying to create the table using products_xsell.sql. Nothing happens, but I get the following:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Cross Sell', 'MAX_DISPLAY_XSELL', '6', 'Maximum number of products to display in the \'Cross Sell\' box', '3', '16', now());[color=#ff0000]# 1 row affected.[/color]

DROP TABLE IF EXISTS products_xsell;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE products_xsell (
  ID int(10) NOT NULL auto_increment,
  products_id int(10) unsigned NOT NULL default '1',
  xsell_id int(10) unsigned NOT NULL default '1',
  sort_order int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;[color=#ff0000]# MySQL returned an empty result set (i.e. zero rows).[/color]

alter table products_xsell add index idx_products_id (products_id);[color=#ff0000]# MySQL returned an empty result set (i.e. zero rows).[/color]
alter table products_xsell add index idx_xsell_id (xsell_id);[color=#ff0000]# MySQL returned an empty result set (i.e. zero rows).[/color]

Please help.

  1. osCommerce Support Forum
  2. → Viewing Profile: dvharrison
  3. Forum Rules