Help please - Photos are not showing

[RayWilk]

Hello

on my site, uploaded photos are not showing, only "No Image Available"

on the Sell & Wanted Ads pages is a upload a photo option to display a photo with the Ad,

I have listed a couple of Sell and Wanted Ads, yet no photos are showing, only the "No Image Available"

I looked in: /public_html /uplimg and yes the photos/images have been uploaded to the server,

if you look at the Home page http://numberthree.netne.net/index.php you will see the "No Image Available"

your help appreciated

[NogDog]

The HTML is specifically pointing to a "noimg" image, and so that is what is displayed. Without seeing the server-side (presumably PHP?) code that generated that HTML, we have no idea why that HTML was output.

[RayWilk]

Hello NogDog

I do appreciate you looking and offering help,

How can I assist you in sorting out the problem?

I went to phpMyAdmin

searched for "ad_image"

1 match(es) inside table content_pages

Clicked on Browse, info below

COLLATE latin1_general_ci
OR topic_content LIKE CONVERT( utf8 '%ad_image%'
USING latin1 )
COLLATE latin1_general_ci
OR topic_lang LIKE CONVERT( utf8 '%ad_image%'
USING latin1 )
COLLATE latin1_general_ci
OR topic_order LIKE '%ad_image%'
OR reg_date LIKE '%ad_image%'
OR page_id LIKE CONVERT( utf8 '%ad_image%'
USING latin1 )
COLLATE latin1_general_ci
OR page_handle LIKE CONVERT( utf8 '%ad_image%'
USING latin1 )
COLLATE latin1_general_ci
OR show_link LIKE '%ad_image%'
)
LIMIT 0 , 30

[cretaceous]

you need to show nogdog the piece of php code that is generating the html - the fact the image is uploaded and shown in phpMyAdmin is not the key point here

show the content of index.php and any relevant code that is used to display images..

[RayWilk]

Hello cretaceous & nogdog, thank you for your replies,

I will happily to give you are copy of all the script files, to assist you, yet I am unable to PM you with a link,

here is the index.php: please tell em what you need, and understand my understanding of scripts is limited 🙂

<?
#################################################################

PHP Pro Bid v6.10

##-------------------------------------------------------------##

index.php

##-------------------------------------------------------------##
#################################################################

session_start();

define ('IN_SITE', 1);
define ('INDEX_PAGE', 1); ## for integration

if (!file_exists('includes/config.php')) echo "<script>document.location.href='install/install.php'</script>";

include_once ('includes/global.php');

include_once ('includes/functions_login.php');
include_once ('includes/functions_item.php');

if (stristr($_GET['option'], 'logout'))
{
logout();
}

include_once ('global_header.php');

if (isset($_GET['change_language']))
{
$all_languages = list_languages('site');

if (in_array($_GET['change_language'], $all_languages))
{
	$session->set('site_lang', $_GET['change_language']);
}

$refresh_link = 'index.php';

$template_output .= '<br><p class="contentfont" align="center">' . MSG_SITE_LANG_CHANGED . '<br><br>
	Please click <a href="' . process_link('index') . '">' . MSG_HERE . '</a> ' . MSG_PAGE_DOESNT_REFRESH . '</p>';
$template_output .= '<script>window.setTimeout(\'changeurl();\',300); function changeurl(){window.location=\'' . $refresh_link . '\'}</script>';

}
else if (isset($_GET['change_skin']))
{
$all_skins = list_skins('site');

if (in_array($_GET['default_theme'], $all_skins))
{
	$session->set('site_theme', $_GET['default_theme']);
}

$refresh_link = 'index.php';

$template_output .= '<br><p class="contentfont" align="center">' . MSG_SITE_SKIN_CHANGED . '<br><br>
	Please click <a href="' . process_link('index') . '">' . MSG_HERE . '</a> ' . MSG_PAGE_DOESNT_REFRESH . '</p>';
$template_output .= '<script>window.setTimeout(\'changeurl();\',300); function changeurl(){window.location=\'' . $refresh_link . '\'}</script>';	

}
else
{
include_once ('global_mainpage.php');
}

include_once ('global_footer.php');

echo $template_output;

?>

[cretaceous]

ok - that is only part of the story - could you do the same for the file
global_mainpage.php
and wrap it in the forum PHP tags to mke it easy to read (the PHP button in 'Go advanced' page)

• the problem may be hard to diagnose if you are very new to PHP !

[RayWilk]

Hello cretaceous, yes impossible to diagnose, I very new to PHP, hoping someone else can spot the problem 🙂

<?
#################################################################
## PHP Pro Bid v6.10															##
##-------------------------------------------------------------##
## Copyright ©2007 PHP Pro Software LTD. All rights reserved.	##
##-------------------------------------------------------------##
#################################################################

$adult_categories = array();

$sql_select_adult_cats = $db->query("SELECT * FROM " . DB_PREFIX . "categories WHERE minimum_age>0 AND parent_id=0");

while ($adult_cats = $db->fetch_array($sql_select_adult_cats))
{
	reset($categories_array);

foreach ($categories_array as $key => $value)
{
	if ($adult_cats['category_id'] == $key)
	{		
		list($category_name, $tmp_user_id) = $value;
	}
}

reset($categories_array);

while (list($cat_array_id, $cat_array_details) = each($categories_array))
{
	list($cat_array_name, $cat_user_id) = $cat_array_details;

	$categories_match = strpos($cat_array_name, $category_name);
	if (trim($categories_match) == "0")
	{
		$adult_categories[] = intval($cat_array_id);
	}
}
}

$adult_cats_query = null;
if (count($adult_categories) > 0)
{
	$adult_cats_list = $db->implode_array($adult_categories, ', ', false);

$adult_cats_query = ' AND (category_id NOT IN (' . $adult_cats_list . ') AND addl_category_id NOT IN (' . $adult_cats_list . '))';
}

if ($layout['hpfeat_nb'] && !$setts['enable_store_only_mode'])## PHP Pro Bid v6.00 home page featured auctions
{
	$featured_auctions_header = header1(MSG_FEATURED_AUCTIONS . ' [ <span class="sell"><a href="' . process_link('auctions_show', array('option' => 'featured')) . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('featured_auctions_header', $featured_auctions_header);

$select_condition = "WHERE
	hpfeat=1 AND active=1 AND approved=1 AND closed=0 AND creation_in_progress=0 AND deleted=0 AND
	list_in!='store'" . $adult_cats_query;

$template->set('featured_columns', min((floor($db->count_rows('auctions', $select_condition)/$layout['hpfeat_nb']) + 1), ceil($layout['hpfeat_max']/$layout['hpfeat_nb'])));

$template->set('feat_fees', $fees);
$template->set('feat_db', $db);

$item_details = $db->random_rows('auctions', 'auction_id, name, start_price, max_bid, currency, end_time, buyout_price', $select_condition, $layout['hpfeat_max']);
$template->set('item_details', $item_details);
}

if ($layout['r_hpfeat_nb'] && $setts['enable_reverse_auctions'])
{
	$featured_reverse_auctions_header = header1(MSG_FEATURED_REVERSE_AUCTIONS);
	$template->set('featured_reverse_auctions_header', $featured_reverse_auctions_header);

$select_condition = "WHERE
	hpfeat=1 AND active=1 AND closed=0 AND creation_in_progress=0 AND deleted=0";

$template->set('featured_ra_columns', min((floor($db->count_rows('reverse_auctions', $select_condition)/$layout['r_hpfeat_nb']) + 1), ceil($layout['r_hpfeat_max']/$layout['r_hpfeat_nb'])));

$template->set('feat_fees', $fees);
$template->set('feat_db', $db);

$ra_details = $db->random_rows('reverse_auctions', 'reverse_id, name, budget_id, nb_bids, currency, end_time', $select_condition, $layout['r_hpfeat_max']);
$template->set('ra_details', $ra_details);
}

if ($layout['nb_recent_auct'])
{
	$recent_auctions_header = header2(MSG_RECENTLY_LISTED_AUCTIONS . ' [ <span class="sell"><a href="' . process_link('auctions_show', array('option' => 'recent')) . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('recent_auctions_header', $recent_auctions_header);

$sql_select_recent_items = $db->query("SELECT auction_id, start_time, start_price, currency, name,
	bold, hl, buyout_price, is_offer, reserve_price, max_bid, nb_bids, owner_id, postage_amount, enable_swap FROM " . DB_PREFIX . "auctions
	FORCE INDEX (auctions_start_time) WHERE
	closed=0 AND active=1 AND approved=1 AND deleted=0 AND creation_in_progress=0 
	" . (($setts['enable_store_only_mode']) ? '' : "AND list_in!='store'") . "		
	" . $adult_cats_query . " ORDER BY start_time DESC LIMIT 0," . $layout['nb_recent_auct']);

$template->set('sql_select_recent_items', $sql_select_recent_items);
}

if ($layout['nb_popular_auct'])
{
	$popular_auctions_header = header3(MSG_POPULAR_AUCTIONS . ' [ <span class="sell"><a href="' . process_link('auctions_show', array('option' => 'popular')) . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('popular_auctions_header', $popular_auctions_header);

$sql_select_popular_items = $db->query("SELECT auction_id, max_bid, currency, name, bold, hl,
	buyout_price, is_offer, reserve_price, nb_bids, owner_id, postage_amount, enable_swap FROM " . DB_PREFIX . "auctions
	FORCE INDEX (auctions_max_bid) WHERE
	closed=0 AND active=1 AND approved=1 AND deleted=0 AND creation_in_progress=0 
	" . (($setts['enable_store_only_mode']) ? '' : "AND list_in!='store'") . "		
	AND nb_bids>0 " . $adult_cats_query . " ORDER BY max_bid DESC LIMIT 0," . $layout['nb_popular_auct']);

$template->set('sql_select_popular_items', $sql_select_popular_items);

$is_popular_items = $db->num_rows($sql_select_popular_items);
$template->set('is_popular_items', $is_popular_items);
}

if ($layout['nb_ending_auct'])
{
	$ending_auctions_header = header4(MSG_ENDING_SOON_AUCTIONS . ' [ <span class="sell"><a href="' . process_link('auctions_show', array('option' => 'ending')) . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('ending_auctions_header', $ending_auctions_header);

 $sql_select_ending_items = $db->query("SELECT auction_id, start_price, IF(max_bid>start_price, max_bid, start_price) AS max_bid, end_time, currency, name, bold,
	hl, buyout_price, is_offer, reserve_price, nb_bids, owner_id, postage_amount, auction_type, enable_swap FROM " . DB_PREFIX . "auctions
	FORCE INDEX (auctions_end_time) WHERE
	closed=0 AND active=1 AND approved=1 AND deleted=0 AND creation_in_progress=0 
	" . (($setts['enable_store_only_mode']) ? 'AND end_time>0' : "AND list_in!='store'") . "		
	AND auction_type!='first_bidder' " . $adult_cats_query . " ORDER BY end_time ASC LIMIT 0," . $layout['nb_ending_auct']);

$template->set('sql_select_ending_items', $sql_select_ending_items);
}

if ($layout['nb_want_ads'])
{
	$recent_wa_header = header4(MSG_RECENTLY_LISTED_WANTED_ADS . ' [ <span class="sell"><a href="' . process_link('wanted_ads') . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('recent_wa_header', $recent_wa_header);

$sql_select_recent_wa = $db->query("SELECT wanted_ad_id, start_time, name FROM " . DB_PREFIX . "wanted_ads
	FORCE INDEX (wa_mainpage) WHERE
	closed=0 AND active=1 AND deleted=0 AND creation_in_progress=0 " . $adult_cats_query . " ORDER BY 
	start_time DESC LIMIT 0," . $layout['nb_want_ads']);

$template->set('sql_select_recent_wa', $sql_select_recent_wa);
}

if ($layout['r_recent_nb'] && $setts['enable_reverse_auctions'])
{
	$recent_reverse_header = header4(MSG_MM_REVERSE_AUCTIONS . ' [ <span class="sell"><a href="' . process_link('reverse_auctions') . '">' . MSG_VIEW_ALL . '</a></span> ]');
	$template->set('recent_reverse_header', $recent_reverse_header);

$sql_select_recent_reverse = $db->query("SELECT reverse_id, name, budget_id, nb_bids, currency, start_time, end_time FROM " . DB_PREFIX . "reverse_auctions
	WHERE	closed=0 AND active=1 AND deleted=0 AND creation_in_progress=0 ORDER BY 
	start_time DESC LIMIT 0," . $layout['r_recent_nb']);

$template->set('sql_select_recent_reverse', $sql_select_recent_reverse);
}


$template->change_path('themes/' . $setts['default_theme'] . '/templates/');

$template_output .= $template->process('mainpage.tpl.php');

$template->change_path('templates/');
?>

[cretaceous]

the trouble is we need to see the code where the images are output to the html ..
it's not in anything you have shown yet
it might be in mainpage.tpl.php but I suspect it's in other code
It could be very simple to fix but the fix has to go in the right place.

Who put this together?
What package /framework is this built in?
Was it working before?

I know a british developer in Bangkok who could fix it for money!

[RayWilk]

Hello cretaceous,

I am happy to give you, or anyone wanting to help the script, so you will have all the php files, everything I uploaded to my server,

how to give you the link to download all files/script?

your help is appreciated 🙂

cretaceous;10997690 wrote:

the trouble is we need to see the code where the images are output to the html ..
it's not in anything you have shown yet
it might be in mainpage.tpl.php but I suspect it's in other code
It could be very simple to fix but the fix has to go in the right place.

Who put this together?
What package /framework is this built in?
Was it working before?

I know a british developer in Bangkok who could fix it for money!

[cretaceous]

I don't have the time to go through all the files to fix this - the forum is meant to be a self help and advice place. I'm not offering to do it for money either - the person I know in Bangkok runs a commercial operation and is not cheap and maybe it's not in Forum rules to pass on his email.

You didn't commment on these:
Who put this together in the first place?
What package /framework is it built in?
Was it working before?

[cretaceous]

looks like you need to go to these guys for support:

PHP Pro Bid v6.10