New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't complete install -- Array to string conversion #272

Closed
olegsemgem opened this Issue Aug 21, 2017 · 6 comments

Comments

Projects
None yet
3 participants
@olegsemgem

olegsemgem commented Aug 21, 2017

I'm trying to complete the steps on install.php. At the end of the wizard, when I push the button to setup my tracker, I'm taken back to install.php and have to start from the beginning.

The error log contains errors like the following:

10:27:23 08/21/17 [debug] Query: SELECT * FROM owa_site WHERE domain = 'https://myservice.example.org'    LIMIT 1 
10:27:23 08/21/17 [debug] <errorentry>
	<datetime>2017-08-21 10:27:23 (PDT)</datetime>
	<errornum>8</errornum>
	<errormsg>Array to string conversion</errormsg>
	<scriptname>{my-owa-path}\plugins\db\owa_db_mysql.php</scriptname>
	<scriptlinenum>220</scriptlinenum>
</errorentry>

I'm running on IIS with PHP 7.1.7, and AWS RDS MySql.

Any help would be appreciated!

@olegsemgem olegsemgem changed the title from Can't complete install -- Array to string conversio to Can't complete install -- Array to string conversion Aug 21, 2017

@abousselmi

This comment has been minimized.

Show comment
Hide comment
@abousselmi

abousselmi Aug 22, 2017

Which type of encoding you are using in your database?

abousselmi commented Aug 22, 2017

Which type of encoding you are using in your database?

@olegsemgem

This comment has been minimized.

Show comment
Hide comment
@olegsemgem

olegsemgem Aug 22, 2017

When I issue:

SHOW VARIABLES LIKE '%colla%';
SHOW VARIABLES LIKE '%char%';

I get:

collation_connection    utf8_general_ci
collation_database    latin1_swedish_ci
collation_server    latin1_swedish_ci

character_set_client    utf8
character_set_connection    utf8
character_set_database    latin1
character_set_filesystem    binary
character_set_results    utf8
character_set_server    latin1
character_set_system    utf8
character_sets_dir   ...

I've also tried with:

collation_connection    utf8_general_ci
collation_database    utf8_general_ci
collation_server    utf8_general_ci

character_set_client    utf8
character_set_connection    utf8
character_set_database    utf8
character_set_filesystem    binary
character_set_results    utf8
character_set_server    utf8
character_set_system    utf8
character_sets_dir   ...

The issue persists either way, though!

olegsemgem commented Aug 22, 2017

When I issue:

SHOW VARIABLES LIKE '%colla%';
SHOW VARIABLES LIKE '%char%';

I get:

collation_connection    utf8_general_ci
collation_database    latin1_swedish_ci
collation_server    latin1_swedish_ci

character_set_client    utf8
character_set_connection    utf8
character_set_database    latin1
character_set_filesystem    binary
character_set_results    utf8
character_set_server    latin1
character_set_system    utf8
character_sets_dir   ...

I've also tried with:

collation_connection    utf8_general_ci
collation_database    utf8_general_ci
collation_server    utf8_general_ci

character_set_client    utf8
character_set_connection    utf8
character_set_database    utf8
character_set_filesystem    binary
character_set_results    utf8
character_set_server    utf8
character_set_system    utf8
character_sets_dir   ...

The issue persists either way, though!

@abousselmi

This comment has been minimized.

Show comment
Hide comment
@abousselmi

abousselmi Aug 24, 2017

I compared to my running mysql instance, it seems that encoding is ok. Which version mysql and php you are running? Mine are: mysql 5.7.19 and php 7.0.22

abousselmi commented Aug 24, 2017

I compared to my running mysql instance, it seems that encoding is ok. Which version mysql and php you are running? Mine are: mysql 5.7.19 and php 7.0.22

@olegsemgem

This comment has been minimized.

Show comment
Hide comment
@olegsemgem

olegsemgem Aug 24, 2017

I've switched off RDS for now, and am using a docker MySql container with the following version:

mysql -V
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper

PHP is 7.17

Still having the same problem, even with the new MySql. I'll try a different version of PHP next.

olegsemgem commented Aug 24, 2017

I've switched off RDS for now, and am using a docker MySql container with the following version:

mysql -V
mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper

PHP is 7.17

Still having the same problem, even with the new MySql. I'll try a different version of PHP next.

@padams

This comment has been minimized.

Show comment
Hide comment
@padams

padams Oct 26, 2017

Owner

Try the new code in master. I've added a query that will disable the strict sql mode that is now on by default in mysql 5.7.

Owner

padams commented Oct 26, 2017

Try the new code in master. I've added a query that will disable the strict sql mode that is now on by default in mysql 5.7.

@padams padams closed this Feb 21, 2018

@padams

This comment has been minimized.

Show comment
Hide comment
@padams

padams Feb 21, 2018

Owner

assuming this fix worked. if not reopen.

Owner

padams commented Feb 21, 2018

assuming this fix worked. if not reopen.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment