Receiving white page on Prestashop...

[Guest]

Hi, i updated Prestashop and everything ran fine for about 30 minutes, i tried installing a new theme, and removing a few older medules, and then the home page just displayed a white page, i have tried switching back to the default theme on Prestashop but no matter what i do its just a white page.

 

I enabled debugging and now the page displays the following message:

 

Table 'david142_animalbaseshop.ps_required_field' doesn't exist

 

SELECT id_required_field, object_name, field_name

FROM ps_required_field

 

 

If anyone can help with what this might be it would be much appreciated!

 

The website is: www.animalbase.co.uk

 

Thanks!

[Guest]

Anyone please help! Really need to get this fixed ASAP thanks!

[Mike Kranzler]

Hi David,

The link you've provided does not appear to be a PrestaShop site. Is there another link you have?

 

-Mike

[Guest]

I had to temporarily redirect the website Another link is: www.davidashcroft.co.uk/jacqui/animalbase.co.uk

[Mike Kranzler]

Hi David,

In phpMyAdmin, please open the SQL tab and paste the following command:

 

CREATE TABLE IF NOT EXISTS `david142_animalbaseshop.ps_required_field` (
 `id_required_field` int(11) NOT NULL AUTO_INCREMENT,
 `object_name` varchar(32) NOT NULL,
 `field_name` varchar(32) NOT NULL,
 PRIMARY KEY (`id_required_field`),
 KEY `object_name` (`object_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

 

This should create the missing table in your database and allow you to access your site.

 

I hope this helps.

 

-Mike

Edited July 27, 2012 by Mike Kranzler
Renamed table for David (see edit history)

[Guest]

Hi Mike! it said my Just tried this, there is no change though, it does say it has been executed successfully, but still no change

 

Thanks for the help so far though Mike!

[Mike Kranzler]

Hi Mike! it said my Just tried this, there is no change though, it does say it has been executed successfully, but still no change

 

Thanks for the help so far though Mike!

 

Ah yes I apologize, the code above would've referred to the table prefix specific to one of my own testing environments. I went ahead and edited the command in my post above to refer to your database, go ahead and try it one more time and let us know if that works any better for you.

 

-Mike

[Guest]

Ok, so i tried that, and i noticed it made a completley new table in the database called

 

"`david142_animalbaseshop.ps_required_field` "

 

It still keeps giving the same error, i noticed that all the other entries starting in "ps_" didnt have the "david142_animalbaseshop." at the beginning.

 

So i tried something else and edited your code, all i edited was the top line to make it like the rest in the database to this:

 

 

 

CREATE TABLE IF NOT EXISTS `ps_required_field` (

`id_required_field` int(11) NOT NULL AUTO_INCREMENT,

`object_name` varchar(32) NOT NULL,

`field_name` varchar(32) NOT NULL,

PRIMARY KEY (`id_required_field`),

KEY `object_name` (`object_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

 

 

I am now receiving another error, different from the first, its a 500 internal server error. Any ideas this time? Or was what i just did a really bad idea haha?

[Mike Kranzler]

Ok, so i tried that, and i noticed it made a completley new table in the database called

 

"`david142_animalbaseshop.ps_required_field` "

 

It still keeps giving the same error, i noticed that all the other entries starting in "ps_" didnt have the "david142_animalbaseshop." at the beginning.

 

So i tried something else and edited your code, all i edited was the top line to make it like the rest in the database to this:

 

 

 

CREATE TABLE IF NOT EXISTS `ps_required_field` (

`id_required_field` int(11) NOT NULL AUTO_INCREMENT,

`object_name` varchar(32) NOT NULL,

`field_name` varchar(32) NOT NULL,

PRIMARY KEY (`id_required_field`),

KEY `object_name` (`object_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

 

 

I am now receiving another error, different from the first, its a 500 internal server error. Any ideas this time? Or was what i just did a really bad idea haha?

 

For that, you will need to contact your hosting provider for additional information.

 

-Mike

[Guest]

I removed the redirect and now i am back to the very original issue, which is a blank white screen any ideas now

[Mike Kranzler]

I removed the redirect and now i am back to the very original issue, which is a blank white screen any ideas now

 

Yes, please try contacting your hosting provider. Additionally, please make sure that everything is configured properly for the values listed here.

 

-Mike

[Guest]

Hi Mike, thanks for the help so far, im pretty sure the 500 server error isnt a host issue... Ive managed to get the front end working again here: http://www.animalbase.co.uk/ however, i cannot login the the admin area, i know at least 3 different username and passwords that all used to work, but now they dont. When i click forgot password, and i enter the email, it gives me the internal server error again on chrome, and a blank screen on firefox.

 

Since the first 500 error wasnt a host issue, i dont think this one wiill be either, strangely i think it has something to do with the database.

 

To make the front end work again, i went into settings.inc.php and i changed:

 

define('_DB_PREFIX_',_PS ''); (i think thats what it said)

 

and i basically removed the _PS and made it:

 

define('_DB_PREFIX_', '');

 

The reason i thought of this was because in phpmyadmin, there are a lot of tables with ps_....... and lots without the ps_ so i thought i would try it.

 

Any ideas for the admin area?

[Mike Kranzler]

There's a great external guide for resetting your admin login information here. Go ahead and give that a try and let us know if that works any better for you.

 

-Mike