PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds How do I...? (http://www.photopost.com/forum/classifieds-how-do-i/)
-   -   Error when adding to vBadvanced module (http://www.photopost.com/forum/classifieds-how-do-i/123747-error-when-adding-vbadvanced-module.html)

kaelaria March 13th, 2006 03:49 PM

Error when adding to vBadvanced module
 
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 March 13th, 2006 04:56 PM

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 March 13th, 2006 05:00 PM

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 March 20th, 2006 12:16 AM

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 March 20th, 2006 08:56 AM

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

Code:

Content visible to verified customers only.

DSades March 20th, 2006 06:05 PM

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 March 20th, 2006 08:01 PM

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

DSades March 20th, 2006 10:32 PM

disregard. Same error as ReviewPost Module.

DSades March 21st, 2006 04:30 PM

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 March 21st, 2006 06:55 PM

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

Code:

Content visible to verified customers only.

DSades March 21st, 2006 08:02 PM

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? :D


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 March 21st, 2006 08:24 PM

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

DSades March 21st, 2006 10:09 PM

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:
Quote:

require "config-intc.php";
$cldata_dir="/home/clonesix/propcircle.com/bazaar/data/";
-hard coded this in (without the "{"):
Quote:

<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:
Quote:

<?php
include('/home/clonesix/propcircle.com/bazaar/inc_ads.php');
echo "$classifiedsfeature";
?>
Here's the URL in config-intr.php:
Quote:

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

Chuck S March 22nd, 2006 08:15 AM

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


All times are GMT -5. The time now is 02:24 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97