Database error...plz fix

[GoogleCodeExporter]

while installation, the following error occurs.....

Database Error: unspecified
Field 'type_name' doesn't have a default value

INSERT INTO account_types (type_type) VALUES ('free'), ('paid') 

please tell me how to fix

Original issue reported on code.google.com by wildlife...@gmail.com on 2 Jun 2010 at 6:16

[GoogleCodeExporter]

prob fixed...had to recode the db schema

Original comment by wildlife...@gmail.com on 2 Jun 2010 at 6:44

[GoogleCodeExporter]

I have the same problem (with PHI 1.4.0.11.2), but no idea how to recode db 
schema. Could someone help?

Regards,
Orlin

Original comment by orlin...@gmail.com on 20 Jun 2010 at 12:44

[GoogleCodeExporter]

i have same problem how fix it help me

Original comment by pushpran...@gmail.com on 8 Jul 2010 at 3:56

[GoogleCodeExporter]

Here's the recoded schema, still a major recode has to be done.But, this works 
for amateurs.

Original comment by wildlife...@gmail.com on 8 Jul 2010 at 4:41

Attachments:

• sql.txt

[GoogleCodeExporter]

Thanks for ur help but can u give me RECODED " dbschema.inc " 

Original comment by pushpran...@gmail.com on 9 Jul 2010 at 6:01

[GoogleCodeExporter]

i can giv u but, it wil require much time. why dont u directly dump the sql 
schema without using the installation script, then edit db.conf.php with 
database credentials.

Original comment by wildlife...@gmail.com on 9 Jul 2010 at 1:53

[GoogleCodeExporter]

bro ur sql on localhost not working good 
so plz give me RECODED " dbschema.inc " 

Original comment by pushpran...@gmail.com on 9 Jul 2010 at 5:50

[GoogleCodeExporter]

can we get a fix?

Original comment by wesleyha...@gmail.com on 26 Jan 2012 at 1:57