These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

phpBB 3.x API Registration Mod v6+
Author
Previous Topic Next Topic
Devaroni
Caldari Provisions
Caldari State
#281 - 2012-07-15 18:38:19 UTC  |  Edited by: Devaroni
I am getting a SQL error when I try to edit a user's profile. This is a brand new forum set up. Everything else seems to be working decently.

Quote:

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

SELECT user_id, group_leader FROM phpbb_user_group WHERE user_id = 2 AND group_id =

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_user.php
LINE: 2771
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/eveapi/functions_eveapi.php
LINE: 204
CALL: group_user_add()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 844
CALL: eveapi_setForumGroups()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
21646854
#282 - 2012-07-15 18:48:45 UTC
I have a new problem... when ever someone puts their api in the registration form and submits they get this - 'Character and API settings do not match -> [random eve name]'.

this has happened for a few different people in the corp.
Andrea Portaro
Very Italian People
The Initiative.
#283 - 2012-07-15 20:18:23 UTC  |  Edited by: Andrea Portaro
Hello, i've installed this mod correctly, but when i create the module and follow the steps up to the screenshot module_3.png in the attachment settings i can't see EVE API Modules [acp_eveapi]

What did i do wrong?
Thanks

NVM: I solved that problem but this **** mod doesn't work anyway, L2CODE and gtfo, bye.
Labrena
Muppets Released
Forged of Fire
#284 - 2012-07-15 21:48:57 UTC
Installed, no errors.

Cleared cache

Enabled API registration is set to Yes

When trying to register, it does not display the API fields. They are also not in the profile for existing users.

Disabled/Uninstalled/Reinstalled, deleted cache, same result.

Using the 6.0.2 on a new install.

Copied the changes to a different theme, and still had same result.

Do you have a manual install package? This automod install just seems messed up.
Cyerus
University of Caille
Gallente Federation
#285 - 2012-07-15 23:12:26 UTC
Devaroni wrote:
I am getting a SQL error when I try to edit a user's profile. This is a brand new forum set up. Everything else seems to be working decently.

*snip*



Devaroni's issue has been fixed by himself. It seems he forgot to upload some files the first time he tried the install.

21646854 wrote:
I have a new problem... when ever someone puts their api in the registration form and submits they get this - 'Character and API settings do not match -> [random eve name]'.

this has happened for a few different people in the corp.


Have you cleared the cache of the forum?
If so and if the problem is still there, try to contact me ingame.


Andrea Portaro wrote:
Hello, i've installed this mod correctly, but when i create the module and follow the steps up to the screenshot module_3.png in the attachment settings i can't see EVE API Modules [acp_eveapi]

What did i do wrong?
Thanks

NVM: I solved that problem but this **** mod doesn't work anyway, L2CODE and gtfo, bye.


Wow, that's a very friendly comment.
Not really going to help you with such an attitude, so L2RTFM and gtfo, bye.

Labrena wrote:
Installed, no errors.

Cleared cache

Enabled API registration is set to Yes

When trying to register, it does not display the API fields. They are also not in the profile for existing users.

Disabled/Uninstalled/Reinstalled, deleted cache, same result.

Using the 6.0.2 on a new install.

Copied the changes to a different theme, and still had same result.

Do you have a manual install package? This automod install just seems messed up.


I think it has to do with the settings.
Can you see if those fields show on the default Prosilver template?
If not, contact me ingame when I'm online.
Labrena
Muppets Released
Forged of Fire
#286 - 2012-07-16 01:08:10 UTC  |  Edited by: Labrena
Cyerus wrote:
I think it has to do with the settings.
Can you see if those fields show on the default Prosilver template?
If not, contact me ingame when I'm online.


I was able to get it to work, after completely wiping the folder, and tossing in a fresh download of 3.1.0.

I do have one issue though....

It seems that when anyone registers, they are not added to a 'default group' automatically. (Those in corp go to the correct group, just not any not associated with a setup corp)

Is there a way to set it so who ever registers, is tossed in to the default "Registered Users" group, as without having a group assigned there is no way to change password if you don't remember what you typed.

And if you have further instructions in a public area on the forum, you are not able to view that either.

Basically not having a user in the default "registered users" group, is having the user inactivated.
Amiar
The Fiction Factory
#287 - 2012-07-17 17:12:05 UTC
Hi Cyerus.

Great mod used by many. I got alot recommendations. I followed your intructions by 100% and things went smoothless with all success. However after creating th catagory "EVE API Mod" and you must select an attacement, it does not appear ( acp_eveapi ). What do i do here?

Thanks.
chick 195
Books and Things
#288 - 2012-07-19 18:22:35 UTC  |  Edited by: chick 195
Any one else having this problem with the EVE fitting ?

http://img.photobucket.com/albums/v80/BabyDragonscybro/phpbb-fitting.jpg

We got it fixed
Labrena
Muppets Released
Forged of Fire
#289 - 2012-07-20 03:08:44 UTC
21646854 wrote:
I have a new problem... when ever someone puts their api in the registration form and submits they get this - 'Character and API settings do not match -> [random eve name]'.

this has happened for a few different people in the corp.


It seems to want full api access key to work. Getting same thing, not sure what the fix is.
Flashman KillerWee
Imperial Academy
Amarr Empire
#290 - 2012-07-20 05:47:01 UTC
Quote:

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

SELECT user_id, group_leader FROM phpbb_user_group WHERE user_id = 2 AND group_id =

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_user.php
LINE: 2771
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/eveapi/functions_eveapi.php
LINE: 204
CALL: group_user_add()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 844
CALL: eveapi_setForumGroups()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
[/quote]

I get that same error, no matter what kind of API I try to use...
Seems to me, like it does it, everytime it's done correctly... :s
Other than that Cy, I really appreciate the amount of efford you've put into this so far...

Cyerus
University of Caille
Gallente Federation
#291 - 2012-07-21 01:58:11 UTC  |  Edited by: Cyerus
Amiar wrote:
Hi Cyerus.

Great mod used by many. I got alot recommendations. I followed your intructions by 100% and things went smoothless with all success. However after creating th catagory "EVE API Mod" and you must select an attacement, it does not appear ( acp_eveapi ). What do i do here?

Thanks.


I've had a chat with Amiar. It turned out not all the files were uploaded to his forum. By reloading all the files from the Upload folder from the package, he managed to make it work.


chick 195 wrote:
Any one else having this problem with the EVE fitting ?

http://img.photobucket.com/albums/v80/BabyDragonscybro/phpbb-fitting.jpg

We got it fixed


This bug is caused by the fitting.css file not being loaded on custom themes. You'll have to manually edit your theme to make it load.


Flashman KillerWee wrote:
Quote:

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

SELECT user_id, group_leader FROM phpbb_user_group WHERE user_id = 2 AND group_id =

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_user.php
LINE: 2771
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/eveapi/functions_eveapi.php
LINE: 204
CALL: group_user_add()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 844
CALL: eveapi_setForumGroups()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()


I get that same error, no matter what kind of API I try to use...
Seems to me, like it does it, everytime it's done correctly... :s
Other than that Cy, I really appreciate the amount of efford you've put into this so far...



This bug is caused by not having made (or set) any manuals groups for the users to added to. Whenever you grant an entity access to the forum, you'll have to select a group from the dropdown box for users that match that entity to be added to it.
This group can be the same for multiple entities, but sohuld always be made manually and cannot be set to any existing defaults groups.
Manage to get ahold of Flashman ingame to explain this, and after some help he's got the forum up and running.
Cyerus
University of Caille
Gallente Federation
#292 - 2012-07-21 02:28:18 UTC
Hereby I'm releasing version 6.0.3


  • Fixed a bug where users could not create a forum account while the mod is installed but disabled.
  • Fixed a bug causing a rare MySQL error on user registration


Default update instructions apply, and don't forget to clear your cache.

Download can be found in the first post of this topic as usual.
Let me know if you come across any other issues.

~Cyerus
SoulForge
School of Applied Knowledge
Caldari State
#293 - 2012-07-21 10:23:44 UTC
Thank you!
Crelic
Terminus.
#294 - 2012-07-21 21:50:36 UTC
I'm using a new PHPBB installation. I've installed the AutoMod and the EVE API automod zip file. When I upload the upload file to the root of phpbb3 and goto /install to install the db part, I get an error 500 and it won't install the DB stuff.

I'm sure I'm doing something wrong, but I can't figure out what.

Server error
The website encountered an error while retrieving http://forum.infinitecovenant.com/install/index.php?confirm_key=GOB3N67DRS. It may be down for maintenance or configured incorrectly
Crelic
Terminus.
#295 - 2012-07-22 13:29:52 UTC
Crelic wrote:
I'm using a new PHPBB installation. I've installed the AutoMod and the EVE API automod zip file. When I upload the upload file to the root of phpbb3 and goto /install to install the db part, I get an error 500 and it won't install the DB stuff.

I'm sure I'm doing something wrong, but I can't figure out what.

Server error
The website encountered an error while retrieving http://forum.infinitecovenant.com/install/index.php?confirm_key=GOB3N67DRS. It may be down for maintenance or configured incorrectly


Someone convo'd me last night and assisted me with this error, and seemed to got it resolved. I had to modify my php.ini and increase the memory usage. I had it set at 32m (probably default) I increased it to about 128m and everything started working fine!

C
Cyerus
University of Caille
Gallente Federation
#296 - 2012-07-22 17:54:51 UTC
Crelic wrote:
Crelic wrote:
I'm using a new PHPBB installation. I've installed the AutoMod and the EVE API automod zip file. When I upload the upload file to the root of phpbb3 and goto /install to install the db part, I get an error 500 and it won't install the DB stuff.

I'm sure I'm doing something wrong, but I can't figure out what.

Server error
The website encountered an error while retrieving http://forum.infinitecovenant.com/install/index.php?confirm_key=GOB3N67DRS. It may be down for maintenance or configured incorrectly


Someone convo'd me last night and assisted me with this error, and seemed to got it resolved. I had to modify my php.ini and increase the memory usage. I had it set at 32m (probably default) I increased it to about 128m and everything started working fine!

C


That person was me Cool
Diddy Rova
KarmaFleet
Goonswarm Federation
#297 - 2012-07-22 18:16:49 UTC
Alright so i've installed the latest version of phpBB, afterwords installed the eve api forum tool with out any probs. No errors or anything. Said was successful. I go to the general tab where i'm suppost to find alliance/corp stuff etc. Nothing there even related to eve. Pretty much just the standard phpBB forum stuff.

Any ideas what might have happened or how i can fix this. Again everything was a success and no errors reported.

Thank you in advance for who can help me with this.
Diddy.
Cyerus
University of Caille
Gallente Federation
#298 - 2012-07-22 20:38:06 UTC
Diddy Rova wrote:
Alright so i've installed the latest version of phpBB, afterwords installed the eve api forum tool with out any probs. No errors or anything. Said was successful. I go to the general tab where i'm suppost to find alliance/corp stuff etc. Nothing there even related to eve. Pretty much just the standard phpBB forum stuff.

Any ideas what might have happened or how i can fix this. Again everything was a success and no errors reported.

Thank you in advance for who can help me with this.
Diddy.


You didn't read the 2nd post of this topic, direct link.
ISuper
State War Academy
Caldari State
#299 - 2012-07-23 07:12:43 UTC
Hi,
I have eveapi 5.3 and ~400 registered users. Is there a way to upgrade to latest version w/o problems? I see many issues with 6++ versions. Thanks.
Cyerus
University of Caille
Gallente Federation
#300 - 2012-07-23 09:09:03 UTC
ISuper wrote:
Hi,
I have eveapi 5.3 and ~400 registered users. Is there a way to upgrade to latest version w/o problems? I see many issues with 6++ versions. Thanks.


There aren't any issues at the moment (to my knowledge at least).
Many, if not all, problems posted here are due to the user lacking experience with the new method of installing, updating or configuring the mod.

Update instruction from v5 to v6 can be found here (applies to any v6 version).
Module installation and configuration can be found here (very similar to v5).

The installer will automaticly try to install the newest version, currently being 6.0.3. If in the future an update is released, you can use the instructions here to update your forum to the latest release.

As long as you create backups, you should be fine. And if not, you can always reply back.