Jump to content

Archived

This topic is now archived and is closed to further replies.

MerDer

1054 - Unknown Column 'p.products_id' In 'on Clause'

Recommended Posts

I had the same problem once again with my different catlog. What I did first was to search on google

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

The first result brought me to this thread and from here again this contribution saved me.

 

http://www.oscommerce.com/community/contributions,4654

 

I saw that I was reading my own post above. How fast we forget.

Share this post


Link to post
Share on other sites
I had the same problem. My sub catagory and search results were showing the same result. I knew that my server was upgraded. I have solved this problem by exactly following this:

 

http://www.oscommerce.com/community/contributions,4654

 

HTH

 

Yogesh

 

That worked PERFECTLY! Thanks for sharing! We updated and prepared for all the other PHP5 migration issues but this one slipped through the cracks. This was the simplest fix of all.


Chris

Share this post


Link to post
Share on other sites

Fix for advanced search feature !

i have osc with Cre loaded and i searched a lot for this fix !

In advanced_search_result.php i haven't seen any of these codes ...

change this :

$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

to this :

$from_str = "from (((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c)";

 

For those who have the same problem go to "catalog/templates/content/advanced_search_result.tpl.php" and there you can make this changes !

Sorry for my bad english ! I`m from romania !

Share this post


Link to post
Share on other sites

hm.. i dont think i have that file either.. actually template folder doesnt exist on my catalog..

 

this is the code that i have on my template

 

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id";

 

then continued by:

 

if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {

if (!tep_session_is_registered('customer_country_id')) {

$customer_country_id = STORE_COUNTRY;

$customer_zone_id = STORE_ZONE;

}

$from_str .= " left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')";

}

 

and:

 

$from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

 

 

now how do i fix it to the following?? please help... thankss

 

$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

Share this post


Link to post
Share on other sites

Hi thanks all who have posted the reply to 1054 - Unknown Column 'p.products_id' In 'on Clause' , This bug apparently due to the version change to mysql5.0 which does not support the JOIN syntax of ',' nested inner left joins.So kindly use parenthesis .Kindly edit the index.php and advanced_search_result.php

 

in Index.php

Use

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

}

 

instead of

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

}

 

 

In advanced_search_result.php

Use

$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

Instead of

 

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

thanks

Share this post


Link to post
Share on other sites

Thanks again for this update.

 

I'm on 2.2 RC1 (I think) and haven't had time (or need) to update to RC2a. I have lots of contributions so it takes while...

 

However the issue was forced last week when my host upgraded to PHP5 without warning... Thanks a bunch guys... :angry:

 

The 1054 error came up, but with a quick web search I found this answer, and using the contribution text file and Beyond Compare I had it fixed in half an hour. Nothing else needed touching. :D

 

Many Thanks to Ozstar

 

Scott

 

http://www.espmodels.co.uk/catalog/

Share this post


Link to post
Share on other sites

Can someone please help me as i'm at a loss .

 

I have followed all of the info in this forum, and followed the help files from

 

http://www.oscommerce.com/community/contributions,4654

 

But I am still getting this error:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name

 

It occurs in my admin dept. when I click on Customer Wishlists - it will identify a list of poeple who have created wishlists, but the error is displayed under the heading "products in wishlist" so I can't actually see what people have in there.

 

Any help would be appreciated as this is the main aspect to my site and I really need it working :(


Many thanks

Cheme1ll

Share this post


Link to post
Share on other sites
Can someone please help me as i'm at a loss .

 

I have followed all of the info in this forum, and followed the help files from

 

http://www.oscommerce.com/community/contributions,4654

 

But I am still getting this error:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

that's because those instructions do not include changes to wishlist - because that's not part of the stock osc.

 

all you need to do is make the same kind of change for your wishlist code as you did in following the rest of the instructions. so

 

select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name

 

changes to:

select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from [b](([/b]products p[b])[/b], products_description pd[b])[/b] left join specials s on p.products_id = s.products_id where pd.products_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name

 

note the parenthesis added after the 'from' clause.

 

since your error message didn't say which file this is in, you may have to do some looking, but it's probably in wishlist.php or something. also, this is what the resulting sql statement should look like. the code will construct this - so you might have to do a little hunting in order to find exactly where these changes should be made.

Share this post


Link to post
Share on other sites
Hi,

 

I also have the exact same error in the BEST SELLERS colums:

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '61' order by p.products_date_added DESC limit 2

 

[TEP STOP]

 

 

Can anyone please help me in fixing this?

 

My url is: http://infinitecoregroup.com/index.php

 

Thnx

 

hi there everyone.

i have exactly the same problem in the BEST SELLERS

i tried everything but nothing as worked for me, and also have this :

 

"\catalog\includes\functions\database.php on line 44"

 

can anyone help me?

 

thanks

Share this post


Link to post
Share on other sites

In advanced_search_result.php, because of:

 

$from_str .= ") left join " . TABLE_TAX_RATES...............

 

 

don't you have to add something like this around line 210:

 

if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {

$select_str .= ", SUM(tr.tax_rate) as tax_rate ";

 

//add this

$from_str = "from (((";

} else {

$from_str = "from ((";

//end add

 

}

Share this post


Link to post
Share on other sites
Fix for advanced search feature !

i have osc with Cre loaded and i searched a lot for this fix !

In advanced_search_result.php i haven't seen any of these codes ...

change this :

 

to this :

 

 

For those who have the same problem go to "catalog/templates/content/advanced_search_result.tpl.php" and there you can make this changes !

Sorry for my bad english ! I`m from romania !

 

Thanks!

 

This worked for me (also using creloaded). There were 3 lines (142, 145, 147) that needed the parentheses added.

Share this post


Link to post
Share on other sites

Hi,

 

I have a working OSC store at www.hypermediaintl.com/catalog/index.php

Now I just added a new URL www.travelmall.us and like to set up a OSC store too.

What I did is to copy all files and directories from working site to new site and backuped the database then restored it at new site.

I thought it will minic a complete store for modification but error shown while I click on any product categories.

the error is as follows:

****************************************************************************

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '182'

*****************************************************************************

why does it happen? Should I do anything on database? I can see all product categories list in admin without problem.

The weird thing is both hosted at the same server running PHP 5.2.9 and MYSQL 5.0.85. The source site is running normally.

I am not good at database, please help. thx

 

0

Share this post


Link to post
Share on other sites

My guess would be that the "working" store is actually at MySQL 4, not 5. You need to update the PHP code to create SQL queries consistent with MySQL 5 (you can use the same code back on MySQL 4). http://forums.oscommerce.com/topic/335136-osc-and-mysql-5-1054-errors

 

In this particular case, the modified query would be:

select count(p.products_id) as total from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '182'

Share this post


Link to post
Share on other sites

I think I will be better to verify my MYSQL version:

In the phpmyadmin panel, it shows that

 

A.two databases listed , 1. database1(for working sotre) 2. OSC1(for new store)

 

B.MYSQL Server version: 5.0.85-community and MySQL client version: 4.1.22

 

Which version is the store running on? Server or client?

 

Again both stores now have same files and directories.

Why? working store is still working but the new one has error.

 

TIA

Share this post


Link to post
Share on other sites

Hmm. My site shows both server and client at 5.0.81. You may have a configuration problem -- talk to your host.

 

It's puzzling if both sites are using the same server, same client, and same PHP code, yet only one gets the 1054 error. The query given in the error message is something that happens with using unpatched osC with MySQL 5, which is why I suggested those fixes. I have no idea what will happen with version 4 client and version 5 server.

Share this post


Link to post
Share on other sites

Hi

I try to login to http://addons.oscommerce.com/info/4654

but it say you username and password is wrong but i use the same username and pass for the community that i am login

any idea

 

Hi,

 

I have been reading all these post and still could not fix my problem. The code that needs to be replaced within index.php does not exist in my index.php .. please check this out and help me out to sole it.

 

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

}

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<!--<link rel="stylesheet" type="text/css" href="stylesheet.css">-->

<link rel="stylesheet" type="text/css" href="style.css"></head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<tr>

<td width="302" height="439" align="left" valign="top"><img src="images/main.jpg" width="302" height="437" alt="Papilon"></td>

<td width="410" height="439" bgcolor="#F5F5F5">

<table border="0" width="410" cellpadding="0" cellspacing="0" height="439">

<tr>

<td width="409" height="100%">

<table border="0" width="100%" cellpadding="0" cellspacing="0" height="100%">

<tr>

<td width="100%" height="196" valign="top" >

<table border="0" width="100%" cellpadding="0" cellspacing="0" >

<!--DWLayoutTable-->

<tr>

<td width="39" height="198" > </td>

<td width="232" align="center" valign="top" >

<table border="0" width="232" cellpadding="0" cellspacing="0" >

<!--DWLayoutTable-->

<tr>

<td height="38" valign="top" style="padding-top:20px;"><img src="images/welcome.jpg" width="232" height="24" alt="" /></td>

</tr>

<tr>

<td height="1" background="images/hpoint.gif"><img src="images/hpoint.gif" width="3" height="1"></td>

</tr>

<tr>

<td width="100%" align="left" style="padding-top:8px; padding-bottom:11px;">

<p align="justify"><img src="images/str_head.gif" width="9" height="5" hspace="2" vspace="1"/><span class="crimson">Dobrodošli u OnLine prodavnicu cvjećare PAPILON.</span> Naš široki asortiman može zadovoljiti sve Vaše potrebe i kreiranu su za sve prilike. Isporuku vršimo na području grada Sarajeva. Dva načina na koje možete izvršiti uplatu su:<br />

<img src="images/str_head.gif" width="9" height="5" hspace="2" vspace="1"/> Plaćanje putem kreditnih kartica Visa i Master<br />

<img src="images/str_head.gif" width="9" height="5" hspace="2" vspace="1"/> Gotovinom</p> </td>

</tr>

<tr>

<td height="1" background="images/hpoint.gif"><img src="images/hpoint.gif" width="3" height="1"></td>

</tr>

<tr>

<td height="30" style="padding-top:6px; " align="left"><!--DWLayoutEmptyCell--> </td>

</tr>

</table></td>

<td width="138" valign="top" bgcolor="#F7F7F7" ><img src="images/index_slika.jpg" width="138" height="196" /></td>

</tr>

<tr>

<td height="1" colspan="3" align="left" background="images/hpoint.gif"><img src="images/hpoint.gif" width="3" height="1" alt=""></td>

</tr>

<tr>

<td height="2" colspan="3" bgcolor="#F5F5F5"><img src="images/spacer.gif" width="1" height="1" alt=""></td>

</tr>

<tr>

<td height="1" colspan="3" align="left" background="images/hpoint.gif"><img src="images/hpoint.gif" width="3" height="1" alt=""></td>

</tr>

<tr>

<td height="18" colspan="3"><?php include(DIR_WS_MODULES . 'special_products.php'); ?></td>

</tr>

</table>

</td>

</tr>

</table>

</td>

<td width="1" height="100%" background="images/vpoint.gif" valign="top"><img src="images/vpoint.gif" width="1" height="3"></td>

</tr>

</table>

</td>

</tr>

<tr>

<td width="100%" height="2" colspan="2" bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1" alt=""></td>

</tr>

<tr>

<td width="302" height="168" valign="top"><?php include(DIR_WS_MODULES . 'new_products.php'); ?> </td>

<td width="410" height="168" bgcolor="#F5F5F5" valign="middle" align="left">

<table width="100%" height="162" border="0" cellpadding="0" cellspacing="6" bgcolor="#F5F5F5">

<tr>

<td rowspan="3" height="61" ><img src="images/buket_index.jpg" width="127" height="154" alt="Buket" /></td>

<td><strong>Našim kupcima obezbjedili smo sigurnost i pouzdanost u potpunosti. Na linkovima ispod možete naći sve iinformacije kojima Vam garantujemo profesionalnost, sigurnost i pouzdanost prilikom kupovine u našem Web Shopu. </strong></td>

</tr>

<tr>

<td height="1" background="images/hpoint.gif" align="left"><img src="images/hpoint.gif" width="3" height="1" alt=""></td>

</tr>

<tr>

<td height="100">

<ul style="list-style-image:url(images/sign_link.jpg); margin-left:25px; ">

<li><a href="privacy_note.php" class="crimson">Izjava privatnosti</a></li>

<li><a href="privacy_note.php" class="crimson">Povrat novca</a></li>

<li><a href="privacy_note.php" class="crimson">Online plaćanje</a></li>

<li><a href="http://www.2co.com" target="_blank" class="crimson">2CO - Autorizovani Reseller</a></li>

</ul></td>

</tr>

</table>

</td>

</tr>

<tr>

<td width="100%" height="3" colspan="2" bgcolor="#FFFFFF"><img src="images/spacer.gif" width="1" height="1" alt=""></td>

</tr>

 

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

 

 

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

Why are you trying to fix this file? There is no "left join" in that code, which is the 1054 error. Exactly what error are you trying to fix?

Share this post


Link to post
Share on other sites

×