News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Unknown column 'data' in 'field list' please help me.

Started by DilSe, January 17, 2015, 09:55:57 PM

Previous topic - Next topic

Illori

Quote from: shawnb61 on July 15, 2015, 06:51:56 AM
Understood.   My point is that it is incomplete.   

The obvious exceptions include mod settings.

It also misses many standard SMF settings.   You MUST audit all of your admin settings even after running repair_settings.php to properly relocate your site.

it will never include mod settings as we dont know what they are for all mods and it will bloat the script.

which standard SMF paths or URL's are missing?

shawnb61

I guess the delta is what is "CORE" and what is not.

I created a list of pages to double-check, but not individual settings.   I found settings on Attachments, Avatars, & Themes. 

The only one I recall by memory is the forum logo URL.

I'm out of town, returning Monday.   I can do a full list upon my return if you like.   I'll do it by relocating my vanilla install & doing an audit.   
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Illori

if you have to manually enter a URL, like the logo, repair_settings.php will never fix that URL as it is specific to where you want it and we can never assume that it is in the same location in all installs.

Kindred

repair_settings DOES correct avatars, attachments and themes -- to the detected standard....   if you have customized the locations of those to be outside of the standard design - obviously, repair_settings can't use ESP to know that...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

shawnb61

So we all agree that if you move your site, running repair_settings.php will NOT update everything you need updated to return your site to full functionality.   

You must also manually ckeck:
    All settings for your mods that include paths/URLs
    Any "manual" SMF entries such as forum logo

That is the point of my posts above.    After running repair_settings, you should not assume you're done, you must also carefully audit all other admin settings. 

When I'm back next week, I'll document some of the other settings I've had to set in the past.   All I have right now is my phone...
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

DilSe

thanks u so much for all. @Illori - @Kindred -   and  shawnb61 ok i  try to check my  if i get anything and i wait for you thanks every one again i really appreciate

shawnb61

#46
As promised, I double-checked to see which folders/URLs were not updated by repair_settings.php.  Basically, anything left blank on initial SMF install: 
   -  Upload folder/URL for Avatars
   -  Forum logo

These are all populated on my site, and when my site moved (when I built a test site), I had to audit admin settings by hand to set them properly.   Attachments were fine - not sure why I had a note to myself to double-check attachments.   

But this is a bit of a tangent & does not solve DilSe's problem.   My point was that he should manually audit ALL admin settings, because they're not all set by repair_settings.php.   

DilSe - have you checked ALL of your admin settings?   

Is your site still down?

EDIT:
Yes, I just checked, he's still down.   So bad, I doubt he can view his admin settings...

HOWEVER...
I just did a Google search on 'unknown column data in field list' and this looks to be a somewhat common MYSQL error. 
I would start checking that the DB restore is complete, and that the MYSQL instance is functioning properly. 
At least one of the posts indicates this is a user/pw/permissions error.   
Another post indicates their issue went away when they restarted MYSQL. 
Other posts indicate their code was using the wrong quotes around strings...

So...   DilSe...

If I were you, I'd head into pmpMyAdmin & poke around a bit...   
Make sure your credentials are OK - user, password, DB, host.   
Make sure basic things work OK with that database, that you can query tables properly. 
If everything looks OK, I'd ask the host to restart MYSQL.   
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

DilSe

thanks for reply shawnb61 . yes i check everything . but i don't understand why still problem.

shawnb61

I had edited my post...  Please read the last EDIT. 

I suspect either your credentials are wrong or your host's MYSQL instance has an issue.   You should open a support ticket with your host & have them confirm credentials & that MYSQL is healthy.

Google the error - you will see that this is a fairly common MYSQL issue.   I don't think it has anything to do with SMF directly.   
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

DilSe

yes sir . i open a support ticket before i make this topic he check but he said this is not a hosting problem. so then i make this topic with smf because always i get very best help form smf always smf experts give v.best help. and i am not a expert .. you know what my site is dead now because i make this topic """"January 17, 2015, 09:55:57 PM"""" almost 6 months ago right now i want back site because i want run from where i lose it. i really don't understand . but i really appreciate you and all for help.

margarett

At this point there isn't much to do if the issue is the same, and I think that this topic went in circles.

Please PM me your host's control panel login details and I'll try to check it for you.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

shawnb61

I'd consider running upgrade.php? 

Its a stretch, but I recently read a Wordpress issue with the same message that was resolved by running upgrade.php.

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

margarett

Hello

I finally could take a look at this. For some reason your smf_sessions table had a totally messed structure. I dropped and recreated it and now your forum does show (maintenance mode)

Check if everything is in place and let us know ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

shawnb61

Excellent support margarett!   You guys are good...
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shawnb61

A clarification to my post above on things that repair_settings.php may not find.

Today I had to rebuild my local test copy of my forum from scratch.  I restored files & DB from my host and ran repair_settings.php.   

Oddly, it did not find & help me out with my attachments folder.   

Earlier this week, I moved my site to a different location (see my July 23 post above) and ran repair_settings.php and it helped with the new attachments location.   Maybe it works for attachments when the host is the same but locations change??? 

So...  I stand by my initial statement above that even after running repair_settings.php you should manually check/fix your attachments folder location. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

DilSe

 :)woooooooo!!!. unbelievable for me. oh my God. it's working again. i have no words to said thanks . i already said smf is best this not a joke it's true really really best v. best smf and team. thanks you guys so much.i really appreciate  :)

Advertisement: