Setup.php fails to create the database tables: WSN Support

Setup.php fails to create the database tables
Setup.php fails to create the database tables

Version:
Status: fixed

Setup.php fails to create the database tables

herby
Beginner

Usergroup: Member
Joined: Sep 24, 2004
Location: Cape Town, South Africa
Total Topics: 2
Total Posts: 4

Posted 09/24/04 - 10:32 PM:	#1
Hello, We cannot even get to first base with this script. Although setup.php reports "Successful installation", that is far from accurate as the database tables are not even created. With a debug line in setup.php, the error given is "Invalid default value for 'id'" Has anyone encountered this problem and know a workaround? Cheers, Herby

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 09/25/04 - 01:59 AM:	#2
Note that by indications so far, it seems like perhaps this has something to do with mysql versions greater than 4.10 -- but I'm not sure if it's all 4.1+ versions, so if anyone using 4.1+ could mention it that'd be useful.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

herby
Beginner

Usergroup: Member
Joined: Sep 24, 2004
Location: Cape Town, South Africa
Total Topics: 2
Total Posts: 4

Posted 09/26/04 - 02:48 AM:	#3
This was resolved by Paul supplying a version of setup.sql with the dafault values removed. Thanks. Herby

alvin
Beginner

Usergroup: Customer
Joined: Aug 25, 2003
Total Topics: 1
Total Posts: 3

Posted 09/28/04 - 07:12 PM:	#4
Tried on mySQL ver 4.1.3 beta-standard and it didn't work. However, works fine when downgrading to lower version. Rgds, Alvin.

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 09/29/04 - 07:01 AM:	#5
I belive I had this problem long time ago and fixed it deleting remarks/notes.
Real Estate Business Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 09/29/04 - 05:06 PM:	#6
The currently available version of 3.12 includes the fixed setup.sql.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.