Announcement

Collapse
No announcement yet.

updating signitures

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

  • jonsidneyb
    replied
    Sorry for not replying. It worked. I am just not sure where that extra stuff is coming from.

    Leave a comment:


  • borbole
    replied
    I am just following up on this. Did you manage to run the query ok now or did you still run into errors?

    Leave a comment:


  • borbole
    replied
    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;

    Leave a comment:


  • metalguy639
    replied
    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.

    Leave a comment:


  • jonsidneyb
    replied
    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.

    Leave a comment:


  • borbole
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • jonsidneyb
    replied
    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.

    Leave a comment:


  • borbole
    replied
    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?

    Leave a comment:


  • jonsidneyb
    replied
    I thought this was the only thing I was supposed to have in the query?

    UPDATE post
    SET showsignature = 1
    WHERE userid = 25982

    Leave a comment:


  • borbole
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • borbole
    replied
    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.

    Leave a comment:


  • Oracle simsim
    replied
    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

    Leave a comment:


  • jonsidneyb
    replied
    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 ?

    Leave a comment:

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