When submiting a download I get the following error emailed to me

includes\db\db.php
CMS Warning line 75: On /index.php?name=Downloads&file=add While executing query "INSERT INTO cms_downloads_downloads (lid, cid, active, access, title, screen, desc_short, desc_long, date, name, email, submitter) VALUES (NULL, '1', 1, '0', 'hello', '1', 'hello', '', '1173981028', '', '', '2')" the following error occured: Field 'notes' doesn't have a default value In: d:\domains\ultimatesoftwares.net\wwwroot\modules\Downloads\add.php on line: 138

Try uploading the download in: /uploads/downloads/

Pce,
Heckler

Note the file IS showing up in the /uploads/downloads/
but then:

A database error has occurred

The webmaster has been notified of the error


With debug of:

includes\db\db.php

* CMS Warning line 75: On /index.php?name=Downloads&file=add While executing query "INSERT INTO cms_downloads_downloads (lid, cid, active, access, title, screen, desc_short, desc_long, date, name, email, submitter, version) VALUES (NULL, '1', 1, '0', 'GEM - Guild Event Manager', '0', 'GEM - Guild Event Manager raid planning', 'This is a required Starblade addon for raid planning.', '1182007165', '', '', '2', '2.25')" the following error occured: Field 'notes' doesn't have a default value In: C:\www\sb2\modules\Downloads\add.php on line: 139

How is this resoved?

You are running MySQL with STRICT_TRANS_TABLES on ... if you can turn it off otherwise set 'notes' field as NULL instead of NOT NULL

or if this is to complicated then try adding some text to the "Notes" input form before submitting the download.

All of those are just a quick workaround till the current release get fixed and released.

NanoCaiordo wrote:

You are running MySQL with STRICT_TRANS_TABLES on ... if you can turn it off otherwise set 'notes' field as NULL instead of NOT NULL or if this is to complicated then try adding some text to the "Notes" input form before submitting the download. All of those are just a quick workaround till the current release get fixed and released.

I tried filling out ALL fields that could be filled and still getting said error.

NanoCaiordo wrote:

You are running MySQL with STRICT_TRANS_TABLES on ... if you can turn it off otherwise set 'notes' field as NULL instead of NOT NULL or if this is to complicated then try adding some text to the "Notes" input form before submitting the download. All of those are just a quick workaround till the current release get fixed and released.

What db table is notes field?

While executing query "INSERT INTO cms_downloads_downloads ....

NanoCaiordo wrote:

You are running MySQL with STRICT_TRANS_TABLES on ... if you can turn it off

Ok, turned off "STRICT_TRANS_TABLES" on the mysql

and still getting:

includes\db\db.php

* CMS Warning line 75: On /index.php?name=Downloads&file=add While executing query "INSERT INTO cms_downloads_downloads (lid, cid, active, access, title, screen, desc_short, desc_long, date, name, email, submitter, version, compat) VALUES (NULL, '1', 1, '0', 'GEM (GuildEventManager)', '0', 'GEM - Guild Event Magaer', 'This is the GEM addon for raid planning, if yoyu are in starblade and want to raid this is a required addon.', '1182065277', '', '', '2', '2.25', 'wow 2.0')" the following error occured: Field 'notes' doesn't have a default value In: C:\www\sb2\modules\Downloads\add.php on line: 139

did you restart MySQL ?

as i can see I've done a spelling error ... its STRICT_TRANS_TABLES

Ok, I initially posted that I was getting an error on uploading that was told it may have been related to the 'notes' field' and that my version of mysql and php may be out of date. So....

I have uniformaly completely screwed up my installs by upgrading just for the Downloads Pro version... and guess what? It still doesn't want to add files.

I fill out all the relevant field, and click save and the screen locks up... starts a progress bar and then freezes. I decided it let it sit for awhile but nothing continued to happen. Then i discovered it was not just the download, but the whole virtual server was locked.

Along with the added hell that now my other sites are messed up from upgrading to new versions.

Why create a new topic relating to your original issue? - merged back where it should have been.

Phoenix wrote:

Why create a new topic relating to your original issue? - merged back where it should have been.

Sorry, had 2 windows open to the site and clicked the wrong add button. My appologies.

had somebody solved that problem i have that problem toooo

it must be an error in php code for input downloads but i can not find it

bookmarked