View Single Post
  #1  
Old 06-04-2008, 04:01 PM
wobbly wobbly is offline
 
Join Date: Sep 2005
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database reporting errors

I think I deleted a userprofile field (One I inserted) in admincp as it was made redundant by a hack. Now the database is reporting the following error via e-mail.

nvalid SQL:
SELECT mydbuser.userid, mydbuser.lastvisit, mydbuser.posts, mydbuserfield.field10 FROM `mydbuserfield` LEFT JOIN `mydbuser` ON mydbuserfield.userid = mydbuser.userid WHERE mydbuser.posts >= '0' AND mydbuserfield.field10 != '';

MySQL Error : Unknown column 'mydbuserfield.field10' in 'field list'
Error Number : 1054

Request Date : Wednesday, June 4th 2008 @ 11:03:23 AM
Error Date : Wednesday, June 4th 2008 @ 11:03:24 AM
Script : http://www.mywebsite.co.uk/cron.php?&rand=726150
Referrer : http://www.mywebsite.co.uk/
IP Address : 86.129.213.98
Username : Unregistered
Classname : vB_Database
MySQL Version :


I have confirmed in phpadmin that field10 does not exist and would like to know if anyone has any ideas for this newbie so that he can sort it all out.

Thank you for any help you can offer in advance.



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

Anybody?

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

Anybody?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01147 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete