Error when adding to vBadvanced module

[kaelaria]

I've added a new module to use the inc_ads.php but get

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 56

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 108

on the page I'm trying to integrate to.

What am I missing?

[Chuck S]

This should help you out. Basically your classifieds and forum are in separate databases right?

http://www.photopost.com/forum/showp...89&postcount=1

You need to uncommnent the $link and mysql_select_db lines and fill them out with the proper information. The thread linked explains more.

[kaelaria]

Yes that did help, thank you! My big problem was waiting for the cron to get me 'verified' so I could see the codes

I've decided to just add an entry in the main menu to the 'last 1 day of ads' though, that works very well for what I need!

[DSades]

what does this mean:

Warning: getimagesize() [function.getimagesize]: URL file-access is disabled in the server configuration in /classifieds/inc_ads.php on line 119

[Chuck S]

It means you can not use a url to get info about the file

In inc_ads.php try adding this line and make sure its the server path to classifieds data directory cause right now we use the config-intc.php and the data url

Content visible to verified customers only.

[DSades]

edit:

Okay, no error now, but the pictures don't show up (they're black boxes) and the tables get all screwed up (pushed to the right side, which push the entire site to the right)

[Chuck S]

If they images are black boxes your data url is missing a trailing slash

[DSades]

disregard. Same error as ReviewPost Module.

[DSades]

Okay, played around with it, and now the header bar is there, the images are lined up nicely... great, right? nope... no image. Black boxes again

I checked the DATA URL and DATA PATH and both have trailer slashes. Got another reason it's not working?

p.s. adding the "$cldata_dir="/var/www/html/classifieds/data/";" helped it get the module in, at least.

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

strange. When I move the Classified module above the PhotoPost module (which works great) I get the "unable to connect to MySQL" once again. When I move it back below PP module, it shows up (works) but the images are black.

Does that help at all?

[Chuck S]

Well remember you changed the data path in the file to account for a server setting that disabled url access thus in the line below you want to replace that variable you changed with hard coding the url to the data directory to overcome the issue

Content visible to verified customers only.

[DSades]

Hard-coded it in. When I check the source code, it points to the correct image. Great! Exceeeept: still a black box. No idea why.

Chuck, can I just pay you to fix the Reviews and Classifieds module?


edit: URL: www.propcircle.com under PhotoPost, you see what's going wrong. ReviewPost module is activated as well, but it doesn't even show up in the source code.

[Chuck S]

You left a { tag in the url when you edited the file

[DSades]

ugh..... someone kill me. It seems to be working now. But here's my last post anyway:



I went to vBadvanced forums, and they told me to run the file from the command line. Exhibit A:

http://www.propcircle.com/modules/bazaar.php

Here are the changes I made in inc_ads.php:

-added the second line:

require "config-intc.php";
$cldata_dir="/home/clonesix/propcircle.com/bazaar/data/";

-hard coded this in (without the "{"):

<tr>
<td style="background: url(http://www.propcircle.com/bazaar/data/{$pcat}/thumbs/{$product}); background-position: 50% 40%; background-color: #000000; background-repeat: no-repeat; background-position: center;"><a href="{$class_path}/showproduct.php?product={$pid}">$mthumb</a></td>

Here's the module file:

<?php
include('/home/clonesix/propcircle.com/bazaar/inc_ads.php');
echo "$classifiedsfeature";
?>

Here's the URL in config-intr.php:

// The URL of your product dir where your images are stored (with / at end)
$rpdata_dir = "http://propcircle.com/review/data/";

[Chuck S]

Yes it works cause you removed the { you left in the file url