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
QuoteSELECT 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..
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.
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.
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
---~ from_prefix: "`{$config['database']['database']}`.{$config['database']['table_prefix']}"
replaced with this it kinda works
---~ from_prefix: "`{$config['database']}`.{$config['table_prefix']}"
but now i get this error lol
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
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
/******************************************************************************/
--- 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;
---*