Closed

Fix my Vbulletin Forum

Hi.

I have a problem with the database on my vbulletin forum and am getting no support whatsoever from vbulletin.

I have a backup of the database which is over a week old and I don't want to restore from backup because I have had quite a few new members and a lot of posts to the forum since the backup. I want someone to go in and fix it.

My site is [url removed, login to view] and the error is on the "home" tab.

Here is the database error that I get on the home page...

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT [url removed, login to view] , ([url removed, login to view] = 1) AS isroot, [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view],

(CASE WHEN [url removed, login to view] = 17 THEN [url removed, login to view] ELSE [url removed, login to view] end ) AS styleid, [url removed, login to view],

(CASE WHEN [url removed, login to view] = 17 THEN [url removed, login to view] ELSE [url removed, login to view] end ) AS layoutid,

[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view],

[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view],

[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view],

[url removed, login to view] as parentpermissions, [url removed, login to view], node.comments_enabled, [url removed, login to view],

[url removed, login to view], [url removed, login to view]

FROM cms_node AS node

LEFT JOIN cms_node AS parent ON [url removed, login to view] = [url removed, login to view]

WHERE [url removed, login to view] = 1;

MySQL Error : Unknown column '[url removed, login to view]' in 'field list'

Error Number : 1054

Request Date : Friday, January 15th 2010 @ 08:45:43 AM

Error Date : Friday, January 15th 2010 @ 08:45:43 AM

Script : [url removed, login to view]

Referrer : [url removed, login to view]

IP Address : [url removed, login to view]

Username : VinceG

Classname : vB_Database

MySQL Version : 5.0.87-community

Skills: PHP, vBulletin

See more: vbulletin forum script, sql get date, getting members, get fix, fix support, fix home, fix home page, node mysql, vbulletin, php support forum, fix database, vbulletin php mysql, url fix, backup sql mysql, sql backup mysql, unknown database, mysql restore backup, 1054 unknown column select, 1054 php, page tab url php, php hidden referrer, error database problem, database fix, 1054 unknown, home page fix

About the Employer:
( 12 reviews ) Leeds, United Kingdom

Project ID: #590520

11 freelancers are bidding on average $43 for this job

SigmaVisual

We can help in your project, please check PMB to see our related experience.

$100 USD in 2 days
(250 Reviews)
7.9
tomydeveloper

Hello,i noticed your error .we fix it with in few hours.Please check pmb.Thanks

$30 USD in 0 days
(247 Reviews)
7.6
TakeReal

I can fix "Unknown column 'node.shownav' in 'field list'" error. I need FTP access to start right now.

$30 USD in 1 day
(1255 Reviews)
7.5
grazianno

hello, please check your PMB.

$30 USD in 0 days
(185 Reviews)
7.0
wincent

easy fix. i know the problem.

$30 USD in 0 days
(79 Reviews)
6.0
saulwilliams

This is a very simple problem and takes less than 1 hour of time to fix it. Please see PM.

$30 USD in 0 days
(23 Reviews)
5.0
sureshmca06

Hi., I am ready to fix this issue., i can fix it in FEW SECONDS., Please check my PM., Thanks,

$30 USD in 0 days
(12 Reviews)
4.8
peruvianmaster

hello this is a very easy job and can be fixed in 5 minutes. pmb for details please

$30 USD in 0 days
(29 Reviews)
4.5
JesseLin

I can fix it.

$30 USD in 1 day
(13 Reviews)
4.0
sailu135cw

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$30 USD in 2 days
(0 Reviews)
0.0
sailu138cw

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

$30 USD in 2 days
(0 Reviews)
0.0
jossdeveloper

Hi, we can do your job as per your specifications... Ravi Bhushan, hncinfotech

$100 USD in 2 days
(0 Reviews)
0.0