Clean Install on Ubuntu 20.04 gives table missing error (mysqli_sql_exception)

[Geoff-Hurst]

I have a fresh installation on Ubuntu 20.04 using AWS EC2 using the instructions on the Github wiki,

I am getting the following error... It appears to me that the table 'avideo.videos_VR360' was not created.

I can't find an option within the administration to create/repair tables.

array(4) { ["type"]=> int(1) ["message"]=> string(1220) "Uncaught mysqli_sql_exception: Table 'avideo.videos_VR360' doesn't exist in /var/www/html/AVideo/plugin/VR360/Objects/VideosVR360.php:48 Stack trace: #0 /var/www/html/AVideo/plugin/VR360/Objects/VideosVR360.php(48): mysqli->query() #1 /var/www/html/AVideo/plugin/VR360/Objects/VideosVR360.php(32): VideosVR360::getFromVideoDb() #2 /var/www/html/AVideo/plugin/VR360/Objects/VideosVR360.php(59): VideosVR360->loadFromVideo() #3 /var/www/html/AVideo/objects/functions.php(970): VideosVR360::isVR360Enabled() #4 /var/www/html/AVideo/objects/video.php(3272): canUseCDN() #5 /var/www/html/AVideo/objects/video.php(4040): Video::getSourceFile() #6 /var/www/html/AVideo/objects/video.php(3952): Video::getImageFromFilename_() #7 /var/www/html/AVideo/objects/video.php(5246): Video::getImageFromFilename() #8 /var/www/html/AVideo/plugin/Gallery/functions.php(227): Video::getVideoImagewithHoverAnimationFromVideosId() #9 /var/www/html/AVideo/plugin/Gallery/functions.php(160): createGallerySectionVideo() #10 /var/www/html/AVideo/objects/user.php(2869): createGallerySection() #11 /var/www/html/AVideo/view/channels.php(105): User::getChannelPanel() #12 /var/www/html/AVideo/view/index.php(52): require('...') #13 {main} thrown" ["file"]=> string(57) "/var/www/html/AVideo/plugin/VR360/Objects/VideosVR360.php" ["line"]=> int(48) }

[DanielnetoDotCom]

disable the plugin VR360 or install it's tables

[Geoff-Hurst]

I would love to but don't know how to do either of those. I didn't install that (or any other) plugin when I installed the application. I look at the plugin list but can't see anything listed...

[DanielnetoDotCom]

Looks like your plugins list is crashing.

I sent some updates earlier, try to update, if you still have nothing on the plugin menu please share the logs again.

[Geoff-Hurst]

I managed to use the install.sql in the plugin folder to create the table structure. Things seem to work now. I'm still confused as I didn't install the plugin. All I did was a vanilla install from your instructions.

I am not sure how to update the code. Do I need to pull it from git? I pressed the "Update Version" button and got...

Is that what you mean?

[Geoff-Hurst]

I think that there must be something faulty with my installation. It won't show any plugins...
The log states that it can't connect to mysql... however mysql is running and storing data... avideo is working. kinda.

I'm only testing/learning at present so it's installed on a AWS free instance with only 2G Ram.

Other strange things are happening.... There is no "Live" button.

I think that I will blow that instance away and start again with something bigger/better.

When I'm ready for a live system I'll likely pay you for an install on a vps I supply. (decoder and encoder)

************ ******** **** ****** **** ************ ********* * ********** ********* * ***** ********* * ************ ************* * ******* - password
[16-Sep-2022 11:13:12 UTC] ERROR: your site is offline we could not connect into MySQL
#9 {main} SCRIPT_NAME: /plugin/UserNotifications/getNotifications.json.php
#8 path/to/my/streamer/site/plugin/UserNotifications/getNotifications.json.php(3): require_once('...')
#7 path/to/my/streamer/site/videos/configuration.php(47): require_once('...')
#6 path/to/my/streamer/site/objects/include_config.php(159): setSiteLang()
#5 path/to/my/streamer/site/locale/function.php(121): AVideoPlugin::getDataObjectIfEnabled()
#4 path/to/my/streamer/site/plugin/AVideoPlugin.php(431): AVideoPlugin::isEnabled()
#3 path/to/my/streamer/site/plugin/AVideoPlugin.php(554): Plugin::getEnabled()
#2 path/to/my/streamer/site/objects/plugin.php(414): sqlDAL::readSql()
#1 path/to/my/streamer/site/objects/mysql_dal.php(169): _mysql_connect()
[16-Sep-2022 11:13:12 UTC] AVideoLog::DEBUG: #0 path/to/my/streamer/site/objects/functions.php(4417): mysqli->__construct()

[DanielnetoDotCom]

maybe your instance is out of space. it is clearly something on your MySQL server.

[Geoff-Hurst]

Thanks Daniel, I’ll re-create it in a larger instance in the next 2 days. Geoff From: Daniel Neto ***@***.***> Sent: Monday, 19 September 2022 9:37 PM To: WWBN/AVideo ***@***.***> Cc: Geoff ***@***.***>; State change ***@***.***> Subject: Re: [WWBN/AVideo] Clean Install on Ubuntu 20.04 gives table missing error (mysqli_sql_exception) (Issue #7120) maybe your instance is out of space. it is clearly something on your MySQL server. — Reply to this email directly, view it on GitHub <#7120 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGCAYLLOOKPIC2GTNGAZUKDV7BJOFANCNFSM6AAAAAAQM5VUOE> . You are receiving this because you modified the open/close state. <https://github.com/notifications/beacon/AGCAYLJXK54MS57VCQKNTQ3V7BJOFA5CNFSM6AAAAAAQM5VUOGWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSKR6ZLM.gif> Message ID: ***@***.*** ***@***.***> >

[Geoff-Hurst]

I removed that instance and re-installed. I think I have it running now though Nginx complains when starting up that it can't fins /run/nginx.pid... and I'm not sure that its security cert is setup correctly. But it all seems to function. Thanks for your assistance... I may need some setup help moving forward.