Help needed

joergstgt · 14-12-2005, 09:39

i really have a problem with a Gaming Ladder script.

I fixed all the Problems like PHP.ini, admin-login and so on. the only thing i can't get fixed is that thing with the validation code.
I Think it's a database Problem because if i want to register an new player the script sends a validation code by email.If i want confirm this validation code @ the HP i get this information:

Quote:

Unable to find that validation code

And if i look @ the database there's nothing stored in it. Only Admin and Staff....

maybe anyone know this Problem or can help me ?

**monaghan** · 14-12-2005, 10:34

without seeing any code, it's difficult to give you any help.

Did you write it or did someone else ?

It's very unlikely to be a database problem, if the database has no content, then either you've not inserted your records into the database or you have inserted data that breaks a table constraint and you're not checking for error during insertion.

joergstgt · 14-12-2005, 10:54

Thx for your reply but i can't post the whole script and the database in here. I said i think it's a db problem because if i login as admin or change something there's no problem.

joergstgt · 14-12-2005, 10:57

thats the join.php

Quote:

deleted it

**monaghan** · 14-12-2005, 11:00

Most database problems turn out to be application problems (I've been a DBA for best part of 10 years, so feel qualified through expereince to make such a generalisation

)

If your admin logon works, then you're going to have to put some debug logging in place so you can see the SQL you're actually sending to the database and what the response is.

Is it your script ? If not, then I guess the quickest option is to go back to the author and ask for help.

joergstgt · 14-12-2005, 11:06

:smile: was nothing against you. I believe that you're absolutely qualified.
And no, it's not my script...I try to contact the author or to debug it as you said.
And many Thanks for your help.....

**monaghan** · 14-12-2005, 11:16

Generally I tend to dump the content of the SQL query string that's passed to the database to screen and then dump the result code from the query to the screen.

Once you've captured the query, run this from a SQL query console as this will give you better visibility of any errors.

14-12-2005, 10:34	#2 (permalink)
monaghan Super Moderator Join Date: Mar 2005 Location: Herts, UK Posts: 1,030 iTrader: 1 / 100%	without seeing any code, it's difficult to give you any help. Did you write it or did someone else ? It's very unlikely to be a database problem, if the database has no content, then either you've not inserted your records into the database or you have inserted data that breaks a table constraint and you're not checking for error during insertion. __________________ Alex Monaghan - Monaghan Consultants Ltd Web hosting, ADSL, IT & Database consultancy Custom Web hosting on UK or USA servers using Linux (cPanel) or Windows (DotNetPanel) Mobile Phone Ringtones, Logos, Java Games & more

14-12-2005, 11:00	#5 (permalink)
monaghan Super Moderator Join Date: Mar 2005 Location: Herts, UK Posts: 1,030 iTrader: 1 / 100%	Most database problems turn out to be application problems (I've been a DBA for best part of 10 years, so feel qualified through expereince to make such a generalisation ) If your admin logon works, then you're going to have to put some debug logging in place so you can see the SQL you're actually sending to the database and what the response is. Is it your script ? If not, then I guess the quickest option is to go back to the author and ask for help. __________________ Alex Monaghan - Monaghan Consultants Ltd Web hosting, ADSL, IT & Database consultancy Custom Web hosting on UK or USA servers using Linux (cPanel) or Windows (DotNetPanel) Mobile Phone Ringtones, Logos, Java Games & more

14-12-2005, 11:16	#7 (permalink)
monaghan Super Moderator Join Date: Mar 2005 Location: Herts, UK Posts: 1,030 iTrader: 1 / 100%	Generally I tend to dump the content of the SQL query string that's passed to the database to screen and then dump the result code from the query to the screen. Once you've captured the query, run this from a SQL query console as this will give you better visibility of any errors. __________________ Alex Monaghan - Monaghan Consultants Ltd Web hosting, ADSL, IT & Database consultancy Custom Web hosting on UK or USA servers using Linux (cPanel) or Windows (DotNetPanel) Mobile Phone Ringtones, Logos, Java Games & more

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Urgent Help Needed	transparentprin	HTML, DHTML and CSS	1	04-07-2007 17:55
Coding help needed.	rustypaulin	HTML, DHTML and CSS	1	15-08-2005 21:51
Domain name needed for 700 wmt	randomman	Wanted Ads	5	15-08-2005 16:30
UK SEO/Promotion Needed	Mike	Search Engine Optimisation (SEO)	2	26-05-2005 16:08
Reviews needed	deaddevil	Website Reviews	14	16-04-2005 20:56

14-12-2005, 10:54	#3 (permalink)
joergstgt Newbie Join Date: Dec 2005 Posts: 6 iTrader: 0 / 0%	Thx for your reply but i can't post the whole script and the database in here. I said i think it's a db problem because if i login as admin or change something there's no problem.

14-12-2005, 11:06	#6 (permalink)
joergstgt Newbie Join Date: Dec 2005 Posts: 6 iTrader: 0 / 0%	:smile: was nothing against you. I believe that you're absolutely qualified. And no, it's not my script...I try to contact the author or to debug it as you said. And many Thanks for your help.....

Help needed

Help needed

Similar Threads