search

fmido88 / moodle-enrol_wallet

Enrollment using wallet credit with coupons and using payments gateways with restrictions.
Other
4 stars 1 forks source link

Transaction error #28

Closed chyntori closed 4 months ago

chyntori commented 5 months ago

Whenever transaction happened, error show. It may be due to my openlitespeed server, mariadb or php setting. Please help solve this error. Below is some screenshot. I am trying to add some credits to a user 1 Screenshot from 2024-06-01 16-14-53 2 Screenshot from 2024-06-01 16-15-03 3 This error showed. Screenshot from 2024-06-01 16-15-11 4 clicking more information leads to this page. Screenshot from 2024-06-01 16-15-34 5 Here i am trying to purchase the course Screenshot from 2024-06-01 16-19-59 6 Screenshot from 2024-06-01 16-20-21 7 Screenshot from 2024-06-01 16-20-33 8 clicking continue lead here. Screenshot from 2024-06-01 16-20-43

when adding credits. It shows error but credits got added nonetheless. but when purchasing, credits got deducted but course is not purchased.

chyntori commented 5 months ago

regarding the help page at page 4, I have change the max_allowed_packet and max_binlog_cache_size to 1G and 4G respectively at /etc/mysql/mariadb.conf.d/50-server.cnf on my ubuntu 24.04 vps on hostinger.

Buda9 commented 5 months ago

Hey @chyntori, regarding first screenshot, value can't be that large. Try without last zero

fmido88 commented 4 months ago

Thank you @chyntori for reporting this The error corresponding to database error related to the number of digits in the numbers

In the next update I'll modify the DB tables structure to allow the fields of costs and balances to sustain more digits.

For the second error about missing parameter that happen because of the first error then redirect again to the confirmation page but without the parameters, if the first error fixed, the second will be fixed too.

I'll upload the new fixed version soon.

chyntori commented 4 months ago

Dear Sir, I have no more error about "error writing to database" again after update. But I still can't purchase a course. This time when I tried to purchase a course the picture 8 showed up immediately, saying a required parameter (id) was missing.