State of ASTPP repo on github

[Philipp Walker]

Hi list,

After a brief look at the Online Demo, I tried to install ASTPP from github.
However, after (manually) installing, I had quite some issues:

• Several files having e.g. white spaces after closing PHP-tags, leading to a lot of blank pages / error messages
  

  Cannot modify header information - headers already sent by ...

• (Possible) DB inconsistencies, leading to Error Message "Request failed", e.g. when going to system configuration
  I was able to fix that by using a modified version of sql/astpp-upgrade-1.7.2.sql
  
• PHP error messages "Undefined index: payment_type" in  filemodels/accounts_model.php when trying to create a new account
• Getting another "Request failed" when going to Customer Report.
  Guess I have to define a little more than just a customer account, but can't find out what...
  -> more on this in my next Post. (I decided to split my question up a little, so that I don't have too many topics in one single post...)
  
• ... and some more ...

Is the github repo really supposed to be usable or is it in some bad state somehow?

Thanks and best regards,

Philipp

P.S.: Versions are:
CentOS 5
Apache 2.2.3
PHP 5.2.17

[Philipp Walker]

Am Mittwoch, 24. April 2013 14:36:36 UTC+2 schrieb Philipp Walker:

• (Possible) DB inconsistencies, leading to Error Message "Request failed", e.g. when going to system configuration
  I was able to fix that by using a modified version of sql/astpp-upgrade-1.7.2.sql
  

• Getting another "Request failed" when going to Customer Report.
  

Hmp.  The latter ("Request failed" on Customer Report.) also seemed to be a database inconsistency: The VIEW "customer_cdrs" was missing in my database...
No clue, why this wasn't created... Somehow, it looks like astpp-1.7.1.sql and astpp-upgrade-1.7.2.sql weren't correctly loaded...
One (minor?) problem I found about this view (and other VIEWS) is, that - in sql/astpp-1.7.1.sql , we have:
DROP TABLE IF EXISTS `customer_cdrs`;
which won't work if it's a VIEW...

Am I the only one having such strange problems...???

[Philipp Walker]

At least part of the problem is caused by the line
ALTER TABLE `fscdr`.`fscdr` ADD INDEX ( `uniqueid` );
in file sql/astpp-upgrade-1.7.2.sql.
That doesn't work if it's an Asterisk installation and will make the upgrade fail after just two lines.
It can be commented out if you're installing for Asterisk or moved to the end of the file - so it doesn't do any harm anymore.

P.