#241 Database upgrade bug

[Harold Underwood]

upgrade an exsisting database and got the following error.

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.

UPDATE events_event SET event_end='1970-01-01 00:00:00' WHERE event_end='0000-00-00 00:00:00';

ChurchInfo mysql Version = 1.2.13
ChurchInfo PHP Version = 1.3.0
harold@red3:~$ Table 'churchinfo.donateditem_di' doesn't exist

[Michael Wilt]

The table donateditem_di should have been created at version1.2.12. These tables were added to support the fundraiser feature in 1.2.12:
paddlenum_pn
fundraiser_fr
donateditem_di
multibuy_mb

You can create any that are missing by running the relevant SQL un phpMyAdmin.

Mike

Michael Wilt
ChurchInfo Team Leader

[Harold Underwood]

Mike,

Thanks for the quick reply and all your help. I was able to bring the
system up and thus far it looks like it working OK.

That was a great suggestion to use phpMyAdmin to add/delete those tables.

On the table "donateditem_di", I had to remove a column
"donateditem_di". phpMyAdmin made it easy.

Harold....

On Tue, Sep 18, 2018 at 9:34 AM Michael Wilt mikewiltwork@users.sourceforge.net wrote:

The table donateditem_di should have been created at version1.2.12. These
tables were added to support the fundraiser feature in 1.2.12:
paddlenum_pn
fundraiser_fr
donateditem_di
multibuy_mb

You can create any that are missing by running the relevant SQL un
phpMyAdmin.

Mike

Michael Wilt
ChurchInfo Team Leader

---

• [bugs:#241] https://sourceforge.net/p/churchinfo/bugs/241/ Database
  upgrade bug*

Status: open
Group: v1.0_(example)
Created: Tue Sep 18, 2018 12:32 AM UTC by Harold Underwood
Last Updated: Tue Sep 18, 2018 12:32 AM UTC
Owner: nobody

upgrade an exsisting database and got the following error.

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.

UPDATE events_event SET event_end='1970-01-01 00:00:00' WHERE
event_end='0000-00-00 00:00:00';

ChurchInfo mysql Version = 1.2.13
ChurchInfo PHP Version = 1.3.0
harold@red3:~$ Table 'churchinfo.donateditem_di' doesn't exist

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/churchinfo/bugs/241/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

--
Harold Underwood