Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2009, 03:28 PM
sebil's Avatar
sebil sebil is offline
 
Join Date: Feb 2008
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Private message problem.. Showing Database Error

Whenever i m trying to pm any memebrs in my forum it showing data base error

Quote:
Database error in vBulletin 3.7.4:

Invalid SQL:
INSERT INTO pm (pmtextid, userid, parentpmid) VALUES (11241, 9266, 0);

MySQL Error : Unknown column 'parentpmid' in 'field list'
Error Number : 1054
Request Date : Friday, January 23rd 2009 @ 05:15:21 PM
Error Date : Friday, January 23rd 2009 @ 05:15:21 PM
Script : http://www.malludreams.com/forum/pri...insertpm&pmid=
Referrer : http://www.malludreams.com/forum/pri...o=newpm&u=9266
IP Address : 86.144.92.18
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.67-community
Could any one tell me what is the problem
Reply With Quote
  #2  
Old 01-23-2009, 04:23 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:
define('DISABLE_HOOKS'true); 
I am pretty sure that colun, parentpmid, was added in 3.8 and you are running 3.7, so it may be that you installed a modification for 3.8 which won't work.
Reply With Quote
  #3  
Old 01-23-2009, 04:59 PM
GhoHan's Avatar
GhoHan GhoHan is offline
 
Join Date: Oct 2007
Location: Jakarta - Indonesia
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by sebil View Post
Whenever i m trying to pm any memebrs in my forum it showing data base error



Could any one tell me what is the problem
You may try this trick
just disable it
please open file ../includes/class_dm_user.php
find on line 2900
this below code:
Quote:
($hook = vBulletinHook::fetch_hook("private_insertpm_comple te")) ? eval($hook) : false;
and add // befor that code like this:
Quote:
// ($hook = vBulletinHook::fetch_hook("private_insertpm_comple te")) ? eval($hook) : false;
Save and please try again.
Reply With Quote
  #4  
Old 01-23-2009, 05:48 PM
sebil's Avatar
sebil sebil is offline
 
Join Date: Feb 2008
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a lot guys for your help..
i got 3.8.0 uploaed in my server but it didnt worked properly.. so i backuped my database.. but didnt remove the 3.8.0 files from server.. because after back up it seems work perfectlyy..

so, shall i just uplaod 3.7.4 files to my server now?

what is the best way ?
Reply With Quote
  #5  
Old 01-23-2009, 06:31 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It looks like if you tried to upgrade to 3.8.0, that you never ran the upgrade script which is what upgrades your database to 3.8.0. Your database is still only upgraded to version 3.7.4.

Do NOT just remove the hook like the person above your post suggested. That may cause problems for other modifications you have running just fine.
Reply With Quote
  #6  
Old 01-23-2009, 06:43 PM
Mike-D Mike-D is offline
 
Join Date: Jan 2006
Location: Cologne / Germany
Posts: 270
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by i-comers.com View Post
You may try this trick
just disable it
please open file ../includes/class_dm_user.php
find on line 2900
this below code:


and add // befor that code like this:


Save and please try again.
Sorry to mention it, but your way is not highly recommended!!! Editing PHP's nor removing the most important $Hooks are no solutions for this. The way like Lynne mentioned is the way you have to go
Reply With Quote
  #7  
Old 01-23-2009, 06:56 PM
sebil's Avatar
sebil sebil is offline
 
Join Date: Feb 2008
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What really happened is..
i tried to upgrade to 3.8.0 and runned the upgrade script.. but the forum home page didnt woked
it showed me some error message
when i showed that vb support team they said it beacsue of vbseo.. and i contacted vbseo.. but it otook a long time .. so i had a back up i just back uped it.. still i got vb 3.8.0 files in sever

what is the best way to resolve it?
Reply With Quote
  #8  
Old 01-23-2009, 08:19 PM
Mike-D Mike-D is offline
 
Join Date: Jan 2006
Location: Cologne / Germany
Posts: 270
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, if I'm not mistaken I'd start the Update without vBSEO. After I'd get in touch with vBSEO to get a fix
Reply With Quote
  #9  
Old 01-23-2009, 09:11 PM
sebil's Avatar
sebil sebil is offline
 
Join Date: Feb 2008
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

so now my site is working with not many problems...

shall i delet all the vbseo files uploaded and installed and try upgrading to 3.8.0?

is that a good choice?
Reply With Quote
  #10  
Old 01-23-2009, 09:22 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There was some problem in vbseo when you upgraded to 3.7.5 or 3.8.0 but a fix was posted. Is that the problem you were having?

If you have a database that is for 3.7.4, then you should put the 3.7.4 files onto the server or else you will have issues like the one in this thread.
Reply With Quote
Reply


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 01:15 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05571 seconds
  • Memory Usage 2,258KB
  • Queries Executed 13 (?)
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
  • (1)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete