SP Medical Appointment Page Not Working
Aries
My appointment setup is not working can you take a look? https://calambadoctorshospital.com/index.php/component/spmedical/appointments
Ofi Khan
Accepted AnswerHello Aries,
Thank you for reaching out to our technical support forum. I’m sorry to hear about the trouble you’re experiencing. Rest assured, I will look into this issue for you and work to resolve it as quickly as possible.
If you could kindly provide any additional information regarding the issue, it would greatly help me investigate and address it more efficiently.
Please share your administrator access here to check the issue. Use the Hidden Content box to share the credentials. Make sure that you have a full site backup before sharing.
Best regards
Ofi Khan
Accepted AnswerYou are welcome 😊
You are using an old version of the extension. Please update your SP Medical extension and then check the issue.
Aries
Accepted AnswerHello, Ofi. I've updated the extension but still no luck. When I tried the appointment still the same issue of looping button https://prnt.sc/MuPOPpVuUMLg
Aries
Accepted AnswerI have updated the php and joomla, but still no luck. can you take a look again?
Ofi Khan
Accepted AnswerIt looks like a bug. I have also found this issue on my local environment. I will talk to the developer team about the bug. Then I will update you.
Ofi Khan
Accepted AnswerApology for the delayed response. I could not talk to the team because the component developer is out of office. Please allow me some more time. I will share your issue with the team tomorrow when the developer is present.
Ofi Khan
Accepted AnswerI have got a solution from the developer. I will check it on your site. Please share your database access in the hidden content.
Ofi Khan
Accepted AnswerYour mail fuction is not active. Please talk to your hosting provider to enable PHP mail function.
Ofi Khan
Accepted AnswerOkay, I am sharing the solution with you. Please run this SQL Query on your database. Make sure to include your database prefix instead of xxxxx
ALTER TABLE `xxxxx_spmedical_appointments`
ADD `choose_patient` TINYINT NOT NULL DEFAULT '1' AFTER `department_id`,
ADD `date_of_birth` DATE NULL DEFAULT NULL AFTER `choose_patient`,
ADD `patient_gender` VARCHAR(6) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'm' AFTER `date_of_birth`,
ADD `patient_address_street` VARCHAR(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `patient_gender`,
ADD `patient_address_city` VARCHAR(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `patient_address_street`,
ADD `patient_address_state` VARCHAR(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `patient_address_city`,
ADD `patient_address_zip_code` INT NULL DEFAULT NULL AFTER `patient_address_state`,
ADD `visiting_option` VARCHAR(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL AFTER `patient_address_zip_code`;Also, go to these locations:
components/com_spmedical/assets/js/spmedical.js
components/com_spmedical/models/appointments.php
components/com_spmedical/controllers/appointments.php
components/com_spmedical/views/appointments/tmpl/default.phpand replace files with the attached files. You need to unzip the files and then replace.
Ofi Khan
Accepted AnswerJust checking in to see if you have feedback on the provided solution. If the answer resolved your query, you can mark it as accepted to close the post and guide others with similar questions. You’ll find a button to accept answers below each comment.
If you need further assistance, feel free to let us know!
Aries
Accepted Answerbut now the Appointments tab in the dashboard has thousands of entries. why is it so? spam?
Ofi Khan
Accepted AnswerI have added a test appointment. It seems to be working.
Aries
Accepted Answeryes, I got that working. The SQL script sent should be of MODIFY and sety up SMTP as well. Finally got it to work. But we're still unsure if the form is being spammed.