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

[DilSe]

Hello

please . i need help i get this error . please anyone help me about that how i can fix that . thanks

when i open my website i just get this error 

Unknown column 'data' in 'field list'

site link is. pakidilse.com/index.php

[kat]

I don't see the SMF copyright, on your forum.

No copyright in the name of SMF = No support.

[Arantor]

Um, K@... you can't *get* to the forum because there's a fundamental error.

So... last mod installed? Because there's no field I can think of called 'data' in any table that would be loaded by default on a normal installation of SMF.

[kat]

Hmm... You might be right.

I saw this and took it as a forum page:

http://sufianakalam.com/index%20Mohammad%20Tufail%20Niazi.html

Looking at the URL, though...

[Arantor]

I wasn't looking at that, I was looking at the URL he actually asked about which is a broken forum. And even when you hit the domain by itself, that's a landing page outside the forum because the forum itself falls over due to the originally reported issue.

Not seeing a problem here yet.

[DilSe]

thanks for reply k@ and Arantor   
and understand. but i never get like this problem . before so i don't no how i can fix that

[Arantor]

So what was the last thing you did before you started seeing it?

Install a new add-on maybe?

[DilSe]

no i don't install any mod. when night time is working but next morning when i try to open . i get this error

[Arantor]

See, things don't just change with computing, there's always a reason.

Something somewhere must have changed... do you have any other admins?

[DilSe]

yes other admin to let me ask them. but i don't think they do any think - i really confuse

[kat]

I see a link's been added to the first post,,,

Makes things a trifle different. I was looking at the link in your sig. http://www.sufianakalam.com

http://pakidilse.com works, though badly.

http://pakidilse.com/index.php is toast.

As Arantor said, things either work, or don't. If it's gone from working, to not working, something MUST have changed.

Silly question, then...

Do you have recent backup of the software, that you can restore?

[DilSe]

Hello

please . i need help i get this error . please anyone help me about that how i can fix that . thanks

when i open my website i just get this error 

Unknown column 'data' in 'field list'

site link is. pakidilse.com/index.php

Hello

i am sorry for i post in very old topic but still i have same problem . "Arantor" and Kat . thanks for help but still i have same problem can please help me how i can fix that thanks

[Kindred]

Did you try to restore a clean version?

If not, or if you can not, then I suggest that you load a clean set of files.

[DilSe]

thanks for reply - Kindred - i upload all new clean set of files. but still i have same issue . you can check    pakidilse.com/index.php

[Kindred]

if you uploaded a clean set of files, then this error would not still be occurring... so - either you did not actually upload a full, clean set -- or your system rejected the overwrite of the messed up files.

delete everything except Settings.php, Settings_bak.php, and the avatars and attachments directories.


THEN upload a clean set of files.

[DilSe]

ok sir

when i delete all old files and upload new files after upload . this error

""Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.""


and when i fix database user password and refresh page have again same error.

[Kindred]

you didn't keep the files that I told you to keep, did you?

[DilSe]

yes sir what you said keep files'  Settings.php, Settings_bak.php, and the avatars and attachments directories.

and all other del. and upload new files

[Kindred]

well, that error only occurs if there is actually a problem connecting to the database.
Are you sure that the database connection information is fully correct?


Did you recently change hosts, by any chance?

When I view your site, I still get the "unknown data column"
So...   since you have replaced all of the files, that suggests that the database has been corrupted, somehow...

Do you have a backup of your database from before this issue started?

[DilSe]

yes i change host but after i move database on new hosting site working good. after few weeks i get this error

and yes i have backup database

[Kindred]

Ah ha!!!!!!!!    You changed hosts...   Did you fully reconfigure smf to use the new host?


Based on your symptoms, I am actually betting that something is still pointing toward your old server..

[DilSe]

so no any solution for that right..?
i try install a new smf and then i change files and upload database. but when i upload database again i get same error . i don't understand

[Kindred]

I answered you...   and asked a question -- which you have not answered.

Ah ha!!!!!!!!    You changed hosts...   Did you fully reconfigure smf to use the new host?


Based on your symptoms, I am actually betting that something is still pointing toward your old server..

[Herman's Mixen]

What is repair_settings.php?

Read this and you will manage to get it working ..

[DilSe]

Ah ha!!!!!!!!    You changed hosts...   Did you fully reconfigure smf to use the new host?


Based on your symptoms, I am actually betting that something is still pointing toward your old server..

oh! i am v.sorry i never seen your post. when i change host site is working good for i think couple months or at least 2 month. i am sure about that after 2 month i get this problem so what i can do now sir


and - Herman's Mixen i already use that repair_settings.php? thanks

[Kindred]

you restored the database from an old backup though...       and your symptoms (making changes on your current site don't seem to take effect) suggest that something is pointing to other places, other than the correct, current locations

[Herman's Mixen]

Herman's Mixen i already use that repair_settings.php? thanks

Acctually, using .... and changing stuff with it is something different...

[DilSe]

so Kindred how i can fix now that i don't no from where i can start to fix this. and i really appreciate you already reply for me many time

[Kindred]

you need to USE and SAVE repair_settings.php (possibly running it twice, the first time to correct the database, the second to correct the paths)

[DilSe]

i am sorry sir for late reply

kindred..          repair_settings.php  i try many time repair setting php show me everything good. but when i try to open my site again same error.

[ziycon]

i am sorry sir for late reply

kindred..          repair_settings.php  i try many time repair setting php show me everything good. but when i try to open my site again same error.

If you want to PM me the link to repair_settings.php file that you placed on your server I can have a look.

[DilSe]

i am sorry sir for late reply

kindred..          repair_settings.php  i try many time repair setting php show me everything good. but when i try to open my site again same error.

If you want to PM me the link to repair_settings.php file that you placed on your server I can have a look.

ok

[DilSe]

any solution..? please

[Kindred]

...your symptoms (making changes on your current site don't seem to take effect) suggest that something is pointing to other places, other than the correct, current locations

[shawnb61]

For me, repair_settings.php does not change ALL references to paths and URLs.   I have found that I needed to hunt around all admin settings looking for "old looking" directories and URLs and updating them.   Repair_settings rapidly gets you so you CAN do the rest by hand.   

You may need to manually crawl thru all your admin menus and submenus looking for paths/URLs to fully restore your site.

[DilSe]

...your symptoms (making changes on your current site don't seem to take effect) suggest that something is pointing to other places, other than the correct, current locations

yes sir you are right .... that's why i ask this question how i can fix that sir ....





and shawanb61 . i did many think but i can't fix . that's why i create this topic.. i need help from experts seniors

[Illori]

For me, repair_settings.php does not change ALL references to paths and URLs.   I have found that I needed to hunt around all admin settings looking for "old looking" directories and URLs and updating them.   Repair_settings rapidly gets you so you CAN do the rest by hand.   

You may need to manually crawl thru all your admin menus and submenus looking for paths/URLs to fully restore your site.

repair_settings.php does not fix the URL's for you, you have to click on the new url to replace the old and then save the page/script and it will repair the URL's for you.

[ziycon]

For me, repair_settings.php does not change ALL references to paths and URLs.   I have found that I needed to hunt around all admin settings looking for "old looking" directories and URLs and updating them.   Repair_settings rapidly gets you so you CAN do the rest by hand.   

You may need to manually crawl thru all your admin menus and submenus looking for paths/URLs to fully restore your site.

repair_settings.php does not fix the URL's for you, you have to click on the new url to replace the old and then save the page/script and it will repair the URL's for you.

URLs are all on and correct.

[shawnb61]

repair_settings.php does not fix the URL's for you, you have to click on the new url to replace the old and then save the page/script and it will repair the URL's for you.

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.

[Kindred]

shawn,

actually, you are incorrect. repair_settings.php WILL update all of the CORE settings for SMF/default installation.

[Illori]

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.   

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

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

[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]

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.   

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

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

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

[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

[shawnb61]

Excellent support margarett!   You guys are good...

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

[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