MyBB Community Forums

I am starting a myBB forum hosted on siteground. Currently i am having problems with logging in to both the forum and ACP. It accepts the pass word, a message appears saying I am logged on, and then when the board appears, I am not logged in. After much anger, I discovered that this problem only occurs using Google Chrome, but does not happen on Safari, where I can log in with no problem. 
I was advised by Tech Support on siteground to change from http:// to https:// in the ACP, which I did, and now accessing certain threads, I get the following:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1054 - Unknown column 'ipaddress' in 'where clause'Query:SELECT * FROM carnivora_pollvotes WHERE uid='0' AND ipaddress=X'76d35f51' AND pid='17'
Please contact the MyBB Group for technical support.

So I'm contacting you guys.

Youtube videos within threads were working a few days ago, and now I am getting error messages.

My forums url: https://carnivora.net/

Hopefully someone can help! Thanks.

For the youtube part. Can you post the content of "video_youtube_embed" template.

For your 1054 error
What plugin are you using? Same problem if you deactivate them?
Have you changed admin folder name?
Try upload all files to admin folder again.

Let us know if the problem is solved or not

Here is the youtube error:



As for the 1054 error, I have no plugins installed yet:

"There are no active plugins on your forum."

Let's try this:
Login to your admin. Press Templates and styles, press on templates, press on the template you are using. Scroll down to Video MyCode Templates, press on video_youtube_embed and cope the content and past it here.

Then, you can try this plugin, 
https://community.mybb.com/mods.php?action=view&pid=450

But please past the content of video_youtube_embed template

Here is what you asked for :

<iframe width="560" height="315" src="//www.youtube.com/embed/{$id}" frameborder="0" allowfullscreen></iframe>

As for adding the plugin, I have no idea how. I am sure it is simple if you know what to do, but everytime I've tried it hasnt worked. Is there a "for dummies step by step" guide?
What from the unzipped file do I transfer to the Remote Site, and where exactly on the Remote site? etc. when using Filezilla?

I am very new to MyBB, being a 'Zetaboards refugee' and have spent many hours this weekend trying to work out why I cant log in on Google, but I can on Safari browser, and how to get a video to actually play.

I really appreciate your time and patience BaggerHD.

Here's a documentation on plugins. See here. Can you link us to a thread you're trying to adding a YT video in?

As for the polls, since MyBB 1.8.14 (I think) ipaddresses were added to the _pollvotes table. Unsure how you've upgraded but the column doesn't seem to be in your setup. Run the following query to fix this issue:

ALTER TABLE mybb_pollvotes ADD ipaddress varbinary(16) NOT NULL default '';

(2018-06-03, 06:05 AM)BaggerHD Wrote: [ -> ]Let's try this:
Login to your admin. Press Templates and styles, press on templates, press on the template you are using. Scroll down to Video MyCode Templates, press on video_youtube_embed and cope the content and past it here.

Then, you can try this plugin, 
https://community.mybb.com/mods.php?action=view&pid=450

But please past the content of video_youtube_embed template

Here is the content of video_youtube_embed template:

<iframe width="560" height="315" src="//www.youtube.com/embed/{$id}" frameborder="0" allowfullscreen></iframe>

I still have two main problems.

1. youtube videos wont play (as explained above). The videos will play in the post reply screen, but not when the post has been posted. If I manually add : &feature=player_embedded  they will play.

2. polls. It still displays the following when someone access a thread with a poll or attached, or when I try to vote in a poll.

"SQL Error:1054 - Unknown column 'ipaddress' in 'where clause'Query:SELECT * FROM carnivora_pollvotes WHERE uid='0' AND ipaddress=X'76d35f51' AND pid='17'

Can anyone help me fix these issues?

I am having the same youtube video problem.

That was with 1.8.16
just upgraded to 1.8.17 an still the same error

So 1.8 will no fix either?

I can can click on the youtube link button and it takes me to youtube and the video works

(2018-07-29, 04:02 AM)slotking Wrote: [ -> ]I am having the same youtube video problem.

That was with 1.8.16
just upgraded to 1.8.17 an still the same error

So 1.8 will no fix either?

I can can click on the youtube link button and it takes me to youtube and the video works

I look forward to getting some support here on the support forum.