vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Error - regimage (https://vborg.vbsupport.ru/showthread.php?t=255900)

SVTCobraLTD 12-26-2010 12:48 AM

Database Error - regimage
 
Anyone know how to resolve this?

Quote:

Database error in vBulletin 3.8.6:

Invalid SQL:

DELETE FROM regimage
WHERE dateline < 1293326765;

MySQL Error : Table 'database_name.regimage' doesn't exist
Error Number : 1146
Date : Saturday, December 25th 2010 @ 08:26:05 PM
Script : http://www.xxxxxxxxxx.com/forums/cro...and=1293330364
Referrer : http://www.xxxxxx.com/forums/
IP Address :
Username : Unregistered
Classname : vB_Database
The issue may be that I am running vb 3.6.11 even though it says 3.8.6. I think I did the update on the wrong database and that might be part of the issue. Not sure how to revert with without loosing new posts.

BirdOPrey5 12-26-2010 02:34 PM

"regimage" isn't a table in vb 3.8.6, I'm not sure if it was ever part of "3.6" either- it might be a broke mod... do you know which cron job is causing the error?

SVTCobraLTD 12-27-2010 08:24 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2139235)
do you know which cron job is causing the error?

How can I check this?

BirdOPrey5 12-27-2010 08:28 PM

In Admin CP -> Statistics & Logs -> Scheduled Task Log... See what was running at the time specified in the error.

SVTCobraLTD 12-27-2010 08:37 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2139779)
In Admin CP -> Statistics & Logs -> Scheduled Task Log... See what was running at the time specified in the error.

Error happened at 3:20pm and 4:20pm but the log only shows this below:

Quote:

127753 Process Mail Queue 17:30, 27th Dec 2010 Processed Mail Queue
127752 Process Mail Queue 17:22, 27th Dec 2010 Processed Mail Queue
127751 Process Mail Queue 17:13, 27th Dec 2010 Processed Mail Queue
127750 Process Mail Queue 17:00, 27th Dec 2010 Processed Mail Queue
127749 Process Mail Queue 16:54, 27th Dec 2010 Processed Mail Queue
127748 Process Mail Queue 16:47, 27th Dec 2010 Processed Mail Queue
127747 Process Mail Queue 16:35, 27th Dec 2010 Processed Mail Queue
127746 Process Mail Queue 16:21, 27th Dec 2010 Processed Mail Queue
127745 Process Mail Queue 16:15, 27th Dec 2010 Processed Mail Queue
127744 Process Mail Queue 16:02, 27th Dec 2010 Processed Mail Queue
127743 Process Mail Queue 15:51, 27th Dec 2010 Processed Mail Queue
127742 Process Mail Queue 15:47, 27th Dec 2010 Processed Mail Queue
127741 Process Mail Queue 15:32, 27th Dec 2010 Processed Mail Queue
127740 Process Mail Queue 15:22, 27th Dec 2010 Processed Mail Queue
127739 Process Mail Queue 15:13, 27th Dec 2010 Processed Mail Queue
There is no 15:20 or 16:20 to match those times. And if this was the error, I should be getting lots of errors sent to me, not just 1 an hour.

BirdOPrey5 12-27-2010 08:54 PM

Hmmm... the only scheduled task that runs on the 20 after of every hour by default is called Hourly Cleanup #2. which is the file ./includes/cron/cleanup2.php.

Whatever is causing your error is in that file... The fact this is a default vbulletin scheduled task strongly suggests the problem is related to your failed upgrade.

Further investigation I confirm the table "repimage" was removed from vBulletin starting in 3.7.0 so you have code from 3.6 and code from 3.8 conflicting.
Some details here. (In the quote.)

Basically you're going to probably need to do a complete/full upgrade to fix this.

If you wanted to simply get rid of the error without fixing the problem go to your phpmyadmin and try creating a new table called PREFIX_repimage where PREFIX is your table prefix you set on config.php. This *may* work but isn't a good long term solution.

preemz10314 12-27-2010 10:30 PM

probably a plug in you recently installed. go down the line and disable/uninstall all new plugins you may have installed.

ccp77 12-28-2010 08:52 PM

yup this is a MOD issue try disabling a mod that yu recently installed remmeber if its a mod that yu installed through FTP remove it from there,...

Digital Jedi 12-29-2010 08:16 AM

Quote:

Originally Posted by preemz10314 (Post 2139849)
probably a plug in you recently installed. go down the line and disable/uninstall all new plugins you may have installed.

Quote:

Originally Posted by ccp77 (Post 2140341)
yup this is a MOD issue try disabling a mod that yu recently installed remmeber if its a mod that yu installed through FTP remove it from there,...

Guys, try reading BirdOPrey's post before jumping in definitively.

BirdOPrey5 12-29-2010 12:55 PM

They might be right... It's possible a mod installed a scheduled task to run every hour at 20 after, the same as HourlyCleanup 2... I hope the OP figures it out either way and returns to post whatever worked.

SVTCobraLTD 12-29-2010 02:06 PM

I am thinking while trying to install a copy of 3.6 in another MySQL database the current sites database may have been affected somehow causing this issue. Since under Products it says vb 3.8.6. However AdminCP says 3.6.11 and the error says 3.8.6. So I believe the database got messed up while attempting to setup my temporary 3.8 board for testing.

Digital Jedi 12-29-2010 02:11 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2140696)
They might be right... It's possible a mod installed a scheduled task to run every hour at 20 after, the same as HourlyCleanup 2... I hope the OP figures it out either way and returns to post whatever worked.

True. But ultimately it seems to stem from his failed upgrade. Correct me if I'm wrong, but wouldn't even some of the default scheduled tasks still trigger the error?

SVTCobraLTD 12-29-2010 06:01 PM

Quote:

Originally Posted by Digital Jedi (Post 2140735)
True. But ultimately it seems to stem from his failed upgrade.

It is, since I am getting this when opening AdminCP...

Quote:

Database error in vBulletin 3.8.6:

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
Date : Wednesday, December 29th 2010 @ 01:59:29 PM
Script : http://www.xxxxxxxxxx.com/forums/adm...ex.php?do=home
Referrer : http://www.xxxxxx.com/forums/admincp/
IP Address :
Username :
Classname : vB_Database


All times are GMT. The time now is 10:29 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.01039 seconds
  • Memory Usage 1,748KB
  • 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
  • (13)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