Looking for psychostats module.

Hangin' Around Joined: Sep 30, 2003 Posts: 35

Different error.

MySQL said Table 'fl4tline_forum.phpbbauth_access' doesn't exist

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

You are 1 post behind. Look at my post above your last one. Your $p_prefix variable is wrong.

Posted: Fri Oct 03, 2003 10:38 pm

Oh yeah I forgot about that underscore. When I was trying to transfer them myself that worked. hehe.
Ok i am done with that part ...on to next. I will keep checking this thread for anything though for a little while! Wink

Thanks for the frequent help!

Posted: Sat Oct 04, 2003 12:01 am

OK, so the script ran and everything looks to be there and I still need to run the match and list tables separately, but now my old forums don't work. Never mind that though, my users can wait a little while. The login page is there, but I can not login. Those impatient kids lol.

I am trying to SQL query wordlist and wordmatch into the nuke DB right now and list gets a duplicate entry error...but then when I go to the table it looks as though everything is there. Wordmatch is in the process of transferring right now.

I am doing this through phpmyadmin, so I wonder if it will time-out. Hmmm... Can I run half of the SQL query(wordmatch or wordlist) then the other half.
Another words, split each sql query up into parts? If this is possible... Do I need to add the "dumping data" stuff at the top of the file?

I am kinda lost and frustrated, but I am even more determined. Wink

Posted: Sat Oct 04, 2003 12:31 am

So, let's go back a bit.
When I said that the script ran...it did. I got just the PHP credit and analysis stuff so I thought everything was good. Maybe something was wrong here.

So....then I transferred the word tables like you said. Everything looked good there.
Then I go to the nuke_users table to check the anonymous # that you say to check and change to a certain # there.
There are NO users there!!! I am so messed up now. I dont have the old forums and now I don't have the users in my nuke.

PLEASE HELP ME!!!?!?!!!!
Crying or Very sad

I wish that you would let us converse through IM. It would be much faster.
I understand though.

Posted: Sat Oct 04, 2003 1:29 am

It's done!!!!!
I had to modify the script some, just for users and rerun it.
Everyone is there. Thank you so much Raven. I will offer up a sacrifice now...lol!!!

TWO LITTLE THINGS:
Avatars show up in "your account", but they are not showing up on posts.
Do you have any ideas or can you point me in a direction and I'll take it from there?

Also, I signed up the super user as reg and super. When I login as reg user, it doesn't sign me into the forums. Any ideas?

Thank you again for ALL of your help and patience.
I will continue to post here and read. I am trying to learn PHP and SQL.
I guess I am still noob. hehe. Rolling Eyes

Posted: Sat Oct 04, 2003 2:38 am

Actually, there are some problems.
Some of the posts, topics are not there from the old forum.
Can you help me? Embarassed

Posted: Sat Oct 04, 2003 8:14 am

I have used the script, or a version of it, many times and always had 100% success. Here is a complete breakdown of what I do.

1 - Run the import script
2 - Change the -1 userid to 0 or (1 if 1 is not already used) in nuke_users.
3 - Using phpMyAdmin, change all poster_id from -1 to 0 in nuke_bbposts.
4 - Using phpMyAdmin, change all topics_poster from -1 to 0 in nuke_bbtopics.
5 - Using phpMyAdmin, change all forum_last_poster_id from -1 to 0 in nuke_bbforums.
6 - Manually export/import the wordlist and wordmatch tables.

If you are getting duplicate entry errors it's because you are importing parts of the table that you already imported.

Posted: Sat Oct 04, 2003 4:59 pm

Did all that. Some posts haven't shown up yet. If you have any other ideas.
I would really appreciate it.
The bulk of it is there. So I am not too concerned.
The users work as far as I can tell. I have had a few people beta test and so far so good.

Do you have any idea how to keep the forum post text from expanding all the way out and not staying resized within say the "header" image?
Also, the avatar forum max size option is not working. Do you know what this is?

I want to say again that Raven did an excellent job in helping me. He is extremely helpful and intuitive. Thanks again for your help Raven!!!!

I will probably have more questions as I am noob and trying my best to soak up this knowledge. Wink

Posted: Sun Oct 05, 2003 2:39 pm

Uh... hello?
What the heck! Times aren't showing up correctly. hmmm.

Posted: Mon Oct 06, 2003 12:49 am

Raven! I need help again!
New users can NOT register.
I tested this. You can sign up, everything looks good, you are sent an email.
Then the link that is in the email goes to a page that says "There is no user in the database with this information. You can register a new user from here."

Please help me someone. What do I need to do?

Thank you for any help in advance. Wink

Posted: Mon Oct 06, 2003 4:43 am

Please verify by using phpMyAdmin that you have a table in your database named nuke_users_temp. Some people end up with one named prefix_users_temp and if you are one of those, then use phpMyAdmin to rename it to nuke_users_temp.

If you have those tables, check the auto increment value in the nuke_users table. is it some extremely large number? If so, did you change the userid of the anonymous user from -1 to zero or one BEFORE you tried registering a new user?

If you have changed the anonymous user from -1 to 0 or 1 and your auto increment value is a very large number, you need to reset it. First of all edit any entries that already have a very large number. Give that user_id a correct small number, in sequence, from 1. Then, use phpMyAdmin and select the user table. Then select the SQL tab. In that window type the following

Code:

ALTER TABLE nuke_users auto_increment=XXX

where XXX is the next user_id to be issued.

Posted: Mon Oct 06, 2003 3:32 pm

Well, I checked it out, and I found that there are two anonymous users (one with 1 user id which I changed it to and another one with a super high # for user id). Could this be the problem? Could I delete one of them? Oh and also the one with the really high # keeps jumping in front of any new users. Hmmmm? Ineteresting huh?

There is a nuke_users_temp. That was fine.
How do I change the auto-increment? All I saw was to choose auto_increment or nothing. I know there must be a connection here between the first part of my post and this. I just don't know what it is yet.

Thank you for you help Raven! Wink

Posted: Mon Oct 06, 2003 3:35 pm

Please reread my previous post to you. I answered all of these questions already Smile

Posted: Mon Oct 06, 2003 3:39 pm

Well, I don't know how to change the auto-increment. Is that just the user id? The first anonymous user ( which has #1 user id ) has auto-increment set way out to the side. None of the other users have this selected.
Then at the very end o f the list the next anonymous user ( which has the really high # for user id) doesn't have aut-increment set way out to the side. The auto-increment thing I am not understanding. Where exactly do I change that? Rolling Eyes

Posted: Mon Oct 06, 2003 3:43 pm

Please reread my last post to you and look closely for the ALTER statement.

Posted: Mon Oct 06, 2003 4:00 pm

Oops...hehe. Embarassed

I am a dummy. I will do that now.

Posted: Mon Oct 06, 2003 4:08 pm

Ok, it is fixed. Thank you so much.

New problem... after the new user signs, they get a red x for avatar for default avatar. I have read some about this, but I am not sure how to approach it. Do you have any ideas?

Posted: Mon Oct 06, 2003 4:17 pm

http://www.ravenphpscripts.com/modules.php?name=Forums&file=viewtopic&t=184#857

Posted: Mon Oct 06, 2003 5:02 pm

You are truly amazing. I am wondering, what school you attended for your undergrad...or if you're even out of highschool yet? I must assume with your knowledge and patience that you are well into a masters?
I will continue to read and post here. You have a wealth of information my friend. I am sure that this community is very appreciative of the effort you put into this. I will make a donation soon on your behalf.

Hope to learn alot more from you,

- Chris

Posted: Mon Oct 06, 2003 5:06 pm

I'll take that as a compliment.

Who is Raven you ask?

http://gaylenandmargie.com

No degree at all. Self taught. Seriously? Talent on loan from God Smile

Worker Joined: Sep 09, 2003 Posts: 165

ummm Master is an understatement here Laughing

he is amazing and very patient. Very Happy

Posted: Mon Oct 06, 2003 5:15 pm

Well, thank you for letting me see a little bit about you.
Are you Chris too? I may have mixed names up, which one are you? Laughing

Posted: Mon Oct 06, 2003 5:16 pm

I'm the old fart - Gaylen (53 years) Laughing

Posted: Mon Oct 06, 2003 5:23 pm

Ah, gotcha!
Well, you have a lovely family. Very Happy

I look forward to learning more from you and everyone else here too!