Cannot save or make new

[Zico Ekel]

Hi i have an Error when try to edit,save or make a new one notice, this is start when i was update to the new version

Database error in vBulletin 5.5.6:

Invalid SQL:
UPDATE notice SET `title`='default_guest_message',`displayorder`=10,`active`=1,`persistent`=1,`dismissible`= 1,`noticeoptions`=0
WHERE (`noticeid` = 1)
/**notice**/;

MySQL Error   : Unknown column 'noticeoptions' in 'field list'
Error Number  : 1054
Request Date  : Monday, January 20th 2020 @ 02:30:30 PM
Error Date    : Monday, January 20th 2020 @ 02:30:30 PM
Script        :
Referrer      :
IP Address    : xx.xx.xx.xx
Username      :
Classname     : vB_Database_MySQLi
MySQL Version : 5.6.46-cll-lve


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
#3 vB_Database->query_write() called in [path]/vb/db/query/update.php on line 116
#4 vB_dB_Query_Update->doUpdates() called in [path]/vb/db/query/update.php on line 101
#5 vB_dB_Query_Update->execSQL() called in [path]/vb/db/assertor.php on line 301
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 538
#7 vB_dB_Assertor->update() called in [path]/vb/library/notice.php on line 179
#8 vB_Library_Notice->saveNoticeInfo() called in [path]/vb/library/notice.php on line 136
#9 vB_Library_Notice->save() called in [path]/vb/api/notice.php on line 522
#10 vB_Api_Notice->save() called in [path]/vb/api/wrapper.php on line 201
#11 vB_Api_Wrapper->__call() called in [path]/admincp/notice.php on line 129
#12 require_once([path]/admincp/notice.php) called in /home/uko6ga6tajny/public_html/includes/api/interface/collapsed.php on line 144
#13 Api_Interface_Collapsed->relay() called in /home/uko6ga6tajny/public_html/includes/vb5/frontend/controller/relay.php on line 33
#14 vB5_Frontend_Controller_Relay->admincp() called in /home/uko6ga6tajny/public_html/index.php on line 74

and also html code not working ...



someone help please ...

[Wayne Luke]

Notices were changed in 5.5.5. Did you skip upgrade steps?

[zeeeichel]

Notices were changed in 5.5.5. Did you skip upgrade steps?

i think i not skip any upgrade steps .. and the upgrade it was mentioned success

now i have a new problem, after trying to solving the previous problem, i was thinking this problem because my hosting is very slow then i buy a private server and remove all into the new server. after searching, i think i got mess because i not change cookie path and make them all error.. this the error log under nginx web server

2020/01/21 02:58:27 [error] 30572#30572: *3 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined index: cookiepath in /home/.../.../public_html/includes/vb5/cookie.php on line 206 PHP message: PHP Notice: Undefined index: cookiedomain in /home/.../.../public_html/includes/vb5/cookie.php on line 207 PHP message: PHP Notice: Undefined index: privacy_consent_cookie_name in /home/.../.../public_html/includes/vb5/cookie.php on line 208 PHP message: PHP Notice: Undefined index: privacy_consent_delete_cookie in /home/.../.../public_html/includes/vb5/cookie.php on line 209 PHP message: PHP Notice: Undefined index: frontendurl in /home/.../.../public_html/includes/vb5/cookie.php on line 216 PHP message: PHP Notice: Undefined index: ipcheck in /home/.../.../public_html/core/vb/session.php on line 750 PHP message: PHP Notice: Undefined index: ipcheck in /home/f.../.../public_html/core/vb/session.php on line 750 PHP message: PHP Notice: Undefined index: timeoffset in /home/.../.../public_html/core/vb/session.php on line 918 PHP message: PHP Notice: Undefined index: dstonoff in /home/.../.../public_html/core/vb/session.php on line 919 PHP message: PHP Notice: Undefined index: languageid in /home/f.../.../public_html/core/vb/db/mysql/querydefs.php on line 3345 PHP message: PHP Notice: Undefined index: languageid in /home/.../.../public_html/core/vb/db/mysql/querydefs.php on line 3345 PHP message: PHP Notice: Undefined index: languageid in /home/forum.paludarium.org/public_html/core/vb/db/mysql/querydefs.php on line 3345" while reading response header from upstream, client: , server: , request: "GET /admincp/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.2-fpm.sock:", host: ""

[Zico Ekel]

fix already .. now thanks

[Zico Ekel]

Notices were changed in 5.5.5. Did you skip upgrade steps?

Hi Wayne, i done 3 times to upgrade and make sure everything is complete .. the error now is

Error Invalid SQL: UPDATE notice SET `title`='default_guest_message',`displayorder`=10,`active`=1,`persistent`=1,`dismissible`= 1,`noticeoptions`=2 WHERE (`noticeid` = 1) /**notice**/;

please help ..

[Wayne Luke]

Your missing a field called "noticeoptions" on your table.

You need to add that field. You ran the following command?

/core/install/upgrade.php?version=555&only=1

I am unsure because I was waiting for an answer to my question before giving it to you. Running the upgrade multiple times can possibly create additional problems so needed that information before proceeding.

[Zico Ekel]

Your missing a field called "noticeoptions" on your table.

You need to add that field. You ran the following command?

/core/install/upgrade.php?version=555&only=1

I am unsure because I was waiting for an answer to my question before giving it to you. Running the upgrade multiple times can possibly create additional problems so needed that information before proceeding.

I dont, .. should i try to run that command ? ...

[Wayne Luke]

Yes.

[Zico Ekel]

Yes.

Hi, sorry i have a busy, sorry to late reply ..done but the error is still persist .. how to fix this please ...

[Wayne Luke]

You will need to purchase a support contract and open a support ticket so someone can look at your database. I have no idea why you're getting a field not found error if you recreated the table using the exact query that I provided.