problems with DB
6 posts,
4 voices
|
Jan 28, 2008 07:55
19 posts
|
SO this is my problem: When trying to create new page I got "page not seved" error, but this is if I am trying to create, when I try to update - everything works fine. Most fun part - if I connect to different DB (with the same info and structure) - everything works fine, even creation of new page. So the question - whats the problem? |
|
Jan 28, 2008 09:18
19 posts
|
And I am using frog 0.2.2 |
|
Jan 28, 2008 09:28
382 posts
|
frog 0.2.2 not supported, sorry |
|
Jan 29, 2008 02:50
19 posts
|
My Job mate uses 0.9.0 version and has the same problem. As I understand the problem is in db, not with frog, but what exactly can be? What settings may be wrong. Permissions are ok. |
|
Jan 29, 2008 03:52
19 posts
|
Found it out! Maybe it is bug, or maybe it must work this way - when creating new page and saving it with "-inherit-" layout sql statment tries to save layout_id = '', and if in database layout_id cannot be NULL then it generates error, because layout_id must be int. |
|
Aug 20, 2008 17:59
9 posts
|
I am still having problems with this myself (0.9.3 r184). Did anyone come up with a solution? I was able to track down that in ...\frog\app\backend\views\page\edit.php line 89 states: code(<option value="">— <?php echo __('inherit'); ?> —</option>) I have changed it to not be a code(NULL) value by adding "0" in the default value for "--inherit--". Should be: code(<option value="0">— <?php echo __('inherit'); ?> —</option>) Could someone double check this and make the change to the project. Thanks. |
|
Sep 16, 2008 16:47
396 posts
|
I realize this reaction is a bit late, nevertheless… Actually, this shouldn’t be a problem. The database should recognize that it is an int value field and should therefore turn the default value NULL into a 0 value. Works fine on multiple of my systems using both MySQL 4 and 5. What DB are you guys using? |