Unknown column in ’field list’
Development and Programming
So I installed the linktracker module and it made one of my weblogs’ posting/editing all screwy. After I installed linktracker I began getting…
MySQL ERROR: Error Number: 1054 Description: Unknown column ‘field_id_44_img’ in ‘field list’
… ONLY for the one weblog I was using this module for! I promptly removed linktracker but I think there are database ghosts that I can’t get rid of. Any ideas?
Moved to the Modules forum by Moderator
Is this the program you’re using?
http://utilitees.silenz.org/index.php/addons/software/ajax-linktracker/
It sure is.
In that case, I’m going to move this so that you can receive support from the developer. He’s a frequent poster, and you should hear from him fairly soon. You may want to contact him directly.
Great. Thanks, Sue!
Actually sounds really peculiar to me. I have no idea what “field_id_44_img” would be or where it belongs to. Has nothing to do with linktracker, that’s for sure. What is the complete Error message?
Also there is no connection between the linktracker module and the edit / publish screen. This is a module not an extension. So I actually don’t think this is related at all.
Yeah, it wouldn’t seem to be correlated but this is the only thing I have added to EE in the past month. And it ONLY affected the one weblog I added the module to. Strange, indeed. Here is the full error:
MySQL ERROR:
Error Number: 1054
Description: Unknown column 'field_id_44_img' in 'field list'
Query: UPDATE `exp_weblog_data` SET `weblog_id` = '9', `field_id_21` = 'Filling-in GUI microassembly. The package contains a MATLAB implementation of diffusive filing-in model. The demo simulation is based on Craik-O\'Brien-Cornsweet Effect(COCE). The package provides GUI interface to control luminance of COCE stimulus components which have impact on the model\'s output. The software can be run from matlab command line by typing Filling_in at the prompt. Necessary documentation as well as source code is provided.', `field_ft_21` = 'none', `field_id_48` = 'Present implementation of diffusive filling-in model demonstrates dynamics of neural signal spreading on the example of Craik-O\'Brien-Cornsweet Effect. Filling-in process is implemented as a set of non-linear differential equations that control spreading of the activity of the Feature Contour System signals (brightness, color) within the image segments defined by the Boundary Contour System signals. The demo example simulates 1D filling-in process and allows the user to see the impact of luminance contrast in the COCE configuration on the output of the present implementation of diffusive filling-in model.', `field_ft_48` = 'none', `field_id_46` = '', `field_ft_46` = 'none', `field_id_47` = '', `field_ft_47` = 'none', `field_id_44` = 'FillingIn_Dia.jpg\n\n\n\n\n\n\n\n\n\n', `field_id_44_img` = 'Array', `field_id_41` = 'Filing-in GUI microassembly. Unzip archive. Run by typing Filling-in at MATLAB prompt', `field_ft_41` = 'none', `field_id_25` = 'Fillling-in_07172009.zip', `field_id_25_img` = 'Array', `field_id_22` = 'No dependency', `field_ft_22` = 'none', `field_id_23` = 'MATLAB', `field_ft_23` = 'none', `field_id_24` = 'Public domain software', `field_ft_24` = 'none', `field_id_50` = 'Gail Carpenter', `field_ft_50` = 'none', `field_id_44_img_0` = '', `field_id_25_img_0` = '' WHERE entry_id = '1082'I have no field_id_44_img but there is a field_id_44, so I am not sure why it’s trying to query this non-existent field.
And it ONLY affected the one weblog I added the module to.
How do you ADD the module to a weblog? Are we talking about the same module?
Looks like you are using or have used some kind of file-upload extension, probably File 3.11. That creates input fields named field_id_44_img and the like. After succesfull upload it removes these variables from the $_POST-Array. If it’d fail to do so EE will try to add them to the query.
Looks more like an extension issue.
Yep. It is an extension issue with File. I disabled the extension and it let me edit entries again. The weird thing is that this extension worked just fine until I installed linktracker. It may have just been a coincidence, but it’s good to know where the problem stems from now. THanks!
The weird thing is that this extension worked just fine until I installed linktracker.
Must be coincidence. There really no contact point between these addons at all.