Unknown column 'com.time' in 'field list'

[Norv]

I'm sorry I don't understand the question.
This whole topic is about this error:

this happens when i click on profile

Unknown column 'com.time' in 'field list'
File: /home/fancya/public_html/Forum/Sources/Profile.php
Line: 1509

Perhaps you can remember when it appeared for you, was it also when clicking "Profile"?
Please try doing that again, and see if the error still appears.

[ShadoWind]

I've just clicked on both profiles that are currently available and they seem to work fine now... It was also when clicking 'Profile' and I receive the same error as the one in the opening post.

[Norv]

Good to hear it's sorted out then!

[ShadoWind]

That's good to know although I still don't know how it was fixed in the first place...

[Norv]

If the above succeeded, then, afterwards, run also:

Code Select Expand


ALTER TABLE smf_profile_comments ADD time INT NOT NULL AFTER date;


This fixed it: the ALTER TABLE statement added a column "time" in the table "smf_profile_comments". The column was missing (and this was the error about)
You said the result was showing you the same statement again, which is normal for phpMyAdmin, but you probably didn't notice that above the statement it must have said a line with "succesful" or something little.
Trust me, if it would have been an error, it would have been a lot of red text.
The complains are always more visible

[ShadoWind]

If the above succeeded, then, afterwards, run also:

Code Select Expand


ALTER TABLE smf_profile_comments ADD time INT NOT NULL AFTER date;


This fixed it: the ALTER TABLE statement added a column "time" in the table "smf_profile_comments". The column was missing (and this was the error about)
You said the result was showing you the same statement again, which is normal for phpMyAdmin, but you probably didn't notice that above the statement it must have said a line with "succesful" or something little.
Trust me, if it would have been an error, it would have been a lot of red text.
The complains are always more visible

I see... So if I have this sort of problem again, I just follow the instructions here?

In the meantime, I sincerely want to thank you for your assistance as I would have been pulling my hair out because of this problem...

[Norv]

Well, if you need to create this particular column again, sure. I think the column missing is due to some profile-related mod, that needs it but failed to create it, for some reason. If you install the mod on another forum and come to the same error, surely creating manually (or using the file database.php, it would have done the same thing) the missing column is the way to go.