15 replies to this topic

[krissuh]

I upgraded to 2.3.1. the installation went well (i thought).

I deleted my catalogues, but it didn't seem to delete my products, so they keep coming up on my front page as Product new in December. when you select them, they give the customer an error.
Dream Duffel Bag Small (product name)
[DD-Sml]
1146 - Table 'alggcom_5starcom.products_images' doesn't exist

select image, htmlcontent from products_images where products_id = '236' order by sort_order

[TEP STOP]




I also tried to edit product via my admin login and i get the following error:

1146 - Table 'alggcom_5starcom.products_images' doesn't exist

select id, image, htmlcontent, sort_order from products_images where products_id = '93' order by sort_order

[TEP STOP]


Obviousley something is wrong with my table, can someone please point me in the correct direction.

[DunWeb]

Kristina,


It appears you have a missing table in your database. Use phpmyadmin provided in your hosting account to create the missing table.



Chris

[krissuh]

Thank you for your reply,

i looked at the database and the name of the table is "products_image"
i tried to change the name to "products_images" but that just gave me another error looking for "products_image"

is there a file i need to change the pointer from "products_images" to "products_image"?

thanks
Kristina

[DunWeb]

Kristina,

I believe, by the error you will need BOTH tables. So, create the second table 'products_images'.




Chris

[burt]

You cannot just use your old 2.2 database on a 2.3.1 site. Your old 2.2 database needs further changes to it, as 2.3.1 database has quite a lot of changes, some small, some large. You have stumbled across a large one, extra product images are contained in their own table, which is different than how it was in 2.2

[krissuh]

hi, i'm a little lost. I figured out how to create a table, but i want to copy a table so that i don't need to re-enter everything.

do you know how to copy a table within a database?

thanks

Kristina

[krissuh]

is there anyway i can upgrade the database? if not, what do i do?

[kurtissn]

burt, on 12 December 2010, 12:23, said:

You cannot just use your old 2.2 database on a 2.3.1 site. Your old 2.2 database needs further changes to it, as 2.3.1 database has quite a lot of changes, some small, some large. You have stumbled across a large one, extra product images are contained in their own table, which is different than how it was in 2.2

I have made changes to the database based on the 2.3 to 2.3.1 pdf upgrade guide but nowhere is there an additional table mentioned for product_image. what gives?

Edited by kurtissn, 23 December 2010, 19:04.

[kurtissn]

kurtissn, on 23 December 2010, 19:03, said:

I have made changes to the database based on the 2.3 to 2.3.1 pdf upgrade guide but nowhere is there an additional table mentioned for product_image. what gives?

Correction: 2.2 to 2.3.1 installation guide

[Xpajun]

kurtissn, on 23 December 2010, 19:03, said:

I have made changes to the database based on the 2.3 to 2.3.1 pdf upgrade guide but nowhere is there an additional table mentioned for product_image. what gives?

I haven't seen the update installation guide but there is also a extra field added in the middle of the product_review table - Have you put that one in?

[krissuh]

HI KURTISAN,
can you send me a link to the upgrade guide. i couldn't find it.

XPAJUN

"I haven't seen the update installation guide but there is also a extra field added in the middle of the product_review table - Have you put that one in?
"
No i haven't. How do i do that? is there somekind of documentation that i can read?

thanks

[Xpajun]

My best advice...


If you have only one or two add-ons that do not have any database fields or no add-ons, install 2.3.1 and import your products, order and customer data only

you will need to run the following via phpMyadmin:

ALTER TABLE `reviews` ADD `reviews_status` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `last_modified` 

before downloading the products, order and customer data only.

If you have more than one or two contributions, especially those that rely on extra fields or tables in the database then the best and quickest way is to start from the beginning and build again - it might be easier for full-time coders to upgrade stripping the tables and rewriting the add-ons as they go but for those that only code when they need something added to their store it's far quicker to add from the begining

Edited by Xpajun, 23 December 2010, 22:51.

[hakito]

It already managed to add the missing table (products_images) and alter the reviews table manually. But i think the installation instructions should be updated in the pdf.

I also think there should be a text version of the instructions because it is not safe to copy and paste the sql-code from the pdf. At least there should be a link to the online upgrade guide: http://www.oscommerce.info/confluence/display/OSCOM23/Upgrade+Guides

[TSchmidt]

Would you mind mentioning how you added that table? What structure is it supposed to have?

I have the same problem and I searched this forum for hours. Many people seem to have had that problem, some report they solved it, but nobody actually tells how. I ran the query
ALTER TABLE `reviews` ADD `reviews_status` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `last_modified`
as recommended by some, but the error message stayed the same. The official 2.2 -> 2.3.1 upgrade guide doesn't mention the table products_images anywhere.

Thanks,
Tilman

[geoffreywalton]

Try this

drop table if exists products_images;
create table products_images (
id int(11) not null auto_increment,
products_id int(11) not null ,
image varchar(64) ,
htmlcontent text ,
sort_order int(11) not null ,
PRIMARY KEY (id),
KEY products_images_prodid (products_id)
);

HTH

G

[TSchmidt]

That did the trick. Thanks a lot!