SP Medical Appointment Page Not Working

Hello 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

You are welcome 😊

You are using an old version of the extension. Please update your SP Medical extension and then check the issue.

Okay, 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.php

and replace files with the attached files. You need to unzip the files and then replace.

spmedical.js.zip

appointments.php.zip

appointments.php.zip

default.php.zip

Just 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!