I need VERY simple PHP/MySQL help - Please

[Kamikaze]

Aloha :hehe:

Listen up guys,

I wanted to make a site that sends anonymous emails (fake emails...).
I've got the fake-mailer script and edited all the files I needed (I think so... LOL).

I'm trying to upload the SQL I've cut out of the txt that's added to the zip file...
I've cutted out this :

CREATE TABLE `messages` (
`message_id` int(16) NOT NULL auto_increment,
`message_to` tinytext NOT NULL,
`message_from` tinytext NOT NULL,
`message_sender` tinytext NOT NULL,
`message_subject` text NOT NULL,
`message_body` longtext NOT NULL,
`message_sender_ip` varchar(16) NOT NULL default '',
`message_time` int(10) NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM;

and saved it as abcd.SQL in notepad.
I've tried to import the file in phpmyadmin, and I'm getting a message telling me that 0 lines were added.
Why ?!
Secondly, I've edited the inc.definitions.php file while leaving the "mysql_hostname" as is (not edited it, like "user", "password" and "database name"...) -

Is this OK to leave it like this or should I enter something in there ?!?

PM if you need the url

I hope I'll be able to put this site up asap

 

[Kate]

I've tried to import the file in phpmyadmin, and I'm getting a message telling me that 0 lines were added.
Why ?!

That is perfectly normal, you have created an empty table (structure only). Your table will be filled by your scripts presumably

Secondly, I've edited the inc.definitions.php file while leaving the "mysql_hostname" as is (not edited it, like "user", "password" and "database name"...) -

You should ask your host for the following information:
user name, database name, password and edit the configuration file accordingly. Host name is most often 'localhost'

 

[Daniel]

I'm guessing you're referring to the script which can be got freely at: http://www.namepros.com/free-resources/359407-free-normally-3-script-packs.html

	define('mysql_hostname', 'localhost'); // This will normally stay the same, not always
	define('mysql_username', ''); // Create a database using your Control Panel, this will be the username
	define('mysql_password', ''); // And the password
	define('mysql_database', ''); // And the database name

 

[Kamikaze]

I'm guessing you're referring to the script which can be got freely at: http://www.namepros.com/free-resources/359407-free-normally-3-script-packs.html

	define('mysql_hostname', 'localhost'); // This will normally stay the same, not always
	define('mysql_username', ''); // Create a database using your Control Panel, this will be the username
	define('mysql_password', ''); // And the password
	define('mysql_database', ''); // And the database name

Yes, that's the one...
What should I do when it's written "Execute this in phpMyAdmin" in the txt file, mentioning this :

CREATE TABLE `messages` (
`message_id` int(16) NOT NULL auto_increment,
`message_to` tinytext NOT NULL,
`message_from` tinytext NOT NULL,
`message_sender` tinytext NOT NULL,
`message_subject` text NOT NULL,
`message_body` longtext NOT NULL,
`message_sender_ip` varchar(16) NOT NULL default '',
`message_time` int(10) NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM;

I've copied and pasted it in a new notepad file and saved it as "abcd.sql".
While trying to import it, I'm getting the mentioned error... ("0 lines added")

That is perfectly normal, you have created an empty table (structure only). Your table will be filled by your scripts presumably
You should ask your host for the following information:
user name, database name, password and edit the configuration file accordingly. Host name is most often 'localhost'

I have the access to the servers I'm on...
I've opened a new database and then a user, then matched them both together (I've done this action before, never had problems like this...).
In the "inc.definitions.php" file, I have those :

define('mysql_hostname', 'localhost');
define('mysql_username', '');
define('mysql_password', '');
define('mysql_database', '');

the 3 LAST lines were edited with my info.
The FIRST line ("define('mysql_hostname', 'localhost')") - was left as-is...

 

[Daniel]

Just open MySQL, select your database on the side so you can see the tables there, then click SQL and just paste it in. Should be fine.

 

[Kamikaze]

Just open MySQL, select your database on the side so you can see the tables there, then click SQL and just paste it in. Should be fine.

I found the place to paste the code, and pressed GO at the end.
Then recieved this error message :

ERROR
SQL query:

CREATE TABLE `messages` (
`message_id` int(16) NOT NULL auto_increment,
`message_to` tinytext NOT NULL,
`message_from` tinytext NOT NULL,
`message_sender` tinytext NOT NULL,
`message_subject` text NOT NULL,
`message_body` longtext NOT NULL,
`message_sender_ip` varchar(16) NOT NULL default '',
`message_time` int(10) NOT NULL default '0',
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM

MySQL said: [?]
#1050 - Table 'messages' already exists

I've sent you the url so you'll be able to see what visitors recieves at the moment.

 

[Daniel]

Table 'messages' already exists

Looks like its already been created. :p

 

[Kamikaze]

Table 'messages' already exists

Looks like its already been created. :p

naaa

AW, PM sent. 10x !

 

[Daniel]

Sorry about slowness of reply. Done.

 

[Kamikaze]

Sorry about slowness of reply. Done.

NP$ sent. from the bottom of my heart. thanks !!!