Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

[HELP] : Error Adding/Creating link properties

Quote Reply
[HELP] : Error Adding/Creating link properties
I am working on creating different link properties & for some reason, Glinks is giving me the following error:

Unable to add column 'affiliations_2': Failed to execute query: 'ALTER TABLE glinks_Links ADD affiliations_2 VARCHAR(255)': 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


Any idea on how to fix this?

Thanks.

Vishal
-------------------------------------------------------
Quote Reply
Re: [VishalT] [HELP] : Error Adding/Creating link properties In reply to
*update*
SOLVED :) :)


It was an issue with InnoDB setting in MySQL on the server.

Solution: Removed InnoDB Strict mode.

Vishal
-------------------------------------------------------
Quote Reply
Re: [VishalT] [HELP] : Error Adding/Creating link properties In reply to
Funnily enough I had this same problem on a server move I did the other week for a GLinks install.

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!