Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page MYSQL Errors
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2004, 03:07 AM
Harley D's Avatar
Harley D Harley D is offline
 
Join Date: Jan 2003
Location: WagnerTech.net
Posts: 266
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MYSQL Errors
I have started working on a site for a client that has been screwed up.
I have managed to repair most of it and even clean out the unused tables.
they are running VB 3.0.1 MYSQL Client API version 4.0.20.

When even I attempt to add a phrase in the ADMINCP I get an error, the same error no matter what phrase on any hack.
Its pretty large so I have it in a TXT file.

If anyone can help, I would really appreciate it. Its the cause of most of the remaining problems on this site and it prevents me from future hacks and mods that include adding any phrases.

Let me add that I can see my added phrases in the ADMINCP, but not on the pages they are supposed to show on.
Attached Files
File Type: txt SQLERROR.txt (276.6 KB, 5 views)
Reply With Quote
  #2  
Old 10-22-2004, 03:13 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Harley D
I have started working on a site for a client that has been screwed up.
I have managed to repair most of it and even clean out the unused tables.
they are running VB 3.0.1 MYSQL Client API version 4.0.20.

When even I attempt to add a phrase in the ADMINCP I get an error, the same error no matter what phrase on any hack.
Its pretty large so I have it in a TXT file.

If anyone can help, I would really appreciate it. Its the cause of most of the remaining problems on this site and it prevents me from future hacks and mods that include adding any phrases.
Thats not the full error, we need the bottom with the error number and script name
Reply With Quote
  #3  
Old 10-22-2004, 03:31 AM
Harley D's Avatar
Harley D Harley D is offline
 
Join Date: Jan 2003
Location: WagnerTech.net
Posts: 266
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Updated the TXT file, should include ALL text on the ERROR page that I get whenever adding phrases.


Quote:
mysql error: Unknown column 'phrasegroup_shoutmanager' in 'field list'

mysql error number: 1054

Date: Friday 22nd of October 2004 12:23:37 PM
Script: http://www.site.com/forums/admincp/phrase.php
Reply With Quote
  #4  
Old 10-24-2004, 12:18 AM
Harley D's Avatar
Harley D Harley D is offline
 
Join Date: Jan 2003
Location: WagnerTech.net
Posts: 266
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Zachery
Thats not the full error, we need the bottom with the error number and script name
O.K. is what I have posted now correct?
Reply With Quote
  #5  
Old 10-24-2004, 12:51 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Harley D
O.K. is what I have posted now correct?
mysql error: Unknown column 'phrasegroup_shoutmanager' in 'field list'

Did you do file base hacked to phrase.php but uninstall the hack?
Reply With Quote
  #6  
Old 10-24-2004, 03:22 PM
Harley D's Avatar
Harley D Harley D is offline
 
Join Date: Jan 2003
Location: WagnerTech.net
Posts: 266
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Zachery
mysql error: Unknown column 'phrasegroup_shoutmanager' in 'field list'

Did you do file base hacked to phrase.php but uninstall the hack?
I have not, but the person before may have. I'll check this file out and see if I can determin if it has been altered.

I replace phrase.php with one from VB3.0.3 it was the same ver as the one installed on the site. I then tried to erase a phrase and reinstall it using the adminpc, and still got the same error.

Any other ideas?
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


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

Contact Us - Archive - Top

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.04009 seconds
  • Memory Usage 2,231KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (1)postbit_attachment
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete