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).
Comment | File | Size | Author |
---|---|---|---|
#3 | error_importing_into_sql_server-1707988-3.patch | 575 bytes | mcruzvcn |
Comments
Comment #1
Daniel_KM CreditAttribution: Daniel_KM commentedHi,
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
Comment #2
KCH CreditAttribution: KCH commentedThank you very much for looking into this issue. Very much appreciated.
Comment #3
mcruzvcn CreditAttribution: mcruzvcn commentedThe problem is in incorrect syntax to 'LIMIT'.
This have to use db_query_range function to limit, not db_query function.
Comment #4
mcruzvcn CreditAttribution: mcruzvcn commented