Upgrading from 2.3.1 to 2.3.3 website crash down

[ce7]

Hi,

can anyone please help?

 

I can not access the cPanel myphpAdmin last night to backup my database.

I asked my server host company to have a look and do not do any upgrade till I back the database up.

 

However hosting company did the upgrade regardless I said to fix my probelm to access database first.

 

This morning my website shut down and has the error message said that one table has gone missing.

 

I suspect this is becasue the 2.3.1 version is different to 2.3.3?

 

1146 - Table 'inmotion_mysite.TABLE_SPECIFICATION' doesn't exist

SELECT s.specifications_id, s.filter_class, s.products_column_name, sd.specification_name FROM TABLE_SPECIFICATION AS s INNER JOIN TABLE_SPECIFICATION_GROUPS AS sg ON s.specification_group_id = sg.specification_group_id INNER JOIN TABLE_SPECIFICATIONS_TO_CATEGORIES AS s2c ON sg.specification_group_id = s2c.specification_group_id INNER JOIN TABLE_SPECIFICATION_DESCRIPTION sd ON sd.specifications_id = s.specifications_id WHERE s.show_filter = 'True' AND sg.show_filter = 'True'

[TEP STOP]

 

can anyone please give me any suggestion that I can fix this problem?

Many thanks in advance.

Lyn

[♥kymation]

Those tables are from the Products Specifications addon. Running the SQL file from that addon will fix your error. However, it sounds like there is a problem with your database that may involve more than just that fix.

 

Regards

Jim

[ce7]

Those tables are from the Products Specifications addon. Running the SQL file from that addon will fix your error. However, it sounds like there is a problem with your database that may involve more than just that fix.

 

Regards

Jim

Hi Jim, Thanks for the reply. I can see the table_specifications in the database list, I did not change anything. The only thing it changed is web host company did upgrade from 2.3.1 to 2.3.3.1 and the errors happened. No idea what going wrong there at all. Trying to backup the files via ftp now and later maybe uninstall and install all again with 2.3.1 and see if the errors go. Will update later, thanks. Lyn

[ce7]

Those tables are from the Products Specifications addon. Running the SQL file from that addon will fix your error. However, it sounds like there is a problem with your database that may involve more than just that fix.

 

Regards

Jim

Hi,

Jim, after a whole day try, I couldn't figure out why, but luckily web host company backup before upgrade,

so at the end I use the restore function and get it back to osCommerce 2.3.1 version.

I did try again on the testing website, and the same table_SPECIFICATION error comes again.

Strangely I check the database, the SPECIFICATION is there, but dont know why the error shows not exit.

and if my rental site upgrade from osC 2.3.1 to osC 2.3.3.1, then it again show the same error

Fatal error: Call to undefined function document_types()

in /includes/modules/boxes/bm_photo_gallery.php on line 40

 

Has no idea at all why upgrade can cause these strange errors.

Thanks in advance.

Lyn

[multimixer]

The error is, because TABLE_SPECIFICATION is not defined in file catalog/includes/database_tables.php.

 

You probably replaced that file during the upgrade. You need to add that "define", same for the other tables in capital letters mentioned in the error message. Take your old file (before the upgrade) and check what is missing in the new file