Announcement

Collapse
No announcement yet.

Cannot save or make new

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cannot save or make new

    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

    Code:
    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 ...

    Attached Files

  • #2
    Notices were changed in 5.5.5. Did you skip upgrade steps?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      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


      Code:
      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: ""

      Comment


    • #4
      Originally posted by Wayne Luke View Post
      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 ..

      Comment


      • #5
        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.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #6
          Originally posted by Wayne Luke View Post
          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 ? ...

          Comment


          • #7
            Yes.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • #8
              Originally posted by Wayne Luke View Post
              Yes.
              Hi, sorry i have a busy, sorry to late reply ..done but the error is still persist .. how to fix this please ...

              Comment


              • #9
                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.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

                Related Topics

                Collapse

                Working...
                X