- @oleksiy opened merge request.
- Status changed to Needs review
almost 2 years ago 9:05am 10 February 2023 - 🇺🇦Ukraine Oleksiy Lutsk 🇺🇦
I faced the same problem and prepared MR with the fix that helped me to solve that.
Greta work and great module! :-)
Our site can't live without them! ;-)
Is it posible to migrate data from old D7 site to new D8 site (with clean migration od site (not other file before migrating process))?
Here what I was doing, but I'm not sure that this is wright metod!??
I go to Drupal 7 DB and in Adminer go to export of "Rows" for „download_count“ and „download_count_cache“ (option: Save+ "CSV,").
Then I go to my Drupal 8 (=v.8.8.0) DB and in same tables „download_count“ and „download_count_cache“ go to import option.
After this I got all my data from D7 site on page "/admin/reports/download-count", and all it seems ok!
(Also after this I not have anymore notice on this page ("/admin/reports/download-count"):
"Notice: Undefined index: #element in template_preprocess_pager() (line 178 of core/includes/pager.inc).
Notice: Undefined index: #parameters in template_preprocess_pager() (line 179 of core/includes/pager.inc).
Notice: Undefined index: #quantity in template_preprocess_pager() (line 180 of core/includes/pager.inc).
Notice: Undefined index: #route_name in template_preprocess_pager() (line 181 of core/includes/pager.inc).")
Only error I have when go to option "details" (for some of the files):
„The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'spartakd8test2dev_abgrejdizd7.dc.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT SUM(dc.count) AS count, FROM_UNIXTIME(date, '%Y-%m-%d') AS time_interval FROM {download_count_cache} dc WHERE (type = :db_condition_placeholder_0) AND (id = :db_condition_placeholder_1) AND (fid = :db_condition_placeholder_2) GROUP BY time_interval ORDER BY dc.date DESC LIMIT 30 OFFSET 0; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 762 [:db_condition_placeholder_2] => 610 ) in Drupal\download_count\Controller\DownloadCountController->downloadCountDetails() (line 353 of modules/contrib/download_count/src/Controller/DownloadCountController.php).“
Because I have some other problem (I fill diferent issue for that) with "Download Count" version 8.x-1.0-alpha1, I'm not sure is this problem just with this version of module (and this migration of data is ok), or is it problem with this type of migrating data??
If I'm go totaly wrong with this procedure ;-) (I was desperate to migrate important data for our site) - is it posible to add posibility of migrating all data from D7 module to D8 module?
Best regards to all maintainers and thanks for great job with this module!! :-)
PS
Sorry for my disaster english! :-/
Needs review
2.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I faced the same problem and prepared MR with the fix that helped me to solve that.