When i try to go to /admin/store, i have this error:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ti.tid IS NULL AND td.vid = '3'' at line 1: SELECT COUNT(DISTINCT n.nid) FROM {node} n LEFT JOIN {taxonomy_index} ti ON n.nid = ti.nid LEFT JOIN {taxonomy_term_data} td ON ti.tid = td.tid WHERE n.type IN () AND ti.tid IS NULL AND td.vid = :vid; Array ( [:vid] => 3 ) в функции uc_catalog_uc_store_status() (строка 374 в файле ../sites/all/modules/ubercart/uc_catalog/uc_catalog.module).

Submenus are working normally.

Comments

tr’s picture

tr commented
Status: Active » Postponed (maintainer needs more info)

This may be a problem with the Drupal MariaDB driver. The SQL syntax works correctly for MySQL and PostgreSQL. Do you know how to print out the actual query being executed and do you have a way to run that query directly in your DB?

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented

The query contains the clause "n.type IN ()". The only way I think this can happen is if you have removed the product catalog field from all of your product catalog content types, but it is still attached to a non-product content type. Please check which content types the catalog field is attached to. Or, disable the Catalog module if you are not using it.

Darth_Beholder’s picture

Darth_Beholder commented

Yes, longwave, you are absolutely right, thanks for response.

Catalog field is in some strange way attached to other content type.
The machine name of termin-link field in that content type matches catalog, but termins are from other vocabulary (tags).
I am confused, don't understand how is that possible.

When i add product catalog field to my product catalog content type, error is gone.
But i think i need to do something about other content type, to which the catalog field is attached. That content type has content already, so i have to export and re-import it with Feeds.

I change catalog vocabulary to other in /admin/store/settings/catalog, then repair catalog field, but it has no effect.

tr’s picture

tr commented
Category: Bug report » Support request
longwave’s picture

longwave
he/him
Primary language English
Location UK
commented

I am not sure I understand the remaining problem, but it sounds like an issue with taxonomy terms and nothing specific to Ubercart.

Darth_Beholder’s picture

Darth_Beholder commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Sorry, forgot to close the issue.