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 ?

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]

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).

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

actual value is "V0.3.0" !?

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.

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...

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.

Yes it works and i found the software very nice.
The software a big work and experience is nice.
Thanks to the Project'OR RIA developper.

Just to indicate, every user a i create has "english" set by default and every base parameter are also in english. Perhaps a side effect of the install problem i got, because i think if configure initially to "french"... But again the software look promise.

Hi everybody,

When i tried to login using the credentials admin/admin the following error message appears :
Invalid login parameters

It seems like projeqtOr points to the table "user" and not "resource".

the dbVersion is 4.1.2

Could you help me please.

Thank you.

Hi,

You already opened a new post for this request.
Please don't dupplicate requests.