[WEB/ADMN] ForumAcc v1.5 - Server forum activation. phpBB, MyBB [1060]

​

Version: 1.5

I'm no longer developing this plugin. If you would like to continue it the source code is in the JAR file. However, I think it needs to be started from scratch.

What is ForumAcc?
ForumAcc allows you to force any users that sign up to your forums to activate their account from your Minecraft server. Perfect for stopping spam!

ForumAcc does NOT affect server ranks. If provides a better activation process for Minecraft server related forums (instead of Email or Admin activation)

How to install


phpBB:

1. Go to your forums, log in as an Administrator and go to the Administration Control Panel
2. Under "General" > "Board Configuration" click "User Registration Settings"
3. Set it to "By Admin"

MyBB:

1. Go to your forums and log in as an Administrator and go to the Admin-CP
2. Click on "Configuration" -> "User Registration and Profile Options"
3. Change "Registration Method" to "Administrator Activation"

1. Download plugin and put into /plugins
2. Start server. The plugin will create /ForumAcc/config.yml in /plugins and disable itself
3. Edit the file appropriately. HELP BELOW
4. Reload Server. DONE

Config.yml

Code:

#forumAcc will test DB connection at startup
Database:
    Table_Prefix: phpbb_
    Port: '3306' // You do not need to change this if it uses the default port
    Database: phpBB
    Password: password
    Username: root
    URL: localhost
Forum:
    Type: phpbb  // Only phpbb or mybb are supported
    URL: http://forum.myserver.com
Optional:
    Custom_Profile_FieldID: '' // Optional. Specifies the field id for the minecraft username in your forum. See "Custom Profile Field ID Help"

Custom Profile Field ID Help
Using a custom profile field allows users to choose a username other than their Minecraft username as their forum username. Here is how to find the Custom_Profile_FieldID for the config.

phpBB

Show Spoiler Hide Spoiler

MyBB

Show Spoiler Hide Spoiler

How to use
Log in as the username registered on the forum and type
/account activate
You will receive a confirmation message

Download
Version 1.5: Jar / ZIP

Changelog

• 1.5 - Added option for Auto-Activation when a player logs in.
• 1.4 - Fixed phpBB not activating users. Better error/success reporting
• 1.3 - Fixed phpBB Custom profile fields
• 1.2 - Fixed a typo in SQL string for mybb custom field. Better Error reporting.
• 1.1 - Added ability to specify custom profile field. This means the user does not have to use their Minecraft username as their forum username
• 1.0 - Plugin now supports MyBB and phpBB without code editing. Better config.
• 0.3 - ReWritten SQL. Now updates "newest_username, newest_user_id, newest_user_colour, num_users". Checks if it can connect to tables at startup
• 0.2 - Fixed txt file bug
• 0.1 - Initial Release

 

hi ive set up the phpbb boards and edited the configs as stated, ive done this once before but i didnt get this error the first time so maybe you can assist me as i did it the exact same as the first time
errors are not plugin related but forum related
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4505: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4507: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4508: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4509: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
i dont rlly know wat it means

^^ fixed Never Mind

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Code:

22:39:33 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commu
nications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
22:39:33 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(Unknown Source)
22:39:33 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
22:39:33 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
22:39:33 [SEVERE]       at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1116)
22:39:33 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionI
mpl.java:2334)
22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Conne
ctionImpl.java:2371)
22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2163)
22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
ava:794)
22:39:33 [SEVERE]       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
.java:47)
22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
22:39:33 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(Unknown Source)
22:39:33 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
22:39:33 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
mpl.java:378)
22:39:33 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
eringDriver.java:305)
22:39:33 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
22:39:33 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
22:39:33 [SEVERE]       at com.imineserver.imine.SQLQuery.checkUser(SQLQuery.jav
a:68)
22:39:33 [SEVERE]       at com.imineserver.imine.phpBBManager.onCommand(phpBBMan
ager.java:121)
22:39:33 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginComman
d.java:35)
22:39:33 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
mmandMap.java:129)
22:39:33 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(Cr
aftServer.java:298)
22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.handleCommand(N
etServerHandler.java:711)
22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.chat(NetServerH
andler.java:676)
22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
ler.java:669)
22:39:33 [SEVERE]       at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:3
3)
22:39:33 [SEVERE]       at net.minecraft.server.NetworkManager.b(NetworkManager.
java:226)
22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
ler.java:84)
22:39:33 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile
:105)
22:39:33 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServe
r.java:451)
22:39:33 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
ver.java:361)
22:39:33 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
ceFile:422)
22:39:33 [SEVERE] Caused by: java.net.ConnectException: Connection refused: conn
ect
22:39:33 [SEVERE]       at java.net.PlainSocketImpl.socketConnect(Native Method)

22:39:33 [SEVERE]       at java.net.PlainSocketImpl.doConnect(Unknown Source)
22:39:33 [SEVERE]       at java.net.PlainSocketImpl.connectToAddress(Unknown Sou
rce)
22:39:33 [SEVERE]       at java.net.PlainSocketImpl.connect(Unknown Source)
22:39:33 [SEVERE]       at java.net.SocksSocketImpl.connect(Unknown Source)
22:39:33 [SEVERE]       at java.net.Socket.connect(Unknown Source)
22:39:33 [SEVERE]       at java.net.Socket.connect(Unknown Source)
22:39:33 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
22:39:33 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
22:39:33 [SEVERE]       at com.mysql.jdbc.StandardSocketFactory.connect(Standard
SocketFactory.java:254)
22:39:33 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
22:39:33 [SEVERE]       ... 29 more
>

This error returns when I attempt to activate an account.

Code:

host=darkcloud784.ipagemysql.com
user=******
pass=****
database=bleh
table_prefix=phpbb_

 

have u tried putting the port to you database in under host?
st=darkcloud784.ipagemysql.com
port=3306 (this is default port)
user=******
pass=****
database=bleh
table_prefix=phpbb_

 

After editing these logging in takes you to a blank white page.

edit: I think I have fixed it.

 

I think I did something wrong. When someone finishes a registration, it says the quote below, and they can freely post.

Even though I replaced the language files. I'm sure its related to the Activation Method though. I don't see where to set it to 'by user' (image below).

http://imageshack.us/f/43/wharitis.png/

 

Sorry for the late reply? If you haven't fixed it it might be worth checking with PHPBB forums. I've never seen an admin control panel with only two options. Have you installed any mods that remove them?

 

any idea why this is happening?

Code:

2011-07-25 08:36:13 [INFO] phpBBManager Enabled
2011-07-25 08:36:13 [SEVERE] java.sql.SQLException: Access denied for user 'sunwind'@'216.172.97.29' (using password: YES)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
2011-07-25 08:36:13 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2011-07-25 08:36:13 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2011-07-25 08:36:13 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2011-07-25 08:36:13 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
2011-07-25 08:36:13 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
2011-07-25 08:36:13 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.SQLQuery.sqlCon(SQLQuery.java:90)
2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.SQLQuery.checkTables(SQLQuery.java:17)
2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.phpBBManager.onEnable(phpBBManager.java:77)
2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
2011-07-25 08:36:13 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
2011-07-25 08:36:13 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

216.172.97.29 this is my servers IP, not the server with phpBB on. this is the config;
host=db.hackr.net
user=sunwind
pass=xxxxxxx
database=sunwinddb
table_prefix=phpbb_
forum_url=forum.ragnacraft.com
not sure why it's trying to use the servers IP?

 

The server IP is showing because that is where you're connecting from. That's normal. It is a username/password problem.

 

ah ok, thanks

 

Idk if you're still in search of a plugin like this, but if you are then; http://forums.bukkit.org/threads/web-forumauth-whitelist-your-server-via-forums-1000.28869/

 

phpBBManager is now ForumAcc.

Changelog:

• Now supports MyBB!
• phpBB no longer requires code editing!
• Far better config.

Download links in OP.

(Sorry it took so long but we got there eventually)

 

Does this work with xenforo? I have users sign up on my forums and "Request Residency" so Is there a way when I approve there application they get approved in game?

 

I'm afraid I don't quite follow. The answer to your first question is no. I would need to find out how xenforo handles activations.

However I don't understand the second question. This doesn't really change anything in game. It just edits the database to activate a user so they can log in. It doesn't affect anything within the Minecraft server iteself.

 

I was able to get this setup and working right away, great job. One small update..

for MyBB, and for whatever reason, most users decide NOT to use thier minecraft name as thier forum name (3k registered members now), i have a custom field set for minecraft username, can we allow it to look for that instead of the main username?

for example.
the table mybb_userfields, and for mine, its fid4, which is a required field during signup.

After that, I'll be able to use this and rid my forum of polish spam bots

 

Working on this now.

Version 1.1:

Allows you to specify custom profile field. If specified the plugin will use this instead of the default. Please let me know if you have any problems.

Download in OP

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Ok, finally had some time to test..

When using it,
i see "09:57:30 [INFO] [ForumAcc] WrenisPinkle Activated" in console, but it doesnt actually activate the account..

 

i was hoping that the way this worked was they sign up for the forum, and then login to the server. and by doing so would activate thier account. without any commands.

 

I'll take a look at this now.

I can easily add an option for that.

 

when i do / activate account i get this

Code:

>13:57:02 [SEVERE] [ForumAcc] [ForumAcc] SQ Error Occurred.

>13:57:02 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

>13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

>13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

>13:57:02 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

>13:57:02 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)

>13:57:02 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

>13:57:02 [SEVERE] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

>13:57:02 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)

>13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)

>13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)

>13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

>13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

>13:57:02 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

>13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

>13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

>13:57:02 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

>13:57:02 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)

>13:57:02 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

>13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

>13:57:02 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

>13:57:02 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)

>13:57:02 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)

>13:57:02 [SEVERE] at info.thekris1234.SQLQuery.sqlCon(SQLQuery.java:165)

>13:57:02 [SEVERE] at info.thekris1234.SQLQuery.checkUser(SQLQuery.java:147)

>13:57:02 [SEVERE] at info.thekris1234.ForumAcc.onCommand(ForumAcc.java:117)

>13:57:02 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)

>13:57:02 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)

>13:57:02 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:320)

>13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:713)

>13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:677)

>13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:670)

>13:57:02 [SEVERE] at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)

>13:57:02 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)

>13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:85)

>13:57:02 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:105)

>13:57:02 [SEVERE] at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)

>13:57:02 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)

>13:57:02 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

>13:57:02 [SEVERE] Caused by: java.net.UnknownHostException: db.8243955.hostedresource.com

>13:57:02 [SEVERE] at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)

>13:57:02 [SEVERE] at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)

>13:57:02 [SEVERE] at java.net.InetAddress.getAddressesFromNameService(Unknown Source)

>13:57:02 [SEVERE] at java.net.InetAddress.getAllByName0(Unknown Source)

>13:57:02 [SEVERE] at java.net.InetAddress.getAllByName(Unknown Source)

>13:57:02 [SEVERE] at java.net.InetAddress.getAllByName(Unknown Source)

>13:57:02 [SEVERE] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)

>13:57:02 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)

>13:57:02 [SEVERE] ... 30 more

>13:57:13 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?

Im using
Table_Prefix: phpbb_
Port: '3306'
Database: a0h1122508380147
Password: xxxx
Username: yyyy
URL: zzzz.db.8243955.hostedresource.com

 

what is the texturepack in the picture?

 

Please try the latest version (1.2) and see if it produces the same error. If it does please let me know.

The texture pack is MixCraft HD

 

My port setting is default and I have not touched it... any idea what I may be doing wrong? :/
I am on CB 1000 and using forumacc 1.2

Config:

P.S. Love the plugin, can't wait to see it in action! This is amazing stuff!

 

hmm. It could be your Database URL. HTTP:// forces the connection through port 80 and with 3306 as the other port there could be a conflict. Are you sure it is correct? Normally the URL would be sql.myserver.com or something along those lines. If your database is hosted on the same server as the forum then try the URL as "paradigne.com"

 

I use bluehost for my web hosting, so it should work... I know I tie into the same area when I use npcx and my information for npcx is as follows:
db-host=tbclick.com
db-name=tbclickc_<censored>
db-port=3306
db-user=tbclickc_<censored>

As such I tried "tbclick.com" and "http://www.tbclick.com" for my database URL, but still nothing :/

 

This is awesome! It works right ahead, this is the first authenication plugin that worked for me thanks bro.
I have 1 idea, if the user is banned on the forum, that he cant get ingame. Because now they can and we need to ban twice -,-. And the other way: ingame ban = forum ban

 

Does the custom field option work with phpBB3? This table doesn't exists... custom fields are stored in phpbb_profile_fields

Code:

2011-08-26 22:22:15 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'forums.userfields' doesn't exist

 

hmm. Try regenerating your config file and typing in the URL as tbclick.com. If it doesn't work let me know and I'll look further into it.

For that functionality you would need to use plugins such as Warrant (I think). It performs the synchronisation features you're looking for. At the moment this plugin will only be for activating accounts.

Can you post your config file please. (remember to star(*) out any usernames/passwords

 

Hello, I'm getting the same problem.

The issue isn't within the config. But where-ever you have set the field that it needs to look for.

My config is as below:

Code:

#forumAcc will test DB connection at startup
Database:
    Table_Prefix: phpbb_
    Port: '3306'
    Database: minescf
    Password: *******
    Username: minescf
    URL: localhost
Forum:
    Type: phpbb
    URL: http://*****************/phpBB3/
Optional:
    Custom_Username_FieldID: 'mc_username'

Hope this helps... As there isn't an option to set the table it needs to look at

EDIT:

Perhaps a separate release version for phpBB3 users or a configuration setting to specify the table it needs to look at.

 

The problem is in the code somewhere. The plugin should change which tables and columns it uses depending on what database type is given. For some reason it is defaulting to mybb even when phpbb is given. I'll take a look at it today.

 

Awesome, Thanks! I'm really eager to get this sorted - Kudos to you ^_^