technonaturalist

image link to hive image link to ko-fi

drupal 6

Drupal 7 upgrade from HELL

Monday, 17 December 2012 @ 8:41am
Modded to be slightly more useful as I wrote the other one while slightly delirious. upgrade to latest D6 drush arb default --destination="wherever/you/like" mysql update systemsetstatus='0' where filename like 'sites%' delete 6.x, retain /files and /sites directories, remember any mods to .htaccess drop in 7.0 files drush updb if no error, press y if error occurs, make a note of what you need to do to fix it. If this is a repeat run, fix all errors noted rename/move your Drupal directory (or delete it but in the event you need it later) from above where the Drupal directory should be, drush arr [backup-filename-without-square-brackets].tar repeat from 3 til everything works drush up -y go do all the other little bits and pieces you need to do with the theme and modules Problems I hit managed file duplicates: mysql select * from `files` where `filepath` like `%string%'; delete from `files` where `fid`='number'; I only had a handful to deal with at any one time so didn’t mind doing them one by one, you’ll probably want a script if you have a lot :) comment stupidity: drop index comment_uid on comments; drop index last_comment_uid on node_comment_statistics; This work by ryivhnn is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License

Drupal notes: backup process with drush

Thursday, 27 September 2012 @ 11:11pm
There’s probably a script for this. Or maybe drush is the script. Is all good, some things are done much faster with commandline :) drush vset maintenance_mode 1 drush cc all drush arb default --destination=../[site]-[date].tar And if there’s updates to be done: drush up -y At the end: drush vset maintenance_mode 0 This work has been marked as dedicated to the public domain

Drupal 6 notes: dealing with a users.csv file

Thursday, 19 May 2011 @ 11:02pm
Think I’m one of the few people on the planet who could have trouble with something as basic as this. Problem: csv dump of the users table will not import no matter how you tweak the settings. Solution: open csv file in NeoOffice (or whatever your spreadsheet thingi of choice is). I had to edit mine to change the user1 in the csv to uid 2 as there is already a user1 in the D7 it will be going into, other people may not need to edit theirs save the file, and keep it in csv format rather than changing to the native format of the spreadsheet using phpmyadmin, go to the database and find the users table, and select import browse for the csv file, leave all settings as they are, press go In my case running the thing through NeoOffice stuck semi-colons all over the place which apparently made it easier for phpmyadmin (or MySQL, not sure which) to deal with. User table inserted.

Beta!

Saturday, 9 October 2010 @ 10:53pm
I survived the alpha iterations! Learned a bit but didn’t end up helping much (or at all really) aside from something like a bug report and confirming a UX issue. So now we’re sitting on beta1 and I feel slightly more confident putting stuff here as from memory the betas are upgradeable. Alphas are not. I remembered to export my Views this time so didn’t have to completely redo them :) I’ve left out the links view though as I’m formulating a better idea on how to do that page, the feed and the fynposts though were a bit of naffing around and twice over was enough. I’m slightly miffed that Zemanta isn’t picking up the editor but I’m currently not sure if that’s the fault of D7, or some component of the editor (it’s Wysiwyg with TinyMCE). Somehing there has changed as it works fine with D6. Hoping that they’ll upgrade Zemanta and it will miraculously fix everything.