social login bug data too long errror

alt=
@perfectgamestudios
10 years ago
106 posts
Hello I not sure whats happened recently with the oneall but now when I use the social login feature I get errors like Query Error: Data too long for column 'data' at row 1 - check debug log
I had to go into the database for the oneall and change the field for data to text as was set to varchar so seems to work now

Stephen
updated by @perfectgamestudios: 08/18/15 12:48:11PM
michael
@michael
10 years ago
7,822 posts
varchar(8192) is pretty big. It needed bigger?
alt=
@perfectgamestudios
10 years ago
106 posts
yes maybe something changed I not sure what yet I also did a fresh install on test site not really sure whatr jamroom changed recently but during install with all my plugins in module folder.

I get this error

CRI: Query Error: Incorrect integer value: '' for column 'required' at row 1


as this is just fresh install I have uploaded this fresh twice now so I know its not upload issue as I downloaded the files from here again

my error logs shows the following



(2015-07-16T07:21:25+00:00.0.10509900 : 0)-(mem: 2097152)-(pid: 98129)-(ip: 198.53.120.184)-(uri: in4music.com/install.php?action=install)
|Query Error: Incorrect integer value: '' for column 'required' at row 1|

(2015-07-16T07:21:25+00:00.0.10509900 : 0)-(mem: 2097152)-(pid: 98129)-(ip: 198.53.120.184)-(uri: in4music.com/install.php?action=install)
|INSERT INTO jr_jrcore_form (`module`,`view`,`created`,`updated`,`user`,`order`,`name`,`label`,`help`,`type`,`validate`,`active`,`required`,`locked`)
VALUES ('jrEvent','create',UNIX_TIMESTAMP(),UNIX_TIMESTAMP(),'installer','4','event_description','4','5','editor','not_empty','1','','1')
ON DUPLICATE KEY UPDATE `updated` = UNIX_TIMESTAMP()|
alt=
@perfectgamestudios
10 years ago
106 posts
whats changed on jr_jrcore_form recently
michael
@michael
10 years ago
7,822 posts
First thought is: it looks like the jrEvent module is doing something to cause that. Usually when a site is installed jrEvent isn't going to be there, but since it is there on your site, its trying to install and activate it when the rest of the modules are turned on.

Try it without jrEvent moudle uploaded.

The code looks like it should be working even without that as the definition of 'required' is:
"`required` TINYINT(1) NOT NULL DEFAULT '0'",
So I would expect that it should default to 0 for a case like yours where the value is ''.

Its not.
alt=
@perfectgamestudios
10 years ago
106 posts
I noticed it was doing this before when I was doing jrimport from jamroom 4 as only reason I left the modules there as did not really want to download them all again so I did fresh install
but I will take the event out for now so it install
alt=
@perfectgamestudios
10 years ago
106 posts
ok just update take module out it installs but put the module back and then I ran the integrity check shows this

(2015-07-16T09:23:03+01:00.0.32597100 : 0)-(mem: 3407872)-(pid: 103849)-(ip: 198.53.120.184)-(user: in4music)-(uri: www.in4music.com/core/integrity_check_save/__ajax=1) |Query Error: Incorrect integer value: '' for column 'active' at row 1|
michael
@michael
10 years ago
7,822 posts
Try checking the ACTIVE checkbox on the modules INFO tab and saving. or un-checking it then re-checking it.
alt=
@perfectgamestudios
10 years ago
106 posts
same issue I uninstalled the events for now till I know its working

Tags