While upgrading to the new version, I received the following error message. Any suggestions?
MySQL error while upgrading database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE autopayment_aut ADD aut_CreditCardVanco text NULL' at line 1
You are seeing this message because you have encountered a software bug.
Please post to the ChurchInfo help forum for assistance. The complete query is shown below.
ALTER IGNORE TABLE autopayment_aut ADD aut_CreditCardVanco text NULL
ChurchInfo MySQL Version = 1.2.13
ChurchInfo PHP Version = 1.2.14
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The PHP team is moving faster than the ChurchInfo team! Please try editing the file AutoUpdate/Update1_2_13To1_2_14.php like this:
Remove "IGNORE" wherever it appears.
You should be able to log in again and it will try to upgrade again. If this gives you touble please contact me directly using the "contact us" link on our web page www,churchdb.org. I can help you fix this.
Mike
Michael Wilt
ChurchInfo Team Leader
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
While upgrading to the new version, I received the following error message. Any suggestions?
MySQL error while upgrading database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE autopayment_aut ADD
aut_CreditCardVanco
text NULL' at line 1You are seeing this message because you have encountered a software bug.
Please post to the ChurchInfo help forum for assistance. The complete query is shown below.
ALTER IGNORE TABLE autopayment_aut ADD
aut_CreditCardVanco
text NULLChurchInfo MySQL Version = 1.2.13
ChurchInfo PHP Version = 1.2.14
By the way, my host is running MySQL 5.7.13
The PHP team is moving faster than the ChurchInfo team! Please try editing the file AutoUpdate/Update1_2_13To1_2_14.php like this:
Remove "IGNORE" wherever it appears.
You should be able to log in again and it will try to upgrade again. If this gives you touble please contact me directly using the "contact us" link on our web page www,churchdb.org. I can help you fix this.
Mike
Michael Wilt
ChurchInfo Team Leader