osCMax v2.0 RC3 migrate database to 2.0.25

[yellowdog]

not sure if anyone is even reading this; from what I can tell 2.0 RC3 is pretty ancient.

I have inherited a client who is using osCMax v2.0 RC3.
I want to completely rebuild the site using the latest stable release ( 2.0.25 from my reading )

I have a SQL backup of the existing RC3 database, and I need to be able to import the product database into the new 2.0.25 database.

Is this possible? I downloaded 2.0.25 source and tried to trun the RC3-to-Stable sql file but immediately ran into errors:

Error
SQL query:

#
# MODIFY EXISTING TABLES
#
ALTER TABLE admin ADD admin_username varchar( 32 ) NOT NULL DEFAULT '' AFTER admin_groups_id,
ADD UNIQUE admin_username( admin_username ) ;



MySQL said:

#1062 - Duplicate entry '' for key 'admin_username'

I have a new web host setup at BlueHost and a SQL copy, so a clean slate in terms of trying things out.

anyone have some ninja moves for me to try?

[michael_s]

Actually, you should use v2.5 RC1, as that is the initial stable release candidate and there are no major issues remaining with it, just minor issues and annoyances here and there. It will save you the effort of having to upgrade again in the near short term.

Next, on to your question about database importing. The problem is that your existing admin users all have blank usernames. The easiest way around your issue is change:

ADD UNIQUE admin_username( admin_username );

to

ADD admin_username( admin_username );

in the upgrade script. Then run the upgrade. Next you will need to use phpmyadmin to manually edit the admin rows adding a unique admin_username to each admin user.

Finally, after each user has a unique username, add the UNIQUE property back to the admin_username field.

[yellowdog]

thank you for posting about this; i tried removing the "UNIQUE" from the sql and ran the upgrade script, but go this error:

Error
SQL query:

#
# MODIFY EXISTING TABLES
#
ALTER TABLE admin ADD admin_username varchar( 32 ) NOT NULL DEFAULT '' AFTER admin_groups_id,
ADD admin_username(

admin_username
);

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(admin_username)' at line 6


the osCmax_v2_5_RC1 /upgrade folder has four files:
2.0.15_to_2.0.25.sql
2.0.15_to_2.0.25_upgrade.php
rc3_to_stable.sql
upgrade.php

do I need to run each one in turn to get up to 2.5 RC1 ? Didn't see an upgrade file for 2.0.25 to 2.5 RC1

thank you again for any feedback