vb.org Archive - Mysql errors after 3.8.1 upgrade

Page 1 of 2

Show 40 post(s) from this thread on one page

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

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

- - Mysql errors after 3.8.1 upgrade (https://vborg.vbsupport.ru/showthread.php?t=203623)

Chadi

01-30-2009 04:39 PM

Mysql errors after 3.8.1 upgrade

Upgraded last night to 3.8.1 and now suddenly I'm getting emailed Mysql errors and have no idea what's causing it. I even uninstalled a few plugins last night after the upgrade too.

One:

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:



                 SELECT count(*)as cnt,max(dateline) as lastupdate

                 FROM groupmessage

                 WHERE groupid='1';



MySQL Error   : Unknown column 'groupid' in 'where clause'

Error Number  : 1054

Request Date  : Friday, January 30th 2009 @ 12:00:47 PM

Error Date    : Friday, January 30th 2009 @ 12:00:49 PM

Script        : http://www.talkjesus.com/cron.php?rand=1233338446

Referrer      : http://www.talkjesus.com/polls/25291-abortion-ever-ok.html

IP Address    : xxxxx

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:



                 SELECT count(*)as cnt,max(dateline) as lastupdate

                 FROM groupmessage

                 WHERE groupid='1';



MySQL Error   : Unknown column 'groupid' in 'where clause'

Error Number  : 1054

Request Date  : Friday, January 30th 2009 @ 11:00:37 AM

Error Date    : Friday, January 30th 2009 @ 11:00:39 AM

Script        : http://www.talkjesus.com/cron.php?rand=1233334836

Referrer      : http://www.talkjesus.com/search.php?searchid=185672

IP Address    : xxxxx

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

Appreciate any help on this.

trickfly

01-30-2009 05:45 PM

I get this error but I'm running 3.8 and have been for a week now and suddenly I've been getting this error:

-------------------------------------------------

Database error in vBulletin 3.8.0: Invalid SQL: SELECT * FROM rsslogWHERE uniquehash IN ('ed54e836c91813857dac7d2a3d4df3c4', '54b4ddf5510431de3f9222081578eb67', '3b08ba4f115eaa0f2572420f50720bf7', 'cac332a13a2584ec723e16ed7664f4fb', '78d1b613ec2297f7bdc84e2f76ea1b2c', 'cec1d40fd4659dba35b06a05f33a4d7b', '2d321b561e898ef860d3d5eb088b140b', 'f189bd37789de25dddbdf3963f53cedd', 'e5975fab882967c45c2bd9c47d3c2b03', '78d39bc2fc7fad05decaa7a6303f5217'); MySQL Error : MySQL server has gone awayError Number : 2006Request Date : Friday, January 30th 2009 @ 02:41:30 PMError Date : Friday, January 30th 2009 @ 02:42:29 PMScript : http://www.symbiangalaxy.org/cron.ph...344479Referrer : http://www.symbiangalaxy.org/IP Address : 218.186.8.245Username : UnregisteredClassname : vB_DatabaseMySQL Version :

-------------------------------------------------

Can anyone help too ?

Chadi

01-30-2009 06:08 PM

I'm getting more, different ones likely from the same cause or, bug.

Code:

    Database error in vBulletin 3.8.1:

   

  Invalid SQL:

   

                    SELECT count(*)as cnt,max(dateline) as lastupdate

                    FROM groupmessage

                    WHERE groupid='1';

   

  MySQL Error   : Unknown column 'groupid' in 'where clause'

  Error Number  : 1054

  Request Date  : Friday, January 30th 2009 @ 02:00:22 PM

  Error Date    : Friday, January 30th 2009 @ 02:00:25 PM

  Script        : http://www.talkjesus.com/cron.php?rand=1233345616

  Referrer      : http://www.talkjesus.com/

  IP Address    : xxxxx

  Username      : Unregistered

  Classname     : vB_Database

  MySQL Version :

trickfly

01-30-2009 10:31 PM

Any help anyone ?

fattony69

01-31-2009 12:45 AM

Did you use social groups mod for 3.7?

Chadi

01-31-2009 12:59 AM

The only social group related mods I have installed are the ones I've been using w/o issues in 3.7

https://vborg.vbsupport.ru/showthread.php?t=165726
https://vborg.vbsupport.ru/showthread.php?t=179413

--------------- Added [DATE]1233373335[/DATE] at [TIME]1233373335[/TIME] ---------------

I noticed mine happens every one hour on the dot. I cannot trace the cron in scheduled task to anything that has rand=### in the cron path.

Code:

    Database error in vBulletin 3.8.1:

   

  Invalid SQL:

   

                    SELECT count(*)as cnt,max(dateline) as lastupdate

                    FROM groupmessage

                    WHERE groupid='1';

   

  MySQL Error   : Unknown column 'groupid' in 'where clause'

  Error Number  : 1054

  Request Date  : Friday, January 30th 2009 @ 09:01:42 PM

  Error Date    : Friday, January 30th 2009 @ 09:01:44 PM

  Script        : http://www.talkjesus.com/cron.php?rand=1233370898

  Referrer      : http://www.talkjesus.com/

  IP Address    : xxxxx

  Username      : Unregistered

  Classname     : vB_Database

  MySQL Version :

Dismounted

01-31-2009 02:42 AM

Quote:

Originally Posted by chadi (Post 1729586)

I noticed mine happens every one hour on the dot.

The query is definitely from a Scheduled Task, and it looks like it is from a modification. Why? Because the query is not written according to the vBulletin Coding Standards.

However, if your "groupmessage" table does not have a "groupid" column, you probably have more issues than this. Can you use group messages properly?

Quote:

Originally Posted by trickfly (Post 1729300)

Can anyone help too ?

Your error is completely unrelated, in future, please start your own thread as it becomes hard to follow if there are two things going on in one thread.

See the manual for solutions to your error.

Chadi

01-31-2009 03:06 AM

1 Attachment(s)

Got the error again just a minute ago.

What group messages are you referring to exactly? Social groups?

I don't see any tasks relating to social groups.

Here is a screen shot of all tasks. Also, I manually ran each task and never got the error, so it shows that it cannot come from them.

Dismounted

01-31-2009 03:08 AM

Quote:

Originally Posted by chadi (Post 1729670)

What group messages are you referring to exactly? Social groups?

Yep.

Quote:

Originally Posted by chadi (Post 1729670)

Here is a screen shot of all tasks. Also, I manually ran each task and never got the error, so it shows that it cannot come from them.

The script definitely shows something about cron.php. Most likely, a plugin by a modification was placed into a hook inside cron.php.

Chadi

01-31-2009 03:31 AM

Sorry but can you please explain exactly what you mean that the mod was placed 'inside' cron.php? I know cron.php is a vb default file. It is also not modified as well just to clarify.

All times are GMT. The time now is 03:52 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01035 seconds Memory Usage 1,749KB 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 (4)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: