Thread: Windows Server + PHP + MySql install-script sql bug

Windows Server + PHP + MySql install-script sql bug

ClassiPress, first installation database bug,

Windows 2008 Server Plesk 9 IIS 7

Admin-Updates.php
Create table cp_ad_fileds, ( upgrade function workin , alter table colums not null )

field property "field_min_length not null",

But insert record cp_ad_fields 12 default record null field_min_length values.

(SQL Query) error message : Field 'field_min_length' doesn't have a default value

Not insert record cp_ad_forms , default form value. ( but admin panel add form working )

And not work Admin panel Add Customs Field


install-script.php
cp_ad_fields integer '' insert value empty, bug because not empty value '0' ( empty value change 0 zero working )

Error Field beacuse required integer value:
field_perm
field_core
field_req

Not inster default form record , and cp_ad_meta relations value ,


Linux / Unix server sql script good work but not create default form and meta.

Windows server sql script writing different ,