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.
11 2664
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.
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, 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!
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:
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.
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:
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 14,534
Recognized Expert Moderator MVP
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
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Alex Hunsley |
last post by:
I am using the smtp module to send emails via a local SMTP server on our network.
I am failing with "connection refused" error, even though we definitely have an
smtp server running on port 25!
the code is like this:
me = 'ahunsley@companyname.com'
you = 'someonelse@companyname.com'
msg = '*** alert'
|
by: Ken Lindner |
last post by:
I have a need to become familiar with SQL Server 2000 for work.
Needless to say I am new to SQL Server any version, but not IT in
general. My employer has provided me with the SQL Server 2000
Personal disk from the SQL Server 2000 Enterprise kit as this is
reported here on the MSDN web site to be the version that is supported
on Windows XP. In fact so many of you kind people confess to having
succeeded in doing it.
I have tried...
|
by: Razzie |
last post by:
Hey all,
I need to connect to an SMTP server and get a notification when it gets a
new mail to send. I want to be able to 'read' that email (retrieve recipient
information for example).
Is that possible? After much much researching I came across this article on
MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmtps/html/writingmngsinks.asp
but it is *horrible*. I downloaded the needed files for it and get stuck...
|
by: Seshadri |
last post by:
Greetings,
I am using C# to write a windows service that will periodically scan the
exchange server for emails,fetch them, process the information in the emails
and flag them after processing.
I would appreciate if anyone reading this post can point me to some code
that will read emails from an Exchange server please. Also, most of the help
on the support on the MSDN site is making use of CDO for Exchange server. I
am developing on...
|
by: MoF |
last post by:
Hello!
I have for a long time used the line:
Set FS=Server.CreateObject("Scripting.FileSystemObject")
in my ASP code. Suddenly one day this week it stopped working and I now get
the error:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
| |
by: Richard Kure |
last post by:
I encountered a problem sending an email on my windows XP, which I thought
was a bit weird, cause it worked for me before on windows XP.
So I tried on some other computers with windows XP, and managed to send
emails on the systems where outlook was not installed.
So I'm pretty sure the problem lies in outlook using exchange server.
Does anyone know how to solve this, maybe send the mail to the exchange
server or outlook instead. I dont...
|
by: maxime_phan |
last post by:
hello, everyone
I use twisted 1.3 in my python application.
in my program, I have one server and on client running at same time (so
2 reactor.run(installSignalHandlers=0) )
the client run in one thread and the server in an other thread (
reactor.callInThread(self.client... , reactor.callInThread(self.server
.....)
when I catch "escape" button, I make a reactor.stop() but it doesn't
seem to work and quit, and the application freeze. does...
|
by: smdupont |
last post by:
Hi everyone!
I am brand new to the Access world. I have downloaded files for a data base that I will use with my new job to my computer.
The data base tables and information is working great.
However, when I attempt to press the button that is suppose to open my outlook and import the emails - so that I can email the selelcted emails formt eh data base - I get a Run-time Error. I am so unfamiliar with programming - and I need some...
|
by: fperri |
last post by:
Hi,
I am trying to configure reporting services which I just added to an already existing installation of SQL Server 2005. When I am in the reporting services configuration manager and I am trying to create the reporting services database I get the following error:
Verifying Database Edition
The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |