Myself and my users are getting this error message when we click on

[Fungsten]

"New Posts"

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'db6252fd45a322bad2f0de043dd67e12' AND orderedids = '10826,10865,10855,10805,10894,10893,10885,6948,10 615,10886,10897,10733,10909,10326,10908,10907,1090 6,10130,10456,10902,10096,10267,10899,10904,10881, 10903,10861,10901,10900,10898,10895,10829,10851,10 799,10873,10892,10887,10094,9569,10890,10888,10772 ,9299,10825,10884,10869,10868,10882,10847,10880,10 849,10539,10834,10780,10879' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Friday, February 16th 2007 @ 02:58:46 PM
Script : http://www.********/forum/search.php?do=getnew
Referrer : http://www.********.com/forum/index.php
IP Address : XXX.XXX.XXX.XXX
Username : **********
Classname : vb_database

What I did yesterday was to re-import the database - for this board - from another site I have. I have VB 3.6.4. Thank you.

[Marco van Herwaarden]

The database you imported was not a vB 3.6.4 database, please run upgrade.php.

[Fungsten]

Though it was a 3.6.4 I'll run the update.

The database you imported was not a vB 3.6.4 database, please run upgrade.php.

On Edit:

Marco I ran the upgrade_364.php and the upgrade_363.php scripts but it came up with this:

Your vBulletin version does not appear to match with the version for which this script was created (version 3.6.3).

Please ensure that you are attempting to run the correct script.

If you are sure this is the script you would like to run, click here.

These's also this


XML File Versions:

vbulletin-style.xml
vbulletin-settings.xml
vbulletin-language.xml
vbulletin-adminhelp.xml

3.6.4
3.6.4
3.6.4
3.6.4

[Marco van Herwaarden]

You never need to run the upgrade_XXX.php manually. Only start upgrade.php, it will automatically perform the steps that are needed.

[Fungsten]

comes up. Also, when I dismiss the "News" in the ACP I get this error:


Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE administrator SET
dismissednews = '11'
WHERE userid = 1;
MySQL Error : Unknown column 'dismissednews' in 'field list'
Error Number : 1054
Date : Saturday, February 17th 2007 @ 01:49:33 PM
Script : http://www.Blah (http://www.blah/) Blahbah.com
Referrer : http://www.Blah Blah . com
IP Address : ***.***.**.**
Username : ***********
Classname : vb_database


You never need to run the upgrade_XXX.php manually. Only start upgrade.php, it will automatically perform the steps that are needed.

[Marco van Herwaarden]

Please run the folowing query:

ALTER TABLE administrator ADD COLUMN `dismissednews` text;

If you get a new error abot a missing languageid column after that, also run:


ALTER TABLE administrator ADD COLUMN `languageid` smallint(5) unsigned NOT NULL default '0';

[Fungsten]

I'll go try it.

Please run the folowing query:


SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE administrator ADD COLUMN `dismissednews` text;


If you get a new error abot a missing languageid column after that, also run:



SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE administrator ADD COLUMN `languageid` smallint(5) unsigned NOT NULL default '0';


On Edit:

Tt did work for "Dismiss News" in the ACP. Thanks!! But the "New Posts" is still a problem.

[Fungsten]

problem. BTW, I have upgraded to 3.6.5 and it still han't been fixed.

Thanks.

Please run the folowing query:


SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE administrator ADD COLUMN `dismissednews` text;


If you get a new error abot a missing languageid column after that, also run:



SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE administrator ADD COLUMN `languageid` smallint(5) unsigned NOT NULL default '0';

[Marco van Herwaarden]

To fix the search problems run:
ALTER TABLE search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';

[Fungsten]

To fix the search problems run:

SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE search ADD COLUMN `completed` smallint(5) unsigned NOT NULL default '1';


I'll try it. It worked!! Thank you Marco!!

Members avatars were not showing back up; some of the members had to re-add them. Is there a query to get them back? Thank you!!