Try this Installer

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

To those that had installer woes, please download Only registered users can see links on this board! Get registered or login! and replace yours and see if that fixes it. Let me know. And please just don't say things like "Nope. Didn't help". because I will say "hmmmmm". Laughing

Posted: Sun Jul 18, 2004 7:59 pm

This is the screen I got after installing the new index.php

Code:

===========


localhost


****


****


===========





Connected successfully to your MySQL Server!





Unable to connect to MySQL database mysql with these credentials: Access denied for user: 'sharlein_sharlei@localhost' to database 'mysql'

There is nothing else on that page. Smile

Posted: Sun Jul 18, 2004 8:13 pm

Hopefully I edited that in time so that no one saw that info Smile

Posted: Sun Jul 18, 2004 8:48 pm

Thank you very much. Embarassed

Posted: Sun Jul 18, 2004 10:30 pm

Well, I have discovered that it works in Windows but not in Linux, so that explains why I wasn't able to reproduce it. Now to figure out why ......

Posted: Sun Jul 18, 2004 11:15 pm

Okay, I've got this working, I hope/think, under Linux. Please try d/l it again and running it.

Posted: Mon Jul 19, 2004 9:33 am

Steve and GeekyGuy:

Have you downloaded and tried the new installer?

Posted: Tue Jul 20, 2004 8:42 am

The new installer worked better, but I still found it a little confusing. It seems it didn't like the fact that I had set up the db in cpanel, the installer complained that the db already existed, but how was I suppose to give permissions to user without a db?

Not sure what the line 66 is about either.

Connected successfully to your MySQL Server!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cody/public_html/install/index.php on line 66

Note: This user does not have Create Database Permissions for this MySQL server. Either select another user/pass combination or you will need to create the database first and then come back to this utility to create the tables.

And despite all that, after I chose replace the db, all 124 tables were created and populated!

Posted: Tue Jul 20, 2004 11:16 pm

It worked exactly as designed. Connecting to the server does not mean that you have any permissions. It just means that MySQL can be connected to. I agree that the FINAL version needs polishing, but this was to test the functionality. Thanks.

Posted: Tue Jul 20, 2004 11:42 pm

One more thing... I checked in phpmyadmin... and I have 125 tables! How did I get an extra one? I'm sure the installer said 124.

Posted: Tue Jul 20, 2004 11:53 pm

Well, since I do not have a crystal ball to look into YOUR phpMyAdmin, my guess would be if you are using the Who Is Where block, the first time you accessed your site it created a HEAP table called nuke_wiw_m

Posted: Wed Jul 21, 2004 2:01 am

ahhhhhhhhh... interesting. Thanks.

Involved Joined: Jul 15, 2004 Posts: 252 Location: OKC, OK

I found out something, when I used phpMyAdmin it would not create the nuke_wiw_m one but when I went stright to MySql it would create it.

To new to this to know why but just thought I would throw that out as an FYI.

Posted: Wed Jul 21, 2004 10:54 am

Yes, I need to contact the phpMyAdmin author. He has a bug Surprised

Useless Joined: Aug 23, 2002 Posts: 213 Location: Chicago

How do you guys make those install files? Do you hand code every single file of it ot is there a tool to drop SQL file and get an install file?

Posted: Sat Oct 02, 2004 10:20 pm

Depends on several factors, but once you have the table designed and working, you just dump the table schema and then you wrap the SQL in PHP code. That's really high level, but that's usually the premise.

Posted: Sat Oct 02, 2004 10:37 pm

Can I by any chance see an example on how to code one based on an SQL table.

Posted: Sat Oct 02, 2004 10:38 pm

My "PHP for Dummies" doesn't show me how to do that Very Happy