IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

[Solved]Could not insert search results


 
IBM Mainframe Forums -> Suggestions & Feedback
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Fri Oct 30, 2015 2:41 pm
Reply with quote

Everytime I try checking other user's posts when posts is about 9k and above, I get this error.

SQL Error : 1406 Data too long for column 'search_array' at row 1

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1805654515, '9a80422ec7af51286e9fb106c68e0b18', 'a:7:{s:14:"search_results";s:77456:"69998, 70144, 70784, 70825, 71756, 72296, 72297, 73055, 73539, 73702, 74183, 74189, 74270, 74301, 74305, 74522, 74548, 74556, 74576, 74577, 74607, 74672, 74677, 74680, 74701, 74726, 74756, 74780, 74838, 74846, 74856, 74871, 75234, 75238, 75275, 75405, 75666, 75769, 75906
.
.
.
332145, 332159, 332161, 332164, 332175, 332186, 332203, 332243, 332247, 332248, 332251, 332271, 332298, 332318, 332327, 332330";s:17:"total_match_count";i:9707;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;}')

Line : 774
File : /var/www/vhosts/ibmmainframes.com/httpdocs/search.php
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1199
Location: India

PostPosted: Fri Oct 30, 2015 8:27 pm
Reply with quote

We are working on this...
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1199
Location: India

PostPosted: Fri Oct 30, 2015 10:34 pm
Reply with quote

Please try now and let me know if its working...
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Fri Oct 30, 2015 11:26 pm
Reply with quote

Looks good for the three users involved.
Back to top
View user's profile Send private message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Mon Nov 02, 2015 12:00 pm
Reply with quote

It's all good. Thank you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> Suggestions & Feedback
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Can we Insert duplicates in Primary U... DB2 0
No new posts Members search in PDS JCL & VSAM 9
No new posts insert into session tables with UR DB2 0
No new posts to Insert Rows from File1 to File 2 ... DFSORT/ICETOOL 1
No new posts Insert System Runtime in HEADER In SY... SYNCSORT 9

Back to Top