Cannot implement PayPal or other payment modules

[IH-Lewis]

Hello!

When I try and activate any payment modules, I get an SQL error.

Any help? I'm using the latest version of HostBill, of course.

Thanks!

[BRJP]

Hi IH-Lewis,

Could you please supply the SQL error and the exact process?  If you have any screenshots that would also be helpful.

Thanks
Brad

[IH-Lewis]

Here you go:

Code Select Expand

Uh oh! Something went wrong ...
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'field list' IN /home/imagihos/public_html/my-afk/hbf/components/mailer/class.mailer.php(344), stack trace:
#0 /home/imagihos/public_html/my-afk/hbf/components/mailer/class.mailer.php(344): PDOStatement->execute()
#1 /home/imagihos/public_html/my-afk/includes/components/events/class.mailnotifications.php(2316): Mailer->Send()
#2 /home/imagihos/public_html/my-afk/hbf/core/class.hbeventmanager.php(167): Mailnotifications->FailedAdminLoginAttempt()
#3 /home/imagihos/public_html/my-afk/hbf/core/class.hbeventmanager.php(152): HBEventManager::_event()
#4 /home/imagihos/public_html/my-afk/hbf/core/class.engine.php(162): HBEventManager::notify()
#5 /home/imagihos/public_html/my-afk/hbf/components/authorization/class.adminauthorization.php(500): Engine->notify()
#6 /home/imagihos/public_html/my-afk/hbf/core/class.controller.php(60): AdminAuthorization->do_login()
#7 /home/imagihos/public_html/my-afk/hbf/core/types/class.admin_frontcontroller.php(69): Controller::globalActions()
#8 /home/imagihos/public_html/my-afk/hbf/core/class.frontcontroller.php(124): Admin_FrontController->dispatch()
#9 /home/imagihos/public_html/my-afk/hbf/core/class.frontcontroller.php(107): FrontController->handleRequest()
#10 /home/imagihos/public_html/my-afk/admin/index.php(14): FrontController::init()
#11 {main}

[BRJP]

OK - so it looks like you have a missing column (obviously!) but I don't know why. 

Assuming the installation of HostBill and the module was correct, this could be a bug you need to report. Bug reports do get answered (but you need to provide excellent and specific details) or the paid service ($75 per ticket) will expedite this process for you.

[IH-Lewis]

OK - so it looks like you have a missing column (obviously!) but I don't know why. 

Assuming the installation of HostBill and the module was correct, this could be a bug you need to report. Bug reports do get answered (but you need to provide excellent and specific details) or the paid service ($75 per ticket) will expedite this process for you.

Thanks. I'm pretty sure that I installed it correctly since I've uploaded this on three other hosts and I'm having the same issue. I'm definitely not paying $75 per ticket so I'll submit a bug report. Thanks again!

[BRJP]

Intersting that it worked on the other installations - that might suggest its not a bug but could be environmental.  You would expect a bug to be consistent across all other installations.