Converting mb1.4

[digitus]

Getting this error ...tried all the sql files posted but no good.

The error MySQL gave was: SELECT command denied to user 'username_digi'@'localhost' for table 'pusers'

Both forums on same db

[ThorstenE]

SELECT command denied

this is a mysql error message.. it is generated when the mysql user cannot access the mybb-database..
two possible reasons:
1) In convert.php you have to enter the mysql password for the database.. maybe you have entered a wrong password or it was a typo.
2) SMF is installed in a different database on the same server and you are using different mysql users for both databases.. the mysql-user from SMF must also have access to the mybb database..

[digitus]

smf and mybb are in the same DB and uses the same user and password any other ideas? 

I think the problem is there is no pusers table but i cant find where to fix it.

[SleePy]

Are you sure the mybb forum works?
It may be the database prefix is incorrect and it can't find the users table. Which would explain that error.

[digitus]

works great  no errors   dont know what the problem is dont know why it would be putting a p instead of mybb_

Its something to do with this line in the sql file

Code Select Expand

---~ from_prefix: "`{$config['database']['database']}`.{$config['database']['table_prefix']}"

replaced with this it kinda works

Code Select Expand

---~ from_prefix: "`{$config['database']}`.{$config['table_prefix']}"

but now i get this error lol

Code Select Expand

Converting topic notifications... Unsuccessful!
This query:
SELECT uid AS ID_MEMBER, tid AS ID_TOPIC
FROM `pinata_main`.mybb_threadsubscriptions
LIMIT 0, 500;
Caused the error:

Table 'pinata_main.mybb_threadsubscriptions' doesn't exist

[ThorstenE]

please check the database for a mybb table "threadsubscription" ..if this table dosn't exist you can remove the converting topic notifications block from the mybb14_to_smf.sql

Code Select Expand


/******************************************************************************/
--- Converting topic notifications...
/******************************************************************************/

TRUNCATE {$to_prefix}log_notify;

---* {$to_prefix}log_notify
---{
$ignore = true;
---}
SELECT uid AS ID_MEMBER, tid AS ID_TOPIC
FROM {$from_prefix}threadsubscriptions;
---*