Author Topic: help! i'm stuck at 3312 entries..  (Read 5467 times)

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« 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..

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #1 on: February 10, 2008, 01:06:09 pm »
Take a look at calem.log and php logs which might have some info.
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #2 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)

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #3 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.
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #4 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).

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #5 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
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #6 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:

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #7 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.
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #8 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..

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #9 on: February 15, 2008, 10:56:20 am »
Can you add a screenshot of the blank screen?
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #10 on: February 18, 2008, 03:34:29 am »
this is before i add the 3313rd entry:



then i add it:



return to the list:



this is after i refresh:



logout and re-login, and finally:

[/url]

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
help! i'm stuck at 3312 entries..
« Reply #11 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.
Calem Community Forum Admin

kopunski

  • Jr. Member
  • **
  • Posts: 16
help! i'm stuck at 3312 entries..
« Reply #12 on: February 21, 2008, 03:40:14 am »
i'm good, waiting for the next release :)