[Release] PServerCMS a Website for your PServer

[KoKsPfLaNzE]

Originally Posted by TrashBag

omg, I was trying to do that but without the )Character) can I ask how I can know when I have to add words like that?

you have to check the view-helper

in this case

[lolixxx]

atal error: Uncaught PDOException: SQLSTATE[42S02]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'user_role'. in C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PDOConnection.php:104 Stack trace: #0 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PDOConnection.php(104): PDO->query('SELECT t0.id AS...') #1 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Connection.php(912): Doctrine\DBAL\Driver\PDOConnection->query('SELECT t0.id AS...') #2 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\Persisters\Entity\BasicEntityPersi ster.php(904): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array) #3 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\EntityRepository.php(181): Doctrine\ORM\Persisters\Entity\BasicEntityPersiste r->loadAll(Array, NULL, NULL, NULL) #4 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\EntityRepository.php(164): Doctrine\ORM\EntityRep in C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\DBALException.php on line 179

Anyone knows the reasone?

[KoKsPfLaNzE]

Originally Posted by lolixxx

atal error: Uncaught PDOException: SQLSTATE[42S02]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'user_role'. in C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PDOConnection.php:104 Stack trace: #0 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PDOConnection.php(104): PDO->query('SELECT t0.id AS...') #1 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Connection.php(912): Doctrine\DBAL\Driver\PDOConnection->query('SELECT t0.id AS...') #2 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\Persisters\Entity\BasicEntityPersi ster.php(904): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array) #3 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\EntityRepository.php(181): Doctrine\ORM\Persisters\Entity\BasicEntityPersiste r->loadAll(Array, NULL, NULL, NULL) #4 C:\wamp64\www\pserverCMSFull\vendor\doctrine\orm\l ib\Doctrine\ORM\EntityRepository.php(164): Doctrine\ORM\EntityRep in C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\DBALException.php on line 179

Anyone knows the reasone?

you didnt exec the db setup script, so it say invalid object user_role, that means table missing

[lolixxx]

Originally Posted by KoKsPfLaNzE

you didnt exec the db setup script, so it say invalid object user_role, that means table missing

hmm i did all like in turtorial!

And i getting errors running this
php ./vendor/doctrine/doctrine-module/bin/doctrine-module orm:schema-tool:create --dump-sql

Error log:
Fatal error: Uncaught PDOException: could not find driver in C:\wamp64\www\pserv
erCMSFull\vendor\doctrine\dbal\lib\Doctrine\DBAL\D river\PDOConnection.php:43
Stack trace:
#0 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OConnection.php(43): PDO->__construct('sqlsrv:server=1...', 'sa', 'xxxxxx...', Array)
#1 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OSqlsrv\Connection.php(36): Doctrine\DBAL\Driver\PDOConnection->__construct('sql
srv:server=1...',sa', 'xxxxxxxxx...', Array)
#2 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OSqlsrv\Driver.php(40): Doctrine\DBAL\Driver\PDOSqlsrv\Connection->__construct('
sqlsrv:server=1...', 'sa', 'xxxxxxxxx.', Array)
#3 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Connectio
n.php(372): Doctrine\DBAL\Driver\PDOSqlsrv\Driver->connect(Array, 'sa', 'xxxxxxx', Array)
#4 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\D in C:\wamp64\www\pser
verCMSFull\vendor\zendframework\zend-servicemanager\src\ServiceManager.php on li
ne 771

[KoKsPfLaNzE]

Originally Posted by lolixxx

hmm i did all like in turtorial!

And i getting errors running this
php ./vendor/doctrine/doctrine-module/bin/doctrine-module orm:schema-tool:create --dump-sql

Error log:
Fatal error: Uncaught PDOException: could not find driver in C:\wamp64\www\pserv
erCMSFull\vendor\doctrine\dbal\lib\Doctrine\DBAL\D river\PDOConnection.php:43
Stack trace:
#0 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OConnection.php(43): PDO->__construct('sqlsrv:server=1...', 'sa', 'xxxxxx...', Array)
#1 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OSqlsrv\Connection.php(36): Doctrine\DBAL\Driver\PDOConnection->__construct('sql
srv:server=1...',sa', 'xxxxxxxxx...', Array)
#2 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Driver\PD
OSqlsrv\Driver.php(40): Doctrine\DBAL\Driver\PDOSqlsrv\Connection->__construct('
sqlsrv:server=1...', 'sa', 'xxxxxxxxx.', Array)
#3 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\Doctrine\DBAL\Connectio
n.php(372): Doctrine\DBAL\Driver\PDOSqlsrv\Driver->connect(Array, 'sa', 'xxxxxxx', Array)
#4 C:\wamp64\www\pserverCMSFull\vendor\doctrine\dbal\ lib\D in C:\wamp64\www\pser
verCMSFull\vendor\zendframework\zend-servicemanager\src\ServiceManager.php on li
ne 771

you didnt installed the sql driver for mssql on your windows server for php

hint

[TrashBag]

{{ sidebarLoggedInWidget(user) }}

is this code right I'm trying to call logged-in player username

[KoKsPfLaNzE]

Originally Posted by TrashBag

{{ sidebarLoggedInWidget(user) }}

is this code right I'm trying to call logged-in player username

just the username?

[TrashBag]

Originally Posted by KoKsPfLaNzE

just the username?

Yes, Sir, can I call the admin panel?

[KoKsPfLaNzE]

Originally Posted by TrashBag

Yes Sir

than you need your own view-helper

[TrashBag]

Originally Posted by KoKsPfLaNzE

than you need your own view-helper

No no please just tell me how to call username XD

[KoKsPfLaNzE]

Originally Posted by TrashBag

No no please just tell me how to call username XD

you need a view-helper to get this data, like the sidebar view-helper, it do mostly what you need

[TrashBag]

Originally Posted by KoKsPfLaNzE

you need a view-helper to get this data, like the sidebar view-helper, it do mostly what you need

<?= $this->escapeHtml($this->user->getUsername()) ?>
i only need to make this line work with the layout.twig

i did this but didn't work {{ sidebarLoggedInWidget(user) }}

[KoKsPfLaNzE]

Originally Posted by TrashBag

<?= $this->escapeHtml($this->user->getUsername()) ?>
i only need to make this line work with the layout.twig

i did this but didn't work {{ sidebarLoggedInWidget(user) }}

PHP Code:

{{ loggedInWidgetPServerCore() }} 


that will show you the login info

if iut shows smth wrong you can edit alias => helper/sidebarLoggedInWidget

there is atm no view-helper to just show the username, easy way would be to create a own view-helper for that case

[TrashBag]

Originally Posted by KoKsPfLaNzE

PHP Code:

{{ loggedInWidgetPServerCore() }} 


that will show you the login info

if iut shows smth wrong you can edit alias => helper/sidebarLoggedInWidget

there is atm no view-helper to just show the username, easy way would be to create a own view-helper for that case

ATM you are the best person I like in vsro world :*


BTW The new Verg of peservercms when u change the style you lose the logged in widget panel older verg didn't have that bug

[KoKsPfLaNzE]

Originally Posted by TrashBag

ATM you are the best person I like in vsro world :*


BTW The new Verg of peservercms when u change the style you lose the logged in widget panel older verg didn't have that bug

what you mean, can you post a screen or smth?