Hello everybody,


I can't add a new database in MySQLadmin 1.4 :blink:

When I right click, I don't have this option ??

I uninstall and reinstall it but the problem is still there.

Did you know a trick to add a database ?

Thanks for your help


This is because I want to try IBF in my home pc :lol:

This is from the package of mysql-4.0.17

Why not do it manually? ;)

http://www.mysql.com/doc/en/mysqladmin.html

So drop to the shell and run mysqladmin create databasename

Hope this helps some Bads :)

/JD

Thanks JacKDynne for your help but I don't know wich command I have to enter :blink:

Ok,


Now I have create a database but the database is empty ?

A meesage from my webpage:


mySQL error: No Database Selected

Bads,

You have php installed? You will need it for ibf and since you will need it then I suggest using phpmyadmin to manipulate your db. Much easier than going command line ;) :)

Lol - look what popped up when I did a google search:

:D

/JD

I have PHP installed,

Now I will try to install phpmyadmin if I find how :D

And for the tutorial of Will, I'm working with it

Cool :)

Holla if you need more help :)

/JD

This is the error I get

Hmm could be a rights issue - you have all the config files using the correct info and does the account used have enough permission?

The problem is the "IBF" Database

She's empty :(

And I can't make one with mysqladmin :blink:

Bads,

Did you run the installer?

That should take care of populating the db ;)

:)

/JD

Yes I run the installer and this is why I receive the message :

mySQL error: No Database Selected

hmmm..... does your conf_global.php file have the following values filled in?

Yes,

I have this

All right bads. hehe

I know what the problem is.

I'm sure you mean no right click menu in msyql. They removed it. Dont have a clue why.

So instead what you need to do is this.

Will update my guide later. Sorry about that. Forgot they did that.

Fist click run:

Then cmd.

Then:

cd C:\mysql\bin

and then run this command to create the database

mysqladmin create ibf -h localhost -u "username" -p "password" -p 3306

where it says username but your mysql username and for password put your mysql password and remove the " " marks of course

now it sould say:

Enter password: ********
mysqladmin: Unknown command: 'password here'

Its a bug. But if you run the command again you will see it was created succesfully and already exists. :)

Then just run the invsionboard installer sm_install.php

then for database name is ibf and type in your user name and pw

then it should work fine

if not then pw and user name where wrong and u know that by now since u would get pw wrong error above

so then you need to edit your my.cnf or my.ini file which should be in your windows or winnt directory

any more problems just ask but you should be good to go

oh and about phpmyadmin

think i will add how to install that to my guide too..going to update the whole thing this weekend :)

anyways download phpmyadmin and put it in your server directory

then open config.inc

and edit it to your needs...its very very well documented so you should have no problem with that...

but anyways u just have to edit line 80 and 81:

$cfg['Servers'][$i]['user'] = 'username goes here'; // MySQL user
$cfg['Servers'][$i]['password'] = 'password goes here'; // MySQL password (only needed
// with 'config' auth_type)

do not use root

thats it there is no installer

u just then open /phpmyadmin/index.php in your web browser and your good to go... basic setup anyways...just check that config.inc for all the other settings you can change...just be sure to back it up...

really should be using a php editing program that backs up automatically...

i use TextPad

Ok,

This is an empty Database who was created but I hvae one.

Now the problem is:

Warning: mysql_connect(): Access denied for user: 'xxxxxxx@localhost' (Using password: YES) in D:\Inetpub\wwwroot\ibf\sm_install.php on line 342

Ok,

I have to edit some lines ;)

Now I receive this message :

Success
Your board has now been installed!

The installation process is almost complete.
The next and final step will install the template files into your database


CLICK HERE TO CONTINUE

All is ok now my friends ;) Thanks for your help again and again

Not really finished :angry:


When the setup is finish and I click on the "CLICK HERE TO LOG IN!"

I have this message :

mySQL query error: DELETE FROM ib_beta_sessions WHERE running_time < 1080249293 or ip_address='xxx.xxx.x.xxx'

mySQL error: No Database Selected
mySQL error code:
Date: Thursday 25th of March 2004 05:14:53 PM

It's almost finished :(

So did you name the datebase ib_beta then?

And you used that when you created the database and in the ivisionpower board installer right.

Have to be the same. Seems like there is a mismatch somewhere. Seems like since it says no database requried.

Even though not sure how the hell it would get to the very last window in the installer and then give that error message. Seeing as it buids the database way before then.

Just start from strach. Seeing as it takes 3secs. to install it over again.

I mean if that dont work cause its probally currupted.

And of course make sure mysql is running. :P Have done that before.

cya,
Will

I just tried to reinstall 4 times and I always receive the same message.

Sql is running and the name of the database and the installer are the same "ibf"


Why I can't login ? I have to link the database but where ?

Try Ultraedit ;) Saves a backup when you save the file :)

Gotta run right now Bads but will holla back in the morning :)

/JD

Edit - check this in the meantime :) http://forums.pcst.org/index.php?act=ST&f=5&t=22

Well you missed up then somewhere.

Cause read it carefully.

mySQL query error: DELETE FROM ib_beta_sessions WHERE running_time < 1080249293 or ip_address='xxx.xxx.x.xxx'

Its trying to connect to ib_beta instead of just ibf.

If it were connecting to the right database but something else went wrong it would say:

wtf it keeps etting my post lol stupid pos

it should say Delete FROM ibf _sessions instead....

So you had to have messed up some where. Its diffenetly not the script.

You are right War,

I didn't see the "ib_beta" before :blink:

I will try to start from scratch tomorrow ;)

Thanks again and goodnight :lol:

I just get out from the bed :D

And in 5 minutes, I have reinstall a new forum ;)

Now this is real, all is working fine in the forum


<span style='color:red'><span style='color:red'>Thanks to all of you for your precious help</span></span>

Told ya. :P

Glad you figured it out. So i take it you love my quide then?

Any comments? Cuase like I said i'm going to update it this weekend.

cya,
Will

Yes,

I like your guide ;)

You have to update the links for the new version of ibf, php etc.........and you can add some informations needed by a newbie like me :D

Yeap will do. Might even change the layout. Maybe even do like power point toturial type deal.

Not sure yet.

What exact guide are you looking for?

Hope these might be useful. I thought I already had them shared.

How-to-Run-your-own-IPB-Forum-in-your-Local-PC-using-Apache
How-to-Run-your-own-IPB-Forum-in-your-Local-PC-using-IIS
How-to-run-a-HTTP-File-Server-using-IIS.

Cheers,
McoreD

WoW,


Thanks McoreD ;)


I just add them all to my collection :lol:

ok cool f it then lol

Can you please elaborate a little? :unsure:

F updating my guide. :P

unless someone wants me too

seeing as mine was like first but old as hell ;)