database tables are not created

[nlagaros]

For some reason, the carddav tables are not created when I log in as a user for the first time in round cube with the plugin enabled. I see several errors that say various tables do not exist.

I just did try to create the tables manually, by running the init script (0000-dbini/mysql.sql), but got the following error: ERROR 1215 (HY000) at line 2: Cannot add foreign key constraint.

Any ideas?

[blind-coder]

That is very weird. Do you have a "users" table in the roundcube database?

[nlagaros]

Yes. The users table is there and populated when I logged on for a couple of users.

[blind-coder]

That's weird... It's literally the one table that gets referenced, so it should certainly work.
What's your db_prefix set to in the roundcube configuration?

[nlagaros]

it’s not set to anything — black.

On Oct 2, 2016, at 12:17 PM, Benjamin Schieder notifications@github.com wrote:

That's weird... It's literally the one table that gets referenced, so it should certainly work.
What's your db_prefix set to in the roundcube configuration?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #164 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/ABYwDzXU9a8yMd9eE51zXfb3wRcGhhzIks5qv9kZgaJpZM4KL_U0.

[blind-coder]

Very weird...
Can you try the following mysql.sql

mysql_noprefix.zip

[nlagaros]

Tables are now created, but think I have larger problems. I go to the carddav settings page in roundcube and get this: Your version of PHP is too old! Please update to at least 5.3.0! You got the following version installed: 5.6.24

[blind-coder]

Oh, that's apparently a bug. I have updated the required version to 7.0.0 but apparently the error message still points to 5.3.0. Oops...

[nlagaros]

So I need PHP 7? I’m running on a Mac / OS X 10.12 — I’d like to not have to update it, but let me know. Thanks.

On Oct 2, 2016, at 1:21 PM, Benjamin Schieder notifications@github.com wrote:

Oh, that's apparently a bug. I have updated the required version to 7.0.0 but apparently the error message still points to 5.3.0. Oops...

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #164 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/ABYwD9TatPI8gylR_uDEvX6Ula_jF2-mks5qv-gAgaJpZM4KL_U0.

[blind-coder]

You might not need PHP7, but it's the version I'm running and I don't have the capacities to test against earlier version.

[nlagaros]

I'm happy to test with the version I have.

On Oct 3, 2016, at 3:12 AM, Benjamin Schieder notifications@github.com wrote:

You might not need PHP7, but it's the version I'm running and I don't have the capacities to test against earlier version.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.

[blind-coder]

That would be great!

[nlagaros]

I just need to know where to disable the version check.

On Oct 3, 2016, at 6:59 AM, Benjamin Schieder notifications@github.com wrote:

That would be great!

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.

[blind-coder]

@nlagaros You can do it in the config.inc.php file.

[vrelk]

@blind-coder I had the same issues listed above. Your modified sql file worked, and disabling the version check also worked. My next problem is that the preset address book is not being added, and when I try to add it manually, I get a white page in settings after clicking save. If I go back, all the values are empty again and nothing was added to the DB.

PHP 5.5.9

[mstilkerich]

PHP 7.1 is required with v4. The version check has been removed, as the current code uses PHP 7.1 specific syntax that older versions won't be able to parse (and thus not be able to execute a runtime version check). PHP version is checked by composer though.