[SOLVED] getting error after upgrading from 1.2.4 to 1.2.5

[Suraj]

i m gettting this error when i update the product and stocks.

when i edit or udpate the product or stock i got this:

  Quote

Table 'sosd_shop.ps_mailalert_customer_oos' doesn't exist

SELECT id_customer, customer_email
FROM `ps_mailalert_customer_oos`
WHERE `id_product` = 100

when i try to repair the database i got this:

  Quote

sosd_shop.ps_mailalert_customer_oos
Error : Table 'sosd_shop.ps_mailalert_customer_oos' doesn't exist
status : Operation failed

[Harshal]

Suraj,

Question for you, could you implement shipping price based on percentage of total order. I was reviewing your conversation but it seems am unable to do as per the instructions. can you help

[TropischBruin]

I just did an upgrade without any issues.

Read what the error says: Table ‘sosd_shop.ps_mailalert_customer_oos’ doesn’t exist
Why do your tables have the prefix sosd_shop?

Before upgrading you should always:

Switch to the Default theme.
Disable Friendly urls. (only on live shops)
Copy a blank (empty) .htaccess in the root of your shop. (only on live shops)
Disable ALL non-default PS modules.
Check wich versions are in between your current version and the one you want to go to (ignore the beta releases).
Upgrade from you version to the next and then first check if you shop still works and make a backup before moving on to the next version.

Did I mention that you should always: BACKUP - BACKUP- BACKUP

[Suraj]

  Quote

Suraj,

Question for you, could you implement shipping price based on percentage of total order. I was reviewing your conversation but it seems am unable to do as per the instructions. can you help

i never got this working, but still trying to figure it out. maybe some other good coders can find this easily lol.

[Suraj]

  Quote

I just did an upgrade without any issues.

Read what the error says: Table ‘sosd_shop.ps_mailalert_customer_oos’ doesn’t exist
Why do your tables have the prefix sosd_shop?

Before upgrading you should always:

Switch to the Default theme.
Disable Friendly urls. (only on live shops)
Copy a blank (empty) .htaccess in the root of your shop. (only on live shops)
Disable ALL non-default PS modules.
Check wich versions are in between your current version and the one you want to go to (ignore the beta releases).
Upgrade from you version to the next and then first check if you shop still works and make a backup before moving on to the next version.

Did I mention that you should always: BACKUP - BACKUP- BACKUP

I did the same as you mention, but i am getting the error not sure why.

for your information, sosd_shop is the database name but this table is missing after upgrade "

  Quote

ps_mailalert_customer_oos

"

[TropischBruin]

Did you use a third party module for mailalerts?

[Suraj]

No, I am using the default alert.

Mail alerts v2.2
Sends e-mails notifications to customers and merchants

[Suraj]

I manually create a new table and the problem is solver:

  Quote

CREATE TABLE `ps_mailalert_customer_oos` (
`id_customer` int(10) unsigned NOT NULL,
`customer_email` varchar(128) NOT NULL,
`id_product` int(10) unsigned NOT NULL,
`id_product_attribute` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[Texar]

Well, for some reason this table is working with innodb engine. So maybe you copied the database by using the files and not with a mysqldump. so you corrupted your database and that is why you have got this error.


Anyway, by recreating the table you solved the proble.

To prestashop programmer: why this table is using innodb engine? Is it an error or something you really wanted to do?


Regards,

Denis

[bulono]

hi, i heva the same problem can you explain me how you resolved it, i mean how do yo creat the new table and where, thanks