Update 4.2 Advertising Error

[ericfahey]

Ask your host for ftp logs....

[ericfahey]

Hello,

I'm trying to set up ads on my forums, however every time I click 'Advertising' in the AdminCP and then click either 'manage ads' or 'add new ad' The page loads blank.

...

[ericfahey]

Hello,

Just wanted to know if it would be possible to change the URL of a forums.

In other words, I want to change my forums domain, but don't want to install a fresh copy of...

[ericfahey]

Once I add that code and uploaded a fresh copy of Vbulletin, I am given the following error:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT t1.templateid,...

[ericfahey]

I uninstalled all my plugins/addons but I'm still given the error....

[ericfahey]

When I attempt to use the style manager or the style and language settings I'm given a database error:

Database error in vBulletin 4.1.12:

Invalid SQL:

SELECT...

[ericfahey]

I currently am using a theme that i purchased from a website which i won't mention for advertising.

Anyways, I believe my main theme is corrupted somehow and I can't remove it via the AdminCP,...

[ericfahey]

Thanks for the help i'll try this and see what happens

Thanks again ...

[ericfahey]

Tried that and used the code that Lynne provided and still not working :S...

[ericfahey]

It's not just for mods, if i try to add a new forum/category i still get the error:

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT t1.templateid...

[ericfahey]

So any advice as to fixing this error? Would it be advised to backup my database and reinstall vbulletin?...

[ericfahey]

Even after trying that I am still given the SQL error....

[ericfahey]

I've been given the following SQL Error and I would like to know how to fix it, Could anybody help me with this issue?

Database error in vBulletin 4.1.11:

Invalid SQL:
...