[kumar]

Hello 

I tried installation of commentics ( wonderful application during demo). But some how I am unable to completed it. I am using old myslq 5.5 and unable to upgrade it, so I followed below suggest provided in this forum 

/upload/install/model/main/install_2.php
/upload/install/model/main/upgrade_2.php

.. and replace each instance of this ..

Code:

Code:

datetime NOT NULL default NOW()

.. with this ..

Code:

Code:

datetime NOT NULL

But even though unable to complete installation, I getting following error on page :

"Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /var/www/vhosts/companyinfoz.com/httpdocs/comments/system/database/mysqli.php on line 69"

The following is the image url when I get database alert (it should be mysql 5.6 and higher), I followed instruction for work around for mysql5.5
https://ibb.co/d6UebF

Then I moved to url http://companyinfoz.com/comments/install...route=menu 

and this moved to next step : http://companyinfoz.com/comments/install...=install_1
here I get error "The programme is already installed" the following is the screen shot :

https://ibb.co/i7duAa

I need help on how to fix and make it workable.

Thank you for assistance in this regard

[Steven]

Hi kumar,

You'll need to drop (delete) the database tables before attempting to install again.

If you still get the same error, can you open the file mentioned and replace this:

PHP Code:

<?php 

return mysqli_fetch_assoc($query); 

[kumar]

Hi Steven,

Thank you very much your response.

I checked database no table was created.

I made suggested changes in mysqli.php file.

When visit http://mydomain.com/comments/install/

Then I get errors. I sent a Pm to you for errors. I just to avoid installation information from public view.

Regards

[kumar]

Hi Steven,

I found one cause of error "Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /var/www/vhosts/companyinfoz.com/httpdocs/comments/system/database/mysqli.php on line 74
"
If I delete config.php then visiting to http://mydomain.com/comments/install/ url error do not appear. Then it appear after system check, where I see "MySQL is 5.6.5 or higher" require.

Looking forward for possible solution.

Thanks and Regards

[Steven]

Hi kumar,

The only reason it would show the "The programme is already installed" message is if there's a database table named 'comments'. Could it be that you have this table due to another script? If so, you will need to use a prefix which you can enter on the database step. If that doesn't help, can you PM me access details to your database and files? I'd be happy to look into it further.

[Steven]

Thanks for confirming you were able to install successfully. I split your reply (about a separate issue) to the integration part of the forum.