Help - Search - Members - Calendar
Full Version: Sql Problem
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
kcc
Please see these two problems and tell me, is it the lame vndv server of mine that always seems to be done and getting errors all the time or hunter.gif is it just the code.

http://pokemonmasters.vndv.com/login.html
http://pokemonmasters.vndv.com/register.html
swordz
They both work for me.

A simple html form, pick username/password.

swordz
kcc
No, after you enter username and pick a password. After that there is this error...

QUOTE
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /www/vndv.com/p/o/k/pokemonmasters/htdocs/register.php on line 6
Could not connect to mysql because Lost connection to MySQL server at 'reading initial communication packet', system error: 111


I can't see how it could have worked for you.
Jacob
QUOTE(kcc @ Sep 28 2008, 03:53 AM) *
Please see these two problems and tell me, is it the lame vndv server of mine that always seems to be done and getting errors all the time or hunter.gif is it just the code.

http://pokemonmasters.vndv.com/login.html
http://pokemonmasters.vndv.com/register.html

Well, if your running PHP and MySQL it needs to be a .php extension, not .html.

Jacob.
kcc
They are not the codes, they are just pages. There functions are in .php format.
Jacob
Well, to execute or use the PHP include then you need to have them as .php.

Jacob.
kcc
Done that too, I ain't that lame.
swordz
The actual processing is being done by register.php, which is fine.

Is it possible for you to pastesite your code here? Then we can actually look at it to debug it.

And sorry for my initial confusion, I was expecting to see the error straight away.

swordz
kcc
Here it goes

CLiiCkCkYYYY!!! wink.gif

Might you as well need my config.php?

The one I used with localhost as server
CODE
<?php
$server = "localhost";    // server to connect to.
$database = "pokemonmasters_members";    // the name of the database.
$db_user = "pokemonmasters_members";    // mysql username to access the database with.
$db_pass = ":D:D:D:P";    // mysql password to access the database with.
$table = "users";        // the table that this script will set up and use.
?>


One I used as mine vndv.com as server
CODE
<?php
$server = "vndv.com";    // server to connect to.
$database = "pokemonmasters_members";    // the name of the database.
$db_user = "pokemonmasters_members";    // mysql username to access the database with.
$db_pass = ":D:D:D:P";    // mysql password to access the database with.
$table = "users";        // the table that this script will set up and use.
?>
Jacob
Database name is over 16 characters. Change that and try again.

Jacob.
kcc
So, umm, that basically means that it should be only of two characters?
Jacob
Make it something very small. My idea is use a single letter.

Jacob.
kcc
Thanks, it worked and my database is working, pretty fine now. It was a test actually to the main theme. Now that it is done, I'm quite happy. smile.gif

Thanks both of you, I appreciate it much.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.