NamelessMC

Hello, I update my website when there are new GitHub commits, but there is one big commit that add new "Types of forums" but when I choose one type of forum like: Discussion Forum it tells me an error: 

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'forum_type' in 'field list'

Is there any way to fix that?

Since you updated your files manually without a release update or runned the installer again 

its requrie database change so u need to wait until next release 

And i fixed the installer for 2 hours ago ca but people can still not update without a release

or you can find a way to run this $queries->alterTable('forums', 'forum_type', "varchar(255) NOT NULL DEFAULT 'forum'");

Partydragen said:

Since you updated your files manually without a release update or runned the installer again 

its requrie database change so u need to wait until next release 

 

And i fixed the installer for 2 hours ago ca but people can still not update without a release

or you can find a way to run this $queries->alterTable('forums', 'forum_type', "varchar(255) NOT NULL DEFAULT 'forum'");

If I find a way to run that I will be not able to use the installer? I meant that I will not need to use the installer?

You can't use the installer again since its already installed but u can try to create a new file and add 

<?php
$queries->alterTable('forums', 'forum_type', "varchar(255) NOT NULL DEFAULT 'forum'");
));

Idk that will work but then u goes to that path in your website if you understand

Oh god.. I hate php lol I am really bad at it

You shouldn't be updating your installation unless it is a stable release.  The updater automatically updates you database to avoid these issues.

But I need this and the only thing that I need to do is create a new table, the problem is that I don't know how 

You could manually run the SQL query from phpMyAdmin if you have it installed or from the MySQL command line if you don't.

dwilson390 said:

You could manually run the SQL query from phpMyAdmin if you have it installed or from the MySQL command line if you don't.

How so? so far I get into the phpMyAdmin console, what I need to do is create a new table

$queries->alterTable('forums', 'forum_type', "varchar(255) NOT NULL DEFAULT 'forum'");

That is the "code" that I need to use, sorry for my english btw 

Since you really need it...

to do it easy

I created a file and download this http://www.mediafire.com/download/a1ckh8ck0hga3t9/updatedatabase.php add it to your webserver in /pages/

then go to website "yourdomain/updatedomain"

you will see a white page then you can delete the file