Jump to content

row size too large on update


NorCal

Recommended Posts

Hi, I went to do the latest update.  I got row size too large error.

Quote

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs => ALTER TABLE `sfu_jreviews_content` CHANGE COLUMN `jr_scheduledate` `jr_scheduledate` DATETIME DEFAULT NULL

This was displayed in the jreviews  joomla admin when I attempted the update.  I looked in my server logs and cannot find the error.  I also searched the jrev docs and forum but I haven't found this. 

My  questions are:

1) Can you point me to the documentation if it exists, instructing on the process of updating the db tables?

2) That is the complete text in the error and I'm not sure if that sql in the error is complete or the error message was cut off.  Am I meant to just run that or is there more to it?

 

Regards,

Paul

 

Link to comment
×
×
  • Create New...