This is my first post; please excuse any shortcomings. Firstly, the end result Im hoping to achieve:
A (soon to be) fairly large MMO community site with a resources database on a subdomain, that runs a calendar, chat room & links database. Im only after a single installation to the root of the subdomain, but currently have two installations running (in subfolders of course) for troubleshooting purposes. I probably won't end up doing custom user group mappings and such - just want straight integration from phpBB3.
The phpBB installation is currently 3.0.3 - the latest version. I've had the same problems trying to run WSN links with phpBB3.0.2 and 3.0.3. The board has no mods installed on it. I have 15 custom fields added to the profiles. The only other edits have been at the template and style level.
I've installed WSN links several times, had several issues and now have reinstalled WSN Links to two locations to assist with troubleshooting.
This installation appears to work fine, except that if you turn on debug reporting (which is currently available for anyone to see), there are several errors under the hood. However, with this installation, I can log into my admin area, can view the memberlist (with errors though) and can generally operate WSN Links. Im wondering whether the errors that are currently shown are what are causing the integration issues.
This installation is problematic. It won't let me in to the admin panel without running the phpMyAdmin query to trash the integration. The memberlist paginates to plenty of pages, which seems (to me) to mean that it found my forums member database, but it won't display any users.
A couple of times when I tried different things on installing with integration, it refused to find my phpBB3 users table and specified I should edit a given integration file. On opening that file, the tables were named correctly and such (yes, I double checked credentials).
Any assistance would be welcome. Im really very keen to get this up and running, as WSNLinks appears to be the one-stop-shop for all the resources & miscellaneous 'bits' I wish to provide to my members. Thanks in advance.
1) Don't turn on strict mode. Strict mode gives recommendations of things the PHP team thinks look like questionable practice, but which are not always actually wrong and do work.
2) The member list problem is a lack of sort order. For that, go to Admin -> Settings -> General and submit the page to get orders selected.
A problem getting to the admin panel would be unrelated. There's no much I can say about that since you haven't shown me the error it gives. If it gives no error, that means simply that you aren't an administrator. Your phpbb account does not have the value '5' in the 'group_id' field of the phpbb_users table as a standard phpBB admin does. What value does it have?
1) Its in normal mode now. Thanks for the info on that one.
2) Memberlist corrected. After going through another search round for help, this actually appeared in your help doco. My apologies! I *swear* I looked at this stuff!
On the admin panel. I turned of integration with the mysql query and it didn't work this time. I ended up using a script to create an MD5 of my desired password and manually updated that into the wsnlinks_members table. It worked.
The group ids on my board appear to start at 209! what the... lol.
Well, there seems to be a(nother) problem On installation, all dirs & files associated with WSN Links have an owner of "33". This means that I cant upload a custom integration script to the file system - no permissions. I accidentally clicked the wrong integration option, the users table wasn't found (of course), so the script nicely created a custom integration script for me. However, I cant actually USE it, edit it or overwrite it. Due to the fact that my forums have weird group_id's for admins (or any group), this means that no matter what I do, I have to use a semi-customized script.
Does this mean Im screwed and am unable to use WSN Links integrated with phpBB3?
I ended up using a script to create an MD5 of my desired password and manually updated that into the wsnlinks_members table. It worked.
Then you aren't using integration at all. The wsnlinks_members table is not queried for members when you're using member integration.
On installation, all dirs & files associated with WSN Links have an owner of "33".
This means your web host hasn't bothered to provide suPHP, so script-created files are a different owner than FTP-uploaded files. The only thing you can do if your host won't use suPHP is use the CHMOD utility in your admin panel to make everything 777, even though that basically destroys the whole point of permissions system.
the users table wasn't found (of course), so the script nicely created a custom integration script for me. However, I cant actually USE it, edit it or overwrite it. Due to the fact that my forums have weird group_id's for admins (or any group), this means that no matter what I do, I have to use a semi-customized script.
You can create a new integration script with the integration wizard (not using the pre-created phpbb option), specifying your special values. Or you can use the chmod utility to chmod 777 that directory.
I believe you misready my previous paragraph. I am attempting to use WSN Links integration. My paragraph actually read that I had used your sql query to turn OFF integration (ie: to get into bugged admin panel from integration issues), but for some reason it FAILED, however I then used an MD5 generator to manually update my admin password in the database and that worked.
I've attempted pretty much every method of integration I could find or figure.
Thanks for the info on the "33" owner issue. Good to know.
As for the new integration script, well that failed also. Although I must admit, the cookie specifications were a little vague to me, especially the one written in german for some reason. I'll admit I'm not great at this stuff though - so it could be me.
From everything I've read so far, the *ONLY* things that are problematic with the installation (that you've identified) are that:
a) my phpbb user groups have odd numbers b) my host is allegedly too lazy to use suPHP.
Also, during the course of multiple attempts to install WSN links, I can now confirm that the integration script *IS* problematic with the latest version of phpBB3. You will need to modify the integration process for that forum type so that it creates all fields (except INT column types) as NULL instead of NOT NULL. Although that might also be a weird thing with my host.
Why is this so difficult? Is there something basic I'm missing? I've installed probably close to a hundred scriptlets, databases, mods and other usual web junk, so I suspect that there's something obvious/simple/stupid I'm doing wrong.
You state that you offer free installation - am I able to avail myself of that service and, if so, does that include phpBB3 integration? I am able to supply you with the admin group_id, and any of the other details (excepting definite answers on cookies, which I suspect you already know anyway) that appear to be required.
Fixed the german. You can skip the cookie section, integration works without it with manual login.
Personally I'd just edit the file though. Since you don't have suPHP, just chmod everything.
The NOT NULL issue is something phpBB has changed since the last time I tested against it, and will be addressed in the next release (releases are approximately weekly).
If you send me your FTP info and admin login, and tell me what value the admin group_id has, I can take care of it.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on Installation, mySQL & integration issues
Beginner
Usergroup: Customer
Joined: Nov 30, 2008
Total Topics: 1
Total Comments: 3
This is my first post; please excuse any shortcomings. Firstly, the end result Im hoping to achieve:
A (soon to be) fairly large MMO community site with a resources database on a subdomain, that runs a calendar, chat room & links database. Im only after a single installation to the root of the subdomain, but currently have two installations running (in subfolders of course) for troubleshooting purposes. I probably won't end up doing custom user group mappings and such - just want straight integration from phpBB3.
The phpBB installation is currently 3.0.3 - the latest version. I've had the same problems trying to run WSN links with phpBB3.0.2 and 3.0.3. The board has no mods installed on it. I have 15 custom fields added to the profiles. The only other edits have been at the template and style level.
I've installed WSN links several times, had several issues and now have reinstalled WSN Links to two locations to assist with troubleshooting.
WSN Links Installation #1 - no integration
resources.ausmmo.com.au/wsn..._no_int/wsnlinks/index.php
resources.ausmmo.com.au/wsn...nt/wsnlinks/memberlist.php
This installation appears to work fine, except that if you turn on debug reporting (which is currently available for anyone to see), there are several errors under the hood. However, with this installation, I can log into my admin area, can view the memberlist (with errors though) and can generally operate WSN Links. Im wondering whether the errors that are currently shown are what are causing the integration issues.
WSN Links Installation #2 - with phpbb3 integration
resources.ausmmo.com.au/wsn...bb3_int/wsnlinks/index.php
resources.ausmmo.com.au/wsn...nt/wsnlinks/memberlist.php
This installation is problematic. It won't let me in to the admin panel without running the phpMyAdmin query to trash the integration. The memberlist paginates to plenty of pages, which seems (to me) to mean that it found my forums member database, but it won't display any users.
A couple of times when I tried different things on installing with integration, it refused to find my phpBB3 users table and specified I should edit a given integration file. On opening that file, the tables were named correctly and such (yes, I double checked credentials).
Any assistance would be welcome. Im really very keen to get this up and running, as WSNLinks appears to be the one-stop-shop for all the resources & miscellaneous 'bits' I wish to provide to my members. Thanks in advance.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
1) Don't turn on strict mode. Strict mode gives recommendations of things the PHP team thinks look like questionable practice, but which are not always actually wrong and do work.
2) The member list problem is a lack of sort order. For that, go to Admin -> Settings -> General and submit the page to get orders selected.
A problem getting to the admin panel would be unrelated. There's no much I can say about that since you haven't shown me the error it gives. If it gives no error, that means simply that you aren't an administrator. Your phpbb account does not have the value '5' in the 'group_id' field of the phpbb_users table as a standard phpBB admin does. What value does it have?
Beginner
Usergroup: Customer
Joined: Nov 30, 2008
Total Topics: 1
Total Comments: 3
Thanks for the quick turnaround Paul!
1) Its in normal mode now. Thanks for the info on that one.
2) Memberlist corrected. After going through another search round for help, this actually appeared in your help doco. My apologies! I *swear* I looked at this stuff!
On the admin panel. I turned of integration with the mysql query and it didn't work this time. I ended up using a script to create an MD5 of my desired password and manually updated that into the wsnlinks_members table. It worked.
The group ids on my board appear to start at 209! what the... lol.
Well, there seems to be a(nother) problem
Does this mean Im screwed and am unable to use WSN Links integrated with phpBB3?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I ended up using a script to create an MD5 of my desired password and manually updated that into the wsnlinks_members table. It worked.
Then you aren't using integration at all. The wsnlinks_members table is not queried for members when you're using member integration.
On installation, all dirs & files associated with WSN Links have an owner of "33".
This means your web host hasn't bothered to provide suPHP, so script-created files are a different owner than FTP-uploaded files. The only thing you can do if your host won't use suPHP is use the CHMOD utility in your admin panel to make everything 777, even though that basically destroys the whole point of permissions system.
the users table wasn't found (of course), so the script nicely created a custom integration script for me. However, I cant actually USE it, edit it or overwrite it. Due to the fact that my forums have weird group_id's for admins (or any group), this means that no matter what I do, I have to use a semi-customized script.
You can create a new integration script with the integration wizard (not using the pre-created phpbb option), specifying your special values. Or you can use the chmod utility to chmod 777 that directory.
Beginner
Usergroup: Customer
Joined: Nov 30, 2008
Total Topics: 1
Total Comments: 3
I believe you misready my previous paragraph. I am attempting to use WSN Links integration. My paragraph actually read that I had used your sql query to turn OFF integration (ie: to get into bugged admin panel from integration issues), but for some reason it FAILED, however I then used an MD5 generator to manually update my admin password in the database and that worked.
I've attempted pretty much every method of integration I could find or figure.
Thanks for the info on the "33" owner issue. Good to know.
As for the new integration script, well that failed also. Although I must admit, the cookie specifications were a little vague to me, especially the one written in german for some reason. I'll admit I'm not great at this stuff though - so it could be me.
From everything I've read so far, the *ONLY* things that are problematic with the installation (that you've identified) are that:
a) my phpbb user groups have odd numbers
b) my host is allegedly too lazy to use suPHP.
Also, during the course of multiple attempts to install WSN links, I can now confirm that the integration script *IS* problematic with the latest version of phpBB3. You will need to modify the integration process for that forum type so that it creates all fields (except INT column types) as NULL instead of NOT NULL. Although that might also be a weird thing with my host.
Why is this so difficult? Is there something basic I'm missing? I've installed probably close to a hundred scriptlets, databases, mods and other usual web junk, so I suspect that there's something obvious/simple/stupid I'm doing wrong.
You state that you offer free installation - am I able to avail myself of that service and, if so, does that include phpBB3 integration? I am able to supply you with the admin group_id, and any of the other details (excepting definite answers on cookies, which I suspect you already know anyway) that appear to be required.
Thanks again.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Fixed the german. You can skip the cookie section, integration works without it with manual login.
Personally I'd just edit the file though. Since you don't have suPHP, just chmod everything.
The NOT NULL issue is something phpBB has changed since the last time I tested against it, and will be addressed in the next release (releases are approximately weekly).
If you send me your FTP info and admin login, and tell me what value the admin group_id has, I can take care of it.