FutureX Posted September 7, 2022 Share Posted September 7, 2022 I'm getting a very similar error that just showed up if I check or uncheck 'Hidden' on a product (asterisks are the actual domain name) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shortDescription' in 'field list' in /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php:485 Stack trace: #0 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(485): PDO->prepare() #1 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #3 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(496): Illuminate\Database\Connection->run() #4 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(429): Illuminate\Database\Connection->affectingStatement() #5 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Query/Builder.php(2802): Illuminate\Database\Connection->update() #6 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Builder.php(792): Illuminate\Database\Query\Builder->update() #7 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Model.php(806): Illuminate\Database\Eloquent\Builder->update() #8 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Model.php(721): Illuminate\Database\Eloquent\Model->performUpdate() #9 /var/www/vhosts/****.****.com/httpdocs/****/configproducts.php(0): Illuminate\Database\Eloquent\Model->save() #10 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shortDescription' in 'field list' (SQL: update `tblproducts` set `shortDescription` = *****, `tblproducts`.`updated_at` = 2022-09-07 08:49:43 where `id` = 3) in /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php:671 Stack trace: #0 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(496): Illuminate\Database\Connection->run() #2 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Connection.php(429): Illuminate\Database\Connection->affectingStatement() #3 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Query/Builder.php(2802): Illuminate\Database\Connection->update() #4 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Builder.php(792): Illuminate\Database\Query\Builder->update() #5 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Model.php(806): Illuminate\Database\Eloquent\Builder->update() #6 /var/www/vhosts/****.****.com/httpdocs/vendor/illuminate/database/Eloquent/Model.php(721): Illuminate\Database\Eloquent\Model->performUpdate() #7 /var/www/vhosts/****.****.com/httpdocs/****/configproducts.php(0): Illuminate\Database\Eloquent\Model->save() #8 {main} 0 Quote Link to comment Share on other sites More sharing options...
leemahoney3 Posted September 7, 2022 Share Posted September 7, 2022 What version of WHMCS are you running? On the latest version (8.5.1) the column name is short_description, not shortDescription. 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 7, 2022 Author Share Posted September 7, 2022 8.5.1 That's the only version that has existed on this server. I installed 8.5.1 fresh 0 Quote Link to comment Share on other sites More sharing options...
leemahoney3 Posted September 7, 2022 Share Posted September 7, 2022 Bizarre, just tested that on my end and its not throwing any errors. If you look in your database, can you see the short_description column on the tblproducts table? Should be towards the end just before the tagline column. 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 7, 2022 Author Share Posted September 7, 2022 (edited) Yes I checked and I do have the 'short_description' column in tblproducts. This error just started happening over the last few days when I installed WHMpress Helper but even when I deactivate that Addon I still get the error. But it seems like the error is looking for the column shortDescription instead of short_description Edited September 7, 2022 by FutureX 0 Quote Link to comment Share on other sites More sharing options...
leemahoney3 Posted September 7, 2022 Share Posted September 7, 2022 That addon seems to be causing a bit of upset lately! Remove the addons files completely (move them to a temporary folder outside of your whmcs installation if necessary) and check inside your /includes/hooks/ folder also. Likely something is lurking around. 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 7, 2022 Author Share Posted September 7, 2022 Yes, seems that way. It's a great plugin if I can just get these few bugs worked out. I moved the folder for WHMpress Helper above the httpdocs folder and got the same result. I checked the /hooks folder and nothing new is there. It had to have updated/changed something. 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted September 8, 2022 WHMCS Support Manager Share Posted September 8, 2022 Hi @FutureX, I've split this into a new thread in order to keep each issue separate. I'm pleased to hear you were able to work-around the error. Another possible solution for this error is detailed at https://help.whmcs.com/m/v85/l/1601133-troubleshooting-a-column-not-found-1054-unknown-column-shortdescription-in-field-list-error 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 8, 2022 Author Share Posted September 8, 2022 I tried the recommendation. I already had data in the Product Short Description field but I changed it and re-saved but got the same error. 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 9, 2022 Author Share Posted September 9, 2022 I see that this error (#CORE-17808) has been fixed in 8.6.0 beta 1 but how stable is beta 1 at this point? 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted September 10, 2022 Share Posted September 10, 2022 18 hours ago, FutureX said: I see that this error (#CORE-17808) has been fixed in 8.6.0 beta 1 but how stable is beta 1 at this point? It’s “beta” so not stable and not for production. 0 Quote Link to comment Share on other sites More sharing options...
FutureX Posted September 10, 2022 Author Share Posted September 10, 2022 (edited) @pRieStaKos Thanks, I ended up solving the error and so rolled back to 8.5.1 Even though this is still a bug in 8.5.1 I didn't need to check the Dynamic Field Translations option for WHMPress. Edited September 10, 2022 by FutureX 0 Quote Link to comment Share on other sites More sharing options...
leemahoney3 Posted September 10, 2022 Share Posted September 10, 2022 49 minutes ago, FutureX said: @pRieStaKos Thanks, I ended up solving the error and so rolled back to 8.5.1 Even though this is still a bug in 8.5.1 I didn't need to check the Dynamic Field Translations option for WHMPress. Good to hear you solved it anyways. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.