Topic: Members List

[TheLookBook]

Just downloaded the members backup from 1.1.14 sql file to a php file from mysql database control panel. How would I upload it from my hard-drive and get the members installed onto my installation of 2.0 allowing me to keep the existing members.

[Ricky.]

You mean only backup of member's table..
That is not advisable, instead simply go for a large upgrade and convert your existing 1.1.x into 2.0 !

[TheLookBook]

I'm currently running 2.0 so how could it be done from here. Get error message when trying to upgrade using the 2.0 large upgrade. Will run it again and leave snapshot of error. It stops working when it gets to making changes in database index.

[TheLookBook]

Here is the error message snapshot when trying to upgrade using the large upgrade.

[Illori]

you could also try this

ETA2: I know why it happens on some upgrades. You may actually try this instead, too:
upgrade_2-0.sql

Code: [Select]

---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';
---#
Cut and move it before the previous step(s), somewhere like, before:

Code: [Select]

---# Populate the attachment extension.


[TheLookBook]

Found this in file: upgrade_2-0_postgresql.sql

---# Adding file hash.
---{
   upgrade_query("

      ALTER TABLE {$db_prefix}attachments
      ADD COLUMN file_hash varchar(40) NOT NULL default ''");
---}
---#

Not to clear on what to do next.

[Illori]

unless you are using postgres as your sql server use the mysql version of that file.

[TheLookBook]

Yes I have the my sql version. Got the info and changes you provided but a little lost on exactly how to do it. Break it down just a little bit more please. Thanks for your support.

[ziycon]

I think that Illori means to cut and paste the snippet from within the mysql sql upgrade file:

Code: [Select]

---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';
---#before the line:

Code: [Select]

---# Populate the attachment extension.

[Illori]

yes exactly

[TheLookBook]

I think that Illori means to cut and paste the snippet from within the mysql sql upgrade file:

Code: [Select]

---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';
---#before the line:

Code: [Select]

---# Populate the attachment extension.

OK, cut this code:

Code: [Select]

---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';
---#
And replace it with:

Code: [Select]

---# Populate the attachment extension.

[Illori]

no the text does not say to replace anything it says to MOVE it before that part.

[TheLookBook]

I picked up on that when I got back to my plesk cpanel. Did just that and got the same results. Look at this just like I did it, maybe it's something I did wrong. I moved it to the top of Populate. Should I leave it where it originate as well?

---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';

---# Populate the attachment extension.
UPDATE {$db_prefix}attachments
SET fileext = LOWER(SUBSTRING(filename, 1 - (INSTR(REVERSE(filename), '.'))))
WHERE fileext = ''
   AND INSTR(filename, '.')
   AND attachment_type != 3;

[Illori]

that should work, you could try putting it higher up in the file as well.

[TheLookBook]

Ok, will move it up and get back with you. Thanks for the support.

[TheLookBook]

Put it higher up in the file:
---#
---# Adding file hash.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN file_hash varchar(40) NOT NULL default '';

---# Altering attachment table.
ALTER TABLE {$db_prefix}attachments
ADD COLUMN fileext varchar( NOT NULL default '',
ADD COLUMN mime_type varchar(20) NOT NULL default '';

ALTER TABLE {$db_prefix}attachments
ADD COLUMN id_folder tinyint(3) NOT NULL default '1';
---#

---# Populate the attachment extension.
UPDATE {$db_prefix}attachments
SET fileext = LOWER(SUBSTRING(filename, 1 - (INSTR(REVERSE(filename), '.'))))
WHERE fileext = ''
   AND INSTR(filename, '.')
   AND attachment_type != 3;

Error message changed slightly, see attachment:

[Illori]

no idea on that one, i have done a few upgrades for charter members with attachments and that fix worked for them. since i dont use attachments on my forum i cant offer much other advice.

[TheLookBook]

Thanks for the support

[ziycon]

Is there an error.log file generated in SMF directory when the upgrade fails? If so could you upload it or post the relevant error message?

[TheLookBook]

I will check Z and let me say this, I have a file labled ( backup_members.sql ) in my database. Opened it in a text format and they are all there. The 8,000 plus that I'm trying to restore. Will check for the error.log file and get back. Thanks for the response. update: Just checked  and there is no such file in the directory. Furthermore is there another place I might look for it?