Jump to content

Recommended Posts

[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

 

DB FEHLER.png

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

  • Like 2

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By modifiedcontent
      I had upgraded my Apache configuration to include PHP7.2 and PHP7.3 for a Laravel-based script on the same server. Somehow it/I messed up a previously fine Processwire site, in a very confusing way.
      The site still looks fine, but editing template files has no effect whatsoever. It is stuck on some kind of cached version. I have already disabled PHP7's OPcache, cleared browser caches, etc, with no effect.
      The pages now apparently come from PW's assets/cache/FileCompiler folder, even though I never enabled template caching for this site.
      I have tried adding "namespace ProcessWire;" to the top of the homepage template file, but then I get this fatal error:
      My functions.php file pulls data in from another Processwire installation on the same VPS with the following line:
      $othersitedata = new ProcessWire('/home/myaccount/public_html/myothersite/site/', 'https://myothersite.com/'); That apparently still works fine; the site still displays data from the other installation, but via the "cached" template that I am now unable to change.
       
      I don't know where to start with this mess. Does any of this sound familiar to anyone? Any pointers in the right direction would be much appreciated. 
       
      Edit:
      Adding "$config->templateCompile = false;" to config.php results in the same fatal error as above. 
    • By gnanasekar
      Hello All,
      Hope all doing good, I am a newbie to processwire. I have an issue please help me out!!!
      Here is my question:
      I have two usernames with one email apparently. when rebuilding my Jenkins server, I get a failed to authenticate and now I cannot reset the password of the other account. Any help would be appreciated.
      Thanks
    • By FrancisChung
      I was wondering if anyone has used AMPPS before? Seems like a decent MAMP replacement for Ubuntu, but I'm wondering if anyone can give their take or experiences on it.
       
    • By DamegoGmbH
      Hi there,
      we are a small Communication Agency in Munich and we are searching for a Processwire Developer.
      A lot of our Online Projects are based on Processwire and our current Developer is switching from Freelance to a full term job.
      The work can be done remotely from anywhere.
      For more Informations please contact me directly via Email: p.kirschvink@damego.de
      Looking forward to hear from you.
      Best
      Paul
    • By karian
      Hi, based on the work of @microcipcip and @gebeer  (see their posts here and here), I put together a Processwire + React boilerplate (profile).
      Github repo: https://github.com/lapico/process-react

      Cheers,
      K
       
×
×
  • Create New...