Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unknown column 'myaac_forum.post_html' in 'field list'' #40

Closed
MxSoft opened this issue Jan 8, 2018 · 6 comments
Closed

Unknown column 'myaac_forum.post_html' in 'field list'' #40

MxSoft opened this issue Jan 8, 2018 · 6 comments

Comments

@MxSoft
Copy link

MxSoft commented Jan 8, 2018

Error in forum:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'myaac_forum.post_html' in 'field list'' in /var/www/html/system/libs/pot/OTS_Base_DB.php:101 Stack trace: #0 /var/www/html/system/libs/pot/OTS_Base_DB.php(101): PDO->query('SELECT `players...') #1 /var/www/html/system/pages/forum/show_thread.php(32): OTS_Base_DB->query('SELECT `players...') #2 /var/www/html/system/pages/forum.php(178): require('/var/www/html/s...') #3 /var/www/html/index.php(390): require('/var/www/html/s...') #4 {main} thrown in /var/www/html/system/libs/pot/OTS_Base_DB.php on line 101
@slawkens
Copy link
Owner

slawkens commented Jan 8, 2018

Did you forget to update common.php or system/migrations/21.php?

There's new database column that will be automatically added into your database when you enter your page.

@MxSoft
Copy link
Author

MxSoft commented Jan 8, 2018

Yes i added both files

@slawkens
Copy link
Owner

slawkens commented Jan 8, 2018

What do you have in your database in table myaac_config under database_version?

If it's 21, then change it to 20 and refresh page.

@MxSoft
Copy link
Author

MxSoft commented Jan 8, 2018

1 database_version 21

@slawkens
Copy link
Owner

slawkens commented Jan 8, 2018

Yeah, that's cause someone visited your website when you made update and file system/migrations/21.php didn't exist yet.

Change database_version to 20 and refresh the page.

@MxSoft
Copy link
Author

MxSoft commented Jan 8, 2018

Now working 100%

@MxSoft MxSoft closed this as completed Jan 8, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants