F2S Database help!

[KornChild]

I made a database on my f2s account and it worked fine but I made a few mistakes that I wasn't able to fix so I am trying to erase everything created and for some reason I can't! I can drop some things in the database when I log in but for some odd reason when I try to drop other things it tells me to log into the database again instead of dropping them! When I log back in its where I started and I cant drop them so I can start all over! I tried deleting my database and I waited a day then I created a new one and they were still there!!!! Is there anyway to erase and start clean with the database?!!? I appreciate everyones help!

[scoutt]

What database are you using? MySql or another one.

[KornChild]

Yes! It is mysql but I only know how to edit the database by loging into it through f2s.com and using the web database tool they provide once I am in. When I click drop table it brings me right back to the login screen for some odd reason and won't drop the table. I've deleted over half of the tables I made mistakes on but I cant drop these for some reason! And I cant reinstall my script without them gone cause the script notices and gives errors!

[scoutt]

I use a program call phpMyAdmin. you can get it here
http://www.phpwizard.net/projects/phpMyAdmin/

I am not sure if your server will let you use this, but I find it an excellent tool. you would have to set it up on your site, it is a bunch of php scripts. i am not sure what tool they are using so I can't tell you if the script is messing up. the script I showed you will let you do anything with your database.

hope that helps

[KornChild]

I got this tool yesterday actually but I cant set it up or seem to get it to work, can you give me some newbie/beginner instructions on how to setup everything for it so it works perfect for me? Thanks for your help

[KornChild]

Well I tried loggin in FTP! For some reason it won't login and it keeps timing out!!! Is this something I could have messed up when I was trying to delete everything in the database even the smallest files??? Or is this just chance?

[scoutt]

It sounds like your ISP/F2 is having problems. if you are having troubles getting PhpMyAdmin started let me know what exactly you are having problems on.

did you make sure you put this line on top of most of the files.

#!/usr/local/php4/bin/php

you can put it in all the files and when you run it and see it on the page you can delete it from that file as it doesn't need it. You might have to change it for your server as this is only the default one.

I just went through all my files and these are the ones I don't have that line in.
Lib.inc.php3, ldi_table.php3, ldi_check.php3, header.inc.php3, footer.inc.php3, english.inc.php3, and config.inc.php3.
If that line is in a file that doesn't need it, it will still run. just make sure you put that line above <? that. then Chmod them all to 755. then if you need to configure the config.inc.php3 file to your database specs. password, login, database name. etc.

if you are still having problems let me know what thye are maybe I can sort through them with ya.
this should get you going though.

Scoutt

[KornChild]

Left FRAME

Home

Warning: Unable to save MySQL query result in /web/sites/124/clanlapd/www.clanlapd.f2s.com/phpmyadmin/left.php3 on line 273

Warning: Supplied argument is not a valid MySQL result resource in /web/sites/124/clanlapd/www.clanlapd.f2s.com/phpmyadmin/left.php3 on line 274

Main Right FRAME

Welcome to phpMyAdmin 2.1.0
MySQL 3.23.36 running on db.clanlapd.f2s.com:3306

Create new database [Documentation]

Show MySQL runtime information [Documentation]
Show MySQL system variables [Documentation]
Show processes [Documentation]
Reload MySQL [Documentation]
phpMyAdmin-Homepage
phpMyAdmin Documentation
Warning: You haven't enabled magic_quotes_gpc in your PHP configuration. PhpMyAdmin needs this to work properly. Please have a look at the configuration section of the PHP manual for information on how to enable it.



EHHHHH??? what now????

[scoutt]

Sorry it took so long. in the config.inc.php3 file and on these line

$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '';
$cfgServers[1]['adv_auth'] = false;
$cfgServers[1]['stduser'] = 'root';
$cfgServers[1]['stdpass'] = '';
$cfgServers[1]['user'] = 'user';
$cfgServers[1]['password'] = 'password';
$cfgServers[1]['db'] = '';
$cfgServers[1]['verbose'] = '';

make sure you put the database name where it says db not between the ' '. But in the password, User, host, ones you need to put in between the ' '. leave the root alone and adv_auth. You don't need to do anything with the other lines that say $cfgServers[2]['db'] = ''; just edit the first ones.

On the host make sure you have the correct one. usually Localhost, but depends on F2. you might want to ask and see if you can run php in the main html folder. usually you need a cgi-bin folder.
try this and see what it does, if you have more problems let me know.

Scoutt

[KornChild]

here is what I have on my config file.

$cfgServers[1]['host'] = 'db.clanlapd.f2s.com'; // MySQL hostname
$cfgServers[1]['port'] = '3306'; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false; // Use advanced authentication?
$cfgServers[1]['stduser'] = 'clanlapd'; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = '578472685'; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'clanlapd'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = '578472685'; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';


I appreciate your help so far so take your time im not in a rush , thanks!

[scoutt]

ok try this. change the ones I have in bold

$cfgServers[1]['host'] = 'db.clanlapd.f2s.com'; // MySQL hostname
$cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false; // Use advanced authentication?
$cfgServers[1]['stduser'] = 'root'; // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = ''; // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'clanlapd'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = '578472685'; // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';


try that and see if it works. also make sure you have the right host, database name, password, and user, just to be on the safe side.

Scoutt

[KornChild]

Here is the error i am getting, i made a small 256 color bmp screen shot. I tried the settings you suggested and no luck : \

[scoutt]

it looks like it is not seeing your database. have you tried to contact them about what host to use, also they will have to setup the magic_quotes_gpc in their php ini. Did you tell them that you got that warning? I would think you have everything setup right it is just that it looks like the problem is on there end.
When I setup my database my ISP had to set the main database and name it and all I had to do was make tables. I don't think I can delete my own database without my ISP doing it. I would get a hold of them and ask them what is going on.

sorry I can't be more of help.

Scoutt

[scoutt]

try adding this line at the very bottom of the config.inc.

$old_val = ini_set(magic_quotes_gpc, 1);

put it right below the other one that is there.

[KornChild]

Hey thanks for your help! It worked but only part of it lol : \ on the left side of the frame (make sure you scroll to see it) I still get the same error, what now? I really appreciate all your help thanks man!

http://www.clanlapd.f2s.com/phpmyadmin/index.php3

[scoutt]

this line in your config file
$cfgServerDefault = 1;

I think the default is 0, change this to 1 if it is not.

I think you have the wrong host name or database name. The left side is trying to connect to the database but coming up with errors. that is what leads me to believe there is an error somewhere. see where it says home on the left? it should show the databases underneath it.

did you make the first database or did F2 make it for you?

[KornChild]

well I logged into my f2s account and created the database through f2s so.........

[scoutt]

hey I just took another look and it seems to be working, except for that magic_quote. did you fix it and what was it?

[KornChild]

Thanks so much for your help! I guess I didn't give it enough time to refresh! Everything worked perfect. One really quick question tho that has nothing to do with database. I have frames setup on my website and when the user clicks a link in the main frame (right) the link comes up but the menu frame (left) appears a 2nd time, is there a way to just click a link in the main right side and have it appear in the main right side? Thanks again so much for your help!

[KornChild]

Hey thanks alot for your help, that target code u gave me for the frames worked perfect! I appreciate it!

[scoutt]

cool, don't mention it.