Help with a repeating error in error log

1,118 Posts

dubbs Reply #1, 9 years, 4 months ago

Hi guys,
I am getting this error repeated many times in error log on MODx 2.3.5 build

(ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'link' in 'where clause'
)

Any idea what the issue is and a fix?

1,118 Posts

dubbs Reply #2, 9 years, 4 months ago

Any ideas anyone?

1,118 Posts

dubbs Reply #3, 9 years, 4 months ago

Anyone?

571 Posts

Andy Tough Reply #4, 9 years, 4 months ago

VersionX? https://forums.modx.com/thread/95773/error-42s22-executing-statement#dis-post-518435

If I help you out on these forums I would be very grateful if you would consider rating me on Trustpilot: https://uk.trustpilot.com/review/andytough.com

email: [email protected] | website: https://andytough.com

24,544 Posts

BobRay Reply #5, 9 years, 4 months ago

It's not a field in any of the MODX objects, so it's most likely an extra.

Check Package Manager for possible updates.

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

1,118 Posts

dubbs Reply #6, 9 years, 4 months ago

Thanks Guys - I don't have VersionX installed AndyTough - but it looks like the same issue! Odd...

24,544 Posts

BobRay Reply #7, 9 years, 4 months ago

The Discuss extra is also a possible culprit.

Keep in mind that some extras leave stuff behind when uninstalled, so it could be an extra you installed, then removed.

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting