Can someone PLEASE tell me why the following code;
my $database_connection = $DB->table("News");
$database_connection->add ( { title => $full_title,
short => $short_article,
full_article => $article,
date => $date_added,
nice_date => $todays_date
} ) or die ("Unable to add article. Reason: $GT::SQL::error");
returns the error;
A fatal error has occured:
Unable to add article. Reason: Column full cannot be left blank. at /www/site.com/cgi-bin/directory/admin/Plugins/Check.pm line 153.
Please enable debugging in setup for more details.
Its telling me I need to fill in the 'full' column, but I've double, tripple, and quadrouply checked the code, to make sure its not calling 'full' to add to, and I've also checked the table to see if there is even a 'full' column, which there isn't!!!!
This is driving me crazy!
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Code:
# now we need to add it to the database... my $database_connection = $DB->table("News");
$database_connection->add ( { title => $full_title,
short => $short_article,
full_article => $article,
date => $date_added,
nice_date => $todays_date
} ) or die ("Unable to add article. Reason: $GT::SQL::error");
returns the error;
A fatal error has occured:
Unable to add article. Reason: Column full cannot be left blank. at /www/site.com/cgi-bin/directory/admin/Plugins/Check.pm line 153.
Please enable debugging in setup for more details.
Its telling me I need to fill in the 'full' column, but I've double, tripple, and quadrouply checked the code, to make sure its not calling 'full' to add to, and I've also checked the table to see if there is even a 'full' column, which there isn't!!!!
This is driving me crazy!
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Defying Logic!