Jump to content
airbag

Invalid loadTaxZones() SQL query!

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

Thnaks

Share this post


Link to post
Share on other sites

I've encountered the same error.

 

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

  • Like 1

Share this post


Link to post
Share on other sites

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 by templaries (see edit history)

Share this post


Link to post
Share on other sites

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`;

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More