"Featured Products" contribution; porblems in completing the last step (adding the table to the database)!

[araisi]

Hi all!

 

I've been trying to install the Featured products contribution for days now. I've downloaded version 1.5.2 of the contribution and I've completed all steps :) (1-10) besides the last one <_< (11) which says:

 

"Now you need to create the database table that will be holding the featured products. You need to run the featured_products.sql file's contents in your favourite sql interface (like phpmyadmin) to your database."

 

My problem with doing this step is that first of all I don't have a program called "phpmyadmin", well now i've downloaded it but there's just a bunch of php files in the program folder. The second problem is that I wouldn't know how to use the program.

 

However, my hosting company has provided me with a program called Mysql (or SQLyog, I'm not sure which is which). As I am new to this kind of stuff :blush: I don't know what I could do with this program. I tried to "execute" the featured_products sql file with it but it just came up with an error:

 

Line no.:10

Error Code: 1046 - No database selected

 

Query:

create table featured (

featured_id int(11) not null auto_increment,

products_id int(11) default '0' not null ,

featured_date_added datetime ,

featured_last_modified datetime ,

expires_date datetime ,

date_status_change datetime ,

status int(1) default '1' ,

PRIMARY KEY (featured_id)

)

 

I don't know what this means, or if I can do the last step with this program at all.

 

So my questions are; how can i run phpmyadmin?

can i do the last step with SQLyog, and if I can HOW??

 

Any help is appreciated!!

[skylla]

you can run phpmyadmin by 'dragging' the whole folder to your catalog/admin folder on your server, for instance by FTP. You will have to set db location, login and pwd in mysql.ini file, which you can do before you copy everything onto your server.

 

then go to your-domain/catalog/admin/phpmyadmin using your browser. use the SQL tab to run queries/make changes to your db

[araisi]

you can run phpmyadmin by 'dragging' the whole folder to your catalog/admin folder on your server, for instance by FTP. You will have to set db location, login and pwd in mysql.ini file, which you can do before you copy everything onto your server.

 

then go to your-domain/catalog/admin/phpmyadmin using your browser. use the SQL tab to run queries/make changes to your db

 

OK, so i "dragged" the folder into catalog/admin using Filezilla. But i can't find the mysql.ini file, and what and where is the SQL tab (as you've probably noticed I am pretty much out when coming to db and php. stuff :blink: )

 

Appreciate it!

[skylla]

sorry, it should be config.inc.php. The bit to change is the server configuration and you'll need to know the mysql host name, user and pwd.

 

Save the file and upload to the same directory you found the file in.

[skylla]

http://www.phpmyadmin.net/documentation/#config

 

btw you have your admin folder pwd protected, right?

[araisi]

I searched the whole phpmyadmin folder in my desktop and found config.class, config.default, db_config.lib and config.auth.lib, but no config.inc.php. But in this link that u put here it says under the "quickinstall" that I should "create" a config.inc.php file. I'm really confused now...(and yes my admin pwd is protected).

[skylla]

There is a file called documentation.html with some info on this.

 

You actually have to create this file (in notepad for instance) in the top-level directory phpmyadmin (renamed from phpMyAdmin-2.8.2 in my case, it also contains index.php). you can use the setup.php file as a template, which you can find in the scripts folder.

 

good luck

[araisi]

HEUREKA!!! IT WORKS!!!

 

I fiiiiiiiinally got phpmyadmin working. But now only remains completing the last step of the contribution. How can this be done with this program?

 

cheers!

[araisi]

Nevermind! i got it aaaall fixed

 

I appreciate all the help you've given me.

 

Thank you!

[skylla]

well done and good luck!