I am totally lost with inc_features

[mrimmer]

www.virtualrealitymc.com/PhotoPost

I have tried to run one database and also now in seperate databases.

The gallery works fine either way and I can not get this inc_features to work.

I get the

line 54 and line 119 error either way I go. I have tried the uncomment and everything I have read for days and still no go

I want to put a box on the home page

www.virtualrealitymc.com that will show random photos.

What am I doing wrong?


Hope someone can help me

Mike

[b6gm6n]

It's a matter of selecting the right database it seems to me, my advice to you would be stick with the one database, no need to comment out those lines and report back with any success or errors then we'll go from there

-b6

[Chuck S]

Also make sure if your using a table prefix for photopost make sure under edit integration options the table prefix is entered

[mrimmer]

Ok back to one database and the table prefix is pp_


Still the same problem. I know that is me and I am missing something

http://www.virtualrealitymc.com/Phot...c_features.php

[Chuck S]

In your edit integration settings you must set your photopost table prefix in there

[mrimmer]

// If your PhotoPost tables have a prefix, put it here
// Example:
// pp = "pp_";
$pp_db_prefix = "pp_";

Still no go

[Chuck S]

Then it has to be something else you have edited in that file. Like do you still have the mysql and link statements uncommenting pointing to other databases

[mrimmer]

I just sent an email to support, Chuck

It has a login and password as an admin

No I do not have the file uncommented

Thanks, for all your trouble

Mike

[mrimmer]

Just incase I uploaded a unmodified file and still get the same error


Mike

[W@NKER]

What was the solution to this problem?
http://www.sushi-inc.dk/photopost/inc_features.php

Then I get the same errors

both vb and photopost are on same db

this is from my config-int
------------------------------------
// We need to know the server paths to both your vB installation and your PhotoPost installation
$vbpath = "/home/y-10147/www/forums";
$pppath = "/home/y-10147/www/photopost";

// We need the URL path to your PhotoPost and vb installation
$url_path = "http://www.sushi-inc.dk/photopost";
$vb_urlpath = "http://www.sushi-inc.dk/forums";

// The URL of your photo dir where your images are stored (with / at end)
$data_dir = "http://www.sushi-inc.dk/photopost/data/";

// If your PhotoPost tables have a prefix, put it here
// Example:
// PP_ = "pp_";
$pp_db_prefix = "pp_";
-------------------------------------

I have tried many things without any luck, can anyone help me here?

Thanks in advance

Mikal

[Chuck S]

Do you have other hacks installed?

This is the error I see

Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

That means we can't connect to mysql. Have you tried uncommenting the link statements and select database things and fill in all the proper connect info?

I tried viewing your forum but it never loads and I am on a cable line connection

[W@NKER]

Hi Chuck

Yes I have tried uncommenting the link statements and select database. When I do that it only says that it cant connect to the database because username and password doesnt match (something like that).

But it is wierd because photopost is working fine, so it should work without uncommenting in inc_features.php?

My site works now, it seems that my hosting provider had some problems earlier. but it should work now. so you should be able to connect now.

Thanks in advance

[Chuck S]

Hello You need to fill out the exact information in the link statement for user password host and database names. If your getting an error saying the info is wrong then it is not entered correctly.


I still see the mysql can not connect through socket issue.

[W@NKER]

ok I have changed it to this:

-----------------------------------------
$link = mysql_connect ("mysql.sushi-inc.dk", "xxxx", "7qxxxxx") or die('I cannot connect to the database.');
mysql_select_db ("tarzan")or die("Could not select photopost database");

// Number of photos to display
$num_display = 1;

// Number of columns (1 for vertical)
$columns = 1;

// which type of images do you want to show (random, most_view, latest)
$q_switch = "random";
-------------------------------------------------

Is that correct?

But now I'm getting this:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/y-10147/www/photopost/inc_features.php on line 54

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/y-10147/www/photopost/inc_features.php on line 119

[Chuck S]

Okay so its not getting the information from your config-int.php file at all

Do a test in the file place your $pp_db_prefix line like so after $qswitch and fill out the prefix

$pp_db_prefix = "pp_";

[W@NKER]

Thanks!

That did the trick
But why it don't get the info from config-int. I dont know

[Chuck S]

Well I dont know enough about your install to say. Is the variable truly set in the config-int.php?

[W@NKER]

I just checked and no it was set to vb_

Well now I will stop fiddling with this when I'm to tired

Sorry bout that!

But again thanks for your help

[Chuck S]

Well then there was the issue