Reactor Server installed... error verifying emails.

[Toast]

First of all... I'm very new to all of this and really do not know anything more than how to "snoop" and try to see what things might be causing problems. I do not know how to program. Everything here is not in a verbatim or verbose format. I think I did well enough though, considering I don't even know how to explain these things. All specs are at end of this post.


Ok... the issue
I have smtp set up properly for outgoing "fake" and I DO recieve an email with an activation link in it... upon clicking the link... it refers me back to my bbs and gives me this message:

"New User Activation Error
There is no user in the database with this information.
You can register a new user from here."

If I try to re-register... it tells me that the email has already been registered and that I can not use it. At this point, I shut down the reactor server and go into Reactor\Core\my sql\data\nuke and clear the new entry in the nuke_users_temp .MYD file so that I may try it again with the same email address. I'm sure I'm doing all sorts of things wrong. Haha.

I went into phpmyadmin and clicked on 'runtime information' and saw a few things in red:

One was "select_full_jo in" and it has a value of 6, as I've been trying to get this thing to work for a bit now. It also says that if the value is anything other than 0 that I need to "carefully check the indexes of your tables"

Other things in red that may help are:

Innodb_buffer_p ool_reads 12
Handler_read_rn d 39
Handler_read_rn d_next 32 k
Created_tmp_dis k_tables 80
Opened_tables 2 k

If the above does not help determine the issue then perhaps maybe you could tell me what they mean and how to "satisfy" the beast.



The specs:
phpMyAdmin 2.7.0-pl2
MySQL 5.0.18
hosted on Apache server... I could not find version... not sure where to look.


Running on Windows XP sp2
Toshiba Equium 7350
PIII 863 mhz Processor
512 MB pc-100

If there are any crucial details that I did not include.... let me know and I will post them here for you.


Thank you in advance for the help.

[Toast]

No one? Please.... this seems to be the only thing keeping me from getting my forum up and running. I know someone here knows and it has to be something so simple. I just don't know much about this stuff..


Thanks in advance.

[ronverdonk]

Well, when you start messing around with the MySQL internal data files, you can expect a lot of problems!

Firstly, what is the code for registering the user and constructing the activation email?

Secondly, what is the script that is invoked when the activation link in the email is clicked?

From that info, you could have a look what possibly could have gone wrong. But NEVER change MySQL's internal data when you don't exactly know what you are doing (it does not only involve the data, but also indexes, data type info, table statistics, etc.).

And remember: when you show code, do it within code or php tags!

Ronald :cool:

[Toast]

Well, when you start messing around with the MySQL internal data files, you can expect a lot of problems!

Firstly, what is the code for registering the user and constructing the activation email?

Secondly, what is the script that is invoked when the activation link in the email is clicked?

From that info, you could have a look what possibly could have gone wrong. But NEVER change MySQL's internal data when you don't exactly know what you are doing (it does not only involve the data, but also indexes, data type info, table statistics, etc.).

And remember: when you show code, do it within code or php tags!

Ronald :cool:

Well.. I never messed with any mysql scripts or anything... All I did was configure fake send with my isp's smtp and pop. I did everything through user interfaces in reactor server... never touched a script. I've reinstalled reactor about 3 times and downloaded a fresh copy again thinking something could have gotten mudded up when I initially downloaded it. Anyway....

I set it so that the website's name is my IP address.... it sends activation link ... I click it and it brings me back and says there is an error and that no user with that info was registered....

I'm not sure how to find the information that you want... I REALLY appreciate ANY help! I absolutely am grateful as it is essential that I get this up and running.

Please tell me how to find the info you want.


Thank you again... thank you very much!

[ronverdonk]

Well, you did say that you changed the MySQL db data

At this point, I shut down the reactor server and go into Reactor\Core\my sql\data\nuke and clear the new entry in the nuke_users_temp .MYD file so that I may try it again with the same email address.

What I asked for was a show of (a) the source code of the program that handles the user input data and performs the actual registration in the database, (b) the source code of the program that is invoked when the reactiviation link in the email is clicked.

The first one to check if there is maybe some error in the database INSERT statement. The second source to see how the activation handler checks the database for the registered user.

Ronald :cool:

[Toast]

edit: as for the MySQL db change.... it was necessary in order to be able to test to see if I could get it working. I found a file with an entry in it that had the email I was trying to register and had to remove that entry in order to use the same email again... Other than that .... I haven't changed anything in any files. I don't believe that it would have caused any error to delete that entry. I really don't know though.... however, there are no NEW errors showing up.

I'm not sure where to find the INSERT.

This is what I have that runs the forum...

+ Apache 2.0.54
+ MySQL 5.0.18
+ PHP 5.1.2
+ Perl 5.8.7 (mini)
+ Openssl 0.9.8a
+ mod_ssl 2.0.53
+ SQLite 2.8.15
+ Zend Optimizer 2.5.10a
+ Fake Sendmail 16.0
+ PHPMyAdmin 2.7.0-pl2
+ PHP-Nuke 7.8
+ Zina 0.11.22

If you can tell me perhaps what directory and what file this may be in...

I apologize for my ignorance and I am trying to learn more about this. It will take me a little while to be able to understand but I will keep working at it as I need to get this up and running.

Thank you for your help.

[ronverdonk]

edit: as for the MySQL db change.... it was necessary in order to be able to test to see if I could get it working. I found a file with an entry in it that had the email I was trying to register and had to remove that entry in order to use the same email again... Other than that .... I haven't changed anything in any files. I don't believe that it would have caused any error to delete that entry. I really don't know though.... however, there are no NEW errors showing up.

I'm not sure where to find the INSERT.

This is what I have that runs the forum...

+ Apache 2.0.54
+ MySQL 5.0.18
+ PHP 5.1.2
+ Perl 5.8.7 (mini)
+ Openssl 0.9.8a
+ mod_ssl 2.0.53
+ SQLite 2.8.15
+ Zend Optimizer 2.5.10a
+ Fake Sendmail 16.0
+ PHPMyAdmin 2.7.0-pl2
+ PHP-Nuke 7.8
+ Zina 0.11.22

If you can tell me perhaps what directory and what file this may be in...

I apologize for my ignorance and I am trying to learn more about this. It will take me a little while to be able to understand but I will keep working at it as I need to get this up and running.

Thank you for your help.

The last thing I'll say on the db file change: do not mess with the internal data storage of MySQL! It is not a text file nor a flat file database, where you can just go around and delete things. It is a relational database where all data objects are connected to each other via pointers. Any changes to the databae should be done via a user interface such as phpMyAdmin, which you have installed.

As for your display of applications: those are server applications, of which some are not even part of your server configuration (like phpMyAdmin).

I deduct that you really have no idea what (source code) I am asking you to show here. My only advice to you at this stage is: get a programmer and let him/her handle this forum thread.

Ronald :cool:

[Toast]

The last thing I'll say on the db file change: do not mess with the internal data storage of MySQL! It is not a text file nor a flat file database, where you can just go around and delete things. It is a relational database where all data objects are connected to each other via pointers. Any changes to the databae should be done via a user interface such as phpMyAdmin, which you have installed.

As for your display of applications: those are server applications, of which some are not even part of your server configuration (like phpMyAdmin).

I deduct that you really have no idea what (source code) I am asking you to show here. My only advice to you at this stage is: get a programmer and let him/her handle this forum thread.

Ronald :cool:

I do understand what you are saying about getting a programmer but I do not have the funds of which I can pay him/her with.

In the interface... there is no way, that I have found... to remove registered email addresses and this was the ONLY way to remove it.
'

Further more... after knowing that I had installed (freshly installed) the server properly and set up the smtp to send out the activation link... I had tried this without even messing with ANYTHING besides the smtp for fakesend and still it did not work.

Edit: Also... I made sure that the "user enable activation" was ticked in the board settings.


I haven't messed with anything that would have caused this... or so this is my deduction of the situation.

I need this to work and aparently you aren't interested in helping someone who is BEGINNING to learn about this. You can't wake up one day, even after many hours or months of learning about something and just simply know EXACTLY how it works. I ask questions hoping to learn about it.

You seem disinterested in helping me. That is fine. Please do no insult me by insinuating that I went in and "messed with the db"... I, based on the fact that it was a temp file, think that it should not have any adverse affects to delete the NEW entry (the only portion of the text in the file that wasn't there before I tried to send out an email) only and did not remove anything else.

Either way... thank you for your help thus far..

Have a good day.

[MMcCarthy]

Toast

Ronverdonk isn't uninterested in helping you he is actually one of the most helpful experts you will find on this site. He is simply trying to explain to you that you are trying to tackle something that you don't have the basic knowledge to be guided through.

He has tried to help you but you are unable to provide the knowledge he needs to proceed further. All beginners have to learn but there are stages to learning and you can't jump ahead to a place beyond your current capabilities. If you can't afford to employ a programmer I would suggest at least buying some Introduction books to programming so you have the basics to at least ask your questions and follow the terminology of the answers. Programming is about learning new languages and like any new language you need the basic grammer and words to navigate a conversation.

I will be happy to discuss this further if you are still unhappy but I'm not sure how we can help.

ADMIN

[Toast]

Toast

Ronverdonk isn't uninterested in helping you he is actually one of the most helpful experts you will find on this site. He is simply trying to explain to you that you are trying to tackle something that you don't have the basic knowledge to be guided through.

He has tried to help you but you are unable to provide the knowledge he needs to proceed further. All beginners have to learn but there are stages to learning and you can't jump ahead to a place beyond your current capabilities. If you can't afford to employ a programmer I would suggest at least buying some Introduction books to programming so you have the basics to at least ask your questions and follow the terminology of the answers. Programming is about learning new languages and like any new language you need the basic grammer and words to navigate a conversation.

I will be happy to discuss this further if you are still unhappy but I'm not sure how we can help.

ADMIN

I understand... I do agree that communication is essential no matter what the endeavor and this, being of the complexity it is, requires the proper terminology be implemented in order to be able to help.

I apologize for my patience... I suppose I am a bit stressed and figured that the information that I supplied should be sufficient to at least point me in the direction of where I need to look for these things.

I am quite knowledgeable when it comes to computers in general... it would not take very long for me to learn about this and figured that if this was the only thing in my way to getting my forum up and going... that at least THAT was accomplished and that I would learn as I go along. Which, generally, is how I learn best.... when tested and stressed to perform.

I apologize again and I thank everyone for the help they provided.

Have a great day.

[MMcCarthy]

Thank you for your reply.

I understand how frustrating it is but remember sometimes the simplest problem actually has the most complicated solution. Good luck with your endeavors and if you can learn a little bit more of the basics please do come back and our experts would be pleased to help.

Mary

[Toast]

Thank you very much, Mary. I appreciate the hospitality. Just as you have said, the most simplest of problems require not so simple solutions.

Thank you again. :)