i messed something up

[xspykex]

i was trying to follow the steps in the "product attribute sort" contribution by following what people had said on that topic...but now something is up with my store. can anyone give me some help on how to fix it since no one is replying to me on that topic?

sidebysidecomputing.com is the location of the store. any help is greatly appreciated since php is still new to me.

thanks.

[Guest]

i was trying to follow the steps in the "product attribute sort" contribution by following what people had said on that topic...but now something is up with my store. can anyone give me some help on how to fix it since no one is replying to me on that topic?

sidebysidecomputing.com is the location of the store. any help is greatly appreciated since php is still new to me.

thanks.

well looks like you have a few problems but if you are asking about the error message you get when you try to view a product, it's because that database table does not exist. Either you didn't create it if it needed to be created or the name is wrong.

 

the error message is pretty self-explanatory....

[241]

From your site

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/sbs/public_html/cart/includes/database_tables.php:62) in /home/sbs/public_html/cart/includes/functions/sessions.php on line 67

 

Header Whitespace

 

download the file cart/includes/database_tables.php open it and place your cursor after the last ?> then press delete several times, save the file and upload it.

 

Do not use the file manager to edit online as this can cause the whitespace.

 

instead use an ftp program such as ws_ftp to download the file to a local machine and edit then upload using the ftp program

 

If you require more information then Click

 

 

From your site

1146 - Table 'sbs_osc.TABLE_PRODUCTS_ATTRIBUTES' doesn't exist

 

select count(*) as total from products_options popt, TABLE_PRODUCTS_ATTRIBUTES patrib where patrib.products_id='354' and patrib.options_id = popt.products_options_id and popt.language_id = '1'

 

 

check that the table exists in the database and check that the table has been defined in cart/includes/database_tables.php

[xspykex]

i got rid of the error message at the top when you first get to the store. thanks for that.

 

however when you try to view a product that has any options to it, the following message is displayed just beneath product description and then no drop-downs are displayed:

 

1054 - Unknown column 'pa.sort_order' in 'order clause'

 

select pov.products_options_values_id,

pov.products_options_values_name,

pa.options_values_price,

pa.price_prefix from

products_attributes pa, products_options_values pov where

pa.products_id = '357' and

pa.options_id = '11' and

pa.options_values_id =

pov.products_options_values_id and

pov.language_id = '1' order by

pa.sort_order

 

[TEP STOP]

 

does that mean i need to get rid of 'pa.sort_order' somewhere? if so, where? again thanks so much

[♥yesudo]

try adding it to the select bit i.e. change:

 

select pov.products_options_values_id, 
pov.products_options_values_name, 
pa.options_values_price, 
pa.price_prefix from 
products_attributes pa, products_options_values pov where
pa.products_id = '357' and 
pa.options_id = '11' and 
pa.options_values_id = 
pov.products_options_values_id and 
pov.language_id = '1' order by 
pa.sort_order

 

to:

 

select pa.sort_order, pov.products_options_values_id, 
pov.products_options_values_name, 
pa.options_values_price, 
pa.price_prefix from 
products_attributes pa, products_options_values pov where
pa.products_id = '357' and 
pa.options_id = '11' and 
pa.options_values_id = 
pov.products_options_values_id and 
pov.language_id = '1' order by 
pa.sort_order

[xspykex]

what page does that go on?

[♥yesudo]

whatever page the error appears on.

[xspykex]

well it's appearing on any products with options and those would be technically under product_info.php pages right? but product_info.php doesn't have the section of code you said to replace. it has things close to it, but not the verbatim code...

[xspykex]

ok nevermind that last post

i added the one line you changed and said to put in my code. it's still doing the same thing error-wise though. any other ideas?

thanks so much for the help, i really do appreciate it.

[♥yesudo]

replace with:

 

select pov.products_options_values_id, 
pov.products_options_values_name, 
pa.options_values_price, 
pa.price_prefix from 
products_attributes pa, products_options_values pov where
pa.products_id = '357' and 
pa.options_id = '11' and 
pa.options_values_id = 
pov.products_options_values_id and 
pov.language_id = '1';

 

or if it is a contrib u have added check the sql part of the contrib or try adding this to the db:

 

Field: sort_order

Type: Int

[xspykex]

its not something i contributed. i'm not exactly sure what all happened...what you said to replace with that time is what you told me should be replaced last time..?

[Mary B.]

It looks like you've changed the $products_options_query on line 135 and added sort_order to the query, both as a value taken from the database, and as the order by value at the end of the query. That being the case, you will also need to add a field named "sort_order" to your products_attributes database table to eliminate the error.

[♥yesudo]

what you said to replace with that time is what you told me should be replaced last time..?

tis different - look closely.

[♥yesudo]

replace with:

 

select pov.products_options_values_id, 
pov.products_options_values_name, 
pa.options_values_price, 
pa.price_prefix from 
products_attributes pa, products_options_values pov where
pa.products_id = '357' and 
pa.options_id = '11' and 
pa.options_values_id = 
pov.products_options_values_id and 
pov.language_id = '1';

 

or if it is a contrib u have added check the sql part of the contrib or try adding this to the db:

 

Field: sort_order

Type: Int

ignore the semicolon on the end.

[xspykex]

ahhhhh thank you so very much