webERP Forum

When loggin out of weberp this error pops up.


Database Error 1146 : Failed to retrieve favorites
Table 'weberp.favourites' doesn't exist

You need to run the sql/mysql/upgrade4.13.1-4.14.sql script.

Tim

the weberp version it shows is 4.14.

webERP

Monday, December 11, 2017 9:02

webERP version 4.14.1 Copyright © 2004 - 2017 weberp.org

(12-11-2017, 08:23 PM)falkoner Wrote: [ -> ]You need to run the sql/mysql/upgrade4.13.1-4.14.sql script.

Tim

The favourites table is created in the upgrade4.13.1-4.14.sql script. If you don't have that table and the error you quote says you don't have it then you need to run that sql.

Tim

Been there... Run the upgrade script and all will be fine.

i ran the sql upgrade and it still did not work....so much for the upgrade

(12-12-2017, 12:14 AM)falkoner Wrote: [ -> ]The favourites table is created in the upgrade4.13.1-4.14.sql script. If you don't have that table and the error you quote says you don't have it then you need to run that sql.

Tim

@rjonesbsink:

After running the upgrade script, do you show that the favourites table was created in the weberp database?

As Paul says, does the favourites table now exist? If it does then you must now be getting a different error message, what is it? If it still doesn't exist then did you get any error messages when the upgrade sql was run?

Tim

@falkoner @VortecCPI

after upgrade script run, I went to phpmyadmin to see if table was created. NO table for favourites exits. when was the favorites table introduced

(12-12-2017, 08:06 PM)falkoner Wrote: [ -> ]As Paul says, does the favourites table now exist? If it does then you must now be getting a different error message, what is it? If it still doesn't exist then did you get any error messages when the upgrade sql was run?

Tim

It was introduced in the upgrade4.13.1-4.14.sql script