Blank page after upgrade to 1.4.0.17 (SOLVED)

[lizhiats]

Hi ,

Anyone meets this problem before??

I was using 1.37 version, it was good and we have been using that for quite long time.

And now we just get upgrade to 1.4, but i open my page, it just shows nothing, all blank.

But the Back Office is good, no problems

i can log into the back office and find all my data is safe.

Just vistor can't view the page.

Any solutions???

[lizhiats]

opps

This is my page

http://www.officepennpaper.com/

[rudders18]

Is it a custom theme you are using, if so, have you updated it to work with 1.4. Does this happen with the supplied Prestashop theme?

[lizhiats]

no, it's not a custom theme.

it's a original themes

i have tried a new installation on a sub-domain on the server

but end up with the same result

[Diemux]

Did you CHMOD the compile/cache folders of Smarty?

[lizhiats]

File permission???

Yes, I have set the file permission as the install instruction does

[Diemux]

Ok, change the following in config/config.inc.php:

@ini_set('display_errors', 'off');
define('_PS_DEBUG_SQL_', false);

to:

@ini_set('display_errors', 'on');
define('_PS_DEBUG_SQL_', true);

and then post the errors here.

[WWWendy]

I have the same problem, it says: Fatal error: Call to undefined function mb_convert_encoding() in /web/htdocs/motovercajkcz/www/classes/Tools.php on line 1524

Thank you in advance

[RobK]

same problem here as well, on a new site and a site I have upgraded.. urgent site down.....

[RobK]

lizhiats - I see your site is now up, how did you fix it?

[ViroPharma]

delete old verison all 1.3.7 . Install full version 1.4 !

[lizhiats]

Hi guy.

For those meet the same problem with me

Set the smartyv2 folder to permission 777 and also child object

I found that the tutorial missed out this.

Then everything will be alright.

But now i met another problem again.....

I was asked by my team to restore the 1.37version.....

then I just did that, but following erorr shown

Invalid loadTaxZones() SQL query!

Then i try a new installation with new database, then transfer the table from old database to the new one.

i was ok but it says

there is 1 error :
you do not have access to this category

When i went back to back office and change the database name from the new one to the old one

this shows again

Invalid loadTaxZones() SQL query!

anyone know how to getback my database??

[RobK]

You have to restore it from a backup, which you have of course.......

[h4r15]

Set permission of smartyv2 didn't make an effect for me, my site is still blank

[lizhiats]

Maybe you can try what Diemux has told us, to display the error.

then see if any file permission is not yet done. That is what I did .

For my own problems, I even tried a fresh new installation and point the datebase from settings.inc.php.

But it doesn't work, I wanna ask if it has something to do with cookies key issue??

Because even the admin login and password was disable due to the cookie key and i have fixed it by searching solution in this forum.

[Jaza]

Hi guy.

For those meet the same problem with me

Set the smartyv2 folder to permission 777 and also child object

I found that the tutorial missed out this.

Then everything will be alright.

But now i met another problem again.....

I was asked by my team to restore the 1.37version.....

then I just did that, but following erorr shown

Invalid loadTaxZones() SQL query!

Then i try a new installation with new database, then transfer the table from old database to the new one.

i was ok but it says

there is 1 error :
you do not have access to this category

When i went back to back office and change the database name from the new one to the old one

this shows again

Invalid loadTaxZones() SQL query!

anyone know how to getback my database??

Hi,

I just solve this problem on my site after my upgrade failed.

The problem is the database upgrade from 1.4 removes the table named "tax_zone" in my case i have the PS prefix.

So, I have to import the "tax_zone" from my backed up database, and it fixed the problem.

I have attached the sql to create or import the TAX ZONE.

Enjoy!!!
JAZA

tax_zone.zip

[lizhiats]

Thank you very very much .

But I gonna ask a very very stupid question, how can i import the table manualy.

My server site phpadmin says that

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-

--
-- Table structure for table `ps_tax_zone

Is that the version different?

[lizhiats]

I did a stupid way,

Install a fresh new one on subdomain, and export the table.

then imtort the zone tax to the old database

Thank for everyone here^^

[Kenny Evitt]

Jaza – thanks for the attachment! I was able to resolve the "Invalid loadTaxZones() SQL query!" by creating the missing tax_zone table, but my site still isn't back to the previous state and I suspect the database is the culprit. I imported a database backup into the database using phpMyAdmin. Should I have deleted the database, or deleted all of the tables in the database, before importing the backup?

[delicjusz]

well i think there are some bugs in this file.

i had to rewrite it to this form :

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

 

CREATE TABLE `ps_tax_zone` (

`id_tax` int(10) unsigned NOT NULL,

`id_zone` int(10) unsigned NOT NULL,

KEY `tax_zone_index` (`id_tax`,`id_zone`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

 

INSERT INTO `ps_tax_zone` (`id_tax`, `id_zone`) VALUES

('1','1'),

('2','1');

 

and it works, but there are all my products missing

have to solve it

[dzindzilia]

Hi,

how did you solve that issue when you updated prestashop, created ps_tax_zone table, and all your products were missing?

I'm experiencing the same problem and would very appreciate your help.

By the way, my other symptoms - none of the modules are showing in the front office and the catalog menu on the left is sorted differently than it used to be.

Thanks in advance!