Error Number : 1054 Unknown column 'edited' in 'where clause'

[OldSchoolDSL]

OK so anytime I rebuild my templates the following happens


Updating style sets with no parent information

No styles needed updating
Updating style information for each style...

Default vBulletin 4 ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Classic SU v3 Lite ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Classic SU v3 - Fixed ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Classic SU v3 Green - Fixed ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Classic SU v3 Green - Fluid ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Classic SU v3 - Fluid ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Mint ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

beta / unstable ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Christmas 2011 ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Aficionado Fluid ... (Templates) (StyleVars) (Replacement Variables) (CSS) Done.


^ All looks well, but below it I see this....

Database error in vBulletin 4.1.8:

Invalid SQL:

		SELECT templateid
		FROM template
		WHERE
			edited=1;

MySQL Error   : Unknown column 'edited' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, December 14th 2011 @ 09:33:11 PM
Error Date    : Wednesday, December 14th 2011 @ 09:33:12 PM
Script        : http://www.sociallyuncensored.eu/forums/admincp/misc.php?do=rebuildstyles
Referrer      : http://www.sociallyuncensored.eu/forums/admincp/misc.php?do=chooser
IP Address    : 7xx.xxx.xxx.xxx
Username      : Adam
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.18-1~dotdeb.1

Solutions, thoughts, opinions?
Anything would be helpful.

[kh99]

I don't see that exact query anywhere, and the template table has no "edited" column. Could that be from a mod? Try temporarily disabling all your mods by putting:

define('DISABLE_HOOKS', true);

at the top of your config.php file, right under the <?php

[OldSchoolDSL]

Originally Posted by kh99

I don't see that exact query anywhere, and the template table has no "edited" column. Could that be from a mod? Try temporarily disabling all your mods by putting:

define('DISABLE_HOOKS', true);

at the top of your config.php file, right under the <?php

You sir or miss, are correct.

Now to track down the evil doer.... sigh .... 200+ modifications to go through... Oh what fun.

edit: just noticed your name there, Kevin.... Thank you

--------------- Added [DATE]1323918737[/DATE] at [TIME]1323918737[/TIME] ---------------

@Kevin thank you so much for your willingness to help. I should have checked a possible mod conflict from the beginning and would have saved myself the trouble.

Removing the following 3 modifications resolved my issues, for anyone else who may in the future have a problem.

https://vborg.vbsupport.ru/showthread.php?t=266696
https://vborg.vbsupport.ru/showthread.php?t=152931
https://vborg.vbsupport.ru/showthread.php?t=243460

I confirmed the error by not only removing these on my site, but also by using them on a fresh install with no other modifications or templates.

This is not to say that these 3 are bad, but simply that your own results may vary.