Invalid loadTaxZones() SQL query!

[airbag]

Hello, I was updating a localhost copy with a refresh of the database.

Got this error:

Invalid loadTaxZones() SQL query!

Any ideas? All files are the same on local and remote, but no site or admin showing, just this error.

[airbag]

For anyone else with this error....
I still dunno whats causing this, but know it is an add on module causing the error, as I reverted locally to a previous copy of the DB and did not get the error.

Will report back if I isolate the cause.

[Juliette]

Hello Airbag,

I'm having the same error but when I'm trying to pass my localhost shop to an internetserver
Have you figured out what's that about?

[Juliette]

AirBag, I solved the problem. In my case, when I uploaded the tables to the db not all of them uploaded so I had missing information. Uploaded the missing tables and all went fine

greetings!

[danipelon]

I was having the same error. The problem was that the import expected ANSI data, but my sql export was in UTF-8. I converted the sql file into ANSI and it worked.

[WWWendy]

How can I convert my sql file to ansi please?

[mecjos]

I got the same error. I tried to upgrade my shop from version 1.3.5 to 1.4.0 but i couldn't then i uploaded my ex files which i got back up and then i got that error. I can't see my site only this error. How can i fix it?

[i2imedia]

Please help i'm having the same error!

[tashigiri]

I was having the same error. The problem was that the import expected ANSI data, but my sql export was in UTF-8. I converted the sql file into ANSI and it worked.

yupz.. thanks a lot..

i change to ANSI and finally success..

 

How can I convert my sql file to ansi please?

there is dropdown box when you want to export or import,, just choice ANSI..^^

 

Please help i'm having the same error!

maybe u can my way above..

[dibs223]

I have no Ansi in my phpmyadmin is there anything else i can do? or im i missing somthing here!

[dibs223]

can somone help me out plz Im stuck on how to fix thhis problem!

 

Thnaks

[dornych]

I've encountered the same error.

 

All i needed to do was regenereate the .htaccess file!!

[templaries]

I have got the same issue, but my tables have got the UTF-8 charset.

 

For example: 

 

 

CREATE TABLE `ps_accessory` (

  `id_product_1` int(10) unsigned NOT NULL,

  `id_product_2` int(10) unsigned NOT NULL,

  KEY `accessory_product` (`id_product_1`,`id_product_2`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

My script is on ANSI to UTF-8 and if convert the file to ANSI, the diacritics chars will broke down.

 

EDIT:

 

OK. The problem was in the sql dump file, many table was missing. 

Edited June 9, 2014 by templaries (see edit history)

[ecentury]

This has happened a few times to me when i am swapping severs, It could just be that the sql import had a timeout because of its size and that database did not get created.

 

If you truncate the following tables first and then export from the old database the sql file should be a lot smaller and then you can import more easily

 

TRUNCATE `ps_guest`;
TRUNCATE `ps_connections`;
TRUNCATE `ps_connections_source`;
TRUNCATE `ps_connections_page`;