1054 I lost two days with it already, please a little help :)

[hent]

heya! ok.. I did search.. I fixed my other errors, but this one is killing me..

 

http://hybrideclothing.com/catalog

 

anyone willing to help ?

 

is a test zone there.. but.. I need this fixed so I can move on and sell like hell :))

[rescuestat]

Hi,

 

If you're talking about the includes/configuration.php file is writable error at the top of your page, change the file permissions to 0444 and should take care of it.

Also some of your language images in the includes/header.php aren't showing up.

 

Good luck.

[rescuestat]

Oops, my bad...just saw the MySQL error in the right column.

 

Sorry can't test this right now. Not at a computer with phpmyadmin access. but possibly move the database definition for p2c to after from statesment.

try this statement (exploded for ease-you can remove the extra spaces/line)

 

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, products_to_categories p2c

 

left join manufacturers m on p.manufacturers_id = m.manufacturers_id

 

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

[mrjd1410]

Hi,

Seems to me you have a few problems (3)

first try changing!

in catalog/includes/configure.php

I think this is the image problem.

 

define('HTTP_COOKIE_DOMAIN', 'http://www.YOURSITE.com');

define('HTTP_COOKIE_PATH', '/catalog/);

 

that should get the images back.

 

 

 

2. Seems to me you might have a php5 or MySQL5 problem here you will have too check the forums

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

 

 

3: Warning Warning: I am able to write to the configuration file.

Minor problem you just have to change the premissions in the /includes/configure.php to 444

 

 

 

 

Oops, my bad...just saw the MySQL error in the right column.

 

Sorry can't test this right now. Not at a computer with phpmyadmin access. but possibly move the database definition for p2c to after from statesment.

try this statement (exploded for ease-you can remove the extra spaces/line)

 

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, products_to_categories p2c

 

left join manufacturers m on p.manufacturers_id = m.manufacturers_id

 

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

[hent]

Heyall,

 

Thanks for replies,

Actually the red warning line is not bothering me , I can fix that just that I was too lazy to do that on that test area :)

I appologise, my fault that I wasnt more explicit,

The problem is the error on the right side,

 

I already fixed the other two errors generated from Php5, I saw that fix from "ozman"

 

Problem is that I dont know what php file generates that right page, I'm not that good with programing,

And it would help me a lot if someone can send me the part which I should copy/paste on "that page" to fix that, like ozman did with the index.php and advanced_search_results.php

 

I saw that ozman explains how to fix any problem with that (( paranthesis.. just that I'm lost :) hehe..

 

Thanks!

One more round of beers for my friends, hehehe

 

ps. oh! and oscommerce rulles! just need a little tackle, lol

I just wish that theese guys to make a "light" version with not so many options.. so many useless options (for me) drives me nuts, but its free and I can keep the money in my pocket, hehe

[♥FWR Media]

Heyall,

 

Thanks for replies,

Actually the red warning line is not bothering me , I can fix that just that I was too lazy to do that on that test area :)

I appologise, my fault that I wasnt more explicit,

The problem is the error on the right side,

 

I already fixed the other two errors generated from Php5, I saw that fix from "ozman"

 

Problem is that I dont know what php file generates that right page, I'm not that good with programing,

And it would help me a lot if someone can send me the part which I should copy/paste on "that page" to fix that, like ozman did with the index.php and advanced_search_results.php

 

I saw that ozman explains how to fix any problem with that (( paranthesis.. just that I'm lost :) hehe..

 

Thanks!

One more round of beers for my friends, hehehe

 

ps. oh! and oscommerce rulles! just need a little tackle, lol

I just wish that theese guys to make a "light" version with not so many options.. so many useless options (for me) drives me nuts, but its free and I can keep the money in my pocket, hehe

 

You need to apply the MySQL5 upgrades, the original osCommerce code did not use joins correctly.

[♥geoffreywalton]

a link to most of the mysql5 patches is in my signature block below.

 

g

[hent]

THANK YOU!!!

I'll let you know..

 

Chip

-----------

PS, well.. not a "great success" lol..

I already saw that page too.. but doesnt say anything about my error.

 

:( any luck ?