Urgent Problem - Index.php

[InfernoVMK]

Hello again!

I have some issues with the homepage (index.php) [http://mysite.com/index.php]
Btw: we do not have http://mysite.com/forums/ before it.

We can't get to the homepage of the forum (Database error comes up) but we can still view everything else (Thread, arcade, etc)

Maybe it got deleted somewhere? Where would I add this file again, and which file is it?

Thanks!

[Marco van Herwaarden]

What is the database error?
A link so we can see what you mean?

[Syulx]

<a href="http://vfkfans.com" target="_blank">http://vfkfans.com</a> thats the error. I work with him.

[Lynne]

If you view the page source, you will see the database error:

Database error in vBulletin 3.7.4:

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_adv_portal AS phrasegroup_adv_portal,
			phrasegroup_calendar AS phrasegroup_calendar,
			phrasegroup_postbit AS phrasegroup_postbit,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM language
					WHERE languageid = 1;

MySQL Error   : Unknown column 'phrasegroup_adv_portal' in 'field list'
Error Number  : 1054

This error is caused by a modification - some advanced portal mod you have? Disable the modification to get rid of the error and then post in the modification thread/forum to get help with the error.

[Syulx]

I did disable it but its still there. What should I do

[Lynne]

Remove any xml files you added for it in includes/xml

[Syulx]

I did. Could you come help me in my admin cp? We really need help.

[Lynne]

I don't think it is in your admin cp, it's in your files. Find the modification and look at the modification installation instructions. Does it ask you to upload any files? Go and remove them all.

[Syulx]

but do you mean on my server,ftp? if you do, let me know, because inferno does. so juste explain to him what you mean and he will see it later.

[Lynne]

Yes, I am talking about on your server. Post 6 was regarding files in your includes/xml directory. You need to remove any files in that directory that were put there for this modification.