orangescrum-community icon indicating copy to clipboard operation
orangescrum-community copied to clipboard

How do I debug what's the issue?

Open timmolter opened this issue 9 years ago • 23 comments

I installed everything and when I go to the URL I get a HTML page that says:

"There is some Problem Please check you database connection in app/Config/database.php or may be some syntax error"

I triple checked my database connections so I know that's not the issue. How can I see what the actualy cause of the problem is?

timmolter avatar Jun 28 '15 10:06 timmolter

Hi Tim,

Please make below changes to the code , you will be able to see the error message.

Navigate to app/Config/core.php Line number 50 change Configure::write('debug',0); to Configure::write('debug',2);

andola-dev avatar Jun 29 '15 14:06 andola-dev

@andola-dev Thanks for the tip. Funny thing is, is that I tried that already, but I couldn't find any errors anywhere. Where exactly will the errors appear?

timmolter avatar Jun 29 '15 14:06 timmolter

It seems to be an issue with php7 and cakephp version they are using. I looked at my logs and it deals the "String" class which was modified to the CakeText class. I am trying to use the tool, but I do not know CakePhp well enough to fix the issue.

jbolt1236 avatar Jan 25 '16 22:01 jbolt1236

Hi all!

Same problem here. I tried with php5 and php7 in different Debian versions, and it did'nt work. Guys, could you provide some pointers to fix the problem?

rocapal avatar Mar 06 '16 18:03 rocapal

If you want an easy way to deploy orangescrum, you could just deploy through docker.

selection_644

I forked the project and created the SCRUMptious version because deployment was such a pain in the butt.

programster avatar Mar 06 '16 19:03 programster

@programster thanks a lot! It was really helpful!

I have used your SCRUMptious version and it worked perfectly! :-)

rocapal avatar Mar 07 '16 16:03 rocapal

@rocapal thanks. If you have any issues with it, please report on its issue tracker.

programster avatar Mar 07 '16 20:03 programster

I had a similar issue. Initially I went to the setup page which loaded ok. I decided to change an email address in the config and reloaded the page which showed the error. Here's the weird part, I tried to enable Configure::write('debug',2); /app/config/core.php but it was now an empty file! I coped it across from the repo, reloaded and it worked. Note: I had also inadvertently chmodded the entire installation to 777 which I also fixed when I edited the email.

andyg2 avatar Jul 11 '16 01:07 andyg2

Hi. I am a new user of orangescrum and i have an issue that i would like you to sort out. I noticed that when i tried installing Orange scrum using xamp latest versions(7.0 and above), i get a cakephp error telling me that database connection cannot be established and that i should check database.php file for configuration error or syntax errors. After a few days of struggling with this problem i ended up changing xampp version to 5.6 and the orange scrum installed succesfully. Could you guys do something so that Orangescrum can work wth latest xampp versions? This will be very helpful so that programmers don't have to waste too much time in setting up your software. Thankyou.

Gordo2 avatar Aug 04 '16 10:08 Gordo2

"There is some Problem Please check you database connection in app/Config/database.php or may be some syntax error"

Hi I was facing this issue , but fix now with removing the mysql strict mode

Check the Sql Mode in Db , Run this Query: SELECT @@sql_mode

How to update SQL MODE in to strict : SET @@global.sql_mode= 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' ;

How to remove strict mysql mode: SET @@global.sql_mode='';

moon759 avatar Sep 21 '16 05:09 moon759

same problem in ubunutu 16.04 @andola-dev I was chaned here ,but without effct

JasonWu93 avatar Feb 08 '17 01:02 JasonWu93

Same Problem on my system, using Ubuntu 16.04, PHP7, MySQL 5.7. Also get no database connection up, sql_mode is empty. Any idea how to solve?

ScIT-Raphael avatar Mar 21 '17 19:03 ScIT-Raphael

Actually, I got bothered from posting issues with no solutions, this is my second time that the project damaged and I couldn't get by, why this bug occurred and how to solve it, I might not using this script again! & the db creditinals are the same and works !

`CakePHP: the rapid development php framework

There is some Problem Please check you database connection in app/Config/database.php or may be some syntax error in your code`

mustafaelnagar avatar Apr 15 '17 20:04 mustafaelnagar

For developers who didn't know where to find the logs file: Go to app/tmp/logs

mustafaelnagar avatar Apr 15 '17 20:04 mustafaelnagar

I have this error,

2017-04-15 20:51:16 Error: Fatal Error (64): Cannot use 'String' as class name as it is reserved in [/mydomain/pm/lib/Cake/Utility/String.php, line 25]
2017-04-15 20:51:16 Error: [InternalErrorException] Internal Server Error
Request URL: /pm/
Stack Trace:
#0 /mydomain/pm/lib/Cake/Error/ErrorHandler.php(203): ErrorHandler::handleFatalError(64, 'Cannot use 'Str...', '/mydomain...', 25)
#1 /mydomain/pm/lib/Cake/Core/App.php(929): ErrorHandler::handleError(64, 'Cannot use 'Str...', '/home4/wenitcom...', 25, Array)
#2 /mydomain/pm/lib/Cake/Core/App.php(902): App::_checkFatalError()
#3 [internal function]: App::shutdown()
#4 {main}
2017-04-15 20:51:17 Error: [MissingControllerException] Controller class CssController could not be found.
Exception Attributes: array (
  'class' => 'CssController',
  'plugin' => NULL,
)

Any advice what I should do ? Thanks in advance

mustafaelnagar avatar Apr 15 '17 20:04 mustafaelnagar

May be abit late to answer this question but i faced the same

Please check you database connection in app/Config/database.php or may be some syntax error" If you check and ure sure that the error is not in your databse.php and your syntax is perfect, you might want to consider downgrading your xampp/wampp. I solved it by changing xampp version 7 to version 5 and it worked correctly. You can try your luck with this solution. Some new updates in the latest versions may be conflicting with the orange scrum settings.

Gordo2 avatar Apr 19 '17 06:04 Gordo2

How i fixed this error: [CakeSessionException] Unable to configure the session, setting session.cookie_path failed. CakeSession.php(187): CakeSession::_configureSession()

ageof avatar Jul 10 '17 12:07 ageof

I had the same problem on a DigitalOcean server with MySql 5.7.19, nginx/1.10.3 and PHP7.0.

I get a 500 HTTP error and a page with:

There is some Problem

Please check you database connection in app/Config/database.php or may be some syntax error in your code

Having already Configure::write('debug',2); I checked the logs in app/tmp/logs and I see this:

2017-07-31 18:48:09 Error: Fatal Error (64): Cannot use 'String' as class name as it is reserved in [__________________/lib/Cake/Utility/String.php, line 25]
2017-07-31 18:48:09 Error: [InternalErrorException] Internal Server Error
Request URL: /
Stack Trace:
#0 __________________/lib/Cake/Error/ErrorHandler.php(203): ErrorHandler::handleFatalError(64, 'Cannot use 'Str...', '__________...', 25)
#1 __________________/lib/Cake/Core/App.php(929): ErrorHandler::handleError(64, 'Cannot use 'Str...', '__________...', 25, Array)
#2 __________________/lib/Cake/Core/App.php(902): App::_checkFatalError()
#3 [internal function]: App::shutdown()
#4 {main}

Clearly a PHP7.0 problem.

Solution

I searched all "String" class occurrences and replaced it with another name. "CakeString" and it worked.

Note, other things that I did before:

  • Disabled MySql strict mode
  • Ensure the configuration file was correct.

IacopoOrtis avatar Jul 31 '17 19:07 IacopoOrtis

While applying IacopoOrtis' solution, I run into some more problems. If dealing with PHP7.0, I do recommend to update the outdated CakePhp library with its latest 2.x version, available at https://github.com/cakephp/cakephp/tree/2.x

Just replace the orangescrum-master/lib/Cake folder with the lib/Cake folder from the above Git repo.

Cyril-C avatar Oct 10 '17 13:10 Cyril-C

@Cyril-C I've applied the solution you've posted. Actually, It have unlocked the application graphics, but I still have the same error on the log-in screen. But this time, the logs don't show anything.

Request URL: / Stack Trace: #0 /var/www/orangescrum/lib/Cake/Model/Model.php(3667): Model->setSource('users') #1 /var/www/orangescrum/lib/Cake/Model/Model.php(1394): Model->getDataSource() #2 /var/www/orangescrum/lib/Cake/View/Helper/FormHelper.php(215): Model->schema() #3 /var/www/orangescrum/lib/Cake/View/Helper/FormHelper.php(480): FormHelper->_introspectModel('User'$ #4 /var/www/orangescrum/app/View/Users/login.ctp(122): FormHelper->create('User', Array) #5 /var/www/orangescrum/lib/Cake/View/View.php(971): include('/var/www/orange...') #6 /var/www/orangescrum/lib/Cake/View/View.php(933): View->_evaluate('/var/www/orange...', Array) #7 /var/www/orangescrum/lib/Cake/View/View.php(473): View->_render('/var/www/orange...') #8 /var/www/orangescrum/lib/Cake/Controller/Controller.php(963): View->render(NULL, NULL) #9 /var/www/orangescrum/lib/Cake/Routing/Dispatcher.php(200): Controller->render() #10 /var/www/orangescrum/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke(Object(UsersContro$ #11 /var/www/orangescrum/app/webroot/index.php(92): Dispatcher->dispatch(Object(CakeRequest), Object($ #12 {main}

Is it better on your side ?

TheWhiteF0x avatar Oct 10 '17 15:10 TheWhiteF0x

I've applied the @Cyril-C solution (replacing Cake's version).

It's working for me, no need to disable strict mode or replace String class occurrences.

EDIT:

Yes, I had to turn off mysql strict mode by running in mysql as root:

SET GLOBAL sql_mode='';

Then, very important: I recreated the database and re-import the database.sql file.

After that, everything OK with PHP 7.0 and Mysql 5.7

EDIT: The pages loads, but AJAX calls fails. I'm moving from this, because is very unstable in an edge updated server. Maybe just works with a very very specific server config.

paulmartimx avatar Dec 14 '17 23:12 paulmartimx

My opinion it's a buggy product. Got tired of it after spending a lot of time. There is no to the point guide for this product and frankly there better crm/pmp open source product out there just google it.

Moral of the store: OrangeScrum SUCKS!!!!!!!

immrakpk avatar Jan 12 '18 02:01 immrakpk

OrangeScrum is really bugy!!!

linuxman1 avatar Mar 27 '18 11:03 linuxman1