[colbyt]

I hate for my first post to be with a problem but, 

I installed this on local machine under xampp and was quite impressed.  Deciding to take it to my vps for further testing I encountered the following error message during the install:

Fatal error: Uncaught mysqli_sql_exception: Access denied; you need (at least one of) the SUPER privilege(s) for this operation in
/home/admin/domains/my_domain.com/public_html/comments/system/library/database/mysqli.php:53 Stack trace: #0
/home/admin/domains/my_domain.com/public_html/comments/system/library/database/mysqli.php(53): mysqli_query() #1
/home/admin/domains/my_domain.com/public_html/comments/system/library/database.php(42): Commentics\MySqli->query() #2
/home/admin/domains/my_domain.com/public_html/comments/install/controller/main/menu.php(24): Commentics\Db->query() #3
/home/admin/domains/my_domain.com/public_html/comments/install/index.php(63): Commentics\MainMenuController->index() #4 {main} thrown in /home/admin/domains/my_domain.com/public_html/comments/system/library/database/mysqli.php on line 53

In the process of reviewing the script I realized that the script not the system generated the message.

I need to provide a bit more info just in case. 
I am using the DirectAdmin control panel on this vps.  DirectAdmin does not allow anyone to create a DB from within phpmyadmin.  Haven't yet tested it but I think that applies to dropping one also. As my DB version number is 10.6.10 I presume I am using MariaDB.

I could export the local machine version and import it on the server but the hash for UN & pass usually does not work when you do that.

I am open to suggestions.

[Steven]

[Steven]

[colbyt]

Thanks for the replies. I did not expect you to be working this weekend.

I'm going to look those over at apply one of them, probably the first one.

FYI, I am running 8.1.10 on localhost and 8.1.12 on the VPS.

I have all privileges on localhost and was using the root login. DirectAdmin does limit some.

[colbyt]

[Steven]

Would you mind posting the error?

You can re-visit the 'install/index.php?route=menu' page without having to uninstall anything.

[colbyt]

Already followed your advice and deleted the install folder.

I will look at the site error logs and get back to this thread.

[colbyt]

Steven,

I could not find a php error log on the vps but i did duplicate the problem on local host.  Using what you posted as the second option under PHP 8.1.10 it reslted in this error code:  Parse error: syntax error, unexpected variable "$this" in C:\xampp\htdocs\temp\comments\system\library\database\mysqli.php on line 31.

And here is a screen shot so you can verify I did what you said and did it correctly.

   

I removed it and the install script loaded just.

[Steven]

Okay thanks, I appreciate the info.