ridwanskaterock / cicool

Cicool is a multifunctional application that is used to facilitate your work in creating a system, CMS, E-Comerce and others
20 stars 13 forks source link

installation error #356

Open franklevis opened 4 years ago

franklevis commented 4 years ago

Every time I try to install the application, the url is changed from www.pippo.com to www.pippo.com:80 and everything stops.

image

if I remove the door 80 then I load a language selection page but then it still freezes and it doesn't seem to have been loaded properly

image

thanks for any help

franklevis commented 4 years ago

I solved the first problem. The script MUST be installed in its "cicool" dir. Otherwise it doesn't work.

But now I have another error:

image

A PHP Error was encountered Severity: 8192

Message: strpos(): Non-string needles will be interpreted as strings in the future. Use an explicit chr() call to preserve the current behavior

Filename: MX/Router.php

Line Number: 239

Backtrace:

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 239 Function: strpos

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 72 Function: set_class

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 329 Function: _parse_routes

File: /web/htdocs/www.topdrives.it/home/cicool/index.php Line: 339 Function: require_once

franklevis commented 4 years ago

Also fixed the second problem, the software is not compatible with the latest version of PHP (7.3). Version 7.2 is installed and everything is fine. Almost, because now I have a third problem. I hope I don't have to go on like this for the next few days.

Third problem:

When I first try to create a new CRUD the table is not loaded. As per attached image. I am asked to give SQL mode to the whole group. Clicking a link which then obviously gives an error because being a rental database I do not have root privileges. Nobody has them.

So, How do I solve this problem too?

image

franklevis commented 4 years ago

Also fixed the second problem, the software is not compatible with the latest version of PHP (7.3). Version 7.2 is installed and everything is fine. Almost, because now I have a third problem. I hope I don't have to go on like this for the next few days.

Third problem:

When I first try to create a new CRUD the table is not loaded. As per attached image. I am asked to give SQL mode to the whole group. Clicking a link which then obviously gives an error because being a rental database I do not have root privileges. Nobody has them.

So, How do I solve this problem too?

image

franklevis commented 4 years ago

Hello? Hello? Hello? Is there anybody in there? Just nod if you can hear me Is there anyone at home? Come on now

:)

inglesuniversal commented 4 years ago

Hello, I am facing the same problem. The lasted update from cicool is AWESOME, but I just happen to install a fresh NEW LAMP server running PHP 7.3 and ALL the rest of my backend apps are running much more smoothly... So, just like you... I BEG the author of the code to update the cicool script to meet PHP 7.3 standards and make those unwanted installation/wizard errors go away for GOOD!

Best regards @franklevis

ridwanskaterock commented 4 years ago

Hello sorry i am in the travel :)

For that can you follow intruction on the top page Of does not work click link .....

You can try click link for it

Thanks

Pada tanggal Jum, 21 Feb 2020 08.27, Hugo Barbosa notifications@github.com menulis:

Hello, I am facing the same problem. The lasted update from cicool is AWESOME, but I just happen to install a fresh NEW LAMP server running PHP 7.3 and ALL the rest of my backend apps are running much more smoothly... So, just like you... I BEG the author of the code to update the cicool script to meet PHP 7.3 standards and make those unwanted installation/wizard errors go away for GOOD!

Best regards @franklevis https://github.com/franklevis

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ridwanskaterock/cicool/issues/356?email_source=notifications&email_token=ACGXJLKSJJJ57L6FDYU7JE3RD4NXJA5CNFSM4KXUBSRKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMRCEII#issuecomment-589439521, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACGXJLN7NX2IBT6AS3WJG7LRD4NXJANCNFSM4KXUBSRA .

franklevis commented 4 years ago

Maybe I don't understand. If I click on the link it doesn't work. It gives me this mistake. Obviously I don't have root rights on mysql servers

A Database Error Occurred Error Number: 1227

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Filename: /web/htdocs/www.topdrives.it/home/cicool/modules/web/controllers/Web.php

Line Number: 48

ridwanskaterock commented 4 years ago

Yes you need permission for access this function, you can contact web administrator for it

Thank you

Pada tanggal Jum, 21 Feb 2020 15.10, Francesco notifications@github.com menulis:

Maybe I don't understand. If I click on the link it doesn't work. It gives me this mistake. Obviously I don't have root rights on mysql servers

A Database Error Occurred Error Number: 1227

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Filename: /web/htdocs/ www.topdrives.it/home/cicool/modules/web/controllers/Web.php

Line Number: 48

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/ridwanskaterock/cicool/issues/356?email_source=notifications&email_token=ACGXJLNFJBR353QMHCON6XDRD6D7LA5CNFSM4KXUBSRKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMR35ZY#issuecomment-589545191, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACGXJLOSDMTLSVGTLWDOUWTRD6D7LANCNFSM4KXUBSRA .

franklevis commented 4 years ago

In the description of the product it should be clearly written that to use it you need to have the root credentials on the MySql DB. Anyone who uses a paid service cannot have it for obvious reasons. We only have administrative privileges on our instance, certainly not on the whole DB. I don't understand the reason for this requirement. Other completely similar products do not have this requirement. Unusable product for me.

agusecc commented 4 years ago

I solved the first problem. The script MUST be installed in its "cicool" dir. Otherwise it doesn't work.

But now I have another error:

image

A PHP Error was encountered Severity: 8192

Message: strpos(): Non-string needles will be interpreted as strings in the future. Use an explicit chr() call to preserve the current behavior

Filename: MX/Router.php

Line Number: 239

Backtrace:

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 239 Function: strpos

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 72 Function: set_class

File: /web/htdocs/www.topdrives.it/home/cicool/application/third_party/MX/Router.php Line: 329 Function: _parse_routes

File: /web/htdocs/www.topdrives.it/home/cicool/index.php Line: 339 Function: require_once

agusecc commented 4 years ago

Please go to this link: https://www.initekno.com/error-di-router-codeigniter-versi-3-1-10-dan-php-7/

mangesh-sutar commented 2 years ago

How can we integrate this Cicool tool with the existing Codeignitor project/application?