Return Authorization Module (RMA)

I must be missing something because although I'm showing the mod in my define_page editor, I don't see any addition to my returns page. Is there something I need to turn on for it to appear?

Please look here

Never mind, I found it. Duh....just had to add the new Define to my information sidebox. Now does anyone know which file to edit to change the words Shipping & Returns to just Shipping in the information sidebox?

Thanks

After installing this mod, I attempted to change the email address on a customers account from the Admin but I receive the following error message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if (() > 0) { and customers_id != '6'' at line 4
in:
[select customers_email_address from zen_customers where customers_email_address = 'REMOVED######################' if (() > 0) { and customers_id != '6']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Where would I correct this? Also, I'm using the current version 1.37 of Zencart.

Thanks for your help

Quote:

---

Originally Posted by Robbyn7

After installing this mod, I attempted to change the email address on a customers account from the Admin but I receive the following error message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if (() > 0) { and customers_id != '6'' at line 4
in:
[select customers_email_address from zen_customers where customers_email_address = 'REMOVED######################' if (() > 0) { and customers_id != '6']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Where would I correct this? Also, I'm using the current version 1.37 of Zencart.

Thanks for your help

---

Un-install the mod and then try changing the e-mail address again.

I have a strange problem, I have had this installed for some time now and I just tested it, good thing I did!! When login in another customers address shows up!! Strange thing is that it is ONLY wrong on the return authorization page....my account it right, new orders are right all the other places where my address would show up is correct, but it is wrong on the RA . Oh and the house #, street, city, state and zip are the only things wrong.

Any idea why this is happening?

Thanks

Quote:

---

Originally Posted by helpme

I have a strange problem, I have had this installed for some time now and I just tested it, good thing I did!! When login in another customers address shows up!! Strange thing is that it is ONLY wrong on the return authorization page....my account it right, new orders are right all the other places where my address would show up is correct, but it is wrong on the RA . Oh and the house #, street, city, state and zip are the only things wrong.

Any idea why this is happening?

Thanks

---

this bug has been fixed. download the latest version from the downloads section.

Thanks Clyde for the reply. I un-installed the module and re-installed to the latest one but I'm still receiving the 1064 error.

Any other suggestions?

Thanks.

Quote:

---

Originally Posted by Robbyn7

Thanks Clyde for the reply. I un-installed the module and re-installed to the latest one but I'm still receiving the 1064 error.

Any other suggestions?

Thanks.

---

1) Un install the contribution. Don't re-install it yet.

I'm not sure why the mod would be causing this error since it doesn't call anything connected with a customer e-mail address from the admin.

2) try changing the e-mail address ( if you receive the error then you'll know it had nothing to do with the mod but lies somewhere else.

I tried this fix but the auto fill for the address is not working. I was having the same problem with the auto fill putting in a users address other than the user who is requesting the RA. So i tired this fix now the form does not auto fill

Quote:

---

Originally Posted by clydejones

Try this fix: I've checked it on each address I have and the come up correct.

Attachment 1984


Just unzip the and upload the includes folder to your server.

---

Quote:

---

Originally Posted by lextechs

I tried this fix but the auto fill for the address is not working. I was having the same problem with the auto fill putting in a users address other than the user who is requesting the RA. So i tired this fix now the form does not auto fill

---

I just created an account on the site, went to the returns page and lo and behold, there was my name and address all auto filled in and correct.