Ubuntu 16.4 LTS
MySQL Ver 14.14 Distrib 5.7.16
PHP 5.6
Error at login as user:
Cannot execute query.
SELECT DISTINCT ucfg_name FROM userconfig_ucfg WHERE ucfg_per_id = 0 AND ucfg_cat = 'SECURITY' ORDER by ucfg_id
Expression #1 of ORDER BY clause is not in SELECT list, references column 'churchinfo.userconfig_ucfg.ucfg_id' which is not in SELECT list; this is incompatible with DISTINCT
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm going to recommend moving to the very latest 1.3.0, available on our web site toward the lower-right corner. The only additional changes will be bug fixes. This latest release has already been labeled 1.3.0 and it will upgrade an existing 1.2.14 database automatically.
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:
New results:
mysql error while upgrading database:
Invalid default value for 'plg_DateLastEdited'
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.
SELECT * FROM version_ver ORDER BY ver_ID DESC
ChurchInfo mysql Version = 1.2.14
ChurchInfo PHP Version = 1.3.0
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.
About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.
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:
I received a fresh computer and installed MySQL, PHP and phpMyAdmin on Ubuntu 16.4 LTS. After that I copied my churchinfo directory to the new box created a churchinfo database using phpMyAdmin then imported the data from my old system via SQL dump. This was where I started having problems with the application.
I can remote into my home system during the day so I can provide you with feedback relatively quickly.
David FullerCountryside Bible ChurchPeculiar, Missouri
On Tuesday, January 3, 2017 12:20 PM, Michael Wilt <mikewiltwork@users.sf.net> wrote:
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.MikeMichael Wilt
ChurchInfo Team LeaderLogin Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Original, current production, is on mysql ver 14.14 distrib 5.5.53 on Ubuntu 14.04 LTS
On Tuesday, January 3, 2017 1:57 PM, djfkc <djfkc@users.sf.net> wrote:
I received a fresh computer and installed MySQL, PHP and phpMyAdmin on Ubuntu 16.4 LTS. After that I copied my churchinfo directory to the new box created a churchinfo database using phpMyAdmin then imported the data from my old system via SQL dump. This was where I started having problems with the application.
I can remote into my home system during the day so I can provide you with feedback relatively quickly.
David FullerCountryside Bible ChurchPeculiar, Missouri On Tuesday, January 3, 2017 12:20 PM, Michael Wilt mikewiltwork@users.sf.net wrote:
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.MikeMichael Wilt
ChurchInfo Team LeaderLogin Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Login Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
What is the version of MySQL on the new server? I assume the data importing went ok and the error showed up when you tried to log in? Please contact me using the "Contact Us" link on our main web site www.churchdb.org.
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:
Ubuntu 16.4 LTS
MySQL Ver 14.14 Distrib 5.7.16
PHP 5.6
Error at login as user:
Cannot execute query.
SELECT DISTINCT ucfg_name FROM userconfig_ucfg WHERE ucfg_per_id = 0 AND ucfg_cat = 'SECURITY' ORDER by ucfg_id
Expression #1 of ORDER BY clause is not in SELECT list, references column 'churchinfo.userconfig_ucfg.ucfg_id' which is not in SELECT list; this is incompatible with DISTINCT
I'm going to recommend moving to the very latest 1.3.0, available on our web site toward the lower-right corner. The only additional changes will be bug fixes. This latest release has already been labeled 1.3.0 and it will upgrade an existing 1.2.14 database automatically.
Mike
Michael Wilt
ChurchInfo Team Leader
Not to hijack the thread, but is there an easy way to upgrade from 1.2.12 to 1.3.0?
New results:
mysql error while upgrading database:
Invalid default value for 'plg_DateLastEdited'
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.
SELECT * FROM version_ver ORDER BY ver_ID DESC
ChurchInfo mysql Version = 1.2.14
ChurchInfo PHP Version = 1.3.0
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.
About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.
Mike
Michael Wilt
ChurchInfo Team Leader
I received a fresh computer and installed MySQL, PHP and phpMyAdmin on Ubuntu 16.4 LTS. After that I copied my churchinfo directory to the new box created a churchinfo database using phpMyAdmin then imported the data from my old system via SQL dump. This was where I started having problems with the application.
I can remote into my home system during the day so I can provide you with feedback relatively quickly.
David FullerCountryside Bible ChurchPeculiar, Missouri
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.MikeMichael Wilt
ChurchInfo Team LeaderLogin Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Original, current production, is on mysql ver 14.14 distrib 5.5.53 on Ubuntu 14.04 LTS
I received a fresh computer and installed MySQL, PHP and phpMyAdmin on Ubuntu 16.4 LTS. After that I copied my churchinfo directory to the new box created a churchinfo database using phpMyAdmin then imported the data from my old system via SQL dump. This was where I started having problems with the application.
I can remote into my home system during the day so I can provide you with feedback relatively quickly.
David FullerCountryside Bible ChurchPeculiar, Missouri On Tuesday, January 3, 2017 12:20 PM, Michael Wilt mikewiltwork@users.sf.net wrote:
Yes- upgrading from any recent release just requires installing the new PHP source and transferring settings in Include/Config.php.About the upgrade error- was this database coming from an earlier version of MySQL? I don't see how to get this error from the upgrade process. Please contact me offline for more help troubleshooting.MikeMichael Wilt
ChurchInfo Team LeaderLogin Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Login Error after copying to new serverSent from sourceforge.net because you indicated interest in https://sourceforge.net/p/churchinfo/discussion/401180/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
What is the version of MySQL on the new server? I assume the data importing went ok and the error showed up when you tried to log in? Please contact me using the "Contact Us" link on our main web site www.churchdb.org.
Mike
Michael Wilt
ChurchInfo Team Leader