Installation Error with Basic system

Peter Lane Posted in Technical Support 2 years ago

I get #1676903028|F30D6A841E5EB8E60C5647044E297043 on first run to access basic system having seen that the files and database were installed. Any clues?

Replies
Indonesian Arsalan Shah Replied 2 years ago
gb Peter Lane Replied 2 years ago

I have installed the HelloWorld files exactly as per the Github instructions. I get the 404 page. Is there an issue with the main system? (See https://mygrworld.com/ossn/hello_custom_template)

gb Peter Lane Replied 2 years ago

Thank you for your help. Strange, I did not do any manual installation.

Indonesian Arsalan Shah Replied 2 years ago

Just did a fresh installation on your request in the email and it worked fine installation was smooth without any issues. I think you may have installed manually before (not followed installer) I am not sure what was the issue.

Indonesian Arsalan Shah Replied 2 years ago

You don't need a VPS unless you want a special configurations like video conversion , ffmpeg tools etc.

gb Peter Lane Replied 2 years ago

I have also been told I need a VPS, thank you.

German Michael Zülsdorff Replied 2 years ago

open your ossn database with phpmyadmin and click the Structure tab. The table names must look like this:
enter image description here

For some reason your host seems to add the prefix mygrsolu_ossnnew, though. That's why the query fails.
Did you configure anything special to achieve automated prefixing? If so, please switch off that option.

gb Peter Lane Replied 2 years ago

In checking the PHP log, I get this:

[20-Feb-2023 15:25:08 Europe/London] PHP Fatal error:  Uncaught OssnDatabaseException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mygrsolu_ossnnew.ossn_site_settings' doesn't exist 
 SELECT * FROM ossn_site_settings as s  WHERE((s.name IN ('theme','site_name','language','cache','owner_email','notification_email','upgrades','display_errors','site_key','last_cache','site_version')))   ;  in /home/mygrsolu/mygrworld.com/ossnnew/classes/OssnDatabase.php:148
Stack trace:
#0 /home/mygrsolu/mygrworld.com/ossnnew/classes/OssnDatabase.php(281): OssnDatabase->execute()
#1 /home/mygrsolu/mygrworld.com/ossnnew/classes/OssnSite.php(59): OssnDatabase->select()
#2 /home/mygrsolu/mygrworld.com/ossnnew/libraries/ossn.lib.system.php(29): OssnSite->getAllSettings()
#3 /home/mygrsolu/mygrworld.com/ossnnew/system/start.php(39): include_once('/home/mygrsolu/...')
#4 /home/mygrsolu/mygrworld.com/ossnnew/index.php(12): require_once('/home/mygrsolu/...')
#5 {main}
  thrown in /home/mygrsolu/mygrworld.com/ossnnew/classes/OssnDatabase.php on line 148