vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Help: MySQL error after making some changes.... (https://vborg.vbsupport.ru/showthread.php?t=176019)

GTX2 04-13-2008 11:43 AM

Help: MySQL error after making some changes....
 
i don't know what's happening, but after replacing some user profile fields, i start receiving thousands and thousands of vbulletin database errors in my email, with this content:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT user.usergroupid, userfield.field28
FROM vbbuser AS user, vbbuserfield AS userfield
WHERE user.userid = ' 15610 '
AND userfield.userid = ' 15610 ';

MySQL Error : Unknown column 'userfield.field28' in 'field list'
Error Number : 1054
Date : Sunday, April 13th 2008 @ 12:37:39 PM
Script : http://www.myurl.com/showthread.php?t=48012
Referrer :
IP Address : xx.xxx.65.235
Username : Not registered
Classname : vB_Database
Can someone help me out?
Browsing the forums i got no errors, but i receive thousands of this email errors!

thanks

Opserty 04-13-2008 11:45 AM

MySQL Error : Unknown column 'userfield.field28' in 'field list'

What changes did you make exactly? You are probably running Plugins or something that are requesting this field and now that you have changed stuff this field no longer exists. So you may have to edit some PHP or Options accordingly.

Disable your modifications and see if your problem persists.

GTX2 04-13-2008 09:13 PM

how can i create again field28? I think problem will be solved if i create again that field number, but now everytime i create a field it goes up and up field29, field30, field31, field32 and so on...

Dismounted 04-14-2008 06:33 AM

Quote:

Originally Posted by GTX2 (Post 1489958)
how can i create again field28? I think problem will be solved if i create again that field number, but now everytime i create a field it goes up and up field29, field30, field31, field32 and so on...

You don't. All fields have a unique identifier and it auto increments. You will have to change whatever is trying to access field28 to your new field.

GTX2 04-14-2008 07:24 AM

i've found the problem: was the hack vb ad management, that was requesting the field28 for shared advertisements. just disabled the shared advertisements.

thank you!


All times are GMT. The time now is 01:02 AM.

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.01127 seconds
  • Memory Usage 1,719KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete