[Release] PServerCMS a Website for your PServer

Quote:

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

[Only registered and activated users can see links. Click Here To Register...]

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?

Quote:

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

Quote:

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

Quote:

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 [Only registered and activated users can see links. Click Here To Register...]

{{ sidebarLoggedInWidget(user) }}

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

Quote:

Originally Posted by TrashBag {{ sidebarLoggedInWidget(user) }} is this code right I'm trying to call logged-in player username

just the username?

Quote:

Originally Posted by KoKsPfLaNzE just the username?

Yes, Sir, can I call the admin panel?

Quote:

Originally Posted by TrashBag Yes Sir

than you need your own view-helper

Quote:

Originally Posted by KoKsPfLaNzE than you need your own view-helper

No no please just tell me how to call username XD

Quote:

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

Quote:

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

Quote:

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

that will show you the login info

if iut shows smth wrong you can edit [Only registered and activated users can see links. Click Here To Register...] 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

Quote:

Originally Posted by KoKsPfLaNzE PHP Code: {{ loggedInWidgetPServerCore() }}  that will show you the login info if iut shows smth wrong you can edit [Only registered and activated users can see links. Click Here To Register...] 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

Quote:

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?