Calem Community Forum

Functionality Help => Asset => Topic started by: kopunski on February 07, 2008, 10:14:28 pm

Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 07, 2008, 10:14:28 pm
help me please..

my database is now reaching 3312 entries. but everytime i added new data(s) by importing from excel (with navicat), it always stuck: i can login to calem, but the asset list is blank. when i delete the data back to 3312 entries, everything is back to normal. so i tried to input it manually (from the calem asset form). it works, but when i refresh it, the data from my custom field (table name "zc_asset" on mysql) are missing / not shown. but when i check the mysql manually, it exist normally. i went back to calem and try to logoff and login again, it cannot display the asset list anymore. i forced to add more data to it, and the custom field are still not shown, and again the asset list stuck..

so, my guess is i'm stuck to 3312 entries.. :(

please help, i don't know where the bug is..
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 10, 2008, 01:06:09 pm
Take a look at calem.log and php logs which might have some info.
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 10, 2008, 10:23:15 pm
any spesific line i should look?

i try to open it, but it's just too much for me :)
(i'm not even a programmer)
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 11, 2008, 09:25:50 pm
After you ran into the issue search in the log file for "error" around the time when blank screen occurred.
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 12, 2008, 10:56:07 pm
i did not find any error on that perticular moment.. :(

again, i try to restore my database and delete some entries to 3312. i log in to calem. everything ok. i try to input manually. everything ok, and the last line show the exact data like this example:

3313 | asset/01/2008 | cpu | acer | finance | sub-dealer

but when i refesh it, the lines become like this:

3313 | asset/01/2008 | cpu | ....... | ........... | ................
3314 | ...................... | ....... | acer | finance | sub-dealer

(the dots mean blank)

the "acer", "finance", "sub-dealer" belong to custom field (zc_asset)
i log out and try log in, it won't dislay the asset again.
so i check the mysql and the last entry that i input are both in the same position 3313 (in table "asset" and table "zc_asset).
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 13, 2008, 08:09:23 am
Thanks for the info. This issue is identified as a defect. You data is kept in the database intact.
http://www.calemeam.com/apps/mantis/view.php?id=102

The asset list being blank issue was caused by mantis 90 that have been resolved. It will be included in r2.1.
http://www.calemeam.com/apps/mantis/view.php?id=90
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 13, 2008, 11:27:29 pm
thank god u found the cure! :D
so is this mean there is nothing i could do to fix my current application, and i should wait for the next release?

nevertheless, u guys are great. i appreciate all the support. i couldn't wait for the next release. please hurry! :wink:
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 14, 2008, 03:20:40 pm
When the asset list shows blank, you may use search to restrict the data you work with. Can you try this out? The goal is to find a workaround so you can still use CalemEAM.
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 15, 2008, 05:06:37 am
i can't use the search form. nothing to click, because the list header is not even shown..
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 15, 2008, 10:56:20 am
Can you add a screenshot of the blank screen?
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 18, 2008, 03:34:29 am
this is before i add the 3313rd entry:

(http://img518.imageshack.us/img518/9042/01beforeresizeig4.th.jpg) (http://img518.imageshack.us/my.php?image=01beforeresizeig4.jpg)

then i add it:

(http://img183.imageshack.us/img183/4316/02entryresizejc1.th.jpg) (http://img183.imageshack.us/my.php?image=02entryresizejc1.jpg)

return to the list:

(http://img204.imageshack.us/img204/1528/03afterresizeoq5.th.jpg) (http://img204.imageshack.us/my.php?image=03afterresizeoq5.jpg)

this is after i refresh:

(http://img207.imageshack.us/img207/2263/04refreshresizeyb9.th.jpg) (http://img207.imageshack.us/my.php?image=04refreshresizeyb9.jpg)

logout and re-login, and finally:

(http://img178.imageshack.us/img178/8976/05blankresizepq3.th.jpg) (http://img178.imageshack.us/my.php?image=05blankresizepq3.jpg)[/url]
Title: help! i'm stuck at 3312 entries..
Post by: calemadmin on February 19, 2008, 09:44:57 am
Thanks for the info. There are two options: a) wait for R2.1 which is coming out around end of March; b) get latest snapshot from sourceforge source tree, build and deploy it. If option b) does not sound familiar (to deal with source code), you should wait for R2.1.
Title: help! i'm stuck at 3312 entries..
Post by: kopunski on February 21, 2008, 03:40:14 am
i'm good, waiting for the next release :)