Hmm...I am trying this on MODx 0.9.6 RC1, and when I try to add a normal Web User via MODx manager, I get this error in SQL:
SELECT memberName FROM dbname.`dbname`.smf_members WHERE memberName = 'NewUserNameHere'
Clearly, you can see that "dbname.`dbname`." is being duplicated... Hmm...
...Commenting out Line #160 of smf_api_1.1.php seems to do the trick (well, partially...)
It appears $dbprefix is already nicely formatted for us in this (and likely recent previous) releases....
However, I’m still getting issues related to dbprefix ... hmm...
Hold Up!
I just realized how ridiculous I’m being...
1. This is a functioning Forum, yes, however it is an old SMF 1.0.7 partially tweaked to work with SMF/Joomla Bridge... SCRATCH THAT!!!!
I will be installing a fresh and clean version of the newest SMF now, and will report back
RE: the dbname and dbprefix, it is related to my SMF Settings.php, which I don’t trust at the moment
OK..first of all, that is MUCH better w/ a clean install of SMF!
Sync Users went great and imported my 1 SMF user into MODx. However, when I try and run the Administration Center via the Module, I get the following:
: Table ’modx_localhost.smf_sessions’ doesn’t exist
C:\wamp\www\htdocs\local\forums\Sources\Load.php
1986
Someone else above on this same page posted the same error, only I didn’t see there was ever a solution?
Oddly, when I ran a second time, everything appears (crosses fingers) to be working... I will let the board know if this surfaces again, hopefully it’s only a one-timer :/