Mysql errors after 3.8.1 upgrade

[Chadi]

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:

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 :

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]

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]

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

    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]

Any help anyone ?

[fattony69]

Did you use social groups mod for 3.7?

[Chadi]

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.

    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]

Originally Posted by chadi

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?

Originally Posted by trickfly

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]

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]

Originally Posted by chadi

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

Yep.

Originally Posted by chadi

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]

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.