Hello, I am trying to install phanbook on WAMP but i get the error page titled "Site maintenance". I checked the log and found:

[Thu, 10 Nov 16 14:54:36 +0000][ERROR] Syntax error, unexpected token EQUALS, near to ' :objectId: AND object = :object:', when parsing: SELECT COALESCE(SUM(positive),0) AS positive, COALESCE(SUM(negative),0) AS negative FROM Phanbook\Models\VoteWHERE objectId = :objectId: AND object = :object: (158)
[Thu, 10 Nov 16 14:54:36 +0000][ERROR] #0 [internal function]: Phalcon\Mvc\Model\Query->parse()

#1 [internal function]: Phalcon\Mvc\Model\Query->execute()
#2 \vhosts\phanbook\core\common\models\ModelBase.php(92): Phalcon\Mvc\Model\Manager->executeQuery('SELECT COALESCE...', Array)
#3 \vhosts\phanbook\content\cache\volt\vhosts_phanbook_content_themes_default_partials_question.volt.php(3): Phanbook\Models\ModelBase->getVotes('66', 'posts')
#4 [internal function]: Phalcon\Mvc\View\Engine\Volt->render('C:\\Users\\czone\\...', Array, false)
#5 [internal function]: Phalcon\Mvc\View->_engineRender(Array, 'partials/questi...', false, false)
#6 [internal function]: Phalcon\Mvc\View->partial('partials/questi...', Array)
#7 \vhosts\phanbook\content\cache\volt\vhosts_phanbook_content_themes_default_partials_list-posts.volt.php(2): Phalcon\Mvc\View\Engine->partial('partials/questi...', Array)
#8 [internal function]: Phalcon\Mvc\View\Engine\Volt->render('C:\\Users\\czone\\...', Array, false)
#9[internal function]: Phalcon\Mvc\View->_engineRender(Array, 'partials/list-p...', false, false)
#10 [internal function]: Phalcon\Mvc\View->partial('partials/list-p...', NULL)
#11 \vhosts\phanbook\content\cache\volt\vhosts_phanbook_content_themes_default_post.volt.php(55): Phalcon\Mvc\View\Engine->partial('partials/list-p...')
#12 [internal function]: Phalcon\Mvc\View\Engine\Volt->render('C:\\Users\\czone\\...', Array, true)
#13 [internal function]: Phalcon\Mvc\View->_engineRender(Array, 'post', true, true, NULL)
#14 [internal function]: Phalcon\Mvc\View->render('posts', 'index', Array)
#15 \vhosts\phanbook\index.php(56): Phalcon\Mvc\Application->handle()
#16 {main}

What might have gone wrong? Thanks

Hi there

Currently, we have some theme but that not good so we need to redesign it

• Material redesign
• Flat redesign

Here some article good for you

• Reddit redesign concept

Hi there,

Currently, we have a logo but this not good, so we need to re-design a awesome logo, any idea are welcome

re: "the name Phanbook is mean - Phan(Phalcon PHP)book(the your note book)".

I don't think it works. People will come to this software primarily for the Q&A functionality. I don't know what the name should be, but "Phanbook" sounds too much like facebook. Even something like "Phalcon Q&A" would be better.

Thanks! I look forward to trying the software very soon.

I've installed phanbook via this instructions http://phanbook.com/docs/manual

Now i'm getting always this error when i try to access the mainpage. I can't get it working. Composer installation was successfull without errors. composer version 1.3.1

composer install --no-ansi --no-dev --no-interaction --no-progress --no-scripts --optimize-autoloader
Loading composer repositories with package information
Installing dependencies from lock file
Package operations: 15 installs, 0 updates, 0 removals
  - Installing symfony/polyfill-mbstring (v1.3.0) Loading from cache
  - Installing danielstjules/stringy (2.3.2) Loading from cache
  - Installing psr/log (1.0.2) Loading from cache
  - Installing pimple/pimple (v3.0.2) Loading from cache
  - Installing monolog/monolog (1.21.0) Loading from cache
  - Installing symfony/event-dispatcher (v2.8.13) Loading from cache
  - Installing guzzle/guzzle (v3.9.3) Loading from cache
  - Installing elasticsearch/elasticsearch (v1.4.1) Loading from cache
  - Installing erusev/parsedown (1.6.1) Loading from cache
  - Installing google/apiclient (v1.1.8) Loading from cache
  - Installing league/flysystem (1.0.32) Loading from cache
  - Installing league/fractal (0.9.1) Loading from cache
  - Installing league/oauth2-client (0.10.1) Loading from cache
  - Installing swiftmailer/swiftmailer (v5.4.3) Loading from cache
  - Installing vlucas/phpdotenv (v2.4.0) Loading from cache
Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/guzzle instead.
Generating optimized autoload files

PHP 7.1 on ubuntu.

PHP message: PHP Fatal error:  Uncaught Error: Class 'Phalcon\Loader' not found in /srv/www/f/bootstrap/autoloader.php:20
Stack trace:
#0 /srv/www/f/public/index.php(17): require()
#1 {main}
  thrown in /srv/www/f/bootstrap/autoloader.php on line 20

I am getting a white screen. In the error I log I see...

[Sun Dec 25 21:03:59.604668 2016] [:error] [pid 3177] [client 127.0.0.1:50798] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' in /var/www/tembo/core/common/library/Auth/Auth.php:186

Stack trace:
#0 [internal function]: PDOStatement->execute()
#1 [internal function]: Phalcon\\Db\\Adapter\\Pdo->executePrepared(Object(PDOStatement), Array, Array)
#2 [internal function]: Phalcon\\Db\\Adapter\\Pdo->query('SELECT `remembe...', Array, Array)
#3 [internal function]: Phalcon\\Mvc\\Model\\Query->_executeSelect(Array, Array, Array)
#4 [internal function]: Phalcon\\Mvc\\Model\\Query->execute()
#5 /var/www/tembo/core/common/library/Auth/Auth.php(186): Phalcon\\Mvc\\Model::findFirst(Array)
#6 /var/www/tembo/core/modules/frontend/controllers/ControllerBase.php(68): Phanbook\\Auth\\Auth->loginWithRememberMe()
#7 [internal function]: Phanbook\\Frontend\\Controllers\\ControllerBase->beforeExecuteRoute(Object(Phanbook\\Common\\Library\\Mvc\\Dispatcher))
#8 [internal function]: Phalcon\\Dispatcher->_dispatch()
#9 [internal funct in /var/www/tembo/core/common/library/Auth/Auth.php on line 186

All the subdomains are down... blog.phanbook.com themes.phanbook.com etc

Also, the "Follow Along" social buttons on your site are broken at the moment, if you're not aware.

Thanks. Look forward to reading more about phanbook.

When I try to save a question on the frontend, it doesn't save. This page loads: posts/save

In the error log I see...

[Sun Dec 25 11:16:41.010392 2016] [:error] [pid 4381] [client 127.0.0.1:51962] PHP Warning: Invalid argument supplied for foreach() in /var/www/yo/phanbook/content/cache/volt/_var_www_tembo_phanbook_content_themes_default_partials_right-side.volt.php on line 76, referer: http://yo.mysite.com/posts/save

In the backend, I can save posts.

Hi, i have a problem with navigation, the section "users, badges, tags" not load.

My server is: Apache 2.0 PHP Version 5.6.8 Phalcon 2.0.7

What could be the problem?

Navigate to /backend/dashboard and you'll notice a link to "store" in the navigation:

Upon clicking it, you get a 404 page:

Judging by the navigation link, it seems like there's supposed to be a StoreController:

https://github.com/phanbook/phanbook/blob/51cc4d7ff6671f66d7b49dfb94b2e8ec2cc6f6b4/core/modules/backend/views/partials/left-side.volt#L51-L55

There's no such controller in the repo, and I can't find one in the history either.
Any input?

Steps to reproduce:
Login as the admin user: admin:phanbook
Click the "settings" link on the to of the page.
Click the DashBoard link.
Once you're in the Dashboard double click "Users".
You should now be looking at the /backend/dashboard page.
It produces a 500 error and writes a log to content/logs:

[Thu, 17 Aug 17 14:52:57 +0000][ERROR] backend [0]: Column 'admin' doesn't belong to the model or alias 'a', when executing: SELECT a.id, CONCAT(a.firstname, ' ', a.lastname) as name, a.username, a.gender, a.email, a.status, a.admin, a.moderator, a.karma FROM [Phanbook\Models\Users] AS [a] GROUP BY a.id

You can run the above directly on the database:

SELECT a.id, CONCAT(a.firstname, ' ', a.lastname) as name, a.username, a.gender, a.email, a.status, a.admin, a.moderator, a.karma FROM users AS a GROUP BY a.id

Trying that yields #1054 - Unknown column 'a.admin' in 'field list'. Removing it from the query and trying again yields #1054 - Unknown column 'a.moderator' in 'field list'. After removing that as well, the query executes fine.

Thus, this issue is caused by the `users` table having no admin or moderator column. I'm not sure exactly when the schema changed, but I clicked to a year back in the commits and found previous schemas were using: https://github.com/phanbook/phanbook/blob/f0b8b1cf4b554f9d1553d869e22505c2d1946abc/schema/phanbook.sql#L596-L597 Thus it would appear the columns were supposed to represent boolean data consisting of N/Y. To determine if a user is an admin, it would seem now that you need to consult three tables:
users, roles_users, and roles. I see we're currently using:

Judging by that table, the only column that looks reliable to me would be type. If it's set to admin or moderator, then it would seem to me they are a user of that role. Thus it seems we now have a replacement for the missing admin and moderator columns.

I wrote up a join query that looks like this:

SELECT a.id, CONCAT(a.firstname, ' ', a.lastname) as name, a.username, a.gender, a.email, a.status, IF(SUM(c.type = 'admin'),'Y','N') AS admin, IF(SUM(c.type = 'moderator'),'Y','N') AS moderator, a.karma  FROM `users` a LEFT JOIN `roles_users` b ON a.id=b.users_id LEFT JOIN `roles` c ON c.id=b.roles_id GROUP BY a.id

Thus it would seem a fix would be to add some joins to our query. Since we're grouping by a.id, there won't be an issue of duplicates. Then we can make use of SUM or COUNT. I'm pretty sure SUM makes more sense in this context.

PR is coming shortly.

Bumps guzzlehttp/guzzle from 6.5.7 to 6.5.8.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Hi,

I set up Google OAuth and Analytics API, but PhanBook failed to login/sign up using Google OAuth. Could you tell me how to fix this issue?

• Log

[Fri Nov 01 22:08:29.166115 2019] [proxy_fcgi:error] [pid 29764:tid 139764724483840] [client 203.141.134.112:58156] AH01071: Got error 'PHP message: PHP Notice:  Undefined property: Phalcon\\Config::$google in /srv/phanbook/core/modules/oauth/controllers/LoginController.php on line 72PHP message: PHP Fatal error:  Uncaught TypeError: Argument 1 passed to Phanbook\\Google\\Auth::__construct() must be an instance of Phalcon\\Config, null given, called in /srv/phanbook/core/modules/oauth/controllers/LoginController.php on line 72 and defined in /srv/phanbook/core/common/library/Google/Auth.php:39\nStack trace:\n#0 /srv/phanbook/core/modules/oauth/controllers/LoginController.php(72): Phanbook\\Google\\Auth->__construct(NULL)\n#1 [internal function]: Phanbook\\Oauth\\Controllers\\LoginController->googleAction()\n#2 [internal function]: Phalcon\\Dispatcher->callActionMethod(Object(Phanbook\\Oauth\\Controllers\\LoginController), 'googleAction', Array)\n#3 [internal function]: Phalcon\\Dispatcher->dispatch()\n#4 /srv/phanbook/core/common/Application.php(158): Phalcon\\Mvc\\Application->handle()\n#5 /srv/phanbook/core/common/Application.php(108): Phanbook\\Common\\Application->getOutput()\n#6 /srv/phanbook/public/index.php(23): Phanbook\\Common\\Application->run()\n#7 {main}\n  thrown in /srv/phanbook/core/common/...', referer: https://stack.uixis.org/users/signin

Hello

As you know when we put css and js into core and modules it will be help clean code but when we want to deploy to CDN maybe it is hard

Any idea for that?

There should be an indicator that you're logged in, along with your username and/or name along the top so you know that you're logged in, rather than having to click "+Settings" to see if the "logout" link is present. As we're using stackoverflow as the rolemodel of what phanbook is supposed to be, let's see what they use to indicate logged in vs not logged in:

Not logged in:

Logged in:

As you can see, they do waaaaaaay more than just change the top menu. They even show you a different landing page, and configure it based on your settings and preferences. Currently phanbook shows you the same page whether or not you're logged in.

We're using a hack in https://github.com/phanbook/phanbook/blob/667d07f9082bb871b73ba6265c66c12d370c9c10/content/themes/default/partials/breadcrumb.volt#L23 to decide if we're viewing the initial / page. Then we're displaying content which users see whether logged in or not, with a sign up link. This sort of logic seems wrong. There should be two different types of header pages I believe. One should be content we welcome users to sign up. The other should be content the user would be interested in like their badge progress, their current reputation, and a history of their activity and a way to view their starred questions etc.

We should be aiming for a page closer in the direction of:

It's not that hard to check if the user is logged in. Just have to do something like:

    $this->view->setVar('loggedIn', $this->auth->isAuthorizedVisitor());

Then from volt you can do something like:

{% if loggedIn %}
    {{ partial('partials/logged-in') }}
{% else %}
    {{ partial('partials/not-logged-in') }}
{% endif %}

And why is this sort of logic currently in breadcrumb.volt? It should be in its own partials page so it's in a place people actually would think to look for it.

Not sure when I'll be able to get around to this. Just jotting out ideas for now until a solution begins to take form.

See error in screenshot below:

The backtrace in the screenshot mentions line 35: https://github.com/phanbook/phanbook/blob/667d07f9082bb871b73ba6265c66c12d370c9c10/core/modules/cli/tasks/DatabaseSeederTask.php#L35

This is caused by the following four pointing nowhere:

use Phanbook\Databases\UsersSeeder;
use Phanbook\Databases\PostsSeeder;
use Phanbook\Databases\TagsSeeder;
use Phanbook\Databases\PostsTagsSeeder;

Almost exactly 2 years ago, you find the last instance of them in the repo:
Commit: 01226ab

They were removed 3 days later:
Commit: c71a76a

Right now the task simply fails due to the error. We could reinstate the seeding files so the task has something to do. and/or revise the task. We could also aim at a different directory structure altogether even. I like the idea of going in the Laravel direction and have a "database" directory to toss in our migrations. I think the schema approach makes it hard to track database changes. What do you guys think?

1. Remove /schema and reinstate /databases?
2. Add /databases so we have both /databases and /schema?
3. Or leave the directory structure alone and remove the task?

The schema right now is a complete mess. You can't even run the two SQL files back-to-back without encountering SQL errors related to the primary key already being used with multiple tables. Once it fails, you try to run it again, and the tables already exists because it's not a transaction. Anyone have any reasons to keep /schema or any reasons against reinstating /databases? I think consistency is a better choice. Also if we're going to head in the Laravel direction, I think we should call it /database rather than /databases in the plural.

TL;DR

I want to drop /schema, reinstate /databases then drop the "s", renaming it to /database.