| Author |
 Topic  |
|
|
vaheh
VP-CART New User
USA
115 Posts |
 Posted - December 07 2016 : 12:33:05
|
Hi,
Are you getting an error when clicking on RMA link through the website backed?
The error is Generic and does not provide any detail.
|
Edited by - vaheh on December 07 2016 13:30:07 |
|
|
danielrichardson
VP-CART Super User
Australia
276 Posts |
Posted - December 08 2016 : 05:48:09
|
There is no error msg like "Unauthorized Administrator" or "Shop Error" or a blank page?
And what''s ure steps until you got the error? |
 |
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - December 08 2016 : 18:13:32
|
what''s your store version? if you''re using version 8 try to update to the latest. i can''t replicate with installation
*peace - serj* |
|
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - December 09 2016 : 11:44:58
|
I tried 8.1.3 and 8.1.5 and both are getting the same error. The error comes from SQL statement. I will post the detail of it later.
Once I login I just click on RMA from the left Menu. nothing else.
|
|
|
|
support
Administrator
4679 Posts |
Posted - December 12 2016 : 22:31:45
|
Dear Vaheh,
I just tried using our latest pack, and the accessing the page : admin/shopa_rmadisplay.asp
There is no such error.
What database you are using (Access/SQL DB/MYSQL) ?
Please also provide screenshot on how the error looks like.
Thanks
VPCART FORUM ADMIN
|
|
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - December 13 2016 : 13:03:46
|
Hi,
DB is MSSQL.
If inside shopa_rmadisplay.asp I change the following lines then it works:
1-If I comment this line: searchfieldname = "rmaid" then searchfieldname = "shoprma.rmaid"
2-If I change mysql = mysql & " order by shoprma." & sortfield & " " & sortupdown
>>TO>>
mysql = mysql & " order by " & sortfield & " " & sortupdown
The problem is SQL error related to shoprma. |
|
|
|
support
Administrator
4679 Posts |
Posted - December 13 2016 : 20:13:24
|
Dear Vaheh,
Unfortunately, I have tried RMA in our very latest version v8.1.0.6 and it is working fine without any error.
The file admin/shopa_rmadisplay.asp also still use the same SQL before your change and it is just working here.
Please see the testing I have done using SQL DB in our localhost, I also write out the SQL syntax in the page so you can see the SQL :
http://www.screencast.com/t/akTmMcalL32
Would you mind posting your issue into our helpdesk ticket at https://helpdesk.vpasp.com/ and provide us your FTP and site admin details and we will check for you.
Thanks
VPCART FORUM ADMIN |
|
|
|
support
Administrator
4679 Posts |
Posted - December 13 2016 : 20:24:31
|
Dear Vaheh,
Just a follow up, I would suggest you to download very latest v8.1.0.6 as this has been fixed in the latest version.
Or you can try below solution :
1. Open file admin$db.asp in your admin folder.
2. Locate this code :
(around line 845-850)
on error resume next
rstemp.Open mysql2,dbc,adOpenKeyset,adLockReadOnly, adCmdText
if err.number <> 0 then
shoperror getlang("langrestart")
end if
on error goto 0
3. Please replace to :
on error resume next
rstemp.Open mysql2,dbc,adOpenKeyset,adLockReadOnly, adCmdText
if err.number <> 0 then
''800 - 2016.11.09 - Better handling on SQL Query if xSQL05Above set to Yes
if lcase(xSQL05Above) = "yes" then
mysql2 = mysql
on error goto 0
on error resume next
rstemp.Open mysql2,dbc,adOpenKeyset,adLockReadOnly, adCmdText
if err.number <> 0 then
shoperror getlang("langrestart")
end if
else
shoperror getlang("langrestart")
end if
end if
on error goto 0
4. Save the file, upload back to your site and test.
Thanks
VPCART FORUM ADMIN |
|
|
|
vaheh
VP-CART New User
USA
115 Posts |
Posted - December 15 2016 : 16:22:17
|
Hi VPCART,
I changed the code per your instruction and it works. Thanks.
Merry Christmas and Happy New Year.
|
|
|
| |
Topic |
|
All Forums
Error on clicking on RMA link
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
