This Help forum is for issues relates to the latest release (1.7.9). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

TOPIC: [SOLVED] Installation problem macosx

Installation problem macosx 4 months 1 week ago #1

  • JSchmid
  • JSchmid's Avatar
  • Offline
  • New
  • Posts: 4
hi,

during webtrees setup the following error message is thrown.

Fatal error: Uncaught ErrorException: Cannot modify header information - headers already sent by (output started at /Users/jochen/Sites/webtrees/setup.php:70) in /Users/jochen/Sites/webtrees/app/Database.php:315 Stack trace: #0 [internal function]: Fisharebest\Webtrees\{closure}(2, 'Cannot modify h...', '/Users/jochen/S...', 315, Array) #1 /Users/jochen/Sites/webtrees/app/Database.php(315): header('Location: site-...') #2 /Users/jochen/Sites/webtrees/setup.php(466): Fisharebest\Webtrees\Database::updateSchema('\\Fisharebest\\We...', 'WT_SCHEMA_VERSI...', 30) #3 {main} thrown in /Users/jochen/Sites/webtrees/app/Database.php on line 315

Any idea whats going wrong?

Thanks Jochen

MySQL 8.0.11
PHP Version 7.1.6
macOS 10.13.5
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #2

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Gold
  • Greetings from Utrecht, Holland
  • Posts: 1454
Bigger chance if we know what the "..." you showed is expanded. Do you have access to a log file?

Nb: I see i your signature: php7.1
Current version of webtrees 1.7.9 was released when php7.1 did not even exist.
So please stay with php7.0 until webtrees 2.0 is released.
stamboom.BertKoor.nl runs on webtrees v1.7.9
Last Edit: 4 months 1 week ago by bertkoor.
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #3

  • JSchmid
  • JSchmid's Avatar
  • Offline
  • New
  • Posts: 4
PHP 7.1 is already loaded in the build of macOS 10.13.5.
I am afraid I have to wait until webtrees 2.0 is released.
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
webtrees should (mostly) work with PHP 7.1. There are a few known issues, such as the upgrade wizard won't work.

The setup scripts are designed to be failsafe, and never error.
However, you are getting an error, and the actual error message isn't being displayed.

(You are seeing a message that effectively says that webtrees failed to show the error message).

Can you edit the file app/Database.php and delete these two lines:

github.com/fisharebest/webtrees/blob/1.7...tabase.php#L314-L315

The result will (I hope) be a more informative error message.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #5

  • JSchmid
  • JSchmid's Avatar
  • Offline
  • New
  • Posts: 4
Hi Greg,

new error message, hope this helps.

Setup wizard for webtrees
An unexpected database error occurred.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'SQL_CACHE' in 'field list'
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
That's a problem in MySQL8.

webtrees uses the keywords SQL_CACHE and SQL_NO_CACHE.

In MySQL8, these are not used. The documentation says they are ignored:
dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-3.html

However, only one is ignored, the other gives an error.

I already created a fix for this: github.com/fisharebest/webtrees/commit/5...daed4b3acdbe6af47e55

Your best option is to download the latest code from the 1.7 branch (github.com/fisharebest/webtrees/archive/1.7.zip) and unzip it over your current installation
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Installation problem macosx 4 months 1 week ago #7

  • JSchmid
  • JSchmid's Avatar
  • Offline
  • New
  • Posts: 4
Great job.
Thanks for your help. Downgrading to MySQL 5.7.22 solved the MySQL8 issue
The administrator has disabled public write access.

[SOLVED] Installation problem macosx 4 months 1 week ago #8

  • JSchmid
  • JSchmid's Avatar
  • Offline
  • New
  • Posts: 4
Problem solved.
The administrator has disabled public write access.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 
Powered by Kunena Forum