Local Test Server Fehler

[MacLeod]

[GERMAN]

Hallo Community,

ich hoffe Ihr könnte mir weiter helfen?

Ich habe Processwire bei meinen Webhosting Anbieter installiert ohne Probleme.

Nun wollte ich es bei meinen Local webserver (MAMP 4.1) installieren...

Leider zeigt er mir einen Datenbank fehler, dass er bestimmte Tabelle nicht finden kann!!!

(Siehe Bild)

Kann mir einer sagen, wodurch der Fehler verursacht wirt?

Habe es auch schon bei einen Kumpel und eine anderen Local Webserver Umgebung Installiert. Immer der Selbe Fehler.

Gruß

MacLeod

 

[ENGLISH]

Hello Community,

I hope you could help me further?

I have Processwire installed at my webhosting provider without any problems.

Now I wanted to install it on my local webserver (MAMP 4.1) ...

Unfortunately he shows me a database error that he can not find certain table !!!

(See image)

Can someone tell me what causes the error?

Have it already installed with a buddy and another Local Web server environment. Always the same mistake.

greeting

MacLeod

 

[Autofahrn]

Is k31648_cms-pro3 a local database? Looks like your local installation tries to communicate with the database of a webhoster.

[MacLeod]

Hi,
no, this is all local, I have only where it is possible to use the same user names and database names, as with my hoster.

greeting

MacLeod

[wbmnfktr]

Check the .sql file that's in your PW site profile.

There might be date ranges similar to 0000-00-00 00:00.

Change them to something like 2019-01-01 11:22.

Then go to your phpMyAdmin or whatever tool you use in your setup and delete everything in your database.

Either import the .sql file manually or try another clean install.

I have had that issue before with several profiles created with the Site Profile Export module I wanted to set up locally (within Laragon). Maybe that's similar to your case and setup even though you are using MAMP.

[MacLeod]

Hi,
in the SQL file = /site/config.php is nothing with date range drine.
I just installed another site profile (Blank),
comes the same mistake.
I deleted everything in DB and reinstalled everything.
But the mistake keeps coming up.

greeting

MacLeod

[wbmnfktr]

I meant the install.sql file within /site-profile-name/install/.

But as the blank profile doesn't work either you want to try this...

In /install.php you will find const TEST_MODE = false; (around line 55) - change this to true and try again.
It will not install anything but tell you possible problems while it tries to do all the install-magic. 

Another thing could be the whole setup.

Which ProcessWire (2.7?), PHP and MySQL version do you use? Maybe there is something... odd.

 

[MacLeod]

Hi,

I have applied your proposal. And the mistake is gone.

But just before the end, another mistake comes:

1. 

Error: Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'k31648_cms-pro3.pages' doesn't exist (in E:\Local Webserver\mamp\html\wire\core\Pages.php line 2103)

This error message was shown because /install.php still exists. Error has been logged.

But that's probably because the Install.php is still available.

But if I remove the file Install.php another error comes up:

2.

Error: Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'k31648_cms-pro3.pages' doesn't exist (in E:\Local Webserver\mamp\html\wire\core\Pages.php line 2103)

This error message was shown because Superuser has never logged in. Error has been logged.

 

greeting

MacLeod

 

[Autofahrn]

I'd focus on the first errors which state: invalid default for 'created'. Not sure for PW2.7 installs (any reason to not use PW3?), but for PW3 the created fields defined like this (in install.sql):

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

Maybe the SQL engine of your MAMP can't deal with the specifications in those older import files and you'll need to adjust them.