On The Fly Contrib help required

[Aussie Dizzy]

Hi There,

 

I have sent this to one of the people in the contrib area but I need to get this resolved ASAP, so I am no posting here for a rapid response.

 

 

I've just downloaded the ON The Fly Auto Thumbnailer and proceeded to complete everything as per the Read Me file but I have hit a stumbling block.

--------------------------

Step #6 Run the SQL statements

 

Find the file auto_thumbnailer_admin.sql and run it on the your database.

--------------------------

 

I found the file but I don't know how to run it on my database. I am using MyPHPAdmin and I am a novice user to all this PHP and database stuff. Any chance you could help me?

 

I think this is a problem I am facing, because after setting everything up my catalog page now shows:

------------------

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/sa/san/mydomain.com.au/public/www/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

-------------------

 

I appreciate your help if you can.

 

Cheers

 

Dizzy

[Aussie Dizzy]

Further to this, I have sorted out the database stuff (special thanks to cujimmy) but I am still having the following error:

 

------------------

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/sa/san/mydomain.com.au/public/www/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

-------------------

 

I have cross references the various files for anomalies and came up blank.

 

Any ideas anybody?

 

Cheers

 

Dizzy

[d4funky1]

Hi Dizzy,

 

Enter phpmyadmin and click on your database name

 

the screen should be split in two, on the right side at the top you should have headings structure, search, sql, query, export.

 

click on sql

 

in the blank box provided copy and paste the sql code from the file auto_thumbnailer_admin.sql and then click on 'GO' this will quickly add the information required to your database.

 

Any further problems give me a shout

 

D4

[Aussie Dizzy]

Hi Dizzy,

 

Enter phpmyadmin and click on your database name

 

the screen should be split in two, on the right side at the top you should have headings structure, search, sql, query, export.

 

click on sql

 

in the blank box provided copy and paste the sql code from the file auto_thumbnailer_admin.sql and then click on 'GO' this will quickly add the information required to your database.

 

Any further problems give me a shout

 

D4

 

Hi D4,

 

I've managed that bit all okay, but since doing that and changing the relevant files as per the instructions I am faced with the error message when trying to open the XXX/catalog.

 

I'm nearly bald now :blink:

 

Cheers

 

Dizzy

[Aussie Dizzy]

This issue has now been resolved, thanks to all that have assisted.

 

Cheers

 

Dizzy