View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Installing on MacOS : trouble - ProjeQtOr
 

Installing on MacOS : trouble

More
12 Mar 2013 16:36 #1 by padorange
Hi,

To try Project'Or RIA i just install it on my MacOS computer (MacOS X 10.6.x) that meet requirements :
PHP and MySQL.

I run the application, configure things : OK (read me should explain to configure "file/..." folder out of web zone (default) for security and accessibility (read-only).

At the first login i attempt admin/admin but it fails.
In the log i notice that "user" table was not created, i check in mysql and indeed lot of tables were created but not "user"... I'm stuck.

Thanks for any help

LOG :
Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.user' doesn't exist
2013-03-12 16:15:38 ***** ERROR ***** For query : desc user
2013-03-12 16:15:38 ***** ERROR ***** Strack trace :
2013-03-12 16:15:38 ***** ERROR ***** #0 Sql->query called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1771]
2013-03-12 16:15:38 ***** ERROR ***** #1 SqlElement->getFormatList called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1573]
2013-03-12 16:15:38 ***** ERROR ***** #2 SqlElement->getDataType called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1119]
2013-03-12 16:15:38 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [/Library/WebServer/Documents/projectorria/tool/loginCheck.php:33]

Please Log in or Create an account to join the conversation.

More
12 Mar 2013 16:48 #2 by babynus
Hi,
is it a brand new setup ?
Did you retrieve Database from another version ?

In fact, table 'user' has been renamed 'resource' in V3.0.
But this step should be transparent...
Do you have a table 'resource' ?

Did you run install only once or did you try several times ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
13 Mar 2013 09:55 #3 by padorange
It's a band new setup (i want to try the software).
So the database is new and empty (no data), just created by the application at first startup.

I check the database (mysql) and there is no "user' table but yes there is a "resource" table with 2 records : admin and guest.

I run the install several times but is trash the whole database before the last install.

My problem is that is seems OK, but a cant log, i used default "admin/admin" but projectorria do not recognize the default password (admin)... i just got an error message "connection parameters incorrect"

If i look at the log file i got : Table 'projectorria.user' doesn't exist

(see below the complete log) :

2013-03-13 09:54:03 ===== TRACE ===== Login error for user 'admin'
2013-03-13 09:54:04 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.user' doesn't exist
2013-03-13 09:54:04 ***** ERROR ***** For query : desc user
2013-03-13 09:54:04 ***** ERROR ***** Strack trace :
2013-03-13 09:54:04 ***** ERROR ***** #0 Sql->query called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1771]
2013-03-13 09:54:04 ***** ERROR ***** #1 SqlElement->getFormatList called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1573]
2013-03-13 09:54:04 ***** ERROR ***** #2 SqlElement->getDataType called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1119]
2013-03-13 09:54:04 ***** ERROR ***** #3 SqlElement->getSqlElementsFromCriteria called at [/Library/WebServer/Documents/projectorria/tool/loginCheck.php:33]
2013-03-13 09:54:04 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.user' doesn't exist
2013-03-13 09:54:04 ***** ERROR ***** For query : select * from user where user.name='admin' and user.isUser = '1'
2013-03-13 09:54:04 ***** ERROR ***** Strack trace :
2013-03-13 09:54:04 ***** ERROR ***** #0 Sql->query called at [/Library/WebServer/Documents/projectorria/model/persistence/SqlElement.php:1152]
2013-03-13 09:54:04 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/Library/WebServer/Documents/projectorria/tool/loginCheck.php:33]

Please Log in or Create an account to join the conversation.

More
13 Mar 2013 10:23 #4 by babynus
Can you check value stored in table 'parameter', for parameterCode='dbVersion'.
It should be 'V3.2.0'.
If it's not, change to correct value, and please post here log file from your setup process (there should have been an issue during setup process).

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: padorange

Please Log in or Create an account to join the conversation.

More
13 Mar 2013 11:22 #5 by padorange

babynus wrote: Can you check value stored in table 'parameter', for parameterCode='dbVersion'.
It should be 'V3.2.0'.


actual value is "V0.3.0" !?

babynus wrote: If it's not, change to correct value,


I change to "V3.2.0".
i try relog and got a message : "DATABASE UPDATE COMPLETED TO VERSION V3.1.4"
I relog agin and now the software start, and seems OK.
I'll try it now.

babynus wrote: and please post here log file from your setup process (there should have been an issue during setup process).


I dont kept the install log (and can't find log related now) but i remember i got problem on my first attempt.
The first time (PHP and MySQL were allready installed and functionnal), is just drop the full directory into my web shared folder and launch (according to readme).
It fails because (file and config subfolders were read-only, as they're in the web sharing folder of MacOS X).
First i just assign read-write permission and relaunch install. It fails again.
Then i read the complete install instruction (i must have done this before) and i restart from scratch (remove any trace un mysql and create a dedicated folder (out of web shared) for file and config and modify paramaters.php according to that settings.
Install wen't right until i got the login problem.

Now it seems OK, i log as admin (installation was english, i change to french now but lists name are still english not a big problem for test).
Sorry for the not so detailed report...

Please Log in or Create an account to join the conversation.

More
13 Mar 2013 11:28 #6 by babynus
Hi,

It's very strange you got a version tagged "V0.3.0" when deploying V3.1.4...
This issue has never been met before.
Maybe a strange MacOS behavior.

I'll have a look to try and get an explanation.

Happy it works now.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: padorange

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.251 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.