Importing with Drupal 7, using version 7.x-5.10 with MS SQL Server. Looks related to issue http://drupal.org/node/1178366

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=17&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'LIMIT'.: SELECT t.tid FROM {taxonomy_term_data} t INNER JOIN {taxonomy_term_hierarchy} h ON t.tid = h.tid WHERE :name LIKE LOWER(t.name) AND t.vid = :vid ORDER BY t.tid ASC LIMIT 1; Array ( [:name] => africa [:vid] => 14 ) in taxonomy_csv_term_find() (line 77 of F:\Development\main\PortfolioManagement\Web\Portfolio Management\sites\all\modules\taxonomy_csv\taxonomy_csv.term.api.inc).

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Daniel_KM’s picture

Hi,

Thank you for your report and it's probably the same bug.

I have to convert the sql into a Drupal 7 query, but I'm a little busy currently and I don't have Microsoft Windows on any computer and I can't check.

I'll do it probably at the end of August.

Sincerely,

Daniel Berthereau
Infodoc & Knowledge management

KCH’s picture

Thank you very much for looking into this issue. Very much appreciated.

mcruzvcn’s picture

Category: Bug report » Support request
Issue summary: View changes
FileSize
575 bytes

The problem is in incorrect syntax to 'LIMIT'.
This have to use db_query_range function to limit, not db_query function.

mcruzvcn’s picture

Status: Active » Needs review