vBulletin Modifications

Database Error in search, New Post and Quick Links

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 01-10-2007, 08:12 AM   #1
vB Newbie
Join Date: Jan 2007
cool999 is on a distinguished road

Thumbs up Database Error in search, New Post and Quick Links

I get database error everytime when someone search, Click on New Post, Quick links.
This is the error-
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'fda6ebd683b75aabcd5157ba69dd5ace' AND orderedids = '97,109,108,107,106,105,104,103,102,101,100,99,98, 96,95,94' AND announceids = '' AND completed = 1;
MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

Please tell me how to solve it, i need to solve this urgently.
Thanksss




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 01-10-2007, 03:19 PM   #2
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

MySQL Error : Unknown column 'completed'

add that column
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-11-2007, 08:30 AM   #3
vB Newbie
Join Date: Jan 2007
cool999 is on a distinguished road

Thumbs up

but how to add column. I have never done this before.
Please reply




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-11-2007, 01:54 PM   #4
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

go into phpmyadmin, then go into table search, then add completed with values of smallint(5), unsigned, not null, default 1
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 04:58 PM   #5
Got Beer ?
Join Date: Jan 2007
Location: Australia
ducksguts is on a distinguished road

Default

I have pretty much the same problem but as cool999 said, you lost me after "go into phpmyadmin, then go into table search" :p

can you give it to us in "an idiots guide to.." format please




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 07:49 PM   #6
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

do u even have phpmyadmin
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 08:54 PM   #7
Got Beer ?
Join Date: Jan 2007
Location: Australia
ducksguts is on a distinguished road

Default

Quote:
Originally Posted by whitemike View Post
do u even have phpmyadmin
I was hoping for something slightly more constructive than that......
....I didn't think it was possible to run vbulletin without php...




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 09:10 PM   #8
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

its not but its possiable to run it without phpmyadmin
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 09:15 PM   #9
Got Beer ?
Join Date: Jan 2007
Location: Australia
ducksguts is on a distinguished road

Default

well thanks for all your instructive assistance with that one, i'll move on.....................




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-17-2007, 09:22 PM   #10
Michael Biddle
Staff
Michael Biddle's Avatar
Join Date: Feb 2005
Real Name: Michael Biddle
Location: Anaheim
Michael Biddle is on a distinguished road

Default

1) goto phpmyadmin
2) click ur database
3) click table search
4) add new field with valuse i said above
__________________
Support will ONLY be offered through forums
Michael Biddle / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -3. The time now is 10:53 PM.


SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)