Jump to content
icreation

404 page not working

Recommended Posts

From a fresh installation of PW2.5 with a profile that I made I get the following error when trying to access the 404 page.

 

Error: Exception: Table 'perfects_db.ProcessRedirects' doesn't exist (in /home/perfectserviceso/public_html/wire/core/Database.php line 114)
 
#0 [internal function]: Database->query('SELECT id, redi...')
#1 /home/perfectserviceso/public_html/wire/core/DatabaseMysqli.php(35): call_user_func_array(Array, Array)
#2 /home/perfectserviceso/public_html/site/modules/ProcessRedirects/ProcessRedirects.module(261): DatabaseMysqli->__call('query', Array)
#3 /home/perfectserviceso/public_html/site/modules/ProcessRedirects/ProcessRedirects.module(261): DatabaseMysqli->query('SELECT id, redi...')
#4 /home/perfectserviceso/public_html/wire/core/Wire.php(411): ProcessRedirects->checkRedirects(Object(HookEvent))
#5 /home/perfectserviceso/public_html/wire/core/Wire.php(344): Wire->runHooks('pageNotFound', Array)
#6 /home/perfectserviceso/public_html/wire/modules/Process/ProcessPageView.module(179): Wire->__call('pageNotFound', Array)
#7 /home/perfectserviceso/public_html/wire/modules/Process/ProcessPageView.module(179): ProcessPageVi
This error message was shown because you are logged in as a Superuser. Error has been logged. 

Can anyone see if something is missing here?

Share this post


Link to post
Share on other sites

It looks like you have Anti's ProcessRedirect module installed but the table is missing.

Maybe you can uninstall/install ProcessRedirects again, but make sure you don't loos the redirect rules. I don't know the plugin myself :)

If you don't need it, just uninstall the module and the error should be gone.

Cheers

Share this post


Link to post
Share on other sites

Thanks for responding Wanze. When I try to uninstall the module as a superuser it tells me "This page may not be deleted".

Share this post


Link to post
Share on other sites

You're welcome!

I don't know what happened, this sounds strange.

But you could try to create the table manually. Here's the SQL statement from the module code: https://github.com/apeisa/ProcessRedirects/blob/master/ProcessRedirects.module#L326 

If you have phpMyAdmin installed or any other MySQL database administrator, execute it there.

CREATE TABLE ProcessRedirects (
			id int unsigned NOT NULL auto_increment,
			counter int unsigned DEFAULT 0,
			redirect_from varchar(255) NOT NULL DEFAULT '',
			redirect_to varchar(255) NOT NULL DEFAULT '',
			PRIMARY KEY(id),
			UNIQUE KEY(redirect_from)
		) ENGINE = MYISAM;
  • Like 1

Share this post


Link to post
Share on other sites

You're welcome!

I don't know what happened, this sounds strange.

But you could try to create the table manually. Here's the SQL statement from the module code: https://github.com/apeisa/ProcessRedirects/blob/master/ProcessRedirects.module#L326

If you have phpMyAdmin installed or any other MySQL database administrator, execute it there.

CREATE TABLE ProcessRedirects (
			id int unsigned NOT NULL auto_increment,
			counter int unsigned DEFAULT 0,
			redirect_from varchar(255) NOT NULL DEFAULT '',
			redirect_to varchar(255) NOT NULL DEFAULT '',
			PRIMARY KEY(id),
			UNIQUE KEY(redirect_from)
		) ENGINE = MYISAM;

Hey I noticed the same thing on my installation and i checked for the existence of the table and found the table but title of table had different cases than what PW is expecting.

PW is expecting table with the name: 'ProcessRedirects'

DB has the name of table: 'processredirects'

Maybe the ProcessRedirects module updated without updating the DB table(s)....?

Share this post


Link to post
Share on other sites

I'll just place this here for anyone who comes across this same error:

Error: Exception: Table 'DB_NAME.ProcessRedirects' doesn't exist (in SITE_PATH_ON_SERVER/wire/core/Database.php line 114)



The fix I used was just rename the table in DB:
 

ALTER TABLE processredirects RENAME TO ProcessRedirects;

Share this post


Link to post
Share on other sites

Yeah, I bumped into that when developing Jumplinks - had to do an insensitive check. If I'm not mistaken, it depends on which version of MySQL you're running...

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 guys
      is there a checklist of items I should consider for diagnosing a series of pages which display a 404 error?
      Basically I have built a Blog and all my posts are under a folder called 'Posts'. Some of these pages successfully display while others display a 404 page. 
      This is what I have confirmed so far...
      1. All pages are within the same root folder 'Posts'
      2. All pages have the same template and fields completed
      3. All pages have the same properties under Settings > Who can access this page
      4. Pages have no redirects in place
      5. Pages have no special characters or anything funky in the URL slug
      There are no errors showing in the log either so I am stuck 😕
      Thanks
    • By EyeDentify
      Hello Dear PW Gurus.

      Hope you fair well in these Corona Crisis times.

      Anyhow, i have a problem with a Cryptic error message that shows up when i am trying to Delete images out of a Images field.
      The Error message does say a little but it does not make sense to me why i can´t delete the images because of it.

      Is it some permission issue perhaps?

      I will attach screenshots of it and what i did prior to it.
      I am from sweden so ignore the funny words here and there.

      Hope you all can send me on the right track.
      i am running PW 3.0.139 on this install.

      Step1:

      Step 2: Select the images with the trashcan symbol

       
      Step 3: Cryptic Error message

      I am scratching my head on this one, have not seen this before.

      Thankfull for all help.
      /EyeDentify
    • By VeiJari
      Hello forum. I'm trying to figure out how to detect if current form has errors after saving it in pw admin page. This is so that our event location isn't added in database if we detect errors. But I can't seem to find a correct way to detect errors? I only found the wire()->errors() and it always triggers even if I don't have any errors. 
      How can I detect errors in a form?
      By error I mean $page->error('this is the red error');
    • By DevCat
      Hi,
      I'm trying to install ProcessWire on XAMPP localhost. I extracted the zip and put the files from master folder to website directory folder and when I go there with Firefox it says 404 page not found (no site configuration or install.php available). At least install.php surely is there. I'm doing WordPress installations on localhost almost every day and no problems. Does anyone here know what is cause for this error?
    • By horst
      Hey,
      I want to hook into the 404 handling of PW at the most earliest stage. Pleas can anybody point me to the hook or file that suits this best?
×
×
  • Create New...