Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-04-2013, 05:29 PM
archievision archievision is offline
 
Join Date: Apr 2012
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Navigation MSqli error

Hello,

We are having a bit of an issue with our site ATM. We cannot change or update the navigation tabs on our site now after the update. Every time we click submit we get this error.
Quote:
mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'NAV_DELETED' in 'field list' in [path]/includes/class_core.php on line 1391
I am a noob at this, so can someone shed some light on what needs to be done, or what direction I should start looking. This is the code for line 1391
PHP Code:
if ($queryresult mysqli_query($link$this->sql, ($buffered MYSQLI_STORE_RESULT MYSQLI_USE_RESULT))) 
We are using the latest 4.2.1 VB version.

The site is at www.teammp.net

Thanks for any help you can give.

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

This must be harder fix than I thought.
Reply With Quote
  #2  
Old 07-06-2013, 01:31 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is that the entire error message? It might help to see the actual SQL. I don't see a column named that in the navigation table, and I searched here and on vbulletin.com and haven't found anyone else mentioning that error.
Reply With Quote
  #3  
Old 07-06-2013, 01:40 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For a start you have this plugin and it is not needed as you have the option in 4.2.1 default vb to add extra tabs now
Reply With Quote
  #4  
Old 07-06-2013, 09:49 PM
archievision archievision is offline
 
Join Date: Apr 2012
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have uninstalled it. And it still is doing the same thing.



Here is Screen from today after uninstalled that new tab add on.

Tell me what you need and I will get it on here as fast as I can.

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

OH Boy!! This was User Error all the way. ROFL!!!

At our site we use a different filing system for the Admin and Mod folders for security purposes. Well, they do not update Automatically. And we forgot to manually update them. This is why we were getting a very weird SQL error. The version in those folders was 4.0.1 and we updated to 4.2.1.

Thanks for all the help guys. But it turns out is was the "Lose nut behind the steering wheel".
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 09:03 AM.


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.04795 seconds
  • Memory Usage 2,192KB
  • 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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete