FIX: mysqlt error: [1048: Column 'arHandle' cannot be null] in EXECUTE("INSERT INTO Areas

Permalink Browser Info Environment
In case anyone comes across this in the future:

I recently got the following error on the job search page:

mysqlt error: [1048: Column 'arHandle' cannot be null] in EXECUTE("INSERT INTO Areas

I narrowed this down to the "Featured Jobs" widget on the widebar. This occurred after adding a job and leaving the 'short description' blank.

To fix this, I added a catch to put some default text in if none was provided.

Open /packages/tony_jobs_board/blocks/tony_featured_jobs/view.php

I added the following code under line 50. You can adjust this to fit your preferences, but it worked for me. See attached.

if(strlen($description)==0)
$description = "No Description Provided";

1 Attachment

Type: Discussion
Status: In Progress
evolveinc
View Replies:
chassa2556 replied on at Permalink Reply
chassa2556
Just wanted to say thank you for this tip - it completely saved my bacon right before Christmas. Thanks for taking the trouble to write this....

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.