IPB>SMF: MySQL account used does not have permissions

[sandfly]

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Access denied for user: 'smf@localhost' to database 'theIPBdatabase'

Hosting uses MyPanel (yuck!) - had to set the tmp folder to install SMF. Installed okay after an apache restart.

Both DB's are on same SQL-server (unless this is hoaxed by MyPanel) - both DB passwords are the same. - double checked in the conf files for both forums...

IPB is in "/home/mydomain/public_html/forums"
SMF is in "/home/mydomain/public_html/forum"

The IPB database is in a DB called "theIPBdatabase"
The SMF database is in a DB called "smf"

I have run the convert files in
"/home/mydomain/public_html/convert/"  and tried them in
"/home/mydomain/public_html/forum/"
"/home/mydomain/public_html/forums/"
"/home/mydomain/public_html/"
just for good measure!

The mySQL server is sited in localhost

Has anyone else seen this or offer any help please?

[Aaron]

The SMF user (smf@localhost) should have access (should be linked) to the IPB database. Apparantly this isn't the case?

[sandfly]

indeed! How would I do this please?

[Aaron]

If you can't grant those permissions to a db user via your control panel, you'll have to contact your host about it.

[sandfly]

Many thanks Aäron 

[sandfly]

Spoken to ISP, they say all is fine - i.e. each of the DB's can be connected to via their respective username! they will not add a user and I cannot do this as I have insufficient rights! :-(

Is it possible to change the script so that the connection to the invision DB can be by that boards' specific user and the SMF DB by its user?

The password for both boards are the same.

2 further questions -

* Should the SMF database be empty first? I have been playing with it?
* would it be better to share the DB of the invision board and then delete the invision tables manually after the conversation as this ought to ensure that access would be allowed?

Kind regards

Adrian

[sandfly]

Okay....
Have installed SMF in the same DB as invision...

ran convert!  It sorta worked...

I have four errors relating to missing fields as follows...

INSERT INTO `databaseName`.smf_members
(ID_MEMBER,....

Unknown column 'pm_email_notify' in 'field list'
Unknown column 'buddy_list' in 'field list'
Unknown column 'pm_ignore_list' in 'field list'
Unknown column 'messageLabels' in 'field list'

I fixed these one at a time by adding the field to smf_members table with type CHAR and length 3 and trying again

The convertion then appeared to work but fell over at the poles (not too worried about those - but a fix would be nice)

I got the following error...

Converting poll options... Unsuccessful!
This query:

    INSERT INTO `databaseName`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('0', 1, 255), 'Yes', 1, 255), '11'),
    (1, SUBSTRING('1', 1, 255), 'No', 1, 255), '0'),
    (1, SUBSTRING('2', 1, 255), 'Don't know/Care', 1, 255), '1'),
    (2, SUBSTRING('0', 1, 255), 'Update the existing forum', 1, 255), '3'),
    (2, SUBSTRING('1', 1, 255), 'Change to a new forum', 1, 255), '5'),
    (2, SUBSTRING('2', 1, 255), 'Stay as we are (Russian puppets)', 1, 255), '1');

Caused the error:

    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 ''11'),
    (1, SUBSTRING('1', 1, 255), 'No', 1, 255), '0'),

What should the field details be or is there an update to the convertion routines?

Kind regards

Adrian

[sandfly]

Bump 

Can anyone tell me the attributes of the following fields please or point me to a document.

Unknown column 'pm_email_notify' in 'field list'
Unknown column 'buddy_list' in 'field list'
Unknown column 'pm_ignore_list' in 'field list'
Unknown column 'messageLabels' in 'field list'

TIA
Adrian