UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Issues With a Move {v. 7.2.2} - multiple problems

We moved from one host to another, successfully {or so I thought} transferred the SQL server, etc, etc and so forth.

http://www.lightsideofdarkness.com/ubbthreads/ubbthreads.php

Is the relevant URL.

Problem number one:

Stuck on a registration loop.

You set your birthdate, you check the rules understanding, you confirm the birthdate.

It should take you to the registration page to get login name/etc.

But it doesn't. It just bounces back and forth between age and accepting the rules.


Problem Two:

Just as a tester, I clicked on the "superadmin"'s profile and clicked "show user's posts" and I got this:

We encountered a problem. The reason reported was

Script: /home/ahjeonggeun/lightsideofdarkness.com/ubbthreads/scripts/userposts.inc.php
Line#: 150
SQL Error: 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 ') AND t3.POST_IS_APPROVED = '1' AND t2.FORUM_IS_ACTIVE = '1' ORDER BY t' at line 7
SQL Error #: 1064
Query: SELECT t3.POST_ID, t1.TOPIC_ID, t3.POST_SUBJECT AS TITLE, t3.POST_POSTED_TIME AS TIME, t1.TOPIC_REPLIES, t2.FORUM_ID, t2.FORUM_TITLE FROM ubbt_TOPICS as t1, ubbt_FORUMS as t2, ubbt_POSTS as t3 WHERE t3.USER_ID = '2' AND t3.TOPIC_ID = t1.TOPIC_ID AND t1.FORUM_ID = t2.FORUM_ID AND t2.FORUM_ID in ( ) AND t3.POST_IS_APPROVED = '1' AND t2.FORUM_IS_ACTIVE = '1' ORDER BY t3.POST_POSTED_TIME DESC LIMIT 0, 50

Please click back to return to the previous page.


Problem Three:

at the bottom of the Admin CP Page for the Post Islands, this is presented:


Warning: Unknown: open(/home/content/l/i/g/lightside/html/ubbthreads/sessions/sess_hmhig5l4ro2q4s3gti2821rom2, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/content/l/i/g/lightside/html/ubbthreads/sessions) in Unknown on line 0


We've reset the database on the DB's, Paths & URL's as they all need to be, but we're still getting those errors - and I'm not entirely sure what needs to be fixed for all of the old DB/paths to be removed from everything in order for this to move.

Update:

The Post Islands page error at the bottom of the page is also presented on the following admin CP pages:

Portal Layout
Gallery Islands
Custom Islands
RSS Feeds


Not sure what the deal is, but... There you have it.

Several things going on here. #1 and #3 are related. Check your /includes/config.inc.php file and look for the SESSION_PATH variable. That appears to be wrong and it's creating the registration issue as well as the error.

The one resulting in the SQL error appears that the user has access to view user profiles but doesn't have access to view any forums. Is this a guest user, or one that's registered? If registered, then check if they belong to any groups. If it's unregistered and the user cannot view any forums (and that's the way you want it), then they probably shouldn't be able to view user profiles either.

Fixed #1 & #3.

The user in question is the only one presently registered. The SuperAdmin, with unlimited permissions.

Could it be because we don't have any forums set up presently? We revamped everything after the move and haven't put everything back in place yet.

That would do it. We should be a little more graceful in the way we handle that situation and we'll get that remedied for our next version.

Alright, those are fixed. Now, however, more problems are happening.

SuperAdmin #2 was already registered.
Three more administrators, numbers 3, 4, and 5 registered.

3 & 4 didn't seem to have any problems, but 5 got an error, and we've tried to register a couple more accounts since then. It's always the same error.

UBB Error
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Duplicate entry '7-3' for key 1
SQL Error #: 1062
Query: insert into ubbt_USER_GROUPS values ('7','3')

Please click back to return to the previous page.

-- that was for user #7 ... each time it was the corresponding number, so

UBB Error
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Duplicate entry '5-3' for key 1
SQL Error #: 1062
Query: insert into ubbt_USER_GROUPS values ('5','3')

Please click back to return to the previous page.

and

UBB Error
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Duplicate entry '6-3' for key 1
SQL Error #: 1062
Query: insert into ubbt_USER_GROUPS values ('6','3')

Please click back to return to the previous page.


Not sure what's causing it or how to fix it - any ideas?

I should clarify that the users go ahead through to the registration queue, and work - but that's happening every time.

Also, some posts from the previous users {that used to have the same member #} that we've deleted are showing up on the new accounts, which is strange considering I reset the auto increment.

I don't want to jump in the middle of what Scott is working on. But it seems apparent that there are some permission/path issues.
You can start in the control panel for a quick check to see if the file permissions are all showing okay.(It will not check all permissions but should check enough to make the board usable)
Then you need to check the mysql user permissions you assigned in the config.inc.php file on the mysql server.
Your mysql user my not have all the permissions needed to work properly in mysql.

All of the permission checks are okay.

I'm not sure how to go about editing and such with that file...

It sounds like the users weren't cleaned up very well. Basically it's stating that the user already exists in the groups table. What you need to do in short order is get the max userid that exists right now and then purge everything in the groups table that is higher than that id.


Grab the result and run the query below, replacing $result with what you got from the above query.

For the user in mysql you should have a tool to add users to the database. Such as cpanel etc.
Check to see if the assigned user for ubb has write/read bla bla access .
Sometimes you get a all option or partial rights.

I will step away now since Scott is already involved.

@Ruben ~ Thanks

@Rick ~ Alright, that worked with the user cleanups fairly well but there are still phantom posts showing up. Easiest way to get rid of them is just to prune them as they show up, but if I needed to reset them and delete them all, what would I need to do?

If you need to delete all posts:

Quick question on some of your previous post/examples.
Deleting user 3-400.
Do you have users 401 and above you are trying to keep?

<3 thank you!

@Ruben - no, we cleared all users.

@Rick - okay, ran both queries, and it seemed like everything was okay but after a few minutes ... Well, this happened:

http://www.meikin.net/issue1.png

BUT... When I run the queries again it says that 0 rows are affected.

I click on the forum to see what I can do...

http://www.meikin.net/issue2.png

Then, I go to click on the shown topic directly, to delete it, and this happens:

http://meikin.net/issue3.png

and when I click into the specific subforum, this is what I get:

http://meikin.net/issue4.png

Ok, run those 2 queries again. Then go into the Content Rebuilder and rebuild everything.

Will that delete the categories and forums?

Also, content rebuilder is located??

No, that won't delete the forums. It's a main option in the control panel menu, although I see you're running 7.2.2, so you don't have it. All of the forum last post information will be wrong until you actually make new posts in each forum.

Ooh, okay - thanks.

Sorry to be on you... so constantly. I really appreciate the help.