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.

[Syulx]

what if there are files for it in the include folder, not the xml folder

[SEOvB]

When you remove a modification, you should remove all the files associated with that modification.

Check

admincp
modules
includes
includes/xml

folders

[Syulx]

So delete all the modules?

[Lynne]

Delete any files in any of those directories that are related to this modification. If every file in the modules directory is from this modification, then I suppose you can just delete that whole directory.

[Syulx]

It says index.php , why should i delete my index. see i am confused. if i gave one of your the server, privatley, could you come help me?

[Lynne]

I'm not familiar with the modification at all, so I'm the wrong person to try to uninstall it. You should be asking for help in the modification thread for uninstalling it. They would know exactly what files to remove.

[Syulx]

I cant find any more files but i still cant get the error to go away. theres a new error now. http://vfkfans.com this is urgent, please some help.

[Digital Jedi]

Guys, you had him remove files associated with the product without having him uninstall the product first.

You should try re-installing vBadvanced starting from scratch, follow all the steps they told you to for a fresh install and make sure the product is enabled. If your still having problems after that then you should take the question to vBadvanced.com for official support of the portal, because that's where your error originated from.

[Syulx]

:erm:I already had it unistalled. but the error is still there. i dont want the portal, i just want the site up again! :( can anyone help me?

[Digital Jedi]

:erm:I already had it unistalled. but the error is still there. i dont want the portal, i just want the site up again! :( can anyone help me?
If you uninstalled correctly, and were using vBAdvanced as your home page, you'll need to put your old home page back into place.

[Syulx]

How do you do that. Can you please come into my server and do it for me. I beg you. Ill give you the info.

[Digital Jedi]

Did you not do the vBa installation yourself?

[InfernoVMK]

We re-booted our server, and everything is back on track.

Thanks for all your help.

[Syulx]

Did you not do the vBa installation yourself?

Yes i did, but my ftp server is run out of trial.

[Digital Jedi]

You mean your FTP client? Why not just use one of the many free FTP clients, like FileZilla or SmartFTP?

Oh well, glad you got it sorted out.