After updating WHMCS v7.0.1 to WHMCS v7.2.1 minor issue | Resloved

[smarters]

Hi,

 

I was getting a very serious issue after I update my WHMCS to v7.2.1.

 

When I try to update my client's product service I am getting database query issue.

 

Issue description something like:

 

Oops!

Something went wrong and we couldn't process your request.

Please go back to the previous page and try again.

 

exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'' in /home/whmcssmarters/public_html/clients/vendor/illuminate/database/Connection.php:441

Stack trace:

#0 /home/whmcssmarters/public_html/clients/vendor/illuminate/database/Connection.php(441): PDO->prepare('insert into `tb...')

 

 

 

Please see the screenshot:

 

 

https://drive.google.com/a/newsparktechnology.com/file/d/0B4s42KnhEOHzTkttZlZKUzZvYkE/view?usp=drivesdk

 

Let me be more clear when I go to Admin area -> Clients -> View / Search Client page

here I choose one of my clients and go to Product/Services Tab

 

then I update anything ( next due date for the product) then click the save then I get this error.

 

I have fixed this issue by updating into the database it takes only 2 mins.

 

Resolution:

It seems while upgrading from WHMCS v7.0.1 to WHMCS v7.2.1 my database table named tblcustomfieldsvalues was not updated/altered according to the latest standard.

 

 

I found there were two column names "created" and "updated" that were supposed to be alerted to "created_at" and "updated_at" for WHMCS v7.2.1.

 

then I had to edit them manually. I had logged in my PHPMyAdmin and edit the table fields names accordingly then it started working for me.

 

I have posted here it may help someone else who is having the same issue.

 

Regards

Amanpreet

WHMCS Smarters - The New Spark Technology Company

All kind of customized solution for your WHMCS

Third Party Custom Module Development Team