close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Big problems with fresh ps4.5 install

Thread began 8/02/2011 12:18 pm by martin400112 | Last modified 8/02/2011 3:36 pm by Jason Byrnes | 1153 views | 2 replies |

martin400112

Big problems with fresh ps4.5 install

Hi,

Where to begin?

Website: www.altonmodelcentre.co.uk

I purchased PS 4.5 yesterday to upgrade an existing PS 3 install and followed all of the instructions. Nothing worked at all and it failed to work a further 4 times. So I removed the entire existing shop and database as your blurb about PS4 boasts about a quick install.

This done, I then uploaded the site to the root directory of the server and followed every instruction I could find on your site and forums.

The site eventually uploaded and installed itself nicely and my client and I started making changes to the design and added some content straight after the install. All went smoothly until we logged out.

All the settings were added in correctly and saved.

We also added one category, two sub-categories and a couple of sub-sub-categories. One had a test product in it.

After logging out we looked at our test product, added it to the cart and went to check-out (we were not in Test Mode). The server returned with a Warning about the website's Security Certificate - was never a problem before the clean install - and then, when we clicked on 'Continue to this Page Anyway', cart.php apparently could not be found.

Then, trying to return to the home page, the site returns this message: 'Subquery returns more than 1 row'. In fact, every page returns the same message.

I cannot explain how annoying and embarassing this is to have happened when sitting *with* a client, unveiling their new website. It has taken over 36 hours to get to a point where it still doesn't work. PS4 has so far been a big disappointment.

The install directory has been deleted as requested and I am at a loss with a very grumpy client on my back and I do not know what to do or where an error lies.

So, there are 3 things here:

Firstly: Every why does every page return the 'Subquery returns more than 1 row' message and no other content.

Secondly: Why the site returns a Website Security Certificate warning when checking out.

Thirdly: Why the site will not allow a check out to complete via cart.php.

Please help at your earliest convenience.

Martin

Sign in to reply to this post

martin400112

UPDATE: Solved the 'Subquery returns more than 1 row' problem. The wa_settings table had a duplicate set of settings in it so I went through the table and deleted the duplicates.

HOWEVER....the site still crashes on check-out.

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

Sign in to reply to this post

Gizza372666

I have the same problem

I have removed the duplicated records and the first problem is fixed.
Now when I try to checkout, I receive the following error:
------------------------------
We're sorry

Your PayPal transaction could not be completed. Please return to checkout and try again.
-------------------------------
Please help

Sign in to reply to this post

Jason ByrnesWebAssist

in the Power Store admin settings section, enable debug mode.

this will output the session contents on the failure page and contain information about why the transaction is not going through.


NOTE: The session information will contain personal information that should be removed before posting it here.

Sign in to reply to this post

Gizza372666

here is the info

We're sorry



Debug Information

Disable debug mode in your admin settings before going live in order to hide this content.

array(11) { ["WAVT_ProductsResults_Errors"]=> string(0) "" ["WADbSearch1_Products_Category_Results"]=> string(0) "" ["orderAdd"]=> string(0) "" ["WA_Store_Cart_Items"]=> string(554) "2|WAECART|Heart Ring in Bilberry|WAECART|
Heart (fully adjustable) ring in "Bilberry" approximately 30 mm, in shades of rich purple and black, giving a beautiful contoured design, in Polyester Resin wi|WAECART|0|WAECART|1|WAECART|0.01|WAECART|d.jpg|WAECART|Heart Ring in 'Bilberry'|WAECART||WAECART|0|WAECART|0|WAECART|0|WAECART||WAECART||WAECART|1|WAECART|0|WAECART|0.01|WAECART|1 Heart Ring in Bilberry (2)|WAECART|0|WAECART|0.01|WAECART|0|WAECART|0|WAECART|0.01" ["WAEC_ContinueRedirect"]=> string(32) "/products_detail.php?ProductID=2" ["WA_Ecart_Coupon_ID"]=> NULL ["eCart_PPECO_System"]=> string(2) "US" ["PayPal_ECO_Token"]=> string(0) "" ["ECO_Auth_Request"]=> string(1372) "normaneames@yahoo.comCompleteSuccess1921DesigNE Jewellery63.0http://mydomain.com/pp_confirm.phphttp://mydomain.com/pp_cancel.phpSoleBilling0.010.01Heart Ring in Bilberry0.0112Authorization" ["ECO_Auth_Result"]=> string(2060) "2013-01-04T18:15:56ZFailurefc12ad1461e6dSecurity errorSecurity header is not valid10002Error63.04181146" ["WA_HTTPS_Redirect"]=> int(1357323343) }

Your PayPal transaction could not be completed. Please return to checkout and try again.

Sign in to reply to this post

Jason ByrnesWebAssist

so, the error being returned from paypal is:

Security errorSecurity header is not valid


this error means there is a problem with the Api details you entered.

double check the API credentials to make sure they are correct.

also, if the store is set to use the sandbox, make sure to use sandbox api credentials.

if the store is in live mode, you need to use live api credentials.

Sign in to reply to this post

Gizza372666

Still problem

Hi,
I managed to logon to my paypal with the username and password that I have added onto the powerstore but still the error is the same.
I can't understand.
Can you please help me?
what do you mean by 'if the store is in live mode, you need to use live api credentials. '
do you mean the paypal username 'email' and password?
Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

the api username and password are not the username and password you use to loginto your paypal account.

see the "Signing up with the PayPal payment gateway" tutorial on the learning resources page for details on obtaining the API Credentials for your account:
tutorials.php

Sign in to reply to this post

Gizza372666

last info

Thanks
Is done.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...