therealjag / laravel-questionanswer Goto Github PK

.

http://qna.therealjag.com/question/82/drawback-creating-true-private-methods-javascript

http://qna.therealjag.com/question/112/javascript-templating-engines

http://qna.therealjag.com/question/98/javascript-templating-engines

The only difference between the questions is the tags.

Don't allow insert if the tag match returns true?

https://www.php-fig.org/psr/psr-4/

3.3 The terminating class name corresponds to a file name ending in .php. The file name MUST match the case of the terminating class name.

https://www.php-fig.org/psr/psr-1/

Class names MUST be declared in StudlyCaps.

Just wondering if there should be a migration for the votes model?

Need to create a migration routine from the sql.txt file in the project.

I'm getting the following when installing the develop branch which upgrades to laravel 5.7

Migrating: 2017_06_03_223031_notifications_foreign_key In Connection.php line 664: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table notificationsadd constraintnotifications_notifiable_id_foreign foreign key (notifiable_id) references users (id`) on delete cascade)

In Connection.php line 458: SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint
`

http://qna.therealjag.com/level/Beginner

Notifications to a user if a question/answer is upvoted/downvoted, leaves answer...

• In Browser, use vue?
• Email
• Chrome

A pivot table should do the trick.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'qadb.votes' doesn't exist (SQL: select questions.*, sum(votes.vote) as vote_ttl from questions inner join votes on questions.id = votes.question_id where questions.created_at >= 2013-04-29 02:10:22 group by questions.id order by vote_ttl desc, questions.created_at desc limit 3)

I have Database\QueryException Error:
SQLSTATE[42000]: Syntax error or access violation: 1055 'qa_laravel.questions.user_id' isn't in GROUP BY (SQL: select `questions`.*, sum(votes.vote) as vote_ttl from `questions` inner join `votes` on `questions`.`id` = `votes`.`question_id` where `questions`.`created_at` >= 2013-04-29 02:10:22 group by `questions`.`id` order by `vote_ttl` desc, `questions`.`created_at` desc limit 3)

Anyone can help me how to fix it?

@TheRealJAG Hello! I'm getting a bug where the new question form isn't submitting, on the demo site you link to as well as my local one. I'm seeing a js console type error that may be linked to it. Will poke around some more

Update: Looks like it's the twitter tags input js, it takes over the input field but doesn't have a "name" attr so that may be preventing it from submitting - when I remove that field, the request goes through

Takes up most of above the fold.

I was wondering about your thoughts on basing off http://laravel-boilerplate.com/
I am looking at porting portions anyway, so would be happy to assist

Well, for example, if you go to an existing tag (or page in general), a page with a 404 error appears, instead of an error, like now http://qna.therealjag.com/tag/javascript5

It's strange that the vote count increases / decreases when you click on the corresponding buttons, although after that a modal window appears with the message that you can only vote registered, and of course, after the page has been reloaded, the vote counter is the same as it was.

I think it's better to hide the voting buttons at all unregistered.