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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Peter Knight
      Hi all
      My .htaccess file is correctly redirecting all requests to
      https:// www. That's great until I want to work locally.
      I thought I had seen a blog post by Ryan where there was a new config setting to ignore both of these if working from localhost?
      I can't find it now so wondering if I was imagining 😕
       
       
    • By abdulqayyum
      Hy Processwire community,
      There are some problem in fileCompiler cache.
      when i change under the directory \site\templates\ it must change under the directory /site/assets/cache/FileCompiler/site/templates/
      but it does not update and functionality working with /site/assets/cache/FileCompiler/site/templates/ directory.
       
      In this case please suggest me how i clear fileCompiler cache?
      what i have to clear it manually?
      Thanks AbdulQayyum.
    • By abdulqayyum
      Hy everyone,
      i am using loginRegister module for front-end user login.
      In this module user can login with Email/username, i am showing with Email. done
      but not showing Email in Forgotton Password section. there still showing with username.

      i want to show Forgotton Password with Email instead username. and should reset with email.

      please help me in this section, how i can set it with Email.

      Thanks AbdulQayyum.
    • By abdulqayyum
      Markup-Google-Recaptcha is not working with LoginRegister module in Forgotton Password Form.
      Here is my code
      wire-> modules -> process -> ProcessForgotPassword.php
      protected function step1_renderForm() {
              $form = $this->modules->get("InputfieldForm");
              $form->attr('action', './?forgot=1');
              $form->attr('method', 'post');
          
              $field = $this->modules->get("InputfieldText");     
              $field->attr('id+name', 'username');
              $field->attr('class', 'redesign-field forgotPassFeild');
              $field->setAttribute('placeholder', 'Username');
              $field->required = true;
              $field->label = $this->_("Forgotton Password");
              $field->description = $this->_("If you cannot remember your password to access the affiliates portal. simply provide your username in the box below and we'll send you a reset link via email.");
              $form->add($field);
               
             // Calling MarkupGoogleRecaptcha Module.
              $captcha = $modules->get("MarkupGoogleRecaptcha");
             //  rendering form with recaptcha
              $captcha->render($form);
         
              $submit = $this->modules->get("InputfieldSubmit");
              $submit->attr('id+name', 'submit_forgot');
              $form->add($submit);
              $this->session->userResetStep = 1;
               
              // rendering form
               $out .= $form->render();
          
              // getting captcha script
              $out .= $captcha->getScript();
              return $out;
          }

      I am following this one example.

      please suggest me how i can show MarkupGoogleRecaptcha in forgotton password.
      Getting log error


      Thanks,
      Abdul Qayyum
    • By Mithlesh
      Hi there,
      My form is not getting submitted, it is showing:
      Unable to verify successful email delivery of this form submission.
      Attaching for your reference as well: 

      In the Backend, it is showing Connection timed out with smtp.gmail.com
      Pl guide me how to resolve that
×
×
  • Create New...