[SOLVED] Help! Cannot Create Tax Rules - Bad SQL query Unknown column 'a.deleted' in 'where clause'

[intandem]

When I try to access the tax rules page, I immediately get this error message:

 

• Bad SQL query
  Unknown column 'a.deleted' in 'where clause'

 

What can I do to fix this? Obviously a major issue!! The shop is a brand new installation, version 1.6.0.11

 

Thanks!

 

Furthermore, I also cannot install a localisation pack - just gives me an error message 

 

This tax rule cannot be saved.

Edited April 9, 2015 by intandem (see edit history)

[PascalVG]

Hi intandem,

 

Was there any more info about the error, like file, line number, function etc?

If not, try to turn on debug mode and try again. Maybe you get some more info out of it.

 

Pascal.

[math_php]

Hi intandem,

 

Look at your mysql table ps_tax_rules_group

 

Is there a 'deleted' column in it ?

 

Here under you will find how your table must look.

 

Did you make a fresh install or an upgrade from 1.4 or 1.5 ?

 

Tell us more.

 

Good luck

 

 

CREATE TABLE IF NOT EXISTS `ps_tax_rules_group` (
  `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `active` int(11) NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
 

[intandem]

Ok, I think we might have figured out the cause of this!! Earlier, we had experienced another database issue where I wasn't able to add a specific price assigned to a customer group to a product. Based on this forum post https://www.prestashop.com/forums/topic/423906-an-error-occurred-while-updating-the-specific-price/ we noticed that some tables were missing in our database and added them which fixed that issue. In it, the person mentioned that they had a 1.6.0.11 installation but used a 1.6.0.9 database.

 

Ours is a clean 1.6.0.11 installation. No upgrades, no imported databased. However, I just heard from my developer that he used the PS Cleaner module right after installation. 1.0.6.11 had only just come out, so I assume the module not yet was compatible with that newest Prestashop version and during the cleaning job it removed the missing tables. Have replaced them and all back to normal. Phew!!

 

Thanks for the suggestions and help!

Edited April 10, 2015 by intandem (see edit history)

[PascalVG]

Hi Intandem,

 

Thanks for the feedback!

 

I'll mark the topic as solved.

 

Happy selling,

pascal.

[David Eschmeyer]

this may be happening from people who got a templatemonster theme and loaded the sample data.  It brings an entire database replacement with a 1.6.0.9 database so if your fileset is 1.6.0.14 for example you will see strange errors like this.  i.6.0.9 IS missing this field in that table.  So this customer is right as to the source of the error, it is not prestashop it is template monster.

[maexmendez]

Hello there,

I have the same issue here and I tried to follow the instructions below but no luck.

 

under Localization/ Tax Rules...

 

message:

 

Bad SQL query

Unknown column 'a.deleted' in 'where clause'

 

 

PrestaShop 1.6.1.3

 

thanks

 

[math_php]

Hi,

 

Did you check  your ps_tax_rules_group ?

Is there a column called 'deleted' ?

 

If not did you add one ?

 

If needed add a column in phpmyadmin : like this `deleted` tinyint(1) unsigned NOT NULL,

 

Regards

[iSung]

Soooo? How its have been fixed/solved?