Error 1054 - unknown column

[Nic du Toit]

error 1054 - Unknown column 'p.product_audio_name' in 'field list'

 

select p.products_id,p.product_audio_name, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '31' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

I get this message when I click on the product listed on the products page.....

I checked in 'phpmyadmin'....no such column or field in the table listing.

 

Where could this message come from?

 

Any suggestion will be appreciated.

 

Regards,

Nic

[Guest]

Nic,

 

STEP ONE of the admin installation instructions says:

 

 

 

1. Execute the following SQL statement using phpmyadmin:

 

ALTER TABLE `products` ADD `product_audio_name` VARCHAR( 255 ) NOT NULL ;

 

 

 

 

Chris

[Nic du Toit]

Hi Chris.

Yep, all that was done during installation of the player.

Subsequently I decided to uninstall the player.

I then did the install.txt in reverse, thus removing all traces of the install. Although there's no [ product_audio_name ] reference in the scripts or Table, I should perhaps just recreate the SQL statement and see what happens.

 

Nic

[Nic du Toit]

Hi Chris.

Yep, all that was done during installation of the player.

Subsequently I decided to uninstall the player.

I then did the install.txt in reverse, thus removing all traces of the install. Although there's no [ product_audio_name ] reference in the scripts or Table, I should perhaps just recreate the SQL statement and see what happens.

 

Nic

[Nic du Toit]

Hi Chris,

Ok, I've re-installed and this time there were no error pages. The music clip also uploaded into the audio folder. (Previously I did screwed up on the SQL statement bit....got it right this time.)

The online store (on the product description page, shows the wording "Play audio clip".... and , you guessed it; underneath it tells me to get the latest flash player. Did that. Still no active player..... I checked the 'head' in /catalog/includes/template_top.php just to be sure the extra bit has been added before [ /head].

The 'flv-imbed' has been unpacked and uploaded into the root of my domain [musicshop.etsga.org].

 

Any ideas of how to fix this?

 

Regards,

Nic

[Guest]

Nic,

 

Although I am updating the Music Player to include some recent suggestions, more than 20 people have installed the current version and none have encountered the issues you have. Did you use the Drop on top files, or manual edits ? I am trying to figure out where you are getting confused.

 

 

 

Chris

[Nic du Toit]

I used the manual edits as per the install.txt list.

Everything works fine....no error pages.....it's only when go to the 'online' store to check if everything works from that end, did I notice the wording "Play audio clip"....and underneath that, the instruction to update my flash player.....which I did twice....

I cam PM you my login details if you'd like to look at the site....

Nic