Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Error 500 when opening question in backend
(1 viewing) (1) Guest
component
Go to bottomPage: 12
TOPIC: Error 500 when opening question in backend
#63050
Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 0
I faced a strange issue after upgrade Ari Quiz. When I create any question in admin panel and save it and then try to open for editing I get error 500. I investigated DB tables and found in table ariquizquestionversion that questions created on old versions has structure in field "Data" like that:
Code:

<answers>
<answer id="58e3ab12085c69.43198081">kghsdfkjghjfsghas</answer>
<answer id="58e3ab12086d18.73755191" correct="true">lfkghskjghsdghsldgs</answer>
<answer id="58e3ab12087385.23931933">shsahdglsdhglashg</answer>
</answers>


But new versions (including latest 3.9.16) creates structure like that:
Code:

<?xml version="1.0" encoding="utf-8"?>
<answers><answer id="5ae8cecaa45d51.83029303"><0>hdfdhsd</0></answer><answer id="5ae8cecaa69711.58065869" correct="true"><0>dfhdsfds</0></answer><answer id="5ae8cecaa750f8.88023936"><0>fhsdfhd</0></answer></answers>


And when I manualy remove tags <0></0> - the questtion opens normally in backend.
So my question is how to resolve this problem?
The administrator has disabled public write access.
 
#63052
Re:Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 760
Hello,

The problem occurs because on old version of "ARI Quiz" was after upgrade PHP to v. 7.x on your server. Execute the following SQL query to fix this problem (we recommended to create DB backup before running the query):

UPDATE #__ariquizquestionversion SET Data = REPLACE(REPLACE(Data,'<0>', ''), '</0>', '') WHERE Data LIKE '%<0>%'

Just replace #__ with your DB prefix.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#63053
Re:Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 0
If I understand right it can fix some existing records created after upgrade, but what about new questions which I will create in future? Do you mean to execute sql query every time I created new question? I hope there should be another solution.
The administrator has disabled public write access.
 
#63054
Re:Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 760
The latest version of the extension doesn't have this problem. It saves new questions in correct format.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#63055
Re:Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 0
I speak about the latest version - 3.9.16 - it makes questions with wrong format. Just checked again - it does. May be you didn't publish the fixed version yet?
The administrator has disabled public write access.
 
#63056
Re:Error 500 when opening question in backend 6 Years, 6 Months ago Karma: 760
This fix was included a long ago (before v. 3.9.16). Could you provide a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12