Hello Guys,

i tested the new 6.x-3-x-dev version from today and found some errors:

File:
$query = "DELETE FRON{{$indexer_table}} should be
$query = "DELETE FROM {{$indexer_table}}

Delete Index Button redirects to a wrong path, in my
case:
http://localhost/drupal6//drupal6/admin/settings/apachesolr/settings/sol...
should be
http://localhost/drupal6/admin/settings/apachesolr/settings/solr/index/d...

drush solr-index command leads to wrong SQL with double LIMIT LIMIT syntax

WD php: User warning: You have an error in your SQL syntax; check the[error]
manual that corresponds to your MySQL server version for the right
syntax to use near 'LIMIT 0, 50' at line 6
query: SELECT aie.entity_type, aie.entity_id, aie.changed
   FROM apachesolr_index_entities_node aie
   WHERE (aie.status = 1)
   AND (aie.bundle IN (''))
   AND (aie.entity_type = '')
   AND ((aie.changed > 0) OR ((aie.changed = 0) AND (aie.entity_id >
0))) ORDER BY aie.entity_id ASC LIMIT LIMIT 0, 50 in _db_query()
(line 147 of /usr/share/drupal6/includes/database.mysqli.inc).

i will more execute more test tomorow.
thanks for the great backport.

kind regards
chris from xeconsulting.de

CommentFileSizeAuthor
#3 1409470-3.patch579 bytesnick_vh

Comments

nick_vh’s picture

Oh wow, great feedback! :-)

Would it be possible to make a patch? That makes it easier for everyone to review and commit improvments!

iTiZZiMO’s picture

ok i will try it:

but i've found a very long index process with drush solr-index:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 76 bytes) in /home/chris/.drush/includes/backend.inc on line 120

Call Stack:
0.0008 737704 1. {main}() /home/chris/.drush/drush.php:0
0.0160 2611560 2. drush_main() /home/chris/.drush/drush.php:40
1.5208 66991512 3. drush_dispatch() /home/chris/.drush/drush.php:90
1.5512 66997104 4. call_user_func_array() /home/chris/.drush/includes/drush.inc:51
1.5513 66997472 5. apachesolr_drush_solr_index() /home/chris/.drush/includes/drush.inc:51
1.5623 67966536 6. drush_backend_batch_process() /usr/share/drupal6/sites/all/modules/apachesolr/drush/apachesolr.drush.inc:126
1.5645 68033632 7. _drush_backend_batch_process() /home/chris/.drush/includes/batch.inc:53
345.1217 182813808 8. drush_backend_invoke() /home/chris/.drush/commands/core/drupal/batch_6.inc:37
345.1217 182814720 9. drush_backend_invoke_args() /home/chris/.drush/includes/backend.inc:252
345.1219 182815400 10. _drush_backend_invoke() /home/chris/.drush/includes/backend.inc:260
687.0216 188029744 11. drush_backend_parse_output() /home/chris/.drush/includes/backend.inc:293
687.0854 198454088 12. json_decode() /home/chris/.drush/includes/backend.inc:120

nick_vh’s picture

Status: Active » Needs review
StatusFileSize
new579 bytes

Fixes the error found

nick_vh’s picture

Status: Needs review » Fixed

Committed

nick_vh’s picture

Status: Fixed » Closed (fixed)