Last week our website met a problem and I tried to restore it, for 3.24.3 the front page display a blank, and the _admin page display the following error:
Fatal error: Uncaught exception 'Exception' with message 'Unable to get asset info due to database error: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for relation sq_ast' in /home/seven/public_html/mysource_matrix/core/include/asset_manager.inc:1642 Stack trace: #0 /home/seven/public_html/mysource_matrix/core/include/mysource.inc(1073): Asset_Manager->getAssetInfo(Array, 'public_user', true, 'updated') #1 /home/seven/public_html/mysource_matrix/core/include/mysource.inc(316): MySource->setupUser() #2 /home/seven/public_html/mysource_matrix/core/include/init.inc(243): MySource->init() #3 /home/seven/public_html/mysource_matrix/core/web/index.php(28): require_once('/home/seven/pub…') #4 {main} thrown in /home/seven/public_html/mysource_matrix/core/include/asset_manager.inc on line 1642
for 3.24.1 and 3.24.2 both front home page and _admin display the similar error page.
Is the databse crashed? or somebody have any idea?
It's likely your restore is being done into a database without the right permissions. Make sure you have users that have the same name (check /SYSTEM_ROOT/data/private/conf/db.inc), and that they have permissions to the database.
Thank you very much, anthony,
I fixed it by this way
after create the database, we still need to Creating the PLPGSQL Language
The PLPGSQL language is required for the database that you have just created, so lets add support for it now:
$ createlang -U postgres plpgsql mysource_matrix
then dump the sql file to the database, and then it works
kind of weird, but eventually works for my system.
thank you for the hint :rolleyes: