|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
StyphonUK
Caldari Fearless Bandits
|
Posted - 2011.06.03 23:20:00 -
[1]
Hi, I've just done a fresh install of this, copied all the files over in the new files and pre edit folders and imported the three sql files but when importing the first 1 I get the following error:
SQL query:
# EVE API start ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR( 10 ) NOT NULL DEFAULT '' AFTER user_form_salt;
MySQL said: Documentation #1060 - Duplicate column name 'api_userid'
What's up?
|
StyphonUK
Caldari Fearless Bandits
|
Posted - 2011.06.04 09:37:00 -
[2]
Edited by: StyphonUK on 04/06/2011 09:43:41 Edited by: StyphonUK on 04/06/2011 09:39:00
Originally by: StyphonUK Hi, I've just done a fresh install of this, copied all the files over in the new files and pre edit folders and imported the three sql files but when importing the first 1 I get the following error:
SQL query:
# EVE API start ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR( 10 ) NOT NULL DEFAULT '' AFTER user_form_salt;
MySQL said: Documentation #1060 - Duplicate column name 'api_userid'
What's up?
It appears you have either executed the SQL file twice, or you used a database which was already filled with data.
Ah, yea. It's a different error to the first time I ran it. The first three columns the file asks to be created are created fine. If you remove those from the SQL file and try to run the rest I get this error:
SQL query:
# EVE API start INSERT INTO phpbb_config( config_name, config_value ) VALUES ( 'eve_avatars', '0' );
MySQL said: Documentation #1062 - Duplicate entry 'eve_avatars' for key 1
That error came up first time I ran it. If I look in the phpbb_config table there is no eve_avatars. If I manually try to input the data to the table it gives the same error.
|
StyphonUK
Caldari Fearless Bandits
|
Posted - 2011.06.04 11:17:00 -
[3]
Originally by: StyphonUK
OK, I've managed to get all the SQL information in (I deleted the table, restored the backup and did it again, worked first time). However now when I try and register a character when you click submit it just reloads the registration page without the captcha but with the form still filled in. Clicking submit again just keeps reloading that page.
The problem was the name didn't match any of the account names, so the mod is working, however it needs to throw an error instead of just returning to the page with no instructions as to why the account isn't being created.
|
StyphonUK
Caldari Fearless Bandits
|
Posted - 2011.06.05 18:09:00 -
[4]
Not sure whether the mod is causing this or not but never seen this happen on a forum before. Users have the correct permissions (checked the masks for the user groups and everything) to edit and delete posts yet they cannot. The buttons don't appear and if you manually browse to the page it says they don't have permission. I have no idea what is happening to stop the masks from being applied properly and just want to cover all the bases. Does this mod edit the users permissions in any way?
|
StyphonUK
Caldari Fearless Bandits
|
Posted - 2011.06.13 17:14:00 -
[5]
Originally by: Pardus Aeon Hey, sorry if this was already asked up further in the thread but I've been playing around with setting this up and have an issue. All was good until I tried to actually register with some API info. A always get the message The API information you entered was invalid. This happens even with valid creds. Any suggestions on where to start with the troubleshooting? It would be cool to be able to get this working soon, I'm going to be talking about setting up forums in my next podcast and would really like to mention this mod along with it if I get it running.
First thing make sure the name they sign up with matches their in game name exactly.
|
StyphonUK
Caldari Fearless Bandits Fearless Bears
|
Posted - 2011.07.31 10:37:00 -
[6]
Hey Cyerus, any ETA on a version for 3.0.9. Can't update my forum because of some conflicting changes.
|
StyphonUK
Caldari Fearless Bandits Fearless Bears
|
Posted - 2011.08.12 18:52:00 -
[7]
Originally by: Gore Neosilver Edited by: Gore Neosilver on 10/08/2011 08:03:51 Hi Admiral Tolwyn, in the ZIP-File is a readme.txt. There you can read what to do, if you have not install any Mod yet. If you have install one, you have to open the XML-File in Firefox or Chrome. In the File is writen what to do and where. It is realy quit easy.
Now my Problem. If i install your MOD in phpBB 3.0.8 it works. But if i make an update or install it on phpBB 3.0.9, i get the Error
SQL ERROR [ mysqli ]
Table 'mydb.LOGIN_ATTEMPT_TABLE' doesn't exist [1146]
Is this a known Error? Or do I something wrong?
Thanks for your reply.
P.S. sorry for my bad english
3.0.9 changed some of the files that this mod changes. That means that Cyerus needs to edit the mod to work with 3.0.9.
|
|
|
|