PDA

View Full Version : Navigation MSqli error


archievision
07-04-2013, 05:29 PM
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. 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 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 1373037492 at 1373037492 ---------------

This must be harder fix than I thought.

kh99
07-06-2013, 01:31 PM
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.

ForceHSS
07-06-2013, 01:40 PM
For a start you have this plugin (https://vborg.vbsupport.ru/showthread.php?t=228507) and it is not needed as you have the option in 4.2.1 default vb to add extra tabs now

archievision
07-06-2013, 09:49 PM
I have uninstalled it. And it still is doing the same thing.

https://vborg.vbsupport.ru/external/2013/07/27.jpg

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 1373197323 at 1373197323 ---------------

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".