Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Upgrade your store
 
Reply
   X-Cart forums > General > General talk
 
Thread Tools
  #171  
Old 08-22-2008, 03:31 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Hi all,

I finally got an answer back from Qualiteam on this one.

I need to chat with Emerson about this, which I haven't done to date. (time zone problems no doubt)

I don't expect him to be on line 24 hours a day, but I hope this will help speed things up a little for him and me.

Below is an abbreviated version of the message I got from Qualiteam, I have masked out the URL and test code. I don't want this test code tattooed on the the web, as I don't know if there is a security risk before, or after the problem is solved.

If anyone who believes they may be able to throw some more light on this, please email me, and I'll give you the test procedure presented to me. Thank you.

================================================== ==================================
Qualiteam:
I have investigated the problem and discovered its origin. It is caused by a malfunction of your web-server. Let me explain.

Open the following test script's URL in your browser:
(masked)

The test script will display the following result:

<<
$REQUEST_URI: /masked.php?paymentid=25mode=checkout
>> >>

As you see, the value of the $REQUEST_URI variable is incorrect - an ampersand character is missing. This causes your X-Cart & PayPal Express Checkout module not to work correctly.

The source code of the test script is:
(masked)

--------------------------------
Please copy and forward this message to your hosting company and ask them to look into and fix the problem. Please keep us updated about the results.

End Qualiteam
================================================== ==================================

I have gone on to ask Qualiteam the following questions in a new message:

As my web host is on a different time zone (Emerson EDWHosting.com), it may be sometime before he gets back to me, so what should we be looking for?

A bad PHP5 installation?
Bad build?
Other?
Have you had others report similar problems?
Would any X-cart on the same server experience exactly the same problem with Paypal and express checkout?

thanks in advance,

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #172  
Old 08-22-2008, 10:42 PM
 
candyman candyman is offline
 

Member
  
Join Date: Apr 2005
Posts: 14
 

Default Re: Upgrade your store

Please keep us updated
__________________
Candyman
x-cart 4.0.18
www.ewdhosting.com
Reply With Quote
  #173  
Old 08-22-2008, 11:43 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Quote:
Originally Posted by candyman
Please keep us updated

Well sure Candyman, lots happening, but no real progress. Has now been 8 days, at a time when business is very slow, and this Paypal problem is really affecting me. I waited 5 days, but no work was started, then I stepped it up to hotrush before any action was taken.

================================================== ==============
Emerson has now tested the Qualiteam test software as follows:
----------------------------
I have uploaded that script to numerous servers(including servers that are still running php4) and the result is the same.
I am rebuilding apache now just in case but I doubt this is the problem. We do not have any other customers having this issue.
Emerson suggests that I ask Qualiteam to dig a little deeper
================================================== ==============
Then from Qualiteam:
---------------------------
Thank you for the update.We are sorry we have to keep you waiting but the engineers responsible for this request will be available on Monday only. Sergey has already started working on this request so it is recommended that he completes the task himself because he knows all the details. We would appreciate your waiting for the engineer. But if the issue still needs to be processed urgently, another specialist will be assigned to it. Thank you for your patience.
================================================== ==============
Then a potential clue from Emerson:
--------------------------
I have a feeling this issue might be related to the XCSEO mod.
Go to http://www.dontronics-shop.com/test_php.php?paymentid=25&mode=checkout and you will see the bloken image at the top right.
If you look at the URL of that image it is showing:
http://www.dontronics-shop.com/phpss_xcseo_pro.php?=PHPE9568F34-D428-11d2-A769-00AA001ACF42

In reality it should be:
http://www.dontronics-shop.com/test_php.php?=PHPE9568F34-D428-11d2-A769-00AA001ACF42

As you see the phpss_xcseo_pro.php is being added to the URL. That could be causing an issue. Not sure but worth a shot.
================================================== ==============

So I sent a message to Jon at phpsitesolutions.com to ask for his assistance.

One of the real problems is that of global times. I can't and don't expect immediate assistance.

Saturday 17:40 here in Australia, and I'm not sure which direction to head next.

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #174  
Old 08-23-2008, 12:36 AM
 
intel352 intel352 is offline
 

X-Wizard
  
Join Date: Dec 2005
Posts: 1,071
 

Default Re: Upgrade your store

Hi All, this issue is likely related to the version of XCSEO Pro (v1.1.5) that Don is using, it's "antiquated" compared to the current release of XCSEO Pro (v1.2.5). I'll be upgrading him later today and should be able to verify then that the bug was local to his module version.

I apologize for any inconvenience Don, I hope this bug hasn't hampered your sales greatly. Hopefully the new features in XCSEO Pro will further boost your SE rankings, and bring in a flood of new sales to make up for any sales you may have lost.

Cheers
__________________
-Jon Langevin
WARNING: Unethical developer - NOT RECOMMENDED
See details here
Reply With Quote
  #175  
Old 08-23-2008, 01:00 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Qualiteam:
Irina tells me Sergey won't be available till Monday.

Because of the X-cart user group and my web host, I find out more information.
See: http://forum.x-cart.com/showthread.php?p=227373#post227373

Jon Langevin of phpsitesolutions.com announces that it appears to be his problem, so I ask Jon to go ahead and do some work Sunday.
If all goes well, I can tell Qualiteam to stop looking for the problem Sunday, before Sergey starts work on Monday his time.

Saturday Sergey works on my site, tells me it is no longer a server problem, but an .htaccess rewrite problem. These rewrite conditions & rules are used by the "phpss_xcseo" module integrated with my X-Cart.

Says the problem should now be fixed, and asks me to try a test order. Of course, I still don't have the ability to do this. I can't be the buyer and seller according to Paypal.
Sergey gives me a full set of backup files, the ones that he changed.

This is fine, and I thank Sergey very much, but the real problem is why tell me Sergey can't work on it till Monday, then he works on it Saturday?
And why would all of this come about by simply updating my server to PHP5?

I have written this single message in a fashion to be able to post it to all parties that are now involved in assisting me, so they can understand what has taken place, and hopefully get my cart back to a good working condition.

Now if only I had a real paypal order to test it.

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #176  
Old 08-23-2008, 01:12 PM
 
Emerson Emerson is offline
 

X-Man
  
Join Date: Mar 2004
Location: Atlanta, GA
Posts: 2,209
 

Default Re: Upgrade your store

Don,

Order id: #8127
Order status: Processed
__________________
Emerson
Total Server Solutions LLC- Quality X-Cart Hosting
Recommended X-Cart Hosting Provider - US and UK servers
Does your host backup your site? We do EVERY HOUR!!!
Shared Hosting | Managed Cloud | Dedicated Servers
Reply With Quote
  #177  
Old 08-23-2008, 01:19 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Quote:
Originally Posted by Emerson
Don,

Order id: #8127
Order status: Processed

Before I can do anything Emerson flashes in a $20 Paypal order and proves the Paypal order system of the cart is working again.

Of course, we will refund the $20

Again, thank you very much Emerson. I don't know how many times you have saved my bacon.

Did I tell you that EWDhosting.com is the very best home for your x-cart?

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #178  
Old 08-30-2008, 03:15 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Quote:
Originally Posted by intel352
Hi All, this issue is likely related to the version of XCSEO Pro (v1.1.5) that Don is using, it's "antiquated" compared to the current release of XCSEO Pro (v1.2.5). I'll be upgrading him later today and should be able to verify then that the bug was local to his module version.
Cheers

Just to put my section of this thread to bed, Jon fixed up my site, it was a problem with his mod. He has nursed me along for the last week, and everything is now fine with my 4.0.17 and PHP5.

Initially Qualiteam got me going, however I had to step the ticket up to hotrush, before I got a response. Emerson suspected what the problem was, and pointed me in the right direction.

So a big thank you to Qualiteam, Jon, and Emerson on this one.

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #179  
Old 10-26-2008, 12:00 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

My story continues on this one. I am now getting admin sql errors, but I am
unable to determine if it is again the result of Phpsitesolutions XCSEO
modification, or the update to PHP5. I have written to Jon many times over many
weeks, but to date, have not been unable to get a response.

Prior to this, Jon has been extremely helpful. Jon?

The error listed below takes place when I save a new item to products. The item
always adds, but I end up with the errors as listed below:

Any help appreciated. Cheers Don...

================================================== ================ Date :
01-Oct-2008 08:11:51 Site :
https://gsxr7.ewdhosting.com/~thewizar/dontronics-shop Request URI :
/~thewizar/dontronics-shop/admin/product_modify.php Remote IP : 220.239.97.136
Logged as : master SQL query : SELECT xcp2.* , MATCH (xcp2.`url_fulltext`)
AGAINST ('"w4r-flexel-1-preprogrammed-chip.html"' IN BOOLEAN MODE) +
IF(xcp2.`query_string` != "" AND xcp2.`query_string` IS NOT NULL, MATCH
(xcp2.`query_string`) AGAINST ('"0="'), 0) AS score FROM( xcart_phpss_xcseo xcp1
)LEFT JOIN xcart_phpss_xcseo xcp2 ON xcp1.`type` = xcp2.`type` AND
xcp2.`current` = 1 AND ( (xcp1.`non_real_id` IS NOT NULL AND
xcp1.`non_real_id`!="" AND xcp2.`non_real_id` = xcp1.`non_real_id`) OR
(xcp1.`real_file_target` IS NOT NULL AND xcp1.`real_file_target`!="" AND
xcp2.`real_file_target` = xcp1.`real_file_target` ) ) WHERE xcp1.`url` LIKE
"w4r-flexel-1-preprogrammed-chip.html" ORDER BY `current` DESC, score DESC,
`priority` DESC Error code : 1191 Description : Can't find FULLTEXT index
matching the column list Backtrace :
/home/thewizar/public_html/dontronics-shop/include/func.php:127
/home/thewizar/public_html/dontronics-shop/include/func.php:86
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/func.phpss_db.php:51
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/outputfilter.xcseo.php:555
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/administrative.xcseo.php:297
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/administrative.xcseo.php:117
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/admin.xcseo.php:134
/home/thewizar/public_html/dontronics-shop/modules/PHPSS_XCSEO/include.func_core.php:15
/home/thewizar/public_html/dontronics-shop/include/func.php:221
/home/thewizar/public_html/dontronics-shop/include/product_modify.php:545
/home/thewizar/public_html/dontronics-shop/admin/product_modify.php:43
/home/thewizar/public_html/dontronics-shop/phpss_xcseo.php:212
================================================== ===============
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
  #180  
Old 10-27-2008, 06:08 PM
 
donmck donmck is offline
 

Senior Member
  
Join Date: Dec 2005
Location: Australia
Posts: 137
 

Default Re: Upgrade your store

Ouch!!!

I just picked up on the messages in the thread at:
http://forum.x-cart.com/showpost.php?p=234012&postcount=111

Thanks Balinor, I better ponder which direction to head now.

Cheers Don...
__________________
Don McKenzie

http://www.dontronics-shop.com/
X-Cart 4.0.17 [Unix]

█ Hosting by www.totalserversolutions.com The very best home for your X-Cart. (was ewdhosting.com)
Reply With Quote
Reply
   X-Cart forums > General > General talk


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 06:59 PM.

   

 
X-Cart forums © 2001-2018