[Marco van Herwaarden]

Originally Posted by criscokid

I've just upgraded a site to vB3.6.8 and when someone tries to update their profile photo the following error message is generated:

Database error in vBulletin 3.6.8:

Invalid SQL:
REPLACE INTO datastore
VALUES
( 'mh_upcd'
, 'a:50:{i:0;a:4:{s:6:\"userid\";s:1:\"1\";s:8:\"use rname\";s:4:\"Bart\";s:23:\"mh_upcd_lastprofilelis t\";i:1188841274;s:13:\"dateformatted\";s:21:\"M on 03 Sep 2007 18:41\";}i:1;a:4:{s:6:\"userid\";s:5:\"11446\";s:8 :\"username\";s:7:\"Opensky\";s:23:\"mh_upcd_lastp rofilelist\";s:10:\"1188672172\";s:13:\"dateformat ted\";s:21:\"Sat 01 Sep 2007 19:42\";}i:2;a:4:{s:6:\"userid\";s:5:\"11445\";s:8 :\"username\";s:15:\"seasonedclubber\";s:23:\"mh_u pcd_lastprofilelist\";s:10:\"1188659831\";s:13:\"d ateformatted\";s:21:\"Sat 01 Sep 2007 16:17\"; (rest of data snipped) }}'
 

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, September 3rd 2007 @ 06:41:15 PM
Script : http://xxx.com/forums/profile.php?do=updateprofilepic
Referrer : http://xxx.com/forums/profile.php?do=editprofilepic
Classname : vb_database

Does anyone know a fix for this?

See https://vborg.vbsupport.ru/showpost....5&postcount=61