vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Error 1054 in admin panel (https://vborg.vbsupport.ru/showthread.php?t=197147)

putergirl 11-24-2008 08:10 PM

Error 1054 in admin panel
 
Hello, a while back I tried to update my forum from 3.7.0 to something more updated and it didn't go well. I had errors all over the board and after days of trying to fix things by hand I reverted to an earlier date. Since then I have this error when I log into the admin cp and I don't know how to fix it. Thanks in advance from someone who doesn't know how to program. :)

Quote:

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054

UKBusinessLive 11-25-2008 08:09 PM

When you uploaded, did you rename the admincp dir again??

Because it uploads to admincp you need to delete the old directory, and rename admincp to that name again

Then it should be ok ;)

Lynne 11-25-2008 08:15 PM

When you reverted back to the older version, did you make sure all the files were reuploaded from that same version - vb 3.7.0 beta 4?

putergirl 11-26-2008 04:41 PM

Lynne, no I didn't do that. I get so nervous about what I can and can't do that usually I don't do anything and I certainly didn't know that I should do that. So you mean to ftp the same files as the ones that I did when I upgraded to vb 3.7.0 beta? And if I do that, do I need to run the install script again? Or the config? Or just re-upload the files and that's good?

UKBusinessLive, I didn't really understand what you meant, sorry.

Lynne 11-26-2008 05:14 PM

If you are using a database that is for 3.7.0, then you need to use the vb files for 3.7.0. If you use a database for 3.7.0 and the files for 3.7.3 and don't run the upgrade script (the upgrade script updates the database), then you will get database errors. So, you need to use the same version files as for the database.

putergirl 11-26-2008 05:39 PM

Ok, I think I get what you are saying. So even if I revert the forum back, the files I had uploaded are still there and that's what the problem is. So I need to re-up the old files.
Correct?

Lynne 11-26-2008 05:46 PM

Yes, that is correct.

putergirl 11-28-2008 01:32 AM

Ok I did as you advised and it fixed the admin control panel (YAY!), but now I have some new issues. The shoutbox ( vBShout By Zero Tolerance) quit working.. it kept saying "loading" but when I tried to shout anyway it went to a blank page.

I then tried "CybChatbox" which did the same thing as the above chatbox.
Then I tried "Dion Dev vBulletin 3.x Shoutbox 1.0" which did work but I don't like it and neither do my members.

Is there a way to make it so that we can use the either of the first two chatboxes listed?

Also, when I click on "quick links" it changes the link to "open buddy list".

Help? :confused:


EDIT: I am having even more problems now, smilies don't work, and one of my members says he can't post now... I'm going to revert back to the first set of problems. :(

Lynne 11-28-2008 08:15 PM

There are three things on your site that all need to be running the same 'version' or you will have issues - your files, your database, and your styles/templates. It sounds to me like you have mismatched versions of these three things on your site.


All times are GMT. The time now is 02:44 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00993 seconds
  • Memory Usage 1,726KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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