| View previous topic :: View next topic |
| Author |
Message |
itwebsolution
Joined: 17 Aug 2004
Posts: 2
|
| Posted: Tue Aug 17, 2004 4:04 pm Post subject: Cannot Write to DB |
|
|
Hello,
I am looking forward to using your software! I am getting the following error message:
Code: Debug info: CREATE TABLE expense ( data varchar(100) NOT NULL default '', date date NOT NULL default '0000-00-00', ) TYPE=MyISAM
When trying to add a new category from the setup.php file. Any ideas on how to fix this? I have chmod'ed the file to 666 with no luck.
When I enter the debug info directly into MySQL, here is what I see:
Quote: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE = MYISAM' at line 3
thanks,
Ian |
|
| Back to top |
|
itwebsolution
Joined: 17 Aug 2004
Posts: 2
|
| Posted: Tue Aug 17, 2004 4:11 pm Post subject: |
|
|
I have the database configuration turned on:
Code: $cfg_database='on'; |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 303
|
| Posted: Thu Aug 19, 2004 9:17 am Post subject: |
|
|
this is caused by a bug in version 0.1
the fix is to look for this line
Quote: date date NOT NULL default '0000-00-00'
in inc.func.php and delete the comma at the end of this line
will be fixed in use PHPfinance version 0.2 soon |
|
| Back to top |
|
micoots
Joined: 23 Aug 2004
Posts: 1
Location: Sydney, Australia
|
| Posted: Mon Aug 23, 2004 9:43 am Post subject: |
|
|
I editted this and yeah, it seems to have resolved that problem.
Thanks.
Michael.
[/quote] |
|
| Back to top |
|
| |
