DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • July 17, 2018, 04:19:32 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: Probleme with create.php  (Read 2348 times)
0 Members and 1 Guest are viewing this topic.
Sacha Fournier
Guest
« on: January 17, 2006, 12:55:00 PM »

Hi,

I've gone throught all logd installation steps including Apache 2, Mysql 5.1 and PHP5. Everything works fine. I've also gone throught installer.php and didn't get any problems. But when I try to create a new character, I get this error

Field 'specialty' doesn't have a default value
Call Stack:
1: db_query("INSERT INTO isi_accounts ...") called from C:\Program Files\Apache Group\Apache2\htdocs\lotgd-1.0.6\create.php on line 189

I took a look at the code and table structure and notice that a lots of non null collumns is not inserted when creating a new character in create.php

Any ideas ?
Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #1 on: January 17, 2006, 09:12:04 PM »

There are some differences between mysql4 and mysql5. Besides others, in mysql4 certain fieldtypes must not have a default value whereas mysql5 allows and requires this.

You'd have to go to you database and manually add empty default values (DEFAULT = '') for those fields.
Logged

Running for more than three years now:
Sacha Fournier
Guest
« Reply #2 on: January 18, 2006, 05:13:55 AM »

Ok. I'll try to replace Mysql 5 to MySQL 4 tonight and let you know. Thanks.
Logged
sachafournier
Guest
« Reply #3 on: January 19, 2006, 06:59:27 AM »

Hey ! That was the problem. It's working now. Thank you.
Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #4 on: January 19, 2006, 07:01:04 AM »

I'm glad, I could help Smiley
Logged

Running for more than three years now:
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Please take the time to read the FAQ and browse the DragonPedia

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
39 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search