1054 - Unknown column 'products_image_array' in 'field list'

[theurbanrooster]

Hi,

I've tried to install this Contribution, but I'm having a bit of trouble. When listing a new product, I am able to add 3 more photos. However, when I go to Preview it shows only the main photo, and when I click Insert I get this:

 

1054 - Unknown column 'products_image_array' in 'field list'

insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_image_array, products_date_added) values ('1', '', '110.00', null, '6.54', '1', '0', '0', 'Spurge.JPG', 'a:0:{}', now())

 

[TEP STOP]

 

Where have I gone wrong? And keep in mind that I am a very new newbie.

Thanks,

pete.

[peter222]

forgot to run a sql ?

 

which contri are you talking about?

[theurbanrooster]

forgot to run a sql ?

 

which contri are you talking about?

 

Yeah, Sorry... The SIMPLE MULTI IMAGE Add-on.

[peter222]

you forgot to run the sql

 

see SQL.txt in your contribution

[theurbanrooster]

I'm pretty sure I ran it... I'll have another go. Thanks.

[theurbanrooster]

I ran the SQL again, and it had an error:

 

Error

 

SQL query:

 

ALTER TABLE `products` ADD `products_image_array` VARCHAR( 800 ) NULL DEFAULT NULL ;

 

MySQL said: Documentation

#1060 - Duplicate column name 'products_image_array'

 

What does this mean?

[peter222]

it means that, like you said, you already run the sql

 

but maybe (seen it before) you run the sql in a wrong database...

[theurbanrooster]

it means that, like you said, you already run the sql

 

but maybe (seen it before) you run the sql in a wrong database...

 

Whoa - now you're really confusing me...

[peter222]

what is confusing you?

 

i'm simply saying, that you might have selected the wrong database to run the sql in.

[theurbanrooster]

what is confusing you?

 

i'm simply saying, that you might have selected the wrong database to run the sql in.

 

Ok... I'm just not sure how many databases I have. My first experience with one was running a sQL 2 weeks ago.

[peter222]

go to phpMyAdmin: on the left you can see your database(s)

 

if there is more then one database, select the database which you are using for your shop, and run the sql

[theurbanrooster]

go to phpMyAdmin: on the left you can see your database(s)

 

if there is more then one database, select the database which you are using for your shop, and run the sql

 

Ah - I'm following you. I've gone there to run my SQLs, but have never checked where they were going.