Update of DB migration
Hi there!
Is there any chance the database migration from mysql to postgresql could be updated? The files are 9 years old and could need to be updated.
Note that I make this request because I'm working on the very same migration for the Hubzilla YunoHost package. Using the file migrate_mypg_fixseq.sql seems to work, but only partially. I'm guessing this is because the file is outdated.
FYI, here are the errors I get when I use the said file:
Warning: ERROR: relation "public.conv" does not exist
Warning: LINE 1: ...'public.conv_id_seq', COALESCE(MAX(id), 1) ) FROM public.con...
Warning: ^
Warning: ERROR: relation "public.fcontact" does not exist
Warning: LINE 1: ...lic.fcontact_id_seq', COALESCE(MAX(id), 1) ) FROM public.fco...
Warning: ^
Warning: ERROR: relation "public.ffinder" does not exist
Warning: LINE 1: ...blic.ffinder_id_seq', COALESCE(MAX(id), 1) ) FROM public.ffi...
Warning: ^
Warning: ERROR: relation "public.fserver" does not exist
Warning: LINE 1: ...blic.fserver_id_seq', COALESCE(MAX(id), 1) ) FROM public.fse...
Warning: ^
Warning: ERROR: relation "public.fsuggest" does not exist
Warning: LINE 1: ...lic.fsuggest_id_seq', COALESCE(MAX(id), 1) ) FROM public.fsu...
Warning: ^
Warning: ERROR: relation "public.group_member" does not exist
Warning: LINE 1: ...group_member_id_seq', COALESCE(MAX(id), 1) ) FROM public.gro...
Warning: ^
Warning: ERROR: relation "public.groups" does not exist
Warning: LINE 1: ...ublic.groups_id_seq', COALESCE(MAX(id), 1) ) FROM public.gro...
Warning: ^
Warning: ERROR: relation "public.mail" does not exist
Warning: LINE 1: ...'public.mail_id_seq', COALESCE(MAX(id), 1) ) FROM public.mai...
Warning: ^
Warning: ERROR: relation "public.manage" does not exist
Warning: LINE 1: ...ublic.manage_id_seq', COALESCE(MAX(id), 1) ) FROM public.man...
Warning: ^
Warning: ERROR: column "id" does not exist
Warning: LINE 1: ...ECT SETVAL('public.register_id_seq', COALESCE(MAX(id), 1) ) ...
Warning: ^
Warning: ERROR: relation "public.spam" does not exist
Warning: LINE 1: ...'public.spam_id_seq', COALESCE(MAX(id), 1) ) FROM public.spa...
I've tried a few things in the package, but I'm getting nowhere. I'm pretty sure that having an updated file in the Hubzilla repo would help me solve this.