shinesoftware / shineisp Goto Github PK

ShineISP is a complete web based solution to manage your web hosting business and your web hosting clients. Our aim is to create a free alternative to the well known management systems for web hosting and Internet Service Provider businesses.

Home Page: http://www.shineisp.com/

License: BSD 3-Clause "New" or "Revised" License

ApacheConf 0.01% PHP 95.19% HTML 2.98% Shell 0.01% PowerShell 0.01% JavaScript 1.69% CSS 0.12% Batchfile 0.01%

shineisp's People

Contributors

Stargazers

Watchers

shineisp's Issues

Password encryption

Password encryption should be changed from plain md5 to crypt, for increased security.
This will break any previously saved password.

Errors after latest pull...

Hi,

We just pulled the latest code and when trying to via the admin control panel, we ge the following:

string(20234) "12 error(s) encountered during migration
========================================
 Error #1 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'region_id'. Failing Query: "ALTER TABLE addresses ADD region_id INT DEFAULT '0' NOT NULL"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE add...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE add...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('addresses', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 84)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #2 - SQLSTATE[HY000]: General error: 1005 Can't create table 'shineisp0.#sql-69a_180d' (errno: 150). Failing Query: "ALTER TABLE addresses ADD CONSTRAINT addresses_region_id_regions_region_id FOREIGN KEY (region_id) REFERENCES regions(region_id)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE add...')
#1 /home/shineisp/web/library/Doctrine/Export.php(524): Doctrine_Connection->execute('ALTER TABLE add...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(184): Doctrine_Export->createForeignKey('addresses', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedForeignKey(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 85)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #3 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'addresses_region_id_idx'. Failing Query: "CREATE INDEX addresses_region_id_idx ON addresses (region_id)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE INDEX ad...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE INDEX ad...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('addresses', 'addresses_regio...', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 85)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #4 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'callback_url'. Failing Query: "ALTER TABLE orders_items ADD callback_url VARCHAR(200)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders_items', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 86)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #5 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'uuid'. Failing Query: "ALTER TABLE orders_items ADD uuid VARCHAR(50)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders_items', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 86)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #6 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_access_tokens' already exists. Failing Query: "CREATE TABLE oauth_access_tokens (id INT UNSIGNED AUTO_INCREMENT, access_token VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_access_to...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #7 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_authorization_codes' already exists. Failing Query: "CREATE TABLE oauth_authorization_codes (id INT UNSIGNED AUTO_INCREMENT, authorization_code VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, redirect_url TEXT, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_authoriza...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #8 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_clients' already exists. Failing Query: "CREATE TABLE oauth_clients (id INT UNSIGNED AUTO_INCREMENT, client_id VARCHAR(250) NOT NULL, secret VARCHAR(250) NOT NULL, redirect_url TEXT, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_clients', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #9 - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_refresh_tokens' already exists. Failing Query: "CREATE TABLE oauth_refresh_tokens (id INT UNSIGNED AUTO_INCREMENT, refresh_token VARCHAR(250) NOT NULL, client_id VARCHAR(250) NOT NULL, user_id INT NOT NULL, expires DATETIME NOT NULL, scope VARCHAR(250) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 ENGINE = INNODB"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE TABLE oa...')
#1 /home/shineisp/web/library/Doctrine/Export.php(312): Doctrine_Connection->execute('CREATE TABLE oa...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(56): Doctrine_Export->createTable('oauth_refresh_t...', Array, Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedTable(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #10 - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'uuid'. Failing Query: "ALTER TABLE orders ADD uuid VARCHAR(50)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE ord...')
#1 /home/shineisp/web/library/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE ord...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('orders', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 87)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #11 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'uuid_idx'. Failing Query: "CREATE UNIQUE INDEX uuid_idx ON orders (uuid)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE UNIQUE I...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE UNIQUE I...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('orders', 'uuid', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 88)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}

 Error #12 - SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'uuid_idx'. Failing Query: "CREATE UNIQUE INDEX uuid_idx ON orders_items (uuid)"
#0 /home/shineisp/web/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'CREATE UNIQUE I...')
#1 /home/shineisp/web/library/Doctrine/Export.php(458): Doctrine_Connection->execute('CREATE UNIQUE I...')
#2 /home/shineisp/web/library/Doctrine/Migration/Process.php(140): Doctrine_Export->createIndex('orders_items', 'uuid', Array)
#3 /home/shineisp/web/library/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedIndex(Array)
#4 /home/shineisp/web/library/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 88)
#5 /home/shineisp/web/library/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(88)
#6 /home/shineisp/web/library/Shineisp/Controller/Plugin/Migrate.php(114): Doctrine_Migration->migrate()
#7 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(309): Shineisp_Controller_Plugin_Migrate->preDispatch(Object(Zend_Controller_Request_Http))
#8 /home/shineisp/web/library/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#9 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#12 {main}
"

Please advise... Thank you...

Order Renew

Hi Guys,

there is a strange code at line 665 at /models/Orders.php.

$order->order_number = self::formatOrderId($orderid);

but $orderid is not set yet.

thanks

Feature Request: Customer Title

Hi,

There should be a variable for the customer's title such as Mr, Ms, Mrs, Dr, etc... There should also be an option to address a customer in a friendly way (eg/ Hi Bob) or formally (eg/ Dear Mr Smith).

Thank you...

Save the status history of the order

hi guys,

a new feature can be adding a status order in each order page. For instance:

Order ID     Status        Date
0001-2013    to be paid    28/05/2013 08:12
0001-2013    paid          28/05/2013 08:15
0001-2013    processing    28/05/2013 08:20
0001-2013    complete      28/05/2013 08:50

what do you think about this feature? Can be useful?

The "Forgot password" doesn't work

Hi guys,

we have discovered a new bug when a customer try to retrieve a new password from the site. The site send two emails. The first one asks to the client if he/she wants restore his/her password. The second one send the password.

In the second one email the password shown is:

$1$VCIXDLcz$TGAncITbSWsslImBrdZi01

Seems to me that this is the hash of the password.

Can you fix it please?

thanks

Customizable services & addon

Each service should have a list of addons that customers could by when ordering.
For example, a standard hosting package with disk space set as addon. When buying, customer choose the hosting package and then choose the exact amount of disk space.
Selling price will be changed automatically with sum for the base package and addon price.
Something like the addon in WHMCS is good.

With tha actual shineisp version is not possible, for example, to sell cloud services in a efficient way. Customers needs to choose the numbers of service hours or virtual resources and this is not possible without creating a set of predefined packages.

Cart doesn't work as well

Hi guys,

ShineISP cart doesn't show the price when a hosting service is added into the cart. Steps to reproduce the problem:

Add a hosting plan into the cart basket
Look at the right cart summary and you will see the wrong price

thanks

Error on submitting a order

hi guys,

when a user try to buy a hosting plan ShineISP shows this error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'uuid_idx'

These are the steps:

Add a hosting product in the cart
Register yourself
Pay by Bank transfer

Regards

Slow Tasks execution

Something goes wrong. Many software sections are slow. One of these sections is the System > Tasks module under http://www.shineisp.com/system/tasks

It takes about 1 minute to elaborate the data.

thanks

Invoice template should be customizable

Invoice template should be customizable. Actually the only way to customize it is to change PHP code.

It should also be customizable for each ISP defined in ShineISP.

This: https://github.com/dompdf/dompdf is still actively mantained and seems to be a good way to generate a PDF from an HTML.

How the Server Group works?

Hi guys,

as mentioned in the subject of the message. How the Server Group works?
I do not see any link in the administration panel.

Are you creating a manual for the users at the http://www.shineisp.com/help/ website?

thanks

API Broken

Commit #9a48208ad69d5dbd9dcfed00daa5974f4ee9c280 breaks States api.

skip domain registration/buy

i would love to have option:
"I don't have domain. I will use free subdomain." When buying a hosting plan, because sometimes user only want to test a project and he really dont want to add his domain.

Thanks,
Tadas

Admin, Tech and Bill Account Contacts

Hi,

It would be really good to be able to have different Customer contacts on the account. So you might send the renewal notice to the Admin contact, support issues to the Tech contact and the invoices to the Bill contact.

So there could be an option under Customer to create new contacts under the account. Then in other areas of the admin control panel, assign which contact should receive which type of email notice or other communication.

It would also be good to be able to handle multiple types of contact. For example, you could have two or more admin contacts within a business who both want to receive renewal notices.

Thank you...

Issue After Latest Pull 2

Just pulled latest version and tried view admin page and the following error was shown:

Parse error: syntax error, unexpected T_SL in /home/ws15shine/web/library/Shineisp/Controller/Plugin/SetupModules.php on line 19

Thank you...

Customer Statement

Hi,

One really important feature that is missing is the ability to generate a statement for a customer account (showing invoices, credit notes and payment and any payment balance due). It would also be good to be able to send a customer a statement automatically every month.

Thank you...

Migration Versions Break

There is a problem in the Migration Version files. Seems that you have created a wrong migration files.

...
CORRECT!
1365764389_version40.php
1365777182_version41.php
1365777183_version42.php
1365780118_version43.php
1365780119_version44.php
1365780481_version45.php
1365780711_version46.php

WRONG!
1366018360_version43.php
1366018539_version44.php
1366020298_version45.php
1366027782_version46.php
1366029802_version47.php
1366029803_version48.php
1366034528_version49.php
1366034845_version50.php
1366034846_version51.php
1366037037_version52.php

Look this screenshot:

Tax rules

Tax rules shold be created in a way similiar to Magento.

Invoice document is not created

After creating the order document, ShineISP doesn't create the invoice document.
Steps:

Create an Order
Set the payment
Click on the Invoice button

No invoice is created.

Cart issue

When a client pays with credit card this error appear:

Message: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'paymentdate' cannot be null
Class: Doctrine_Connection_Mysql_Exception
Error: /library/Doctrine/Connection.php on line 1082

Attributes code inconsistency

Actually, attribute code is sanitized with URLRewrite::format() method that will remove any chars other than A-Z, 0-9 and "-"

This creates two bugs:

any mandatory attributes added to a product can't be saved. ShineISP doesn't detect that attribute value if attribute code has "-" in it's name. The same attribute without "-" in code is saved properly
ISPConfig module needs some attributes with "_" in it's code. (for example: "ssh_chroot"). Is not possible to save the needed attribute code because shineisp will remove the "-" from it's name and ispconfig doesn't detect it anymore.

I think that these 2 bugs are related.

Wrong price and cart error

hi guys,

when we try to create a new simple product with a fixed price we get a strange behaviour of the prodcut public page.

We have created a simple product with these parameters in the billing tab:

This is the result in the product page:

and this is the issue when I try to add it in the cart:

Error on saving the Server data

Hi guys,

here another problem when you try to save the data in the Server admin page:

Fatal error: Call to undefined method stdClass::save() in
/application/models/OrdersItemsServers.php on line 70

Invoice Date Search

Hi,

In the admin area, under Home>Invoices, the following issues appear under the Date search field:

You can't search by date as the forward slah ('/') is not recognised. When used, no records are returned.
The initial text in the field reads "Search Co..." instead of "Search Date".

Thank you...

Wrong Fastlinks

There are two important functions in ShineISP that helps the administrator and the customer to jump up to the dashboard using the fastlinks.

If a client tries to register a profile, he is redirected to a wrong page instead of the dashboard
If the administrator click in the Public Profile at the administration customer profile page, he is redirected in a wrong page.

The problem seems to me the fastlink that doesn't login the user with right credencials.

regards

Invoice not updated after order paid.

Hi,

Using the admin control panel only, I created a customer and then a domain. Then I placed an order for the domain for the customer. Then I generated the invoice. Then I paid the order. But when I then viewed the invoice, this still showed as unpaid. Therefore, unless I have got it wrong, the invoice needs to be marked paid when an order is paid.

Thank you...

Translation: Gettext Integration

As soon as possible ShineISP will handle the *.po and *.mo files to translate the contents of the project.

The email template will be not translated by gettext because they have html code embedded.

The administrator receives two emails for each message posted

Hi guys,

all the orders, domains, customers messages (commenti) section are sent 2 times to the administration. The first message email is the "order_message" and second one is the "order_message_admin".

thanks

Email Template: tinyMCE change the html code

The email template is changed by tinyMCE on save.
Look at the "ticket_message" template.

Pull Request: #60

Multi ISP support

Multi ISP support should be done.
Each ISP should be able to customize invoice numbering (with a custom prefix/postfix) and should have it's own settings.

Registrant (domain name owner) Multiple Choice

Hi,

Another really good feature would be to add a registrant (domain name owner) manager. This could be similar to how Amazon lists delivery postal addresses. So you have a list of registrants associated with the customer account. When you register a new domain name, then you can easily choose which registrant will be used.

This could also be extended to WHOIS Admin, Tech and Bill contacts and name servers.

Thank you...

Invoice & Order PDF file

Invoice and Order PDF have not the amount of the bank transfer.

Order issue

When I try to add within a new order more domains I get this error:

Strict Standards: Non-static method Orders::SaveDomainsDetails() should not be called statically in /application/models/Orders.php on line 396

and this:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shineisp`.`orders_items`, CONSTRAINT `orders_items_billing_cycle_id_billing_cycle_billing_cycle_id` FOREIGN KEY (`billing_cycle_id`) REFERENCES `billing_cycle` (`billing_cycle_id`))

Invoice and Credit Note Buttons

Hi,

It would be good to provide the same button options for Credit Notes as for Invoices (eg/ Email Credit Note and Dropbox It).

Also, it would be good to have the following options:

'View Invoice': Displays the PDF invoice in the browser.
'Save Invoice': Prompts to save the invoice from the browser.

Thank you...

Automatic Product Setup

Hi guys,

there is a problem when we try to save the product. Steps to reproduce it:

Edit one product in the admin catalog
Select the Automatic Product Setup
Click on the save button

No Automatic Product Setup preferences will be saved.

Orders & Invoice issue

Orders payed with the payment module doesn't change the order status from "To be paid" to "Paid".

thanks

Wrong Orders number in Customers panel

Hi guys,

we have found this strange problem in the administration customer panel. As you can see in the attachment file the column "Number" have the same value but they are two different orders.

What happens?

Object of class Zend_View_Helper_Currency could not be converted to string

We receive this error when trying to access to a product list on public area:

Catchable fatal error: Object of class Zend_View_Helper_Currency could not be converted to string in /application/modules/default/views/scripts/partials/prices.phtml on line 41

Email Templates: Strange email language selection

After importing the email template the user needs a way to translate it.
How they do?

thanks

Error on Order list (client side)

Hi guys,

I have found a new issue in the client side in the order list page:

 Notice: Undefined index: order_number in /application/modules/default/controllers/OrdersController.php on line 76

Furthermore when the user delete the order, the subject of the email sent contains a placeholder

Ordine nr. [orderid] cancellato

Thanks again for your effort!

Domains with the status delete is not visible in the customer domain page

Hi guys,

as mentioned in the subject there is an issue in the user domain page. The user must see all his domains in the domains page in order to renew them.

How to reproduce it:

Go to the customer profile at the public website
Click on the subscribed domains list
If a domain has been set as deleted (expired) the customer cannot see it

In this way the customer cannot renew the domain service.

regards

Error on save a NEW product

Hi guys, when we try to save a product in the administration product page we get this error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shineisp`.`products_tranches`, CONSTRAINT `products_tranches_product_id_products_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`product_id`) ON DELETE CASCADE)

We are trying to create a simple product with no recurring payment. (fixed price)

thanks

Small English Language Fixes

Hi,

In the admin area, please see the following English language issues:

'Domini' should be changed to 'Domains'.
'Payed' should be changed to 'Paid'. Payed is technically acceptable but not commonly used.
'Statuses' should be changed to 'Status' (plural is 'Status').
Under Home>Admin>Orders>Edit>Payment, the following should be updated:
a). "Does the Transaction has been confirmed?" -> "Has the Transaction been confirmed?"
b). "No, it has been not", "No, not yet"

Thank you...
Thank you...

Issues after latest pull

Hi,

Have just been going through the order process testing ShineISP and then performed the latest pull. After this, the customers/orders/domains were no longer displayed in the admin control panel. I reinstalled with a new database and then tried to add a new customer and received the following error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shineispdb`.`addresses`, CONSTRAINT `addresses_region_id_regions_region_id` FOREIGN KEY (`region_id`) REFERENCES `regions` (`region_id`))

The system appears to be broken at present. Please advise. Thank you...

Invoice Generated from Unpaid Order

Hi,

When an invoice is generated manually from an unpaid order, it should be generated as unpaid. It should only be marked as paid when the payment is received (not when the invoice is generated which appears to occur at the moment).

The reason for this is that an ISP may want to manually create an order for a trusted customer and enable the service before payment is received. Then the ISP sends the customer an invoice with 30 days payment terms. This process is very common and the customer expects an invoice requesting payment as opposed to an order requesting payment (customers do not like making payment without an invoice).

Thank you...

Install Problem - Rewrite 302 Loop

Hi,

Just tried installing ShineISP v2 as follows (fresh install):

Download zip file from https://github.com/shinesoftware/shineisp/archive/master.zip.
Unzip.
Move all contents of 'shineisp-master' folder (including all hidden files) to web hosting account root.
Set write permissions on 'public/' and 'application/configs/' (including all contents recursively).
Create VirtualHost entry in Apache (DocumentRoot set to 'public' directory).
Restart Apache.
Visit the web hosting account URL to complete the configuration (as per http://www.youtube.com/watch?v=idJNXYe9L3c&feature=player_embedded).

But no page is shown and instead it 302 rewrites to .../setup -> .../setup -> .../setup -> ... looping...

The ShineISP .../public/logs/errors.log shows the following:

05-05-13 01:10:01 EXCEPTION_OTHER: Unknown connection: doctrine
#0 /home/shineisp/web/library/Doctrine/Manager.php(554): Doctrine_Manager->getConnection('doctrine')
#1 /home/shineisp/web/library/Doctrine/Core.php(1085): Doctrine_Manager->getConnectionForComponent('Languages')
#2 /home/shineisp/web/application/models/Languages.php(101): Doctrine_Core::getTable('Languages')
#3 /home/shineisp/web/library/Shineisp/Controller/Plugin/Language.php(54): Languages::get_language_id_by_code('en')
#4 /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php(260): Shineisp_Controller_Plugin_Language->routeShutdown(Object(Zend_Controller_Request_Http))
#5 /home/shineisp/web/library/Zend/Controller/Front.php(923): Zend_Controller_Plugin_Broker->routeShutdown(Object(Zend_Controller_Request_Http))
#6 /home/shineisp/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#7 /home/shineisp/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#8 /home/shineisp/web/public/index.php(53): Zend_Application->run()
#9 {main}

The Apache error_log show entries as follows (partial):

[Sun May 05 13:10:00 2013] [error] [client 123.123.123.123] PHP Fatal error:  Uncaught exception 'Zend_View_Exception' with message 'script 'error/error.phtml' not found in path (/home/shineisp/web/application/modules/default/views/scripts/)' in /home/shineisp/web/library/Zend/View/Abstract.php:988\nStack trace:\n#0 /home/shineisp/web/library/Zend/View/Abstract.php(884): Zend_View_Abstract->_script('error/error.pht...')\n#1 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render('error/error.pht...')\n#2 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('error/error.pht...', NULL)\n#3 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render()\n#4 /home/shineisp/web/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()\n#5 /home/shineisp/web/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->n in /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php on line 336
[Sun May 05 13:10:01 2013] [error] [client 123.123.123.123] PHP Fatal error:  Uncaught exception 'Zend_View_Exception' with message 'script 'error/error.phtml' not found in path (/home/shineisp/web/application/modules/default/views/scripts/)' in /home/shineisp/web/library/Zend/View/Abstract.php:988\nStack trace:\n#0 /home/shineisp/web/library/Zend/View/Abstract.php(884): Zend_View_Abstract->_script('error/error.pht...')\n#1 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render('error/error.pht...')\n#2 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('error/error.pht...', NULL)\n#3 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render()\n#4 /home/shineisp/web/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()\n#5 /home/shineisp/web/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->n in /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php on line 336
[Sun May 05 13:10:01 2013] [error] [client 123.123.123.123] PHP Fatal error:  Uncaught exception 'Zend_View_Exception' with message 'script 'error/error.phtml' not found in path (/home/shineisp/web/application/modules/default/views/scripts/)' in /home/shineisp/web/library/Zend/View/Abstract.php:988\nStack trace:\n#0 /home/shineisp/web/library/Zend/View/Abstract.php(884): Zend_View_Abstract->_script('error/error.pht...')\n#1 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render('error/error.pht...')\n#2 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('error/error.pht...', NULL)\n#3 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render()\n#4 /home/shineisp/web/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()\n#5 /home/shineisp/web/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->n in /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php on line 336
[Sun May 05 13:10:01 2013] [error] [client 123.123.123.123] PHP Fatal error:  Uncaught exception 'Zend_View_Exception' with message 'script 'error/error.phtml' not found in path (/home/shineisp/web/application/modules/default/views/scripts/)' in /home/shineisp/web/library/Zend/View/Abstract.php:988\nStack trace:\n#0 /home/shineisp/web/library/Zend/View/Abstract.php(884): Zend_View_Abstract->_script('error/error.pht...')\n#1 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render('error/error.pht...')\n#2 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('error/error.pht...', NULL)\n#3 /home/shineisp/web/library/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render()\n#4 /home/shineisp/web/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()\n#5 /home/shineisp/web/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->n in /home/shineisp/web/library/Zend/Controller/Plugin/Broker.php on line 336

Have previously successfully installed on the same server before the new setup procedure (http://www.shineisp.com/setup-installation-released/). Is this an issue or have I missed something? Please help...

Thank you...

Currency

Hi!

When a customer logs on and there is an order, he see it:
"The order number xy that you have requested the xxxxx with total 123456.00 euro has been not payed yet, click here to show more details." -> The website use HUF, not EUR!

And on the details page, the Paypal Checkout form use Euro - not the selected currency (Hungarian Forint in this case).

Wrong Password

Hi guys,

we get another time an issue with the credencial process.

This is the new password: NfIi6OgHIyEfIsek

Here the result after the reset of the password:

Customers::login row 899

14-05-13 12:49:23 Login: John Doe tries to login with [email protected] and EdHxCBOAeRKCeuzd as password.
14-05-13 12:49:23 Login: this is the hashed password:$6$s.AE2flfJCbo$ISFm16MR.jk4EoGTWTDneW8MVj2sAfxzyGyFgbi.RNGIV2VHTA/BpDIyb9SEg3vQhZsOmuE59.GoYVaIr8zFE/
14-05-13 12:49:23 Login: this is the database hashed password:$6$s.AE2flfJCbo$ISFm16MR.jk4EoGTWTDneW8MVj2sAfxzyGyFgbi.RNGIV2VHTA/BpDIyb9SEg3vQhZsOmuE59.GoYVaIr8zF
14-05-13 12:49:23 Login: Authorization KO

Registrars: New add-on registrars modules management

We have to create a way to add many registrars module on the fly. Just copy and paste and the registrar module will be ready to be customized.

We invite all the developers to help us to create all registrars modules.

shinesoftware / shineisp Goto Github PK

shineisp's People

Contributors

Stargazers

Watchers

Forkers

shineisp's Issues

Recommend Projects

Recommend Topics

Recommend Org