How to use madcat?

[cheo25]

Any idea what I'm doing wrong here?

madcat_error.png (173.04 KiB) Viewed 3175 times

[Palyarmerc]

Use the PHPmyAdmin in WAMP (left click icon in system tray when WAMP is running)
Create a database.
Ideally, the databse created has no password initially.
All these details need to be entered into the _mysql.php
Tick the do not create database...you've already done that bit

NOTE my bad, because I don't initiall set password (long story) but if you password your database in WAMP
the install.php will need these lines changed (search for possibly 3 occassions)

.............HOST, MYSQL_USERNAME, MYSQL_PASSWORD); //, MYSQL_PASSWORD
or ....BASE == "" || MYSQL_HOST == "" || MYSQL_USERNAME == "") // MYSQL_PASSWORD == ""
and change to
.............HOST, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_PASSWORD);
or....BASE == "" || MYSQL_HOST == "" || MYSQL_USERNAME == "" || MYSQL_PASSWORD == "")

One further edit to this post
I'm not sure i like your folder structure.
MADCAT should be in it's own folder /madcat194
madcat194/install/install.php
madcat194/config.php
madcat194/index.php
madcat194/_mysql.php
madcat194/admin/index.php
etc etc

[cheo25]

Thanks for the quick response. I'm not sure I understand all of this, but I will try to change what I can. Pretty sure I can change the folder structure. I may just start from scratch and try to re-install. Thanks again!

[Palyarmerc]

Most of the files code you should not need to touch, and if you are unfamiliar with SQL PHP programs, it can be daunting.
I'll try and re-write area of the tutorial that seem complicated.

The lines I am asking you to change are (if you look closely) complete. // in php means "dont read this line"
so you simply put it back into the bracketed area. Hope you get that.

Now, provided you have created a Database in WAMP called nfl un-passworded (normally is by default, or it will be your e107 password if you installed it)
all you really should have to do is
1) unzip the folder to wamp, (it is in a folder called madcat194 and folder structure should be kept)
2) specify your details in the _mysql.php (leaving password blank at this point, or try with (but edit the install.php to ask for the password! as mentioned)
3) navigate your browser to install.php, tick do not create database and hit return

It really should be that simple.

[cheo25]

Palyarmerc, I really appreciate your patience. I am pretty good with HTML but that's the extent of my computer knowledge, so this is all new ground. I will try your suggestions later today when I get home and have a little bit more time.

I might post if I have more trouble, but I'm hoping it goes smoothly and I certainly don't want to be a pest. Thanks again for all of your help.

[Palyarmerc]

No worries, I'm even prepared to chat with you on Teamspeak to get it working.

I have updated the Tutorial

I have goofed the installation process (thanks for feedback at footballidiots)
Here is the new install folder
Madcat_Install_Folder.zip
navigate to the install_passworded.php if you used a password

Remember the main difference between html and php is single ' ' quotes "", you'll pick it up easily enough.

[cheo25]

I'm pretty much having the same trouble. I wonder if in part it's because your demo has e_107 1.0.2 and I'm using e_107 1.0.4. You had the option of not setting a password when installing e_107, whereas I had to enter one because it was required. The e_107 1.0.2 version doesn't appear to be available for download, which is why I'm having to use 1.0.4.

Also, I wonder if maybe my computer has a setting that is messing things up?

[Palyarmerc]

That's ok, I just upgraded to 1.4 too.

Just install the new install folder (overwrite the old one)
set your _mysql.php with all values

$mysql_host = "localhost";
$mysql_username = "root"; // or whatever your main username is
$mysql_password = "your e107 password";
$mysql_database = "your madcat database"; // not your e107 one
$mysql_prefix = "madcat_";

and navigate to the install/install_passworded.php (click do not create database) and it should work

[cheo25]

Nope, still no dice. I've tried just about everything.

I think I'm gonna step away from it for a few days and maybe try again over the weekend.

I appreciate the help. Thanks for your patience.

[Palyarmerc]

Actually, looking at your folder structure, it looks like you are trying to install WAMP with the MADCAT installation folder.

In fact file:///C:/wamp/install/install.php is all wrong you should be on your http home serverlocalhost/madcat194/install/install.php

You have to install WAMP, your home computer web server
Once this is done,you have to run it and you'll see a W in the system icon tray
Then you alter the settings in WAMP for short_open_tag (right click the W, and tick it, in PHP settings)
// Then you Install e107 (that creates it's own database quite successfully) // actually this bit is optional website content operating software
Then you install MADCAT (creating a database in WAMP first of course)

Read through my tutorial again, let me know if I omitted to mention anything, or could re-write it to be clearer about anything that confused you