Jevents 1.5 to 2.5 Migration Database Issue

[nphic]

When I try and run the migration script this is the error that I get:

500 - SELECT command denied to user 'xxxx_xxxxx'@'99.999.999.999' for table 'jos_jev_defaults' SQL=CREATE TABLE xxxx_xxxxx.2.5-db-prefix_jev_defaults LIKE xxxx_xxxxx.jos_jev_defaults

I changed the specific database name and user as well as the IP address in the error message above to keep it confidential.

[Tonyp]

Ok,

Are both sites now under the same database?

Does the database user have the required permissions? You could set to all for this task atleast.

Regards
Tony

[nphic]

No they are not under the same database. We did not use Jupgrade, we used SP Upgrade.

The 1.5 site is a distinctly different database than the 2.5 site.

Can the migration script be modified to pass the username and password of the 1.5 site to get access to its tables and then import the data to the 2.5 site?

If not, then this appears it will force me to clone the 1.5 site and bring it into a locamachine environment, use Jupgrade to create a new 2.5 site for just Jevents. Then I would have Jevents in a 2.5 site, export all the Jevents tables from this localmachine 2.5 site and import them into the production 2.5 site on the server.

[carcam]

Upgrade Script is run under 1.5 environment so that it can take advantage of Joomla! 1.5 db functions, so Joomla! 1.5 db user needs access to Joomla! 2.5 db. I think it's not an easy workaround I'm afraid to include a different db user in the middle.

I do not think you need to do a local migration, you just need both dbs to be in the same host for both sites and that Joomla! 1.5 db user has access to Joomla! 2.5 db.

[nphic]

I do not think you need to do a local migration, you just need both dbs to be in the same host for both sites and that Joomla! 1.5 db user has access to Joomla! 2.5 db.

Rackspace hosting will not allow this.

[carcam]

So, yes you will need to do te migration in localhost (or in another server) and then upload the migrated site.