[URGENT] Error on last page of checkout

[Guest]

http://www.russellcampbellracing.co.za/store/index.php

 

The site works 100% except on the last page during checkout there is an error:

 

---------------------------------------------

Billing Address (Edit)

 

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /usr/www/users/russelh/store/includes/functions/general.php on line 42

 

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /usr/www/users/russelh/store/includes/functions/general.php on line 42

Payment Method (Edit)

Online Transfer / Bank Deposit

----------------------------------------------

 

I have a feeling it has to do with the customers address. Feel free to reproduce the error on the site --url is above.

 

I dont even know where to start looking for a solution.

 

Xenlab

[impulsive]

I had the same problem. If you were working on your Countrys and Country codes after your test account was created, more then likely something in your address broke.

 

In my case, when 'as the user' I edited my address book information, I had no country selected.. As soon as that was fixed, your error below fixed itself up. (Any account created now, will have no issues as well)

[Just figured I'd sign up and let you know what I found myself here today]

 

 

http://www.russellcampbellracing.co.za/store/index.php

 

The site works 100% except on the last page during checkout there is an error:

 

---------------------------------------------

Billing Address (Edit)

 

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /usr/www/users/russelh/store/includes/functions/general.php on line 42

 

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /usr/www/users/russelh/store/includes/functions/general.php on line 42

Payment Method (Edit)

Online Transfer / Bank Deposit

----------------------------------------------

 

I have a feeling it has to do with the customers address. Feel free to reproduce the error on the site --url is above.

 

I dont even know where to start looking for a solution.

 

Xenlab

[sonictrip.net]

I had the same problem. If you were working on your Countrys and Country codes after your test account was created, more then likely something in your address broke.

 

In my case, when 'as the user' I edited my address book information, I had no country selected.. As soon as that was fixed, your error below fixed itself up. (Any account created now, will have no issues as well)

[Just figured I'd sign up and let you know what I found myself here today]

 

Im not getting the htmlspecialcharacters error coming up anymore, just no address at all under delivery and billing address, what the hell?

When i go into a customers account in the admin end, none of their details are there incl. name, address, everything, yet when you place an order, it is recording all the info in the db, just not displaying it in the admin end at all.

Would anyone even know what files to replace? Ive tried replacing loads of files but still nothing... :angry:

[sonictrip.net]

Im not getting the htmlspecialcharacters error coming up anymore, just no address at all under delivery and billing address, what the hell?

When i go into a customers account in the admin end, none of their details are there incl. name, address, everything, yet when you place an order, it is recording all the info in the db, just not displaying it in the admin end at all.

Would anyone even know what files to replace? Ive tried replacing loads of files but still nothing... :angry:

 

Ok, after hours of searching ive finally found out how to fix the address problem. It's a db issue as far as i can tell (although some files have been replaced along the way like general.php orders.php html_output.php) but i think this is the main step to get the addresses showing:

 

If you have a backup of your db (obviously u do) then load it into Word pad or something like that. Copy and paste the info separately for your "customers" table and the "address_book" table and execute the SQL in phpMyAdmin. Make sure you copy all the values incl. customers details, not just the table info...

 

I recreated the table info a couple of times which did nothing, it wasnt til i deleted all the customers accounts by accident that i noticed it fixed it when i restored those 2 tables with all their values in them...

 

This should fix the problem! :thumbsup: