vb.org Archive - Myself and my users are getting this error message when we click on

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Myself and my users are getting this error message when we click on (https://vborg.vbsupport.ru/showthread.php?t=139606)

Fungsten

02-16-2007 09:05 PM

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

"New Posts"

Quote:

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

02-17-2007 06:06 AM

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

Fungsten

02-17-2007 04:18 PM

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

Quote:

Originally Posted by Marco van Herwaarden (Post 1184413)

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:

Quote:

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

Quote:

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

02-17-2007 07:22 PM

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

Fungsten

02-17-2007 07:54 PM

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

Quote:

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 Blahbah.com
Referrer : http://www.Blah Blah . com
IP Address : ***.***.**.**
Username : ***********
Classname : vb_database

Quote:

Originally Posted by Marco van Herwaarden (Post 1184748)

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

02-18-2007 09:04 AM

Please run the folowing query:

[sql]ALTER TABLE administrator ADD COLUMN `dismissednews` text;[/sql]

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

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

Fungsten

02-18-2007 04:25 PM

I'll go try it.

Quote:

Originally Posted by Marco van Herwaarden (Post 1185163)

Please run the folowing query:

SQL Query: (how to run 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)
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

03-02-2007 10:15 PM

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

Thanks.

Quote:

Originally Posted by Marco van Herwaarden (Post 1185163)

Marco van Herwaarden

03-04-2007 12:22 PM

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

Fungsten

03-04-2007 03:43 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 1195433)

To fix the search problems run:

SQL Query: (how to run 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!!

All times are GMT. The time now is 09:16 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01164 seconds Memory Usage 1,742KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: