Jump to content

Column not found error


Recommended Posts

I got this error today (below, and edited for brevity) when trying to add a new customer.  It created/added the customer but i'm guessing it was just this one record that didnt get added.. I'm hoping this table just needs to be added into the database or something easy like that?

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' in /home/vendor/illuminate/database/Connection.php:462
WHMCS\User\Client->marketingEmailOptOut('71.x.x.210', false)
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'marketingemailsoptin' in 'field list' (SQL: update `tblclients` set `updated_at` = 2018-09-04 16:25:26, `marketingemailsoptin` = 0 where `id` = 104) in /home/

 

 

Link to comment
Share on other sites

25 minutes ago, iHelpersLLC said:

I ran the conversion process but i'm still seeing the same error when adding a new client.

have you examined the tblclients database table to check that it doesn't exist? if it's missing from there, then that may mean that the v7.6 update didn't complete properly as it didn't convert the table to the new columns.

if that's occuring, then Support might be able to give you a SQL query to fix the table structure.

Link to comment
Share on other sites

if it helps...

H242BED.png

it's basically just a boolean field (0/1)... if this is the only column missing, you should be able to insert it manually using phpmyadmin without the need for SQL.

that said, if you're still using v7.6, I might be tempted to get the full v7.6.1 download, install that and see if that updates the database structure for you.

Link to comment
Share on other sites

  • 3 weeks later...
20 hours ago, iHelpersLLC said:

I guess i dont know how to add a table in PHPMyadmin (although i've done it many times in the past) ..

it's not a new table, just a new column in the tblclients table... you could use phpmyadmin to add it - perhaps the video tutorial below might walk you through it.

 

Link to comment
Share on other sites

phpmyadmin says it should be this...

CREATE TABLE `tblmarketing_consent` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `opt_in` tinyint(1) NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `ip_address` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci	
13 minutes ago, iHelpersLLC said:

make the support-guy's lives easier!

i'm not sure that I agree with that policy!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated