NorCal Posted July 2, 2020 at 05:14 PM Share Posted July 2, 2020 at 05:14 PM 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
Alejandro Posted July 2, 2020 at 05:20 PM Share Posted July 2, 2020 at 05:20 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
NorCal Posted July 2, 2020 at 06:18 PM Author Share Posted July 2, 2020 at 06:18 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
Alejandro Posted July 2, 2020 at 06:56 PM Share Posted July 2, 2020 at 06:56 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
NorCal Posted July 2, 2020 at 07:30 PM Author Share Posted July 2, 2020 at 07:30 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
Alejandro Posted July 2, 2020 at 08:57 PM Share Posted July 2, 2020 at 08:57 PM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
Recommended Posts