vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   To change all IP numbers of a single user (https://vborg.vbsupport.ru/showthread.php?t=250353)

borbole 08-21-2012 05:10 PM

Quote:

Originally Posted by Bob_R (Post 2358756)
Since PHP and MySQL have been updated in the last 2 years post #2 in this thread doesn't work.

It asked me to select at least 1 column/row (or something like that)

What is the way to do it now?

Thanks!

Updating of php and mysql has nothing to do with the query above. In order to troubleshoot your problem we would need to see the full error that you got.

But most likely as mentioned above, you are using a prefix for your db tables and you did not include it in the query as mentioned at my other post above.

Bob_R 08-21-2012 05:30 PM

Quote:

Originally Posted by Lynne (Post 2358757)
That query is still correct. Make sure if you use a table prefix that you add that to the beginning of the table name.

Quote:

Originally Posted by borbole (Post 2358771)
Updating of php and mysql has nothing to do with the query above. In order to troubleshoot your problem we would need to see the full error that you got.

But most likely as mentioned above, you are using a prefix for your db tables and you did not include it in the query as mentioned at my other post above.

OK, guys. Thanks. I'll check it out and get back to ya!

--------------- Added [DATE]1345592796[/DATE] at [TIME]1345592796[/TIME] ---------------

Here's what I entered:

UPDATE post
SET ipaddress = '66.28.139.242'
WHERE userid = 67;

And, here is the result

You have to choose at least one column to display

----------------------

What did I do wrong?

Thanks.

--------------- Added [DATE]1345593235[/DATE] at [TIME]1345593235[/TIME] ---------------

I figured it out. I was in the wrong window.

Thanks for your help.


All times are GMT. The time now is 08:38 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00996 seconds
  • Memory Usage 1,716KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete