Announcement

Collapse
No announcement yet.

updating signitures

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

  • [CMS] updating signitures

    UPDATE post
    SET showsignature = 1
    WHERE userid = xxxxx

    is there something wrong with the way I did this? I have managed to do this before.

    error number: 1146


  • #2
    Why not use the option available within:

    AdminCP > Maintenance > Execute SQL Query >

    Make sure that your userid is able to run queries by editing the following section of the config.php file:

    Code:
     // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
     // The users specified here will be allowed to run queries from the control panel.
     // See the above entries for more information on the format.
     // Please note that the ability to run queries is quite powerful. You may wish
     // to remove all user IDs from this list for security reasons.
    $config['SpecialUsers']['canrunqueries'] = 'x';
    where 'x' is your userid.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      UPDATE post
      SET showsignature = 1
      WHERE userid = 25982

      An error occurred while attempting to execute your query. The following information was returned.
      error number: 1146
      error desc: Table 'jsbur2_vb4edc.post' doesn't exist

      Error number: 1146 ?

      Comment


      • #4
        I think there is nothing can prevent excuting this command, as long as you have this userid in your forum and you have QUERY RUNNING PERMISSION

        try to run that in phpmyadmin if you can
        منتديات درر العراق

        Comment


        • #5
          Originally posted by jonsidneyb View Post
          UPDATE post
          SET showsignature = 1
          WHERE userid = 25982

          An error occurred while attempting to execute your query. The following information was returned.
          error number: 1146
          error desc: Table 'jsbur2_vb4edc.post' doesn't exist

          Error number: 1146 ?
          The problem is that your database tables have a prefix and you are not inluding it in your query.

          Comment


          • #6
            I had run two of these before successfully. Where would I put the prefix at on the query?

            Comment


            • #7
              Originally posted by jonsidneyb View Post
              I had run two of these before successfully. Where would I put the prefix at on the query?
              Before the table name.

              Comment


              • #8
                I thought this was the only thing I was supposed to have in the query?

                UPDATE post
                SET showsignature = 1
                WHERE userid = 25982

                Comment


                • #9
                  Originally posted by jonsidneyb View Post
                  I thought this was the only thing I was supposed to have in the query?

                  UPDATE post
                  SET showsignature = 1
                  WHERE userid = 25982
                  Like this you are missing the closing semicolon ;

                  It should be like this:

                  Code:
                  UPDATE post
                  SET showsignature = 1
                  WHERE userid = 25982;
                  But seeing the error mysql threw above you haven''t included the db tables prefix in your query. Hence my advice/suggestion to do so above.

                  P.s. Can you make a screenshot of the db tables where you are running the query?

                  Comment


                  • #10
                    http://www.vbulletin.org/forum/showthread.php?t=123906

                    See post #5 I was able to get it to work successfully for two user numbers. I need to do two more. They way I understand it this is all I need to do and it did work before.

                    It is actually costing me about $20.00 per day not being able to get this run.

                    Comment


                    • #11
                      Do you have a table prefix defined in your config.php file If so what is it?

                      Comment


                      • #12
                        Originally posted by jonsidneyb View Post
                        http://www.vbulletin.org/forum/showthread.php?t=123906

                        See post #5 I was able to get it to work successfully for two user numbers. I need to do two more. They way I understand it this is all I need to do and it did work before.

                        It is actually costing me about $20.00 per day not being able to get this run.
                        According to the error Mysql throws it appears that you are not including the db prefix when running the query, as told here and at your other thread. If you would provide us with a screenshot of the db tables or check the config.php file as adviced above then we would be able to help you further.

                        Comment


                        • #13
                          vb4_
                          this is the table prefix in the config file.
                          for some reason it is showing the first part of the table name as the prefix when its not the prefix.

                          I was able to get this to work twice before.

                          Comment


                          • #14
                            I'm working with Jonsidneyb on his site.

                            The table prefix is vb4_

                            The vbulletin database table name begins with the jsbur2 part. That is not a prefix at all never was This did not happen until after we updated to 4.0.3 I believe. He was able to do this before the update.

                            Comment


                            • #15
                              Try to run the query like this and see if it will be run successfully.

                              Code:
                              UPDATE vb4_post
                              SET showsignature = 1
                              WHERE userid = 25982;

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X